Skip to content

Cancelled registrations · 40

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

N77TLLuark Ted KIT FOX · S/N 77Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Babczak John N5815ZPiper PA-22-108 · S/N 22-9672Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1963 · Rothrock Virgil Jr N33285Piper J4A · S/N 4-1353Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1940 · Rothrock Virgil Jr N2904ZPiper PA-22-160 · S/N 22-6870Cancelled Jul 19, 2017 · Registration expired, pending cancellation · Built 1959 · Rothrock Virgil Jr N18504State Securities ARROW F · S/N 47Cancelled Feb 4, 2017 · Revoked, pending cancellation · Streator Air Svc N73061Cessna 140 · S/N 10273Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Proud Kline S N7366ACessna 172 · S/N 29466Cancelled Feb 4, 2017 · Revoked, canceled · Built 1956 · Hallam James F N446RARemos REMOS GX · S/N 255Cancelled Aug 27, 2013 · Sale reported, canceled · Built 2008 N66CJMurphy RV-3 · S/N 118Cancelled Aug 14, 2013 · Revoked, canceled · Built 1975 · Mcdonald Cedric J N61949Fairchild M-62C(PT-23A) · S/N 321HOCancelled Aug 5, 2013 · Revoked, canceled · Built 1943 · Burns John R N113QQAnnis Aldon S QUICKIE Q 2 · S/N 2113Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1982 · Annis Aldon P N9644DPiper PA-22-150 · S/N 22-6558Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1959 · Rothrock Virgil Jr N5705ZPiper PA-22-108 · S/N 22-9543Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1962 · Rothrock Virgil Jr N5828ZPiper PA-22-108 · S/N 22-9685Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1963 · Rothrock Virgil Jr N45660Aeronca 11AC · S/N 11AC-1307Cancelled Apr 1, 2013 · Sale reported, canceled N4388FCarden John E III CHALLENGER II · S/N CH20192-0780Cancelled Sep 10, 2012 · Registration pending, canceled · Built 1993 N64316Howard DGA-15P · S/N 806Cancelled Sep 5, 2012 · Revoked, canceled · Built 1943 · Missel Leonard N46578Laister-Kauffman LK-10A · S/N 146Cancelled Jul 31, 2012 · Revoked, canceled · Built 1943 · Knoedler Dick N96289Taylorcraft BC12-D · S/N 8589Cancelled Sep 21, 2009 · Registration revoked · Built 1946 · Steator Air Service N9801HCessna T-50 · S/N 3819Cancelled Sep 18, 2009 · Registration revoked · Built 1942 · Streator Air Svc N96093Taylorcraft BC12-D · S/N 8393Cancelled Sep 17, 2009 · Registration revoked · Built 1946 · Streator Air Service N30BRBenckendorf-Renner KR-2 · S/N 1166-ACCancelled Apr 25, 2003 · Triennial form not returned · Built 1976 · Benchendorf R S N5325NBoeing E75 · S/N 75-5989Cancelled Mar 29, 1999 · Exported to Turkey · Rothrock Virgil N Jr N2918YCessna 182E · S/N 18253918Cancelled Jul 10, 1979 · Exported to Canada · Perkins Larry A N5900YPiper PA-23-250 (6PCLM) · S/N 27-3055Cancelled Feb 9, 1978 · Jarrett Robert T N3325VBeech B35 · S/N D-786Cancelled Nov 15, 1973 · B & S Aviation N41180Piper J5A · S/N 5-1268Cancelled Sep 23, 1970 · Grooms John N7240DPiper PA-22-150 · S/N 22-5066Cancelled Jun 26, 1970 · Opdyckes Inc N3574JCessna 150E · S/N 15061274Cancelled Jul 26, 1966 · Knoedler Dick N5163CBeech B35 · S/N D2448Cancelled May 20, 1965 · Streator Decorating Co N42328Piper J3C-65 · S/N 14578Cancelled Oct 27, 1960 · Exported to Iceland · Proud Kline S DBA Streator Air Services N9073ACessna 170A · S/N 18832Cancelled Feb 25, 1957 · Exported to Germany · Duis Electric Co N52034Consolidated Vultee SNV-2 · S/N 79-217Cancelled Nov 22, 1955 · Built 1943 · Matsick Billie N92054Piper J3C-65 · S/N 16487Cancelled Apr 7, 1955 · Exported to Mexico · Proud Kline S N47150Fairchild M-62A · S/N T43-5983Cancelled Mar 31, 1955 · Proud Kline S N84648Aeronca 7AC · S/N 7AC-3366Cancelled Oct 24, 1951 · Proud Kline N48325Fairchild M-62A · S/N 334SLCancelled Aug 17, 1951 · Streator Air Service N84170Aeronca 7AC · S/N 7AC-2858Cancelled Mar 18, 1949 · Paul S Willard N55012Cessna UC-78 · S/N 2603Cancelled Dec 7, 1948 · Kakara Lawrence E N9874Travel Air E-4000 · S/N 1060Cancelled Jun 27, 1932 · Hill Harry N

Back to Streator, IL