OpenAirDocs.org
Dodson Aviation Inc

Earlier aircraft under this name · 31

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

N478BBBeech A36 · S/N E2344Cancelled May 8, 2021 · Registration expired, pending cancellation · Ottawa, KSN117FRCessna 172P · S/N 17276602Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1986 · Ottawa, KSN552TRPiper AEROSTAR 600 · S/N 6008478161243Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1981 · Ottawa, KSN411BWMitsubishi Acft International MU-300-10 · S/N A1008 S.A.Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1985 · Ottawa, KSN9061EPiper PA-31-310 · S/N 31-522Cancelled Jan 16, 2013 · Expired dealer · Built 1969 · Ottawa, KSN8684YPiper PA-30 · S/N 30-1829Cancelled Mar 29, 2011 · Expired dealer · Built 1969 · Ottawa, KSN9756QSmith AEROSTAR 601P · S/N 61P-0374-121Cancelled Jan 7, 2011 · Expired dealer · Ottawa, KSN5459NPiper PA-28-180 · S/N 28-4145Cancelled Jan 6, 2011 · Expired dealer · Ottawa, KSN13963Piper PA-23-250 · S/N 27-4578Cancelled Jan 3, 2011 · Expired dealer · Built 1970 · Ottawa, KSN30MWPiper PA-31-310 · S/N 31-44Cancelled Jan 3, 2011 · Expired dealer · Built 1967 · Ottawa, KSN460PCPiper PA-23-250 · S/N 27-4675Cancelled Jan 3, 2011 · Expired dealer · Built 1971 · Ottawa, KSN90FFBritish Aerospace HS 125-700A · S/N NA0279Cancelled Feb 9, 2006 · Exported to South Africa · Built 1980 · Ottawa, KSN4610Boeing 727-35 · S/N 18811Cancelled Mar 12, 2004 · Exported to South Africa · Ottawa, KSN270AXBoeing 727-90C · S/N 19170Cancelled Oct 20, 2000 · Exported to São Tomé and Príncipe · Ottawa, KSN41441Aero Commander 680 · S/N 68037660Cancelled Sep 12, 1996 · Triennial form not returned · Ottawa, KSN2652ZCessna 501 · S/N 5010145Cancelled Jul 5, 1994 · Triennial form not returned · Ottawa, KSN7138CBeech B90 · S/N LJ446Cancelled May 24, 1993 · Ottawa, KSN928RDBeech C90 · S/N LJ680Cancelled Mar 2, 1992 · Exported to Canada · Ottawa, KSN6577BCessna 404 · S/N 4040102Cancelled Aug 8, 1991 · Exported to Germany · Ottawa, KSN20879Piper PA-31 · S/N 31-7401243Cancelled May 16, 1990 · Exported to Mexico · Built 1989 · Ottawa, KSN6601LPiper PA-31 · S/N 31-528Cancelled May 14, 1985 · Exported to Canada · Ottawa, KSN3790MPiper PA-28R-201T · S/N 28R-7803193Cancelled Feb 24, 1982 · Exported to Canada · Built 1978 · Ottawa, KSN55834Piper PA-28-140 · S/N 28-7325497Cancelled Dec 6, 1979 · Exported to Canada · Ottawa, KSN35971Cessna U206F · S/N U20602839Cancelled Sep 18, 1979 · Exported to Canada · Built 1975 · Ottawa, KSN8283SCessna 150F · S/N 15061883Cancelled Sep 27, 1978 · Exported to CanadaN10996Cessna 150L · S/N 15075189Cancelled Nov 28, 1977 · Built 1973 · Ottawa, KSN9079HCessna 172M · S/N 17265929Cancelled May 10, 1977 · Exported to SwitzerlandN7871GCessna 172L · S/N 17259571Cancelled Aug 24, 1976 · Exported to CanadaN11036Champion 7ECA · S/N 40Cancelled Jun 15, 1973 · Exported to Canada · Ottawa, KSN3812UCessna 336 · S/N 3360112Cancelled May 30, 1973 · Exported to Canada · Ottawa, KSN6420SCessna 150H · S/N 150-67220Cancelled Sep 30, 1970 · Exported to Canada · Kansas City, KS
Back to Dodson Aviation Inc