Pontiac, MI
Cancelled registrations · 159
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 = 'MI' AND d.registrant_city = 'PONTIAC' 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 = 'MI' AND d.registrant_city = 'PONTIAC' 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.
N41PCDassault/Sud FAN JET FALCON · S/N 19N70903Cessna U206F · S/N U20602108N77CZBeech D18S · S/N A198N93604Cessna 152 · S/N 15285526N440YGreat Lakes 2T-1 · S/N 157N3891SCessna 172E · S/N 17251091N2668NDouglas C-47 · S/N 11982N4252UMattoon Floyd HUMMER-B · S/N 0060BN563WBeech E18S · S/N BA139N6750PBeech G18S · S/N BA496N5692LEnstrom Helicopter 280C · S/N 1177N30618Cessna 177A · S/N 17701364N9633RBeech G18S · S/N BA-479N427QBeech D18S · S/N A336N11ZBBeech G18S · S/N BA-510N180PBeech G18S · S/N BA-478N438ABeech E18S · S/N BA452N80369Beech D18S · S/N A-157N50713Bellanca 8KCAB-180 · S/N 62280N1812DBeech D18S · S/N A-826N5CQAerotek PITTS S-2A · S/N 2110N955GPBeech H-18 · S/N BA-620N2135LBeech A36 · S/N E-891N4906BBeech E18S · S/N BA-89N150GLCessna 150M · S/N 15075904N201GLMooney M20J · S/N 24-0029N7507GCessna 150L · S/N 15074675N172GLCessna 172M · S/N 172-63630N66066Cessna 150M · S/N 15075811N19357Cessna 150L · S/N 15074361N2368Beale BENSEN B-8M · S/N 1N74181Douglas C54B-DC · S/N 27236N5268WPiper PA-28-160 · S/N 28-314N11RLCessna 172M · S/N 17262868N12660Cessna 172M · S/N 172 62155N7590GCessna 172L · S/N 17259290N7333RBeech B-60 · S/N P-276N193CPBeech D18S · S/N A-830N5990GCessna 150K · S/N 15071490N6463SCessna 150H · S/N 15067263N74182Douglas C54D-DC · S/N 10746N7511JPiper PA-28R-180 · S/N 28R-30878N8548GCessna 150G · S/N 15066908N51403Cessna 150J · S/N 15069984N6922GCessna 150L · S/N 150-72422N6594SCessna 150 · S/N 15067394N7385QCessna 182P · S/N 18261025N387BBeech E18S-9700 · S/N BA-410N42282Cessna 182 · S/N 18258943N6652GCessna 150L · S/N 15072152
Back to Pontiac, MI