Indianapolis, IN

Cancelled registrations · 559

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 = 'IN' AND d.registrant_city = 'INDIANAPOLIS'
  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.

N695EEGulfstream Aerospace 695B · S/N 96205Cancelled Jan 23, 2019 · Exported to Canada · Eagle Creek Aviation Services IncN3017Phillips Auto-Gyro PA1067 · S/N CP-1Cancelled Dec 17, 2018 · Revoked, canceled · Phillips Calvin HN38249Piper J5A · S/N 5920Cancelled Nov 17, 2018 · Revoked, pending cancellation · Gerdts David BN825WVDJI INSPIRE 1 · S/N W13DDA12060039Cancelled Oct 17, 2018 · Wthr-TvN5570JDJI PHANTOM 2 VISION + · S/N PH645484049Cancelled Sep 18, 2018 · Registration expired, pending cancellation · Jordan James WN5572JDJI PHANTOM 2 VISION + · S/N PH645494759Cancelled Sep 18, 2018 · Registration expired, pending cancellation · Jordan James WN558QJDJI PHANTOM 2 VISION + · S/N PH646039071Cancelled Sep 18, 2018 · Registration expired, pending cancellation · Jordan James WN558TBDJI PHANTOM 2 VISION + · S/N PH645501242Cancelled Sep 18, 2018 · Registration expired, pending cancellation · Jordan James WN562RJDJI PHANTOM 2 VISION + · S/N PH645451937Cancelled Sep 18, 2018 · Third renewal notice · Jordan James WN563HJDJI PHANTOM 2 VISION + · S/N PH645497290Cancelled Sep 18, 2018 · Third renewal notice · Jordon James WN563JJDJI PHANTOM 2 VISION + · S/N PH645497266Cancelled Sep 18, 2018 · Third renewal notice · Jordan James WN563KJDJI PHANTOM 2 VISION + · S/N PH645501202Cancelled Sep 18, 2018 · Third renewal notice · Jordan James WN99176Ercoupe 415-D · S/N 1799Cancelled Aug 23, 2018 · Revoked, canceled · Built 1946 · Indianapolis Morris Plan CorporationN78224Globe GC-1B · S/N 2224Cancelled Jul 26, 2018 · Revoked, pending cancellation · Built 1946 · Weinland KelvinN5224HPiper PA-16 · S/N 16-26Cancelled May 23, 2018 · Revoked, canceled · Built 1949 · Osman MitchellN6992MStinson 108 · S/N 1084992Cancelled May 18, 2018 · Revoked, canceled · Built 1948 · Campbell David TN96432Taylorcraft BF · S/N 8732Cancelled Apr 10, 2018 · Revoked, canceled · Built 1946 · Bower Charles SN86GBGauger MONOPLANE · S/N 1Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Gauger Glenn WN494VPiper PA-28-180 · S/N 28-4242Cancelled Mar 26, 2018 · Registration expired, pending cancellation · Built 1967 · Brewer Richard WadeN1967YMooney M20D · S/N 232Cancelled Mar 23, 2018 · Revoked, canceled · Built 1964 · Indiana Avn CorpN2909MPiper PA-12 · S/N 12-1435Cancelled Mar 23, 2018 · Revoked, canceled · Built 1946 · Hoosier Aero Club IncN40151Air Creation CLIPPER · S/N T98/062Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Coughlin Timothy JN415HHHinchman Herman Roland H-1 RACER · S/N 0001Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 1990 · Hinchman Herman RolandN26921Tevebaugh CLOUD CLIPPER · S/N 1975Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1975 · Tevebaugh David VN199TMSpitzer Craig A SPI 6536 162F · S/N SP16536Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Built 2002 · Ragnar Logistics LLCN9605TBudny Billy C MINI 500 · S/N 159Cancelled Feb 15, 2018 · Sale reported, canceledN70586Bell 206B · S/N 198Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Vincennes UniversityN823ALBoeing 737-230 · S/N 23154Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1985 · Skybus LLCN6017PPiper PA-24 · S/N 24-1112Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1959 · Wiseman Charles EN4455WSearle Tim S CHALLENGER 1 · S/N 0904BW050Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1994 · Searle Exhibit Technologies IncN428DCPiper PA46-500TP · S/N 4697124Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 2002 · Heritage Aircraft LLCN3219Piccard AX-4 · S/N 28Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1969 · Hot Air Balloon Club Of Indiana IncN531DWLawson Doyle W 1300 Z-MAX · S/N 192893Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1993 · Lawson Doyle WN934ASMcdonnell Douglas DC-9-83(MD-83) · S/N 49235Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1985 · Skybus LLCN501AWDavid Algie LP 1 · S/N 001Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Algie David GN294AGBoeing 737-376 · S/N 24296Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Skybus LLCN27924Piper J3F-60 · S/N 4450Cancelled Nov 22, 2017 · Revoked, canceled · Built 1940 · Richardson Guy EN6412HPiper J3C-65 · S/N 19584Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Pacilla Richard L PtnrN8015Davison-Bensen B-8M · S/N 291-6742Cancelled Nov 21, 2017 · Revoked, canceled · Davison Edgar MN99571Engineering & Research ERCOUPE 415-C · S/N 2194Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Weaver Richard P Co OwN9989HConsolidated Vultee SNV-1 · S/N 8482Cancelled Nov 21, 2017 · Revoked, canceled · Built 1942 · Carlson George RN51383Taylorcraft DC-65 · S/N 4267Cancelled Nov 20, 2017 · Revoked, canceled · Built 1943 · Oconnor Patrick FN36950Aeronca 65-TAF · S/N F2591TACancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Fuller John LN430Engineering & Research ERCOUPE 415-C · S/N 3005Cancelled Nov 18, 2017 · Revoked, canceled · Built 1946 · Heidelberger KendallN8645CPiper PA-22-135 · S/N 22-1318Cancelled Nov 18, 2017 · Revoked, pending cancellation · Built 1953 · Ajc Flg ClubN33457Piper J3F-65 · S/N 5966Cancelled Oct 28, 2017 · Revoked, canceled · Built 1940 · Coffman Richard MN4088QCessna 401 · S/N 401-0188Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1968 · Moore General LLCN5606BSix Chuter SKYE RYDER · S/N 93-1073-2Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Wichlinski Matthew JN5068SSeber John J EINDECKER · S/N 12Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 2004 · Seber John JN231BQMooney M20K · S/N 25-0119Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1979 · Hot Wings Aviation LLC
Back to Indianapolis, IN