Floair Inc

Earlier aircraft under this name · 738

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

N404RMCessna 402B · S/N 402B0637Cancelled Oct 15, 1993 · Exported to South Africa · Wichita, KSN5458GCessna 404 · S/N 4040075Cancelled Aug 23, 1985 · Exported to Gabon · Wichita, KSN5172UCessna 172RG · S/N 172RG0273Cancelled Mar 5, 1982 · Exported to Hong Kong · Wichita, KSN6855XCessna 441 · S/N 441-0236Cancelled Oct 29, 1981 · Exported to Australia · Wichita, KSN4697JCessna A188B · S/N 18803763TCancelled Jul 30, 1981 · Exported to Syria · Wichita, KSN4803JCessna A188B · S/N 18803766TCancelled Jul 30, 1981 · Exported to Syria · Wichita, KSN4805JCessna A188B · S/N 18803767TCancelled Jul 30, 1981 · Exported to Syria · Built 1981 · Wichita, KSN4820JCessna A188B · S/N 18803769TCancelled Jul 30, 1981 · Exported to Syria · Wichita, KSN4834JCessna A188B · S/N 18803771TCancelled Jul 30, 1981 · Exported to Syria · Built 1981 · Wichita, KSN4837JCessna A188B · S/N 18803772TCancelled Jul 30, 1981 · Exported to Syria · Wichita, KSN711DBeech H-18 · S/N BA-671Cancelled Nov 24, 1980 · Exported to Indonesia · Wichita, KSN4CRCessna 550 · S/N 550-0045Cancelled Nov 13, 1980 · Built 1978 · Wichita, KSN731RBCessna A188B · S/N 18803086TCancelled Jul 3, 1980 · Exported to Singapore · Wichita, KSN734EXCessna U206G · S/N U20604829Cancelled Jul 3, 1980 · Exported to Philippines · Wichita, KSN5017VCessna R172K · S/N R1722273Cancelled Jun 25, 1980 · Exported to Philippines · Wichita, KSN731SECessna A188B · S/N 18803112TCancelled Jun 25, 1980 · Exported to Singapore · Wichita, KSN5695CCessna 414A · S/N 414A0224Cancelled Jun 24, 1980 · Exported to Australia · Wichita, KSN2625NCessna 441 · S/N 441-0130Cancelled Jun 23, 1980 · Exported to Australia · Built 1979 · Wichita, KSN26461Cessna 550 · S/N 550-0141Cancelled Jun 13, 1980 · Exported to Australia · Built 1980 · Wichita, KSN3175MCessna 402C · S/N 402C0287Cancelled Jun 5, 1980 · Exported to South Africa · Built 1980 · Wichita, KSN4763ECessna A185F · S/N 18503869Cancelled Jun 3, 1980 · Exported to Niger · Wichita, KSN88506Cessna 421C · S/N 421C0504Cancelled Mar 17, 1980 · Exported to Sri Lanka · Wichita, KSN758RYCessna R172K · S/N R1723311Cancelled Mar 5, 1980 · Exported to Indonesia · Wichita, KSN758RZCessna R172K · S/N R1723312Cancelled Mar 5, 1980 · Exported to Indonesia · Wichita, KSN6309UCessna U206G · S/N U20605414Cancelled Jan 15, 1980 · Exported to Gabon · Wichita, KSN756ZACessna R182 · S/N R18201199Cancelled Jan 3, 1980 · Exported to Gabon · Wichita, KSN2643XCessna 310R · S/N 310R1808Cancelled Dec 26, 1979 · Exported to Cameroon · Wichita, KSN2717FCessna 402C · S/N 402C0222Cancelled Dec 21, 1979 · Exported to South Africa · Wichita, KSN8807KCessna 404 · S/N 404-0418Cancelled Dec 15, 1979 · Exported to Taiwan · Wichita, KSN5366UCessna U206G · S/N U20605247Cancelled Nov 29, 1979 · Exported to Malaysia · Wichita, KSN5381UCessna U206 · S/N U20605262Cancelled Nov 29, 1979 · Exported to Malaysia · Wichita, KSN758CJCessna R172K · S/N R1722986Cancelled Nov 7, 1979 · Exported to Gabon · Wichita, KSN4755ECessna A185F · S/N 18503861Cancelled Oct 29, 1979 · Exported to Indonesia · Whicita, KSN4716ECessna A185F · S/N 18503846Cancelled Sep 25, 1979 · Exported to Niger · Wichita, KSN731ZYCessna A188B · S/N 18803297Cancelled Sep 13, 1979 · Exported to Côte d’Ivoire · Wichita, KSN732HXCessna 210L · S/N 21061536Cancelled Sep 13, 1979 · Exported to Australia · Wichita, KSN46958Britten-Norman BN-2A-21 · S/N C584Cancelled Aug 14, 1979 · Exported to Indonesia · Wichita, KSN8799KCessna 404 · S/N 404-0414Cancelled Aug 9, 1979 · Exported to Singapore · Wichita, KSN4621UCessna U206G · S/N U20605006Cancelled Aug 8, 1979 · Exported to Malaysia · Wichita, KSN4819UCessna U206G · S/N U20605115Cancelled Aug 8, 1979 · Exported to Malaysia · Wichita, KSN733UKCessna U206G · S/N U20604793Cancelled Jun 26, 1979 · Exported to Gabon · Wichita, KSN756GPCessna U206G · S/N U20604082Cancelled Jun 13, 1979 · Exported to Philippines · Wichita, KSN49322Cessna 152 · S/N 15283447Cancelled Jun 12, 1979 · Exported to Philippines · Built 1979 · Wichita, KSN8361QCessna U206F · S/N U20603222Cancelled May 30, 1979 · Exported to Philippines · Wichita, KSN46978Cessna 152 · S/N 15283155Cancelled May 25, 1979 · Exported to Germany · Wichita, KSN68347Cessna 152 · S/N 15282274Cancelled May 15, 1979 · Exported to Germany · Wichita, KSN46802Cessna 152 · S/N 15283107Cancelled May 14, 1979 · Exported to Germany · Wichita, KSN5224ECessna 172N · S/N 17271780Cancelled May 14, 1979 · Exported to Germany · Wichita, KSN756GSCessna U206G · S/N U20604085Cancelled May 10, 1979 · Exported to Singapore · Wichita, KSN47072Cessna 152 · S/N 15283165Cancelled May 4, 1979 · Exported to Indonesia · Wichita, KS
Back to Floair Inc