Cancelled registrations · 16

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 = 'NE' AND d.registrant_city = 'MINDEN' 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 = 'NE' AND d.registrant_city = 'MINDEN'
  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 = 'NE' AND d.registrant_city = 'MINDEN'
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.

N5530LCavanaugh Mike AVID FLYER · S/N 103Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Miller Rebecca E N7547KDJI PHANTOM 3 ADVANCED · S/N P76DCE12013082Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Kulhanek Enterprises Inc N8580LPiper PA-25-260 · S/N 25-4948Cancelled Apr 6, 2018 · Revoked, canceled · Built 1969 · Cavanaugh Larry N8588SJacobsen Charles E FISHER FP-101 · S/N FP-101Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1984 · Jacobsen Charles E N91483North American NAVION · S/N NAV-4-284Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1946 · Bontz George R N3745EPiper PA-36-300 · S/N 36-7960060Cancelled Apr 8, 2003 · Exported to Turkey · Coslor Donald D N8807CEagle EAGLE DW-1 · S/N DW1004681Cancelled Aug 4, 1994 · Triennial form not returned · Pioneer Aerial Applicators Inc N13538Spencer V HEATH · S/N 1Cancelled Aug 18, 1992 · Triennial form not returned · Harold Warp Pioneer Village Fnd N5613SBeech 95-C55 · S/N TE256Cancelled Nov 4, 1991 · Exported to Sri Lanka · Petersen Aviation Inc N6358ZPiper PA-25 · S/N 25474Cancelled Mar 29, 1991 · Triennial form not returned · Cavanaugh Michael P N6400MStinson 108-3 · S/N 108-4400Cancelled Oct 8, 1985 · Bosworth Arthur D N1150BLuscombe 8A · S/N 5777Cancelled Jun 21, 1982 · Sale reported N4533YPiper PA-25-235 · S/N 25-4170Cancelled Mar 18, 1982 · Built 1966 · Coslor Donald N9919HTimm N2T-1 · S/N 193Cancelled Jan 18, 1972 · Olson Harold M N37030Luscombe 8A · S/N 1691Cancelled Oct 22, 1971 · Olson Harold Lm N8090ACessna 170B · S/N 20942Cancelled May 14, 1965 · Morris Dale

Back to Minden, NE