Skip to content

Cancelled registrations · 33

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_state = 'MO' AND d.registrant_city = 'FLORISSANT' 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_state = 'MO' AND d.registrant_city = 'FLORISSANT'
  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_state = 'MO' AND d.registrant_city = 'FLORISSANT'
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.

N322DGGlennie Donald G TEAM 1600 R · S/N MK594Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 2006 · Glennie Donald G N851DRRuffell David Lewis RIDGE RUNNER MDL II · S/N 100501065Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2003 · Mcgougan David W N87833Delaney EASYRISER · S/N FF2FFCancelled Mar 16, 2018 · Revoked, canceled · De Laney Taylor A N2316ZBeech 23 · S/N M-19Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1962 · Powers Stephen M N17981Piper J-2 · S/N 1581Cancelled Oct 28, 2017 · Revoked, canceled · Built 1937 · Weston Charles N Jr N859RBeech 35-33 · S/N CD-16Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1959 · Midwest Sewing Co N6580NBellanca 14-19 · S/N 2033Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1950 N34305Meyers OTW-145 · S/N 50Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1941 · St Louis Aviation Museum N9981Robert Lindsay B-8M · S/N RKLG-1Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1970 N5441CCessna 170B · S/N 19475Cancelled Aug 22, 2012 · Revoked, canceled · Built 1950 · Wanlowski John B N5MWBalloon Works FIREFLY 7 · S/N 7918Cancelled Jul 19, 2012 · Registration expired, pending cancellation · Samco Enterprises Ltd DBA N2611CCessna 402C · S/N 402C0071Cancelled Apr 14, 2011 · Expired dealer · Built 1979 · Butler Graham J DBA N616GLBritten-Norman BN-2A-27 · S/N 616Cancelled Dec 11, 2006 · Triennial form not returned · Expomax Enterprises Inc N8HEPiper PA-31-350 · S/N 317852102Cancelled Aug 1, 1996 · Exported to Thailand · Tsd Leasing Co Ltd N27LCMaggert Charles H GN-1 AIRCAMPER · S/N 925Cancelled Nov 12, 1992 · Second triennial mailing, no response · Maggart Charles H N931VNPiper PA-32-300 · S/N 327740084Cancelled Oct 16, 1991 · Web Associates Electronics Inc N6753FCessna 150F · S/N 15063353Cancelled Jun 4, 1991 · Triennial form not returned · Clay Robert D N6372YCessna 210N · S/N 210-64356Cancelled Apr 2, 1984 · Exported to Australia · Butler Graham J DBA Southern Cross Credit N6457NCessna 210N · S/N 210-63031Cancelled Dec 28, 1982 · Exported to Australia · Butler Graham J N6431VCessna 172 · S/N 172RG-0692Cancelled Nov 23, 1982 · Exported to Australia · Butler Graham J DBA Southern Cross Credit N5633DMaule M-5-235C · S/N 7258CCancelled Nov 18, 1982 · Exported to Australia · Built 1979 · Butler J Graham DBA Souther Cross Credit N40CWWeston THORP T-18 · S/N 100CWCancelled Sep 2, 1982 · Revoked, pending cancellation · Weston Charles N Jr N66910Beech 58 · S/N TH-1103Cancelled Jun 9, 1982 · Exported to Australia · Graham J Butler DBA Southern Cross Credit N3702DBeech 58 · S/N TH-1185Cancelled Jan 5, 1982 · Exported to Australia · Built 1980 N40BHCessna 402C · S/N 402C0262Cancelled Jan 5, 1982 · Exported to Australia · Built 1980 · Butler Graham N6752LBeech 58 · S/N TH-1134Cancelled Jan 5, 1982 · Exported to Australia · Graham J Butler DBA Southern Cross Credit N2646DCessna 310R · S/N 310R1821Cancelled Dec 9, 1981 · Exported to Australia · Built 1979 · Butler Graham J DBA N1774GCessna 402C · S/N 402C0273Cancelled Jun 17, 1981 · Exported to Australia · Built 1980 · Butler Graham J DBA N181MBierman CASSUTT IIIM · S/N BDB-1Cancelled Jul 2, 1980 · Built 1970 · Housley John M N3009HErcoupe 415-C · S/N 3634Cancelled May 20, 1975 · Built 1964 · Garrett William T N13879Piper PA-18-150 · S/N 18-8966Cancelled Jul 20, 1973 · Saint Louis Soaring Association Inc N3323CBeech E35 · S/N D-3989Cancelled May 25, 1965 · Broughton John A & George D Keller N32727Piper J3C-65 · S/N 5562Cancelled Aug 16, 1954 · Built 1940 · Galli Charles

Back to Florissant, MO