Albany, OR
Cancelled registrations · 123
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 = 'OR' AND d.registrant_city = 'ALBANY' 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 = 'OR' AND d.registrant_city = 'ALBANY' 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.
N28EZDixon Harley M LONG EZ · S/N 232N379CCleveland Orson STARDUSTER SA-300 · S/N 502N1445PDuncan Richard S C · S/N 375N675MBUrban Air Sro UFM-13 LAMBADA · S/N 101/13N130GACessna 208B · S/N 208B2090N63ASCessna U206F · S/N U20603252N1908DBeech C35 · S/N D-3186N66972Consolidated Vultee BT-13A · S/N 5566N2460SCessna T337C · S/N 337-0760N7490TCessna 172A · S/N 47090N9452KStinson 108-2 · S/N 1082452N44238Piper PA-28-151 · S/N 28-7415606N609JKenneke Jon K EVANS VP-1 · S/N V-1206JKN2643LCessna 172H · S/N 17255843N308PAPiper PA-28-181 · S/N 28-7990532N734MFCessna 172N · S/N 17268955N1562GCessna 421B · S/N 421B0801N16720Dehavilland DH 114 HERON 2X · S/N 14065N48776Cessna 152 · S/N 15283374N89519Cessna 152 · S/N 15282767N95499Fisher Flying Products FP-202 · S/N 0241N176RGGreenwood Richard C GULL 2000 · S/N 076N5294BMooney M20 · S/N 1156N2295UBrantly B-2B · S/N 468N52971Cessna 172P · S/N 17274648N7208LAerospatiale SE3160 ALOUETTE III · S/N 1483N156EHS N I A S AS350D ASTAR · S/N 1185N456TFFobar Terry L GOLDWING · S/N 20602N903PDMiltenberger D/Miltenberger P FAMILY FUN · S/N G4852N58CMMosier Colby/N73cm ADVENTURE AIR · S/N 78N219RMAerospatiale SA315B · S/N 2465N5196BBell 47G-2 · S/N 2016N62398Hiller OH-23G · S/N 1005N5161BBell 47G-2 · S/N 1979N9630EAeronca 11AC · S/N 11AC-1270N2611SCessna T210L · S/N 21061339N7453VMooney M20F · S/N 22-1230N644PHBell 206B · S/N 160N5349ACessna T210N · S/N 21063382N6597SCessna 150H · S/N 15067397N766MPAerospatiale AS350B · S/N 1301N8624Aerospatiale SA316B ALOUETTE III · S/N 1714N48079Hiller-Fisher UH-12E · S/N 1452N5212CBeech B35 · S/N D-2557N97524Stinson 108 · S/N 108-524N93219Hiller UH-12B · S/N 337N90494Hiller UH-12L4 · S/N 2540N6930MStinson 108-3 · S/N 108-4930N6248ZPiper PA-25 · S/N 25-306N5966XHelio H-250 · S/N 2529
Back to Albany, OR