Skip to content

Airflite Inc South

Earlier aircraft under this name · 55

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

N37479Cessna 421C · S/N 421C0416Cancelled Nov 4, 1983 · Exported to Mexico · Built 1977 · Long Beach, CA N92606Cessna 172M · S/N 17261593Cancelled Oct 1, 1983 · Administratively canceled · Long Beach, CA N7348CCessna T210N · S/N 21063940Cancelled Jun 10, 1981 · Exported to Mexico · Long Beach, CA N2742NCessna 414A · S/N 414A0621Cancelled Jun 9, 1981 · Exported to Mexico · Long Beach, CA N5380XCessna TU206G · S/N U20605696Cancelled Jun 20, 1980 · Exported to Australia · Long Beach, CA N4158GCessna 402B · S/N 402B1205Cancelled Jun 2, 1977 · Exported to Mexico · Long Beach, CA N1213QCessna U206F · S/N U20602874Cancelled Apr 2, 1976 · Exported to Mexico · Built 1975 · Long Beach, CA N1249QCessna TU206F · S/N U20602876Cancelled Mar 11, 1976 · Exported to Mexico · Built 1975 · Long Beach, CA N1457QCessna TU206F · S/N U206-02901Cancelled Mar 11, 1976 · Exported to Mexico · Ling Beach, CA N1195QCessna TU206F · S/N U20602865Cancelled Jan 1, 1976 · Exported to Mexico · Long Beach, CA N1318QCessna TU206F · S/N U20602881Cancelled Jan 1, 1976 · Exported to Mexico · Built 1975 · Long Beach, CA N6042FCessna 182P · S/N 18264065Cancelled Dec 30, 1975 · Exported to Mexico · Long Beach, CA N9912ECessna 182P · S/N 18263972Cancelled Dec 29, 1975 · Exported to Mexico · Long Beach, CA N94271Cessna 210L · S/N 21060575Cancelled Dec 17, 1975 · Exported to Mexico · Long Beach, CA N1546GCessna 421B · S/N 421B0642Cancelled Nov 8, 1975 · Exported to Mexico · Long Beach, CA N5030JCessna 310R · S/N 310R0150Cancelled Nov 5, 1975 · Exported to Mexico · Built 1974 · Long Beach, CA N33289Cessna TU206F · S/N U20602714Cancelled Aug 28, 1975 · Exported to Mexico · Long Beach, CA N1746XCessna 210 · S/N 21060767Cancelled May 5, 1975 · Exported to Mexico · Built 1975 · Long Beach, CA N5739JCessna 182P · S/N 18263508Cancelled Apr 17, 1975 · Exported to Mexico · Long Beach, CA N1340GCessna 310R · S/N 310R0024Cancelled Dec 17, 1974 · Exported to Mexico · Long Beach, CA N1368VCessna U206F · S/N U20602586Cancelled Dec 13, 1974 · Exported to Mexico · Long Beach, CA N94112Cessna 210L · S/N 21060510Cancelled Nov 19, 1974 · Exported to Mexico · Long Beach, CA N94033Cessna 210L · S/N 21060486Cancelled Nov 1, 1974 · Exported to Mexico N7444NCessna 182P · S/N 18263222Cancelled Oct 18, 1974 · Exported to Mexico · Long Beach, CA N7447NCessna 182P · S/N 18263225Cancelled Sep 26, 1974 · Exported to Mexico · Long Beach, CA N1232VCessna U206F · S/N U20602525Cancelled Sep 12, 1974 · Exported to Mexico · Long Beach, CA N7776QCessna 340 · S/N 340-0209Cancelled Jul 3, 1974 · Exported to Australia · Long Beach, CA N2455UCessna U206 · S/N U20602377Cancelled May 24, 1974 · Exported to Mexico · Long Beach, CA N93192Cessna T210L · S/N 21060304Cancelled May 24, 1974 · Exported to Mexico · Long Beach, CA N7268NCessna 182P · S/N 18263057Cancelled May 23, 1974 · Exported to Mexico · Long Beach, CA N2218UCessna TU206F · S/N U20602356Cancelled May 15, 1974 · Exported to Mexico · Long Beach, CA N52331Cessna 182P · S/N 18262533Cancelled Apr 25, 1974 · Exported to Mexico · Long Beach, CA N69948Cessna T310Q · S/N 310Q1039Cancelled Apr 3, 1974 · Exported to Mexico · Long Beach, CA N52720Cessna 182P · S/N 18262797Cancelled Feb 22, 1974 · Exported to Mexico · Long Beach, CA N7488QCessna U206 · S/N U20602222Cancelled Jan 29, 1974 · Exported to Mexico · Long Beach, CA N1545UCessna U206F · S/N U20602252Cancelled Jan 17, 1974 · Exported to Mexico · Built 1973 · Long Beach, CA N71527Cessna TU206F · S/N U20602151Cancelled Sep 19, 1973 · Exported to Mexico · Long Beach, CA N71684Cessna U206F · S/N U20602159Cancelled Sep 10, 1973 · Exported to Mexico N70666Cessna U206F · S/N U20602092Cancelled Jun 25, 1973 · Exported to Mexico · Long Beach, CA N91076Cessna 182P · S/N 18261951Cancelled May 17, 1973 · Exported to Mexico · Long Beach, CA N21470Cessna 182P · S/N 18261651Cancelled Mar 1, 1973 · Exported to Mexico · Long Beach, CA N6267QCessna 310Q · S/N 310Q0525Cancelled Nov 14, 1972 · Exported to Mexico N1165QCessna T210L · S/N 21059665Cancelled Sep 13, 1972 · Exported to Mexico · Long Beach, CA N20864Cessna 182P · S/N 18261268Cancelled Sep 13, 1972 · Exported to Mexico · Long Beach, CA N20873Cessna 182P · S/N 18261277Cancelled Sep 13, 1972 · Exported to Mexico · Built 1972 · Long Beach, CA N20776Cessna 182P · S/N 18261194Cancelled Jun 21, 1972 · Exported to Mexico · Long Beach, CA N5116QCessna 210L · S/N 21059616Cancelled Jun 21, 1972 · Exported to Mexico · Long Beach, CA N8100GCessna 210K · S/N 210-59400Cancelled Jun 6, 1972 · Exported to Mexico · Built 1970 · Long Beach, CA N8252GCessna 177RG · S/N 177RG0152Cancelled May 18, 1972 · Exported to Mexico · Long Beach, CA N4698QCessna T210L · S/N 21059598Cancelled Apr 27, 1972 · Exported to Mexico · Long Beach, CA

Back to Airflite Inc South