Cancelled registrations · 41

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 = 'ELMHURST' 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 = 'ELMHURST'
  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 = 'ELMHURST'
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.

N312SAEurocopter Deutschland EC135P1 · S/N 0054Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1998 · Bennett Aviation LLC N3557FCessna 182J · S/N 18257557Cancelled Mar 16, 2018 · Revoked, canceled · Built 1966 · Van Toorn Gerardus Johannes N218MXConnon Richard L MONERAI · S/N M218-2Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Cannon Richard L N9566ZBeech C-45H · S/N AF-845Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1952 · Rupa Flyers N694APiper PA-22 · S/N 22-97Cancelled Sep 3, 2014 · Revoked, canceled · Built 1951 · Byrne Daniel N7181KBerson L / Couden R M LONG EZ · S/N 602LCancelled Sep 24, 2013 · Registration expired, pending cancellation · Berson Lawrence N6621MStinson 108-3 · S/N 108-4621Cancelled Aug 14, 2013 · Revoked, canceled · Built 1948 · Conover William L N13CRRebold Curt B-8M · S/N STRWY-2-HVNCancelled May 30, 2013 · Registration expired, pending cancellation · Built 1981 · Rebolt Curt A N40712Piper PA-32-260 · S/N 32-7400021Cancelled Sep 18, 2012 · Exported to Guyana · Built 1973 · First American Realtors Inc N3301APiper PA-22 · S/N 22-1581Cancelled Jul 13, 2011 · Revoked, canceled · Built 1953 · Mcelroy John N111RZBritish BAC 1-11 401/AK · S/N BAC.056Cancelled Nov 14, 2008 · Triennial form not returned · Built 1965 · R O II Inc N7133JMooney M20C · S/N 3116Cancelled May 10, 2002 · Triennial form not returned · Built 1965 · Albin Gregory N2598UCessna 172D · S/N 17250198Cancelled Apr 26, 1996 · Triennial form not returned · Byrne Amyrose N6326YCessna T210N · S/N 21064336Cancelled Feb 1, 1991 · Triennial form not returned · Bagge Allan E N2271QPiper PA-28-161 · S/N 28-7716093Cancelled May 30, 1984 · Administratively canceled · Hermetet Ira E N3856GCessna U206B · S/N U206-0856Cancelled Dec 16, 1981 · Built 1967 · International Flying Club Inc N60715Cessna 150J · S/N 15070521Cancelled Apr 3, 1975 · Exported to Switzerland · Schmid Henry N28543Luscombe 8A · S/N 1372Cancelled Feb 21, 1974 · Welin John C N18500Arrow F · S/N 43Cancelled Oct 6, 1970 · Robert W Siegfried N28945Ercoupe 415-C · S/N 40Cancelled Jun 18, 1970 · Mcglashan Andrew N71117Luscombe 8A · S/N 2544Cancelled May 21, 1965 · Mcnamara James E N9806KStinson 108-2 · S/N 108-2806Cancelled May 21, 1965 · Klein George J N3809KTemco GC-1B · S/N 1502Cancelled May 20, 1965 · Cottle Richard A N657QBeech 95 · S/N TD-216Cancelled Dec 17, 1964 · Exported to Switzerland · Leo Seren N2043CBeech 95 · S/N TD-222Cancelled Dec 18, 1963 · Exported to Switzerland · Seren Leo N2442HEngineering & Research 415-C · S/N 3067Cancelled Jun 6, 1962 · Exported to Canada · York Aero Club N9541RBeech K35 · S/N D-6091Cancelled Jun 1, 1962 · Exported to France · Seren Leo N1339APiper PA-18 · S/N 18-1143Cancelled May 21, 1956 · Tufts-Edgcumbe Inc N3648KPiper J3C-65 · S/N 22340Cancelled Feb 14, 1956 · Northern Illionis Airways Inc N1532NPiper J3C-65 · S/N 23064Cancelled Oct 5, 1955 · B & M Aircraft Maintenance N37108Engineering & Research ERCOUPE 415-C · S/N 75Cancelled Oct 25, 1954 · Built 1941 · B& M Aircraft Maintenance N6885KPiper PA-16 · S/N 16-729Cancelled Jun 13, 1952 · Tufts Edgcumbe Inc N3654KPiper J3C-65 · S/N 22343Cancelled Sep 7, 1951 · Tufts Edgecumbe Inc N77641Fairchild 24R-46 · S/N R46341Cancelled Aug 2, 1951 · Exported to Canada · Alvin E Anderson N5541NAnderson Propeller Special A1 · S/N 1Cancelled Aug 31, 1950 · Built 1948 · Anderson Alvin E N3208NPiper J3C-65 · S/N 22399Cancelled Nov 17, 1948 · Built 1946 · Tufts Edgcumbe Inc N48122Fairchild M-62A · S/N T43-5658Cancelled Oct 28, 1948 · Mitchell K T N481NTravel Air B-4000 · S/N 1396Cancelled Mar 3, 1948 · Stanley Paul R N13640Hankinson Nathan A HANKINSON-HEATH V · S/N 1Cancelled May 17, 1939 · Seaman Walter E N802Monocoupe 70 · S/N 107Cancelled Mar 31, 1935 · Abbout L W N489YStinson SM-8A · S/N M-4285Cancelled Apr 27, 1931 · Built 1930 · Brazelton Edgar E

Back to Elmhurst, IL