Cancelled registrations · 23

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 = 'IL' AND d.registrant_city = 'MUNDELEIN' 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 = 'IL' AND d.registrant_city = 'MUNDELEIN'
  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 = 'IL' AND d.registrant_city = 'MUNDELEIN'
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.

N260GKPiper PA-32-260 · S/N 32-1073Cancelled Dec 6, 2023 · Exported to Canada · Built 1968 · Ye Weihang N24044Taylorcraft BL · S/N 1579Cancelled Mar 23, 2018 · Revoked, canceled · Built 1939 · Hannaford Foster Jr N2629BWagner Nathan D HART BIRD II · S/N HB2-004Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Wagner Nathan D N203FSHarmenings High Flyers STANDARD · S/N HHF5857Cancelled May 20, 2015 · Registration pending, canceled · Built 1997 N2015FBalloon Works FIREFLY 7 · S/N 190Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1974 · Strand C R N549LSFlight Design CTLS · S/N 07-11-19Cancelled Jul 9, 2014 · Second renewal notice · Built 2007 · Mayworm Daniel E N91BDBede James R BD-9 · S/N 0001Cancelled Sep 18, 2013 · Registration expired, pending cancellation · Built 1983 · Bede James R N104APRaven S55A · S/N S55A-749Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1981 · Fay Peter C N408TCThunder & Colt Airborne Amer AX6-65S1 · S/N 2157USACancelled Jul 30, 2013 · Sale reported, canceled · Built 1992 N6063VPiper PA-18 · S/N 18-921Cancelled Apr 10, 2013 · Revoked, canceled · Sky Soaring Inc N83HSSorensen Harvey L QUICKIE Q-2 · S/N 2458Cancelled Apr 2, 2013 · Built 1983 · Butler William G N76DPPiccard AX-6 · S/N 723Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1974 N1700UPiper PA-23-160 · S/N 23-1346Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1958 · Production Group Alpha Inc N1738Bensen B-8M · S/N 1Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1968 · Garrett Paul E N47552Fairchild 24 G · S/N 2916Cancelled Aug 6, 2012 · Revoked, canceled · Built 1937 · Henrotte Emil J N3988BSmith/Forrest ROTEC RALLY 3A · S/N 25320Cancelled Mar 15, 2005 · Second triennial mailing, no response · Built 1983 · Smith David M N47EEBeech 35 · S/N D-788Cancelled Apr 29, 2004 · Triennial form not returned · Built 1947 · Weidner Brian T N9726ALotter-Robert SONERAI · S/N 00116Cancelled Jan 3, 1992 · Triennial form not returned · Lotter Robert F N83262Piper PA-34-220T · S/N 348133004Cancelled Feb 14, 1991 · Exported to Italy · Ocker Larry W N3912HEngineering & Research ERCOUPE 415-CD · S/N 4613Cancelled Jun 24, 1976 · Crunk Thomas C N2746CCessna 170B · S/N 26290Cancelled Sep 26, 1974 · Exported to Canada · Ostrowski John V & Bateman John R N3746EAeronca 11AC · S/N 11AC-S1Cancelled Aug 22, 1973 · Barlow Richard E N3305APiper PA-22-135 · S/N 22-1578Cancelled Sep 4, 1970 · James J Beranek

Back to Mundelein, IL