OpenAirDocs.org
Auburn, ME

Cancelled registrations · 31

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_state = 'ME' AND d.registrant_city = 'AUBURN'
  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.

N9593WPiper PA-28-140 · S/N 28-23041Cancelled Mar 4, 2021 · Exported to Mexico · Built 1967 · Ward Thomas RN701CSSchnitzlein Charles E ZENAIR CH-701 · S/N 7-3093Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1997 · Elder David WN249DSmallridge Denzil L 1650R · S/N 001Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Elder DavidN55740Air Creation CLIPPER · S/N A03105-3101Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 2000 · Dingley Peter NN20673Mackinnon Mark SEAREY · S/N 1DK278CCancelled Nov 12, 2014 · Registration expired, pending cancellation · Timoney JamesN52456Galaxy Balloons GALAXY 7 · S/N GLX-1037Cancelled May 30, 2013 · Registration expired, pending cancellation · Valcourt Daniel EN572BACessna 172N · S/N 17271675Cancelled Dec 2, 2009 · Triennial form not returned · Built 1979 · Twin Cities Air Service LLCN7413SBalloon Works FIREFLY 7 · S/N F7-280Cancelled Jul 23, 2009 · Triennial form not returned · Crites Walter WN19952Cessna 172M · S/N 17260882Cancelled Sep 30, 2008 · Triennial form not returned · Built 1972 · Twin Cities Air Service LLCN47105Cessna 152 · S/N 15283169Cancelled Oct 23, 2006 · Exported to Kenya · Built 1979 · Twin Cities Air Service LLCN511ARCessna T303 · S/N T30300192Cancelled Feb 12, 2002 · Triennial form not returned · Built 1982 · Twin Cities Air Service IncN47900Piper PA-28-161 · S/N 28-7816154Cancelled Mar 30, 2000 · Triennial form not returned · Twin Cities Air Service IncN1006VCessna R172K · S/N R1722076Cancelled Dec 11, 1991 · Exported to Canada · Mooney Francis J JrN704JECessna 150M · S/N 15078641Cancelled Apr 4, 1978 · Exported to Canada · Executive Aviation IncN9537HCessna 172M · S/N 172-66211Cancelled Mar 10, 1978 · Exported to Finland · Built 1976 · Executive Aviation IncN6714YPiper PA-23-250 (6PCLM) · S/N 27-4044Cancelled Mar 16, 1977 · Exported to Canada · Executive Aviation IncN4182JPiper PA-28-140 · S/N 28-22520Cancelled May 9, 1975 · Exported to Canada · Built 1966 · Executive Aviation IncN7344TCessna 172A · S/N 46944Cancelled Jun 4, 1973 · Bernard Harold J JrN3927AAeronca 7BCM · S/N 47-1042Cancelled Jan 9, 1973 · Exported to Canada · Built 1956 · Twin City Flying ClubN72596Cessna 140 · S/N 9768Cancelled Jul 18, 1969 · Exported to Canada · Tozier Stanley JrN3386BPiper PA-22 · S/N 22-2185Cancelled May 10, 1956 · Exported to Canada · Allard Chevrolet CoN3090EAeronca 7AC · S/N 7AC-6679Cancelled Oct 31, 1952 · Sky Harbor Flying ServiceN6225KRepublic RC-3 · S/N 431Cancelled May 25, 1949 · Gross Leroy CN36011Taylorcraft BL-65 · S/N 2976Cancelled Aug 23, 1948 · Built 1941 · Maheuxs Airport IncN1560EAeronca 7AC · S/N 7AC-5123Cancelled Aug 12, 1947 · Built 1946 · Dingley Henry M Jr / DBA Sky Harbor Flying ServiceN84662Aeronca 7AC · S/N 3374Cancelled Aug 12, 1947 · Sky Harbor Flying ServiceN8791Cessna AW · S/N 176Cancelled Jul 1, 1938 · Charest Wilfred JN10823Stinson SM-6000-B · S/N 5039Cancelled Jun 27, 1937 · Built 1931 · Charest Wilfred JN17586Taylor J-2 · S/N 1086Cancelled May 31, 1937 · Maheux Roland RobertN6583Ryan B1 · S/N 125Cancelled May 31, 1937 · Built 1929 · Maheux RolandN4182Travel Air 4000 · S/N 354Cancelled Nov 8, 1935 · Sherman Ernest A
Back to Auburn, ME