Easton, MD
Cancelled registrations · 47
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 = 'EASTON' 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 = 'EASTON' 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.
N886DLRaytheon HAWKER 800XP · S/N 258391N2143GPiper PA-28-161 · S/N 28-7916176N2695EGaulden William David SONERAI II L · S/N 679N502PGDassault-Breguet FALCON 10 · S/N 144N999HTBeech 95-B55 · S/N TC-1607N46562Boeing A75N1(PT17) · S/N 754420N736DRDJI PHANTOM 3 PROFESSION · S/N P76DCE30017255N736KRDJI PHANTOM 3 PROFESSION · S/N P76DCF15016056N644TBVickers-Armstrong SPITFIRE MK IX · S/N PL344N201TBVickers Armstrong SPITFIRE MK.XIV · S/N 6S-663417N590ZWDJI PHANTOM 3 PROFESSION · S/N 5014030N594YWDJI PHANTOM 3 ADVANCED · S/N 3013196N721UAL-3 Bai Aerosystems VIKING 100 · S/N 106N3848JCessna 150G · S/N 15065148N22697Cessna 150H · S/N 15068455N423FML-3 Unmanned Systems VIKING 300 · S/N 301N423GGL-3 Unmanned Systems VIKING 300 · S/N 302N24814Cessna 152 · S/N 15280394N8497RBowser Timothy B HUMMER-B · S/N 0033BN8670FHughes Helicopters HUGHES 369D · S/N 870168DN276Piper PA-32R-300 · S/N 32R-7680095N14541Semco Balloon MARK V · S/N SEM132N11010Cessna 172H · S/N 17256474N119GCSC Aerostar YAK-52W · S/N 0012207N22469Cessna 172S · S/N 172S10488N7436VSliwinski ED PAZMANY PL 1 · S/N 276N2539MPiper PA-34-200T · S/N 34-7870086N10VKVon Kleeck John S JR AIR COMMAND · S/N 1001N19VBRobinson Helicopter R44 II · S/N 10229N66874Piper PA-31-350 · S/N 31-7405180N689RSSweet Ronald C LONG EZ · S/N 689N72KBBeagle B.206 SERIES 2 · S/N B206/064N6116XCessna 310R · S/N 310R1284N7611CCessna TU206G · S/N U20603925N89810Cessna 140 · S/N 8859N9068WPiper PA-28-235 · S/N 2810667N8005YPiper PA-30 · S/N 30-1105N1506CCessna 180 · S/N 30206N737Aeronca 7AC · S/N 7AC-169N3326KGlobe GC-1B · S/N 1319N731Cessna T-50 · S/N 6526N730Cessna T-50 · S/N 5940N733Cessna T-50 · S/N 6694N29235Aeronca 50-TL · S/N L2840TN19770Aeronca KC · S/N KC-8N13884Aeronca C-3 · S/N A-306N12421Aeronca C-3 · S/N A-187
Back to Easton, MD