OpenAirDocs.org
Fontana Aviation Inc

Earlier aircraft under this name · 25

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

N7264TCessna 172A · S/N 46864Cancelled Jan 9, 1978 · Iron Mountain, MIN1775GBeech H-18 · S/N BA-635Cancelled Dec 20, 1977 · Iron Mountain, MIN454HCessna 421A · S/N 421A0155Cancelled Dec 15, 1977 · Built 1969 · Iron Mountain, MIN5396JCessna 421B · S/N 0946Cancelled Dec 15, 1977 · Iron Mountain, MIN73033Cessna 172M · S/N 17267244Cancelled Jan 25, 1977 · Exported to Canada · Iron Mountain, MIN3945QCessna 172L · S/N 172 60045Cancelled Sep 23, 1976 · Exported to Canada · Iron Mountain, MIN4PACessna 414 · S/N 414-0515Cancelled Aug 17, 1976 · Exported to Germany · Built 1974 · Iron Mountain, MIN6800YPiper PA-23-250 (6PCLM) · S/N 27-4137Cancelled Aug 3, 1976 · Exported to Canada · Iron Mountain, MIN9161MCessna 182P · S/N 182 64710Cancelled Jul 7, 1976 · Exported to Canada · Iron Mountain, MIN18830Cessna 320E · S/N 320E0107Cancelled Jun 3, 1976 · Exported to Canada · Built 1967 · Iron Mountain, MIN8101QCessna 414 · S/N 414-0001Cancelled Feb 26, 1976 · Exported to Canada · Iron Mountain, MIN87236Cessna T310R · S/N 310R0313Cancelled Oct 22, 1975 · Exported to Canada · Iron Mountain, MIN30263Cessna 172M · S/N 17264128Cancelled Sep 17, 1975 · Exported to Canada · Iron Mountain, MIN21375Cessna 172M · S/N 17263939Cancelled Apr 2, 1975 · Exported to Canada · Built 1974 · Iron Mountain, MIN72FABeech H-18 · S/N BA-631Cancelled Feb 10, 1975 · Iron Mountain, MIN73FABeech H-18 · S/N BA-649Cancelled Nov 7, 1974 · Iron Mountain, MIN6122FCessna 210H · S/N 21059022Cancelled Jun 27, 1974 · Exported to Canada · Iron Mountain, MIN12817Cessna 172M · S/N 17262287Cancelled Jun 14, 1974 · Exported to CanadaN11969Cessna 150L · S/N 15075747Cancelled May 10, 1974 · Exported to CanadaN52627Cessna 182P · S/N 18262724Cancelled Feb 27, 1974 · Exported to Canada · Iron Mountain, MIN11296Cessna 150L · S/N 15075306Cancelled Nov 30, 1973 · Exported to Canada · Built 1973 · Iron Mountain, MIN12967Cessna 172M · S/N 17262412Cancelled Nov 30, 1973 · Exported to Canada · Built 1973 · Iron Mountain, MIN70374Cessna A185F · S/N 18502134Cancelled Apr 24, 1973 · Exported to Canada · Built 1973 · Iron Mountain, MIN19961Cessna 172M · S/N 17260890Cancelled Jan 17, 1973 · Exported to Canada · Built 1972 · Iron Mountain, MIN550Howard DGA-15P · S/N 1747Cancelled Sep 23, 1959 · Iron Mountain, MI
Back to Fontana Aviation Inc