Duluth, MN
Cancelled registrations · 826
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 = 'DULUTH' 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 = 'DULUTH' 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.
N2096Cirrus Design SR20 · S/N 8571N221TNCirrus Design SR22T · S/N 8504N871LBCirrus Design SR22T · S/N 8822N238TSCirrus Design SR22 · S/N 8931N839JBCirrus Design SR22T · S/N 8839N895WPCirrus Design SR22T · S/N 8895N818DMCirrus Design SR22 · S/N 8908N141CACirrus Design SR22T · S/N 8911N199FCirrus Design SR22T · S/N 8679N874CZCirrus Design SR22 · S/N 8874N890DECirrus Design SR22T · S/N 8890N381JSCirrus Design SR20 · S/N 8650N132JSCirrus Design SR20 · S/N 8734N65GHCirrus Design SR22T · S/N 8675N789MKCirrus Design SR22T · S/N 8789N811CZCirrus Design SR20 · S/N 8811N279LPRobinson Helicopter R22 BETA · S/N 2968N865BWCirrus Design SR22T · S/N 8787N210MLCirrus Design SR20 · S/N 8709N708TNCirrus Design SR22T · S/N 8708N909PPCirrus Design SR22T · S/N 8730N135JPCirrus Design SR22 · S/N 8611N695CZCirrus Design SR20 · S/N 8695N661SUCirrus Design SR22 · S/N 8661N871LBCirrus Design SR22T · S/N 8715N259KACirrus Design SR20 · S/N 8652N385LMCirrus Design SR22T · S/N 8636N281JRCirrus Design SR20 · S/N 8580N581AWCirrus Design SR22T · S/N 8581N861FGCirrus Design SR22 · S/N 8613N351CVCirrus Design SF50 · S/N 0351N395SYCirrus Design SR22T · S/N 8599N209ZCirrus Design SR22T · S/N 8627N1782KCirrus Design SR22 · S/N 5120N22UMCirrus Design SR22 · S/N 5006N501UACirrus Design SF50 · S/N 0357N865GNCirrus Design SR22 · S/N 5060N317BWCirrus Design SF50 · S/N 0317N455HUCirrus Design SR22T · S/N 2455N375MSCirrus Design SR22T · S/N 2431N510SKCirrus Design SR22 · S/N 5102N318RSCirrus Design SR22T · S/N 2427N432RKCirrus Design SR22T · S/N 2432N238MSCirrus Design SR22T · S/N 2384N302CVCirrus Design SF50 · S/N 0302N315DKCirrus Design SR22T · S/N 2417N134MYCirrus Design SR22 · S/N 4692N505TBCirrus Design SR22 · S/N 5082N373WWCirrus Design SR22T · S/N 2373N377RHCirrus Design SR22T · S/N 2377
Back to Duluth, MN