Professional Aviation Corp
Earlier aircraft under this name · 92
Cancelled registrations that named this owner when they ended, newest first.
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_name = 'PROFESSIONAL AVIATION CORP' OR list_contains(d.other_registrant_names, 'PROFESSIONAL AVIATION CORP') 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_name = 'PROFESSIONAL AVIATION CORP' OR list_contains(d.other_registrant_names, 'PROFESSIONAL AVIATION CORP') 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.
N2677DCessna 404 · S/N 404-0425N756QSCessna U206G · S/N U20604277N759QFCessna 182Q · S/N 18266169N736XQCessna R172K · S/N R1722873N45951Cessna 152 · S/N 15282957N45977Cessna 152 · S/N 15282970N1377LCessna 337H · S/N 33701869N4917QCessna A185F · S/N 18503574N7595BCessna A152 · S/N A1520776N49809Cessna 152 · S/N 15281330N66797Cessna 152 · S/N 15281664N7390LCessna A152 · S/N A1520807N5286CCessna 310R · S/N 310R1535N759YTCessna 182Q · S/N 18266371N94185Cessna A185F · S/N 18503287N88672Cessna 404 · S/N 404-0212N756WPCessna U206G · S/N U20604417N736XWCessna R172K · S/N R1722879N88728Cessna 404 · S/N 404-0241N736ZACessna R172K · S/N R17228907N736ZCCessna R172K · S/N R1722909N736YJCessna R172K · S/N R1722891N736YVCessna R172K · S/N R1722902N7597TCessna R182 · S/N R18200048N756RZCessna U206G · S/N U20604308N736JJCessna R172K · S/N R1722561N761XKCessna 210M · S/N 21062599N1927GCessna 310R · S/N 310R1226N6363XCessna 402B · S/N 402B1326N735MGCessna 182 · S/N 18265527N37525Cessna 414 · S/N 414-0965N4193GCessna 402B · S/N 402B1239N3501GCessna 310R · S/N 310R0854N37164Cessna 404 · S/N 404-0127N4192GCessna 402B · S/N 402B1238N3759GCessna 310R · S/N 310R0913N8578GCessna 310R · S/N 310R0939N37094Cessna 404 · S/N 4040104N5426GCessna 404 · S/N 4040044N3734GCessna 310R · S/N 310R0907N2998VCessna R172K · S/N R1722236N3972CCessna 402B · S/N 402B-00844
Back to Professional Aviation Corp