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.
N64405Cessna 172P · S/N 17275555N3525JCessna A188B · S/N 18803650N2718CCessna 402C · S/N 402C0228N2719LCessna 402C · S/N 402C0236N758QHCessna R172K · S/N R1723272N68087Cessna 404 · S/N 4040844N5202HCessna 152 · S/N 15284069N4066JCessna A188B · S/N 18803717N758WXCessna R172K · S/N R1723427N758WZCessna R172K · S/N R1723429N758XDCessna R172K · S/N R1723433N26959Cessna 340A · S/N 340A0776N70362Cessna 207A · S/N 20700549N3173UBell Helicopter Textron 206L-1 · S/N 45746N2094JCessna A188B · S/N 18803384TN6879QCessna 402C · S/N 402C0610N6489NCessna 210N · S/N 21063063N6844VCessna 425 · S/N 4250067N9374NCessna A185F · S/N 18504342N6614ZCessna U206G · S/N U20606344N756MQCessna U206G · S/N U20604203N6769LCessna 404 · S/N 4040825N3052JCessna 188B · S/N 18803597TN3061JCessna A188B · S/N 18803599TN2069VBell Helicopter Textron 206L-1 · S/N 45623N5744JCessna 172N · S/N 17273831N6097ZCessna U206G · S/N U20606138N6547XCessna U206G · S/N U20605943N6105CDouglas DC-6B · S/N 44105N6831ECessna 310R · S/N 310R2110N6788CCessna 402C · S/N 402C0425N3217ECessna 172N · S/N 17271472N6470XCessna U206G · S/N U20605908N7583LCessna A152 · S/N A1520820N8132LCessna A152 · S/N A1520826N5204NCessna 182Q · S/N 18267570N5275JCessna 404 · S/N 4040632N5369XCessna U206G · S/N U20605685N6362UCessna U206G · S/N U20605451N25985Cessna 152 · S/N 15280896N733WACessna U206G · S/N U20604801N758JJCessna R172K · S/N R1723130N4594ACessna A152 · S/N A1520835N4662ACessna A152 · S/N A1520856N735MVCessna U206G · S/N U20604941N2636XCessna 310R · S/N 310R1651N14850Bell 206B · S/N 876N2656DCessna 421C · S/N 0712N4627NCessna 402B · S/N 402B1380N6200CCessna 310R · S/N 310R1333
Back to Professional Aviation Corp