Flight Contract Services Inc
Earlier aircraft under this name · 43
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 = 'FLIGHT CONTRACT SERVICES INC' OR list_contains(d.other_registrant_names, 'FLIGHT CONTRACT SERVICES 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 = 'FLIGHT CONTRACT SERVICES INC' OR list_contains(d.other_registrant_names, 'FLIGHT CONTRACT SERVICES 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.
N80220Piper PA 46-350P · S/N 4636775N5516ACessna T210N · S/N 21063475N122LACirrus Design SR22 · S/N 1241N50913Textron B300 · S/N FL-1013N11524Cessna 172S · S/N 172S10340N991PGCirrus Design SR22 · S/N 2960N2442HBeechcraft G58 · S/N TH-2442N994TSDiamond Aircraft Ind DA 42 · S/N 42.AC094N50385Beechcraft B300 · S/N FL-985N2427WBeechcraft G58 · S/N TH-2427N61PADiamond Aircraft Ind DA 42 · S/N 42.AC021N5019RHawker Beechcraft B200 · S/N BB-2019N50293Beechcraft G58 · S/N TH-2393N5080NBeechcraft G58 · S/N TH-2380N50919Hawker Beechcraft C90GTI · S/N LJ-2049N5049QHawker Beechcraft G58 · S/N TH-2364N290FSBeech C90A · S/N LJ1290N80172Hawker Beechcraft G58 · S/N TH-2322N8124WHawker Beechcraft G58 · S/N TH-2324N6260AHawker Beechcraft G58 · S/N TH-2276N60325Hawker Beechcraft G58 · S/N TH-2275N4TGBeech 58 · S/N TH-335N791JTHawker Beechcraft G58 · S/N TH-2260N32287Hawker Beechcraft G58 · S/N TH-2247N3207CHawker Beechcraft G58 · S/N TH-2240N188TCBeech B200C · S/N BL-64N968MBRaytheon B200 · S/N BB-1667N2698CFairchild SA227-AC · S/N AC-665N208DGCessna 208B · S/N 208B0862N861CMCessna 208B · S/N 208B0861N9944SPiper PA 46-350P · S/N 4636188N800RACessna 208 · S/N 20800360N186SWEmbraer EMB-120ER · S/N 120.034N51CUCessna 425 · S/N 4250171N268UEEmbraer EMB-120ER · S/N 120.207N1253YCessna 208B · S/N 208B0649N1253KCessna 208B · S/N 208B0648N111MUBeech C90A · S/N LJ-1367N1428ECessna T206H · S/N T20608524N689CDCirrus Design SR20 · S/N 1441N142CDCirrus Design SR20 · S/N 1033N41354Piper PA-28-181 · S/N 28-43213N9798FCessna 208 · S/N 20800213
Back to Flight Contract Services Inc