Skip to content

Cancelled registrations · 47

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

N385VUPiper PA-23-150 · S/N 23-1068Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1957 · Vincennes University N169AWStuckman Larry EXEC 162F · S/N 6463Cancelled Apr 24, 2017 · Registration expired, pending cancellation · Built 2008 · Stuckman Larry N N340DKDouglas Dilley A4-B · S/N 91001Cancelled Jul 19, 2016 · Sale reported N4VUBell 47G · S/N 52-7869Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Aviation Maintenance Technology Vincennes Univ N3660YAir Tractor AT-301 · S/N 301-0338Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1981 · Vieck Flying Svc N32897Piper PA-34-200T · S/N 34-7570065Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1975 · Vincennes University Aviation Maintenance Tech N2814SCessna 150G · S/N 15066714Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1967 · Vincennes University N1284EAeronca 7AC · S/N 7AC-4844Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1946 N391PLockheed T-33 · S/N 56-1669Cancelled May 9, 2013 · Sale reported, canceled · Built 1956 N333WNBell UH-1B · S/N 62-1890Cancelled Sep 11, 2012 · Sale reported, canceled N23400Cessna 150H · S/N 15068930Cancelled Sep 4, 2012 · Registration expired, pending cancellation · Built 1968 · Vincennes University Aviation Maintenance Tech N5VUVincennes Univ-Avn Maint Tech. BREEZY RLU-1 · S/N 77-1BCancelled Jul 24, 2008 · Second triennial mailing, no response · Aviation Maintenance Technology Vincennes Univ N66381Cessna 150M · S/N 15076005Cancelled Jul 10, 2008 · Built 1974 · Brown Terry M N1832NBeech B-55 · S/N TC-2413Cancelled Apr 10, 2007 · Triennial form not returned · Built 1981 · Bomac Equipment Corp N1525MBeech B36TC · S/N EA-464Cancelled Mar 14, 2005 · Built 1987 · Equipco Inc N369JSSnider John K BKB2 · S/N 030569Cancelled Mar 4, 1999 · Snider John K N23GEEvans A L/Goldsberry G E GGAE 2-3 · S/N GGAE11744Cancelled Sep 16, 1995 · Triennial form not returned · Snider Auction And Appraisal Inc N4718YPiper PA-25-260 · S/N 254458Cancelled Sep 26, 1984 · Ueding Robert G N66378Cessna 150M · S/N 15076002Cancelled May 7, 1981 · Vincennes University N7569ZPiper PA-25-235 · S/N 25-3629Cancelled Sep 15, 1977 · Exported to Canada · Midwest Pawnee Center DBA N8674LPiper PA-25-235 · S/N 25-5126Cancelled Jul 18, 1977 · Klein Charles R N9829PPiper PA-25-260 · S/N 25-7556147Cancelled May 13, 1977 · Exported to Canada · Built 1975 · Ueding Robert G DBA Ueding Flying Service N54923Piper PA-25-235 · S/N 257656062Cancelled Jan 4, 1977 · Exported to Canada · Ueding Flying Service N17623Sikorsky H-19D · S/N 51-14304Cancelled May 6, 1975 · Vincennes University N17624Sikorsky H-19D · S/N 51-14287Cancelled May 6, 1975 · Vincennes University N8931LPiper PA-25-235 · S/N 25-5395Cancelled Oct 21, 1974 · Exported to Canada · Ueding Robert G N21730Cessna A188B · S/N 18800988TCancelled Jun 20, 1974 · Built 1972 · Ueding Robert G DBA Ueding Flying Service N8144GCessna A188B · S/N 18801247TCancelled May 14, 1973 · Exported to Canada · Ueding Robert G N76594Cessna 120 · S/N 11034Cancelled Feb 27, 1973 · Exported to Canada · Redmond Garey N4392YPiper PA-25-235 · S/N 25-4903Cancelled Dec 8, 1972 · Exported to Honduras · Ueding Robert DBA Ueding Flying Service N6982ACessna 172 · S/N 29082Cancelled May 10, 1972 · Oneal Aviation Corp N8797LPiper PA-25-235 · S/N 25-5223Cancelled Mar 6, 1972 · Exported to United Kingdom · Ueding Flying Service N84142Aeronca 7AC · S/N 7AC2828Cancelled Jan 6, 1971 · Built 1946 · O'Neal Aviation Corp N70318Piper J3C-65 · S/N 17295Cancelled Dec 30, 1970 · Oneal Aviation Corr N35892Piper J3L-65 · S/N 6641Cancelled Dec 7, 1970 · Oneal Aviation Corp N23219Piper J3C-50 · S/N 2990Cancelled Dec 4, 1970 · O'Neal Aviation Corp N59594Boeing A75N1 · S/N 75-2496Cancelled Sep 25, 1970 · Exported to El Salvador · Ueding Robert G N872VCessna 172 · S/N 28178Cancelled Mar 5, 1968 · Exported to Canada · Board Of Trustees For The N83817Aeronca 7AC · S/N 7AC 2497Cancelled Dec 14, 1956 · Exported to Canada · O Neal Aviation Corp N9557KStinson 108-2 · S/N 108-2557Cancelled Nov 15, 1955 · O Neal Aviation Corp N74643Boeing A75N1 · S/N 75-3682Cancelled May 16, 1955 · Exported to Mexico · Robert G Ueding N70445Piper J3C-65 · S/N 17440Cancelled Mar 29, 1955 · Exported to Mexico · Oneal Aviation Corp N98557Piper J3C-65 · S/N 18773Cancelled Apr 14, 1954 · Exported to Canada · Oneal Aviation Corp N48319Fairchild PT-19 · S/N T437349Cancelled Aug 22, 1951 · O Neal Aviation Corporation N29313Waco UPF-7 · S/N 5340Cancelled Dec 31, 1945 · Built 1940 · O'Neal F J N436Standard J-1 · S/N 900HWCancelled Jun 1, 1931 · O Neal Frank J N1877Standard STANDARD J-1 · S/N 42Cancelled Oct 19, 1928 · Built 1927 · O'Neal Aircraft Co

Back to Vincennes, IN