Hermantown, MN
Cancelled registrations · 143
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 = 'MN' AND d.registrant_city = 'HERMANTOWN' 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 = 'MN' AND d.registrant_city = 'HERMANTOWN' 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.
N529VJCirrus Design SF50 · S/N 0529N35SBCirrus Design SR22 · S/N 9515N547EPCirrus Design SR22 · S/N 9547N483VJCirrus Design SF50 · S/N 0483N403AKCirrus Design SR22T · S/N 9206N913CZCirrus Design SR22 · S/N 9133N135GBCirrus Design SR20 · S/N 8701N687CZCirrus Design SR22T · S/N 8687N274JLCirrus Design SR22 · S/N 8566N857CZCirrus Design SR22T · S/N 8574N264CZCirrus Design SR20 · S/N 2646N237MMCirrus Design SR22T · S/N 2124N108PECirrus Design SR22T · S/N 2011N722RCCirrus Design SR22 · S/N 4804N465CZCirrus Design SR20 · S/N 2465N318MSCirrus Design SR22T · S/N 1827N458RKCirrus Design SR20 · S/N 2458N455JPCirrus Design SR20 · S/N 2455N261AVCirrus Design SR20 · S/N 2320N708SLCirrus Design SR22 · S/N 4467N773MMCirrus Design SR22 · S/N 4600N115JTCirrus Design SR22T · S/N 1704N584PDCirrus Design SR22 · S/N 4584N253AVCirrus Design SR20 · S/N 2317N127CACirrus Design SR22T · S/N 1615N545VBCirrus Design SR22 · S/N 4545N157SPCirrus Design SR22T · S/N 1576N482BLCirrus Design SR22 · S/N 4482N882SYCirrus Design SR20 · S/N 2289N618DSCirrus Design SR22 · S/N 4335N387FACirrus Design SR22T · S/N 1387N283SLCirrus Design SR22 · S/N 4283N212SACirrus Design SR22 · S/N 4230N331PDCirrus Design SR22T · S/N 1012N326CCCirrus Design SR20 · S/N 2170N171AZCirrus Design SR22 · S/N 4171N228CCCirrus Design SR20 · S/N 2157N238CCCirrus Design SR20 · S/N 2158N266KTCirrus Design SR20 · S/N 2266N45AHCirrus Design SR22T · S/N 0701N114CZCirrus Design SR22 · S/N 4114N771CSCirrus Design SR22T · S/N 0771N318KTCirrus Design SR20 · S/N 2246N183JSCirrus Design SR22T · S/N 0725N266CCCirrus Design SR20 · S/N 2167N168FTCirrus Design SR20 · S/N 2171N259RSCirrus Design SR22 · S/N 3985N213RSCirrus Design SR22 · S/N 3973N237RSCirrus Design SR22 · S/N 3976N249RSCirrus Design SR22 · S/N 3981
Back to Hermantown, MN