Old Town, ME
Cancelled registrations · 54
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 = 'ME' AND d.registrant_city = 'OLD TOWN' 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 = 'ME' AND d.registrant_city = 'OLD TOWN' 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.
N925MFBell UH-1H · S/N 65-9871N2532EAeronca 7DC · S/N 7AC-6114N6006YPiper PA-23-250 · S/N 27-3187N9548WPiper PA-28-140 · S/N 28-22980N738HECessna 172N · S/N 17269983N714EJCessna 150M · S/N 15079117N975MFBell UH-1H · S/N 64-13810N985MFBell UH-1H · S/N 66-16138N5482KCessna 172P · S/N 17274148N51413Cessna A185F · S/N 18503594N106MFBell UH-1B · S/N 6312910N185NMCessna A185F · S/N 18504054N255LCessna A185F · S/N 18504434N43452Piper PA-28-151 · S/N 287415496N5753UPiper PA-28-140 · S/N 28-26578N451FLPiper PA-28-140 · S/N 28-7125244N5254TPiper PA-28-140 · S/N 287225374N6653YPiper PA-23-250 · S/N 27-3965N5308SPiper PA-28-140 · S/N 2826925N8646NPiper PA-32-300 · S/N 32-7140041N4485JPiper PA-28-140 · S/N 28-22903N60987Cessna T-50 · S/N 2705N13834Piper PA-23-250 · S/N 27-4476N4264JPiper PA-28-140 · S/N 28-22621N7811NPiper PA-28-180 · S/N 28-5263N7405RPiper PA-28-140 · S/N 28-21922N7244JPiper PA-28-140 · S/N 28-24585N6591YPiper PA-23-250 · S/N 27-3894N4137WPiper PA-32-300 · S/N 32-40204N9506WPiper PA-28-140 · S/N 28-22929N6494WPiper PA-28-140 · S/N 28-20570N3372PPiper PA-23-160 · S/N 23-1329N5871YPiper PA-23-250 · S/N 27-3024N8171YPiper PA-30 · S/N 30-1284N6320WPiper PA-28-140 · S/N 28-20376N8628PPiper PA-24-260 · S/N 24-4072N3195PPiper PA-23-150 · S/N 23-1133N7581PPiper PA-24 · S/N 24-2792N6779PPiper PA-24-250 · S/N 24-1910N7274DPiper PA-18 · S/N 18-5682N9131CCessna 180 · S/N 31230N9768EAeronca 11AC · S/N 11AC-1412N3472PPiper PA-23-160 · S/N 23-1446N9011DPiper PA-22-160 · S/N 22-6146N3330PPiper PA-23 · S/N 23-1281N83089Aeronca 7AC · S/N 7AC-1746N2757PPiper PA-22 · S/N 22-3064N3745PPiper PA-22-150 · S/N 22-3465N3241BPiper PA-22 · S/N 22-2071N3634VCessna 140 · S/N 14905
Back to Old Town, ME