Business Air Parts Inc
Earlier aircraft under this name · 40
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 = 'BUSINESS AIR PARTS INC' OR list_contains(d.other_registrant_names, 'BUSINESS AIR PARTS INC') 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 = 'BUSINESS AIR PARTS INC' OR list_contains(d.other_registrant_names, 'BUSINESS AIR PARTS INC') 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.
N53049Thrush S2R-T34 · S/N T34-319DCN5301UThrush S2R-T34 · S/N T34-310N5306JThrush S2R-T34 · S/N T34-330N323RRBeech 200 · S/N BB-380N19466Beech F17D · S/N 230N20DHBeech B200 · S/N BB-1263N41337Robinson Helicopter R22 BETA · S/N 4353N757WSRaytheon 400A · S/N RK-169N8243Beech 95-B55 (T42A) · S/N TC-2393N59BSRaytheon G36 · S/N E-3681N649CHCessna 210R · S/N 21064978N14PXPiper PA-31T1 · S/N 31T-8104060N63SKBeech 200 · S/N BB-747N6747LBeech 58 · S/N TH-1126N544LFRaytheon 400A · S/N RK-428N5367UPiper PA-34-220T · S/N 3449283N61383Beech C90 · S/N LJ-1009N850GPSocata TBM 700 · S/N 430N4493MRobinson Helicopter R44 II · S/N 12942N134CMRaytheon 400A · S/N RK144N88QMPiper PA-31T1 · S/N 31T-8104025N206DUBell Helicopter Textron 206B · S/N 4581N7HGHawker Beechcraft C90GTI · S/N LJ-1907N3493YHawker Beechcraft G58 · S/N TH-2239N850ABSocata TBM 700 · S/N 381N65817Cessna 172S · S/N 172S9760N408MBeech 400A · S/N RK-6N584LVHawker Beechcraft G58 · S/N TH-2190N3245YRaytheon A36 · S/N E-3245N53689New Piper PA-34-220T · S/N 3449299N773MHRobinson Helicopter R44 II · S/N 11814N581CDCirrus Design SR22 · S/N 1650N908GRBeech C90 · S/N LJ-861N563PBCirrus Design SR22 · S/N 2358N67333Beech 58 · S/N TH-1114N23596Cessna 172S · S/N 172S10542N73SGHawker Beechcraft G36 · S/N E-3840N5271NCessna 172S · S/N 172S9189N4709CCessna 210N · S/N 21063594N1468PCessna T182T · S/N T18208684
Back to Business Air Parts Inc