Carolina, PR
Cancelled registrations · 74
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'PR' AND d.registrant_city = 'CAROLINA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'PR' AND d.registrant_city = 'CAROLINA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N551PRDehavilland D H 114 HERON 2DA · S/N 14086N557PRDehavilland DH 114 HERON 2X · S/N 14077N561PRDehavilland D H 114 HERON 2DA · S/N 14104N565PRDehavilland DH 114 HERON 2X · S/N 14116N6304ECessna 172 · S/N 46404N6332PCessna 152 · S/N 15285002N5611ZPiper PA-22-108 · S/N 22-9384N616TCPiper PA-23 · S/N 23-1058N525DWPiper PA-23-250 · S/N 27-3562N3486GBeech C-45H · S/N 52-10590N609SSGrumman G-73T · S/N J-9N2333SCessna 337B · S/N 337-0633N140WBeech C-45H · S/N AF-700N1159SDouglas DC3-G202A · S/N 2237N127LBBritten Norman BN-2A MK III · S/N 1010N102APDouglas DC3A · S/N 2257N902GDBritten-Norman BN-2A-27 · S/N 905N35MNBritten-Norman BN-2A-8 · S/N 542N300AWLockheed L-1011-385-1 · S/N 193P-1134N766BELockheed L-1011-385-1 · S/N 193P-1112N4752DCessna 172N · S/N 17272349N5519QMooney M20C · S/N 2948N6230LAmerican AA-1 · S/N AA1-0430N3218LCessna 172H · S/N 17256118
Back to Carolina, PR