Annapolis, MD
Cancelled registrations · 78
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 = 'MD' AND d.registrant_city = 'ANNAPOLIS' 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 = 'MD' AND d.registrant_city = 'ANNAPOLIS' 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.
N17LHLearjet 35A · S/N 428N145GJLearjet 35A · S/N 145N200YGates Lear Jet 36 · S/N 014N136STGates Lear Jet 36A · S/N 36A049N2252QPiper PA-32R-300 · S/N 32R7780235N5631DMaule M-5-235C · S/N 7239CN730TJPiper PA-22-135 · S/N 22730N123WTCessna 150M · S/N 15077050N8140ACessna 170B · S/N 20992N5001SVan Dine Peter MERGANSER · S/N VND001AN7429ECessna 210 · S/N 57129N9327BCessna 175 · S/N 55127N31NAGrumman American Avn. AA-1C · S/N AA1C-0208N8804WPiper PA-28-235 · S/N 28-10350N4211CStinson 108-3 · S/N 108-5211N66335Cessna 150M · S/N 150-75989N5839XCessna 310F · S/N 310-0139N532S N I A S SE 3130 ALOUETTE II · S/N 1145N2263UBrantly B-2B · S/N 425N504Sud SE3130 ALOUETTE II · S/N 1085N46090Taylorcraft DCO-65 · S/N 4356N2HStruble Arthur Dewey PD3-1 · S/N PD-3-1N6269KRepublic RC-3 · S/N 479N46983Fairchild M-62A · S/N T41-488N87511Republic RC-3 · S/N 64N2236MPiper J3C-65 · S/N 21028N88348Piper J3C-65 · S/N 15966N2755HErcoupe 415-C · S/N 3380
Back to Annapolis, MD