Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2072821', '2070107')
ORDER BY n_number"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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2072821', '2070107')
ORDER BY n_numberRun 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.
N93229Back Country Club LLC · Crawford, TXN93267Cachorro Cattle Co · Granbury, TXN93272Grossman Marc · Lake Oswego, ORN93276Fitzgerald Robert Paul · Eagle River, AKN93298Callen Jerry R Jr · Jerome, IDN93323Smith Ellis E · Anchorage, AKN93343Mcivor Bruce D · Menomonie, WIN933DB933db LLC · St Louis Park, MNN934TCVandentoorn Randy J · Caledonia, MIFirst renewal noticeN9355NGardner Tyler J · Lowell, MEN9358NHarvey Kandace A · Snohomish, WAN93769Sourdough Air Service Inc · Fairbanks, AKN93777Arbach Enterprises Inc · Watertown, SDN93797Lattin Travis W · Beloit, KSN9380NAlaska Department Of Public Safety · Anchorage, AKN93814Haltmann Sven · Fairbanks, AKN93827State Of Colorado Department Of Natural Resources · Denver, CON93842N93842 LLC · Blanding, UTN9385NStovall Eric · Marathon, TXN93904Wagon Air LLC · Anchorage, AKN93913Sage C Michael · Anchorage, AKN93934Billman Jon A · Eagle River, AKN93943Alaska Aircraft Leasing LLC · Silverdale, WAN9395NUnited States Department Of Interior · Boise, IDN94059Moriarty Gerald J · Anchorage, AKN94061Guinn LLC · Bothell, WAN9411HFeaga Charles C · Abbot, MEN9412NBeechinor Cattle Feeding Co Inc · Bakersfield, CAN9414NComprehensive Land Technologies Inc · South China, MEN94168Sullivan Sandra E · Maple Valley, WAN94219Feenstra Patrick · Scottsdale, AZN94237Brett Ryan J · Wasilla, AKN94260Sutton Aircraft Salvage LLC · Palmer, AKN94266Braun Kristy J · Fairbanks, AKN9434NAnderson Thomas R · Renton, WAN9438NSallmon James Henry · Sandpoint, IDN9446NSkywagon LLC · Goochland, VAN9452NAlaska Department Of Public Safety · Anchorage, AKN9464HAlsworth Leon R · Port Alsworth, AKN9471NBas Part Sales LLC · Greeley, CON9472NHuang Sophie M · Newcastle, WAN9494NMaine Department Of Inland Fisheries And Wildlife · Augusta, MEN9496HKoropp Michael L · Anchorage, AKN94DMLad Salvage LLC · Morgan City, LAN9515RCunningham Michael K · Pinebluff, NCN9533HPatnode Jeffrey W · Lewistown, MTN955LSSomd Seaplanes LLC · Lexington Park, MDN9563HHartman Thomas J Trustee · Anchorage, AKN957DFNorthern Flight Expeditions LLC · Hopkins, MNN9581HCole Jimmie D · Cotopaxi, CO
Back to Cessna A185F