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 ('2072618')
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 ('2072618')
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.
N3484YSport Obermeyer Ltd · Aspen, CON3490YRouse & Rouse-Houck LLC · Gunnison, CON3494YAltitude Fix Aviation LLC · Mesa, AZN3496YPincus Howard E · Grass Valley, CAN3497YBraden John C · Anchorage, AKN369CMOharra Robert J · Buckley, WAN36APAnalysis Inc · Grand Junction, CON39JApex 1996 LLC · Kilgore, TXN3SMQuaintance Christian N · Culpeper, VAN3YNWeaver Carl · Halstead, KSN406DPWings & Blades LLC · Columbia Falls, MTN4090HSouthern Air Transport Services LLC · Dover, DEN429PCShanks Charles Scott · Edmonds, WAN4384KLewis Flying Service Inc · Morse, LAN444XPEiron Nadav · Portola Valley, CAN4488SMartens Paul A · Fairview, OKN449Destroyla Inc · Los Angeles, CAN470JCCox Patrick A · Torrance, CAN4750UHancock Stephen E · Yulee, FLN4751UPlano Daniel W · Willow, AKN4757UPj Aviation LLC · Eden Prairie, MNN4763UCopper River Airmotive LLC · Copper Center, AKN4764URegistered aircraftN4766UMoore Murray H · Twain Harte, CAN4771ULoomis Rick A · Prescott, AZN4775UBishop Mike · Rifle, CON4779UBergh Eugene H · Roberts, WIN4787UDreyer Jeffrey J · Payson, AZN4792UWegman Atlas George · Ghent, NYN4795UParker Omalley Corp · Chatham, NYN4799UChase 13 LLC · Wilmington, DEN4803EC180 Holdings LLC · Austin, TXN48091Krueger Luke T · Anchorage, AKN500AKJones Thomas F · Boerne, TXN511CWSydow Daniel P · Duluth, MNN51PHAasen Christopher N · Corvallis, ORN51RMiozzi Thomas E · Jamestown, RIN5383XWillard Raymond C · Wasilla, AKN544ZLeary Ken R · Fairbanks, AKN54572Perry Dennis T · Seward, AKN58647Omara Timothy · Tampa, FLN6219UHardy Jeffrey T · Ellsworth, MEN625MMRamsdell Myron J · Hartwell, GAN64DBFyrberg Forest M · Oakland, MEN6523TVan Bavel Ethan G · Soldotna, AKN65DWNorth Stream Capital LLC · Scottsdale, AZN67WWFrontier Fence LLC · Fallon, NVN6LTDierks Herman D Jr · Round Rock, TXN7069USmith Alwyn · Boca Raton, FLN70788Mercier Michael S · Chugiak, AK
Back to Cessna 180H