Cancelled registrations · 28

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 = 'VA' AND d.registrant_city = 'DANVILLE' 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 = 'VA' AND d.registrant_city = 'DANVILLE'
  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 = 'VA' AND d.registrant_city = 'DANVILLE'
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.

N2300QBeech 23 · S/N M-371Cancelled May 8, 2020 · Revoked, canceled · Built 1963 · Dowdy John L Jr N98550Piper J3C-65 · S/N 18763Cancelled Jan 10, 2020 · Sale reported, canceled N208AULiberty Aerospace XL-2 · S/N 0114Cancelled Oct 14, 2015 · Built 2008 · Averett University Of Danville Va N9089NPiper PA-28-161 · S/N 2816003Cancelled May 21, 2014 · Built 1986 · General Aviation Inc N29ETThomas Emory M MINI 500 · S/N ET3-0124Cancelled Jun 1, 2000 · Triennial form not returned · Thomas Emory M N428ETThomas Emory M RW133 · S/N ET2Cancelled Sep 2, 1998 · Triennial form not returned · Thomas Emory M N2426APiper PA-38-112 · S/N 3878A0682Cancelled Feb 18, 1997 · Triennial form not returned · General Aviation Inc N25693Piper PA-38-112 · S/N 3881A0056Cancelled May 7, 1992 · Triennial form not returned · General Aviation Inc N56863Piper PA-28R-200 · S/N 28R7435051Cancelled Feb 14, 1992 · Triennial form not returned · Amt Enterprises N739QPCessna 172N · S/N 17270723Cancelled Jul 22, 1991 · Exported to Germany · Fleming Thomas W N873DBBeech 200 · S/N BB315Cancelled Apr 25, 1991 · Exported to Zimbabwe · Dibrell Brothers Incorporated N43905Piper PA-28-161 · S/N 288516043Cancelled Apr 10, 1991 · Triennial form not returned · General Aviation Inc N8781VBellanca 17-30A · S/N 30321Cancelled Feb 22, 1984 · Administratively canceled · Donelson Martin Jr N64289Bell 47G-3B-1 · S/N 3668Cancelled Sep 19, 1981 · City Civil Defense N3629NPiper J-3 · S/N 22882Cancelled Dec 7, 1970 · Chester H Hosey N2727AStinson SR-10J · S/N 3-5827Cancelled May 24, 1960 · Built 1938 · Baker Corporation N1676PPiper PA-18A · S/N 18-3805Cancelled Apr 27, 1959 · Smith Joseph Jones N2725APiper J3C-65 · S/N 8361Cancelled Jan 9, 1957 · General Aviation Inc N55066Boeing A75 · S/N 75217Cancelled Oct 11, 1955 · Danville Flying Service Inc N94108Engineering & Research 415-C · S/N 1431Cancelled Nov 2, 1951 · Richardson J C Jr N3257HEngineering & Research ERCOUPE 415-C · S/N 3882Cancelled Jan 15, 1951 · Built 1946 · Danville Flying Service Inc N34833Rearwin 175 · S/N 1559Cancelled Aug 17, 1948 · Built 1941 · Swicegoodh. Frank N8766Swallow TP · S/N 166Cancelled Apr 1, 1948 · Miller Edward Howe Jr N88572Piper J3C-65 · S/N 16197Cancelled Sep 11, 1947 · Southern Airways Of Danville Inc N163ECurtiss-Robertson ROBIN · S/N 76Cancelled Jan 14, 1940 · Southern Airways Of Danville Inc N10880Stinson JR. S · S/N 8051Cancelled Sep 22, 1936 · Built 1931 · Southern Airways Of Danville Inc N9047Travel Air 2000 · S/N 848Cancelled Sep 15, 1936 · Built 1929 · Camden S W Jr N5244A V Roe AVRO BIPLANE · S/N 1257Cancelled Jan 5, 1931 · Moser W A

Back to Danville, VA