Skip to content

Earlier aircraft under this name · 29

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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 = 'AIRFLITE INC' OR list_contains(d.other_registrant_names, 'AIRFLITE INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'AIRFLITE INC' OR list_contains(d.other_registrant_names, 'AIRFLITE 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 = 'AIRFLITE INC' OR list_contains(d.other_registrant_names, 'AIRFLITE 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.

N70853Cessna TU206F · S/N U20602105Cancelled Jul 22, 2011 · Expired dealer · Built 1973 · Long Beach, CA N68074Cessna 404 · S/N 404-0836Cancelled Jul 21, 2011 · Expired dealer · Built 1981 · Long Beach, CA N222CLCessna 210N · S/N 21063607Cancelled Jul 18, 2011 · Expired dealer · Long Beach, CA N50985Cessna U206F · S/N U20601967Cancelled Jul 18, 2011 · Expired dealer · Built 1973 · Long Beach, CA N53645Cessna 337G · S/N 33701753Cancelled Jul 18, 2011 · Expired dealer · Long Beach, CA N5541NCessna 182R · S/N 18267780Cancelled Jul 15, 2011 · Expired dealer · Built 1980 · Long Beach, CA N64188Cessna 172M · S/N 17265074Cancelled Jul 15, 2011 · Expired dealer · Built 1975 · Long Beach, CA N21589Cessna 182P · S/N 18261735Cancelled Mar 9, 2011 · Expired dealer · Built 1973 · Long Beach, CA N9272WPiper PA-28R-201 · S/N 2844006Cancelled Sep 28, 1999 · Exported to Japan · Long Beach, CA N350AFDassault-Breguet FALCON 50 · S/N 35Cancelled Jan 26, 1994 · Exported to Mexico · Long Beach, CA N92349Piper PA-28R-201 · S/N 2837052Cancelled Jun 3, 1992 · Exported to Japan · Long Beach, CA N92352Piper PA-28R-201 · S/N 2837053Cancelled Jun 3, 1992 · Exported to Japan · Long Beach, CA N4362PPiper PA-28-181 · S/N 288490033Cancelled Dec 3, 1990 · Exported to Japan · Long Beach, CA N758HFCessna R172K · S/N R1723103Cancelled May 3, 1979 · Exported to Mexico · Long Beach, CA N35747Cessna 210L · S/N 21060010Cancelled Aug 16, 1973 · Exported to Mexico · Long Beach, CA N60503Cessna U206F · S/N U20602026Cancelled Jul 16, 1973 · Exported to Mexico · Oakland, CA N51240Cessna TU206F · S/N U206 01986Cancelled Apr 6, 1973 · Exported to Mexico · Long Beach, CA N8247GCessna 177RG · S/N 177R G0147Cancelled Apr 20, 1972 · Exported to Mexico · Long Beach, CA N8991GCessna 182N · S/N 18260531Cancelled Aug 27, 1971 · Exported to Mexico · Built 1970 · Long Beach, CA N9118MCessna U206E · S/N U20601518Cancelled Aug 31, 1970 · Exported to Peru N5372SCessna 337A · S/N 337-0472Cancelled May 12, 1970 · Long Beach, CA N5423SCessna 337A · S/N 337-0523Cancelled May 12, 1970 · Long Beach, CA N72357Cessna TU206D · S/N U206-1379Cancelled Dec 31, 1969 · Exported to Australia · Long Beach, CA N3008UCessna 172E · S/N 17250608Cancelled Nov 20, 1967 · Freeland, MI N6955FCessna 150F · S/N 15063555Cancelled Nov 15, 1967 · Long Beach, CA N2711SCessna 150G · S/N 15066611Cancelled May 15, 1967 · Exported to Germany · Long Beach, CA N6050TCessna 150D · S/N 150-60750Cancelled Nov 5, 1964 · Long Beach, CA N5068UCessna 206 · S/N 206-0068Cancelled Mar 20, 1964 · Exported to Australia · Long Beach, CA N59347Consolidated Vultee BT-13A · S/N 3452Cancelled Jan 4, 1949 · Built 1942 · Houston 12, TX

Back to Airflite Inc