Aurora, IL

Cancelled registrations · 72

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

N1796ZCessna 336 · S/N 3360096Cancelled Dec 29, 1970 · Missionaries Of The Sacred HeartN27506Taylorcraft BF-65 · S/N 2148Cancelled Jun 12, 1970 · Built 1940 · Stratman Joseph HN155JMCessna P206 · S/N P206-0108Cancelled Nov 26, 1969 · Exported to Australia · Society Of The Missionaries Of The Sacred HeartN4501LEvangel Air 4500-300 · S/N 001Cancelled Mar 18, 1968 · Built 1964 · Evangel-Air IncN645SBuck Richard D PUDDLE JUMPER · S/N 1Cancelled Nov 24, 1965 · Buck Richard DN39921Taylorcraft BC12-D · S/N 6574Cancelled Sep 15, 1959 · Built 1945 · Weiland Donald GN88428Piper J3C-65 · S/N 16046Cancelled Feb 24, 1956 · Built 1946 · Crop Guard IncN69691Fairchild M-62C · S/N 3083AECancelled Oct 14, 1955 · Hessler Edmund JN3008KCulver V · S/N V-227Cancelled Oct 5, 1955 · Edward C PriceN36187Taylorcraft BF-65 · S/N 3076Cancelled Dec 9, 1954 · Nuebert A HN72054Luscombe 8A · S/N 3481Cancelled Oct 6, 1954 · Lab Flying ClubN4682CCessna 170B · S/N 25626Cancelled Mar 12, 1954 · Stansbury A EN5511NAeronca 7AC · S/N 7AC6832Cancelled Sep 7, 1951 · Built 1947 · Aurora AirwaysN9881Swallow TP · S/N 181Cancelled Mar 15, 1938 · Fox Valley Flying ServiceN823VWaco NAZ · S/N 4021Cancelled Jul 11, 1936 · Midwest Airways CorpN781KWaco GXE · S/N 2085Cancelled Nov 9, 1934 · George W BrayN13605Thompson Bros Balloon THOMPSON HOT AIR · S/N 122Cancelled Apr 26, 1934 · Built 1933 · Thompson Brothers Balloon & Parachute CoN818VWaco NAZ · S/N 4025Cancelled Mar 13, 1933 · Midwest Airways CorporationN820VWaco NAZ · S/N 4020Cancelled Mar 13, 1933 · Midwest Airways CorpN801VWaco NAZ · S/N 4002Cancelled Mar 8, 1933 · Midwest Airways CorporationN333VEvans Allsteel Glider GLIDER · S/N 176Cancelled Jan 11, 1933 · Built 1930 · Frazier Donald PN10104Hotchkiss Warren HEATH PARASOL · S/N 1001Cancellation date not recorded · Hotchkiss Warren G
Back to Aurora, IL