Joliet, IL

Cancelled registrations · 77

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

N5205CBeech B35 · S/N D-2550Cancelled Nov 30, 1971 · Barthelme Charles EN45936Luscombe 8A · S/N 2463Cancelled Jan 18, 1971 · Martin P HaleyN1872HCessna 310C · S/N 35972Cancelled Jan 4, 1971 · Yonely JohnN36VBeech AT-11 · S/N 6514Cancelled Jun 26, 1970 · Rubens Robert GN2603GCessna 182B · S/N 51903Cancelled Jun 19, 1970 · Spencer Layton CN2171PPiper PA-23 · S/N 23-776Cancelled May 21, 1965 · Rubens Robert GN7838TCessna 172A · S/N 47438Cancelled May 20, 1965 · Markgraf Richard LN800UBeech D18S · S/N A218Cancelled Oct 20, 1964 · Pietsch Leonard CN30673Piper J3L-65 · S/N 5043Cancelled Jun 26, 1964 · Exported to Canada · Built 1940 · Dupee Robert SN5276BMooney M20 · S/N 1139Cancelled Jan 4, 1962 · Reynolds-CollinsN1905DBeech C35 · S/N D-3183Cancelled Mar 29, 1956 · Matthews WilburN64795Cessna T-50 · S/N 5197Cancelled May 23, 1955 · Matthews Wilbur CN86218Aeronca 11AC · S/N 11AC-22Cancelled Nov 5, 1952 · Marshall Edgar BN86020Aeronca 11AC · S/N 11AC-439Cancelled Oct 17, 1951 · Built 1946 · Ohlhaver Harry BN47309Ryan Aeronautical ST3KR · S/N 1808Cancelled Aug 1, 1951 · Kaynish HerbertN34244Frankfort GLIDER B · S/N B-1-9Cancelled Nov 26, 1948 · Frankfort Sailplane CompanyyN34207Frankfort GLIDER B · S/N A-1-2Cancelled Aug 16, 1948 · Frankfort Sailplane CompanyN8759Swallow TP · S/N 159Cancelled Apr 2, 1948 · Demple Harold FelixN34211Frankfort GLIDER B · S/N A-1-4Cancelled Sep 29, 1947 · Frankfort Sailplane CompanyN18238Payne MC-7 · S/N 102Cancelled Oct 15, 1938 · Payne Aircraft CorpN9320Nicholas Beazley NB-3 · S/N 22Cancelled Apr 20, 1935 · Joliet Park District IncN5185Texas Aero TEMPLE C4 · S/N 104Cancelled Feb 16, 1933 · Oliver Harvey TN2189Standard J-1 · S/N 963Cancelled Jan 7, 1932 · Built 1927 · Stanley Verdie CN5376Thomas Morse S4C · S/N 226Cancelled Nov 19, 1931 · Herman J WilhelmiN10477Marsh-Obannon MARSH-OBANNON · S/N P-228Cancelled Aug 19, 1931 · Built 1930 · Birsa LudwigN4108Travel Air 2000 · S/N 339Cancelled Mar 28, 1930 · Johnson Carl EN822Thomas Morse SB4 · S/N 200Cancelled Oct 11, 1929 · Michael Cassidy & Maurice Hebert
Back to Joliet, IL