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 ('2072706')
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 ('2072706')
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.
N2794GClark Jeremiah Jacob · Pleasant Plains, ARN2796GDouglas Cattle LLC · Douglas, AZN2798GBremerton City Flying Club · Poulsbo, WAN2799GMartin Aviation LLC · Scottsboro, ALN279RWPoe James K · Walterboro, SCN314MPTeristar LLC · Lewes, DEN3490GTucker Shad E · Sandia, TXN34DMGlotfelty John E · Durango, CON37JSNewton Wm L · China Spring, TXN4054DBass Edward J · Richland, WAN406WMMcelvain Michael R · Billings, MTN43LWRotgers Benjamin Leroy · Malabar, FLN46AMDuffy Kevin · Manchester Center, VTN4848DThompson Kelly W · Portland, ORN48KCGraham Norman J · West Ossipee, NHN50PZHill Robert P · Naknek, AKN525AGNoland Ronald E · Weston, ORN555SWAtlantic Resources Of Miami Inc · Deland, FLN59181Meader Luke C · Marfa, TXN59182Abbott James H · Gallatin, TNN59BMLissow William M · New Port Richey, FLN66KJBlagg Robert D III · Santa Fe, NMN707MGTawoda Leanne · Sun City, AZN7102EWeaver Clifford A · East Berlin, PAN7103EHarcharek Nagruk R · Anchorage, AKN7104EBlomquist Alan · Richfield, UTN7105EAerial Adventure Demos Inc · Hopewell, VAN7107ECreel Dustin C · Olney, TXN7108EButaud Michael E · Jasper, TXN7109EMccarty John W · Edmond, OKN7112EAircraft Structural Repair Inc · Hamilton, MTN7114ETlm Properties LLC · Gladewater, TXN7119ENary Jeffrey C · Bend, ORN711ACLandry Michael J · Elkin, NCN7125ETrinity County Sheriffs Department · Weaverville, CAN7126EHjk Aviation LLC · Boston, MAN7127EHostetler Robert J · Windyville, MON7128ESchlumpberger Charles P · Mount Shasta, CAFirst renewal noticeN7131ETravis Michael James · Burns, ORN7136ECreel Jeffrey G · Gaylesville, ALN7137ESss Inc · Anchorage, AKN7139EBarnes Gary · Idaho City, IDN7140EJ W Bamford Inc · Oroville, CAN7141EBobek Janice C · Soldotna, AKN7142EDuncan Wayne K Trustee · Athol, IDN7143EPfisters Flying Wahine LLC · Waialua, HIN7145EJones Robert · Anchorage, AKN7148EBush Dale L · Medford, ORN7152ERobinson Andrew K · Pahrump, NVN7153EStec Inc · Seminole, TXNon-citizen corporation, flight hours not reported
Back to Cessna 182B