Dassault Falcon Jet Corp
Earlier aircraft under this name · 44
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 = 'DASSAULT FALCON JET CORP' OR list_contains(d.other_registrant_names, 'DASSAULT FALCON JET 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 = 'DASSAULT FALCON JET CORP' OR list_contains(d.other_registrant_names, 'DASSAULT FALCON JET 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.
N478FJDassault FALCON 7X · S/N 487N716CQDassault FALCON 7X · S/N 255N371FJDassault FALCON 2000EX · S/N 370N358FJDassault FALCON 2000EX · S/N 358N8XDassault FALCON 7X · S/N 403N165FJDassault FALCON 7X · S/N 165N728FJDassault FALCON 2000EX · S/N 728N260FJDassault FALCON 7X · S/N 260N715FJDassault FALCON 7X · S/N 215N716FJDassault FALCON 2000EX · S/N 716N120FJDassault FALCON 7X · S/N 220N258FJDassault FALCON 2000EX · S/N 258N268FJDassault FALCON 7X · S/N 168N183MKDassault FALCON 7X · S/N 183N159FJDassault FALCON 7X · S/N 159N106FJDassault FALCON 7X · S/N 106N215FJDassault FALCON 2000EX · S/N 215N781EXDassault FALCON 2000EX · S/N 187N763FJDassault FALCON 7X · S/N 63N209EXDassault FALCON 900EX · S/N 209N257QSDassault FALCON 2000EX · S/N 191N470DDassault FALCON 2000EX · S/N 139N190FJDassault FALCON 900 EX · S/N 190N186EXDassault FALCON 900 EX · S/N 186N900KMDassault FALCON 900 EX · S/N 177N129EXDassault FALCON 2000EX · S/N 129N176EXDassault FALCON 900 EX · S/N 176N287FDassault FALCON 2000EX · S/N 87N907DXDassault FALCON 900 EX · S/N 607N60EXDassault FALCON 900 EX · S/N 60N610ASDassault FALCON 2000 · S/N 008N141EXDassault FALCON 900 EX · S/N 141N142EXDassault FALCON 900 EX · S/N 142N53FJDassault-Breguet FALCON 50 · S/N 53N198FJDassault MYSTERE FALCON 900 · S/N 198N969EXDassault FALCON 900 EX · S/N 69N900VMDassault FALCON 900 EX · S/N 64N2194Dassault FALCON 2000 · S/N 110N399FADassault FALCON 2000 · S/N 101N179FJDassault MYSTERE FALCON 900 · S/N 178N2146Dassault FALCON 2000 · S/N 59N7243UCessna 650 · S/N 6507054N901FJDassault-Breguet MYSTERE FALCON 900 · S/N 147N246FJDassault MYSTERE-FALCON 50 · S/N 246
Back to Dassault Falcon Jet Corp