This repository contains a Python script that generates a CSV file of PIA history for aircraft by looking at Git the history of plane-alert-db pia CSV file. The repository also contains the CSV file generated by the script. The CSV file contains information about the International Civil Aviation Organization (ICAO) code, registration number, and the date and time when the PIA ICAO code was added or removed from the database plane-alert-db.
You will see a reg/tail number can appear multiple times because this is the history of all PIA changes that we know of (submitted to the plane-alert-db), a null removed_dt means it's still currently in the original CSV file.
| icao | reg | added_dt | removed_dt |
|---|---|---|---|
| A0FDFB | N650HC | 2022-09-14 11:11:45-07:00 | |
| A0FE01 | N658HC | 2022-02-18 12:26:58-07:00 | |
| A0FE02 | N113CS | 2022-02-18 12:26:58-07:00 | |
| A0FE85 | N83EP | 2022-02-18 12:26:58-07:00 | |
| A0FE90 | N2E | 2022-02-18 12:26:58-07:00 | 2022-11-23 22:30:32-07:00 |
| A0FE2E | N439PW | 2022-02-18 12:26:58-07:00 | |
| A0FE3B | N16DJ | 2022-02-18 12:26:58-07:00 | |
| A0FE3D | N682HS | 2022-02-18 12:26:58-07:00 | 2022-04-20 12:48:59-07:00 |
| A0FE3F | N725DT | 2022-02-18 12:26:58-07:00 | |
| A0FE6E | N437JD | 2022-02-18 12:26:58-07:00 | |
| A0FEAA | N8200E | 2022-02-18 12:26:58-07:00 | 2022-04-04 17:36:32-07:00 |
| A0FEAB | N302AK | 2022-09-13 23:27:43-07:00 | |
| A0FEAF | N68KP | 2022-02-18 12:26:58-07:00 | |
| A0FEB0 | N8000E | 2022-02-18 12:26:58-07:00 | 2022-04-04 17:36:32-07:00 |
| A0FEBA | N977V | 2022-02-18 12:26:58-07:00 | |
| A0FEBB | N628TS | 2022-02-18 12:26:58-07:00 | 2022-04-15 14:29:03-07:00 |
| A0FDF9 | N9XJ | 2022-03-25 10:28:00-07:00 | |
| A0FE30 | N279PH | 2022-03-25 10:28:00-07:00 | |
| A0FE5C | N681HS | 2022-03-25 10:28:00-07:00 | 2022-04-20 12:48:59-07:00 |
| A0FED0 | N68885 | 2022-03-25 10:28:00-07:00 | |
| A0FEE1 | N6JR | 2022-03-25 10:28:00-07:00 | |
| A0FEE7 | N98AC | 2022-03-25 10:28:00-07:00 | |
| A0FEF2 | N8200E | 2022-04-04 17:37:20-07:00 | 2023-09-30 22:41:04-07:00 |
| A0FEF1 | N8000E | 2022-09-13 23:36:51-07:00 | 2023-03-03 13:04:07-07:00 |
| A0FEF0 | N8100E | 2022-04-11 10:31:24-07:00 | |
| A0FEF6 | N302AK | 2022-04-11 10:31:24-07:00 | 2022-09-13 23:27:43-07:00 |
| A0FECB | N628TS | 2022-04-15 14:29:03-07:00 | |
| A0FEEA | N8000E | 2022-04-15 14:29:03-07:00 | 2022-09-13 23:36:51-07:00 |
| A0FED6 | N758PB | 2022-04-15 14:29:39-07:00 | 2022-09-13 23:27:43-07:00 |
| A0FE84 | N952DA | 2022-04-15 14:56:39-07:00 | |
| A0FEED | N681HS | 2022-04-20 12:48:59-07:00 | 2023-08-21 18:36:47-07:00 |
| A0FEEF | N682HS | 2022-04-20 12:48:59-07:00 | 2023-08-21 18:36:47-07:00 |
| A0FEF4 | N998PB | 2022-06-13 11:12:58-07:00 | |
| A0FEFC | N1980K | 2022-06-21 10:05:32-07:00 | 2023-03-03 13:04:07-07:00 |
| A0FEFB | N32MJ | 2022-06-23 11:56:41-07:00 | |
| A0FDDB | N50KL | 2022-09-13 23:27:43-07:00 | |
| A0FEF6 | N928SZ | 2022-09-13 23:27:43-07:00 | |
| A0FF05 | N542TP | 2022-09-13 23:27:43-07:00 | |
| A0FF0B | N271DV | 2022-09-13 23:27:43-07:00 | |
| A0FF11 | N758PB | 2022-09-13 23:27:43-07:00 | 2022-11-23 22:30:32-07:00 |
| A0FEEA | N8800E | 2022-09-13 23:36:51-07:00 | 2023-03-03 13:04:07-07:00 |
| A0FF09 | N414KU | 2022-09-14 10:22:24-07:00 | |
| A0FE9F | N17513 | 2022-09-14 10:25:02-07:00 | 2023-03-03 13:04:07-07:00 |
| A0FEF7 | N634BE | 2022-09-14 10:34:45-07:00 | |
| A1DC4A | N711PV | 2022-09-14 11:31:35-07:00 | |
| A4E954 | N88BK | 2022-09-16 15:34:34-07:00 | |
| A0FEEE | N51TE | 2022-09-22 15:20:24-07:00 | |
| A0FF24 | N14KL | 2022-11-01 16:20:10-07:00 | |
| A0FF21 | N68KJ | 2022-11-04 21:17:41-07:00 | |
| A0FF17 | N311JX | 2022-11-23 22:30:32-07:00 | |
| A0FF22 | N898TS | 2022-11-23 22:30:32-07:00 | 2022-11-26 13:30:19-07:00 |
| A0FF25 | N758PB | 2022-11-23 22:30:32-07:00 | |
| A0FF27 | N2E | 2022-11-23 22:30:32-07:00 | |
| A0FF1F | N621MM | 2022-11-23 22:46:24-07:00 | 2022-12-07 13:57:10-07:00 |
| A0FF20 | N898TS | 2022-11-26 13:30:19-07:00 | 2023-03-03 13:04:07-07:00 |
| A0FED7 | N650JR | 2022-12-02 19:06:53-07:00 | |
| A0FEB4 | N676JM | 2022-12-07 13:44:54-07:00 | |
| A0FF22 | N621MM | 2022-12-07 13:57:10-07:00 | 2023-03-03 13:04:07-07:00 |
| A0FE68 | N935EF | 2022-12-08 16:41:31-07:00 | |
| A102F8 | N586GA | 2022-12-12 21:32:28-07:00 | |
| A0FEDA | N101RE | 2023-03-03 13:04:07-07:00 | |
| A0FF16 | N311JA | 2023-03-03 13:04:07-07:00 | |
| A10309 | N1980K | 2023-03-03 13:04:07-07:00 | |
| A10397 | N621MM | 2023-03-03 13:04:07-07:00 | 2023-03-07 12:30:38-07:00 |
| A103A8 | N8800E | 2023-03-03 13:04:07-07:00 | 2023-07-15 23:52:43-07:00 |
| A103CA | N898TS | 2023-03-03 13:04:07-07:00 | |
| A103E1 | N17513 | 2023-03-03 13:04:07-07:00 | |
| A103F8 | N8000E | 2023-03-03 13:04:07-07:00 | 2023-07-15 23:52:43-07:00 |
| A10410 | N421SZ | 2023-03-03 13:04:07-07:00 | |
| A10404 | N621MM | 2023-03-07 12:30:38-07:00 | 2023-07-15 23:52:43-07:00 |
| A10099 | N6431S | 2023-07-15 23:52:43-07:00 | |
| A100B2 | N8800E | 2023-07-15 23:52:43-07:00 | 2023-09-30 22:41:04-07:00 |
| A100CC | N8000E | 2023-07-15 23:52:43-07:00 | 2023-09-30 22:41:04-07:00 |
| A100F0 | N621MM | 2023-07-15 23:52:43-07:00 | 2023-10-13 16:10:27-07:00 |
| 0000C8 | N917BC | 2023-07-15 23:53:00-07:00 | |
| A100D0 | N681HS | 2023-08-21 18:36:47-07:00 | |
| A100D9 | N682HS | 2023-08-21 18:36:47-07:00 | |
| A100E2 | N941KL | 2023-08-21 18:36:47-07:00 | |
| A1039F | N16CP | 2023-08-21 18:37:13-07:00 | |
| A100F1 | N8800E | 2023-09-30 22:41:04-07:00 | |
| A100F4 | N8000E | 2023-09-30 22:41:04-07:00 | |
| A1010E | N8200E | 2023-09-30 22:41:04-07:00 | |
| A1010F | N17ZP | 2023-09-30 22:41:04-07:00 | |
| A100CB | N124FG | 2023-10-13 16:10:27-07:00 | |
| A10119 | N621MM | 2023-10-13 16:10:27-07:00 |