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 ('2072602')
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 ('2072602')
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.
N3194DMatthews James B · Wills Point, TXN3195DRegistration Pending · Fort Mohave, AZRegistration pendingN3196CWeir Ryan L · Buckley, WAN3197CScott James D · Mesa, AZN3199CGreenleaf Michael G · Tacoma, WAFirst renewal noticeN319MTSimply Living LLC · Fort Myers, FLN3201DMelnick Victor D · Mount Bethel, PAN3204DGriffith Sherman · Southlake, TXN3205DWest James · Monroe, MIN3206DDenny Michelle L · Chugiak, AKN3211DNielson Donald L · Independence, ORN3218DWright James Cope · Round Rock, TXN3222DBeggs Patrick C · Salem, ORN3223DCliff Robinson Real Estate Corp · Madison, INN3224DE W Aircraft LLC · Manhattan, MTN3228DNulsen Eric Randall · Greenbrier, ARN3231DMcfarlane Claude L · Fitchburg, WIN3232DZucchero David M · Stanwood, WAN3236DFrey Joseph · Fallon, NVN3238DLutes Richard L · Hampshire, ILN3239DJaj Flying LLC · Sutton, NEN3244DBrooks Laura · Palmer, AKN3246DJaden H Erwin Dds Pllc · Helena, MTN3248DPalmer Cade E · Eagle River, AKN3251DE S P Aviation LLC · Wilmington, DEN3252DQuigg Aircraft LLC · Muskegon, MIN3255DAzul Aviation Inc · Fort Worth, TXN3257DAlaska Dall Sheep Guides LLC · Anchorage, AKN3259DLutes Stacy J · Mooresville, NCN3261DCastorina John Salvatore · Anthem, AZN3265DMiller Matthew S · Washougal, WAN3267DDavidson Danny F · Anchorage, AKN3270DMcbride Robert W Jr · Cedar Park, TXN3274DMcroberts David M · Washoe, NVN3275DCrystoff James J · Kodiak, AKN3276DFarkas Jonathan · Mukwonago, WIN3279DDavies James E · Eagle, IDN3281DRichardson John David · Willis, TXN3282DLafleur Kerry P · Fort Worth, TXN3283DAllen Roger B · Gardnerville, NVN3284DKornfield Edward A · Anchorage, AKN3288DSmith James O · Montgomery, TXN3293DGuilliams Carl · Gilbert, AZN32FCZimin Transportation LLC · South Naknek, AKN3301DJohnson Peter L · Chico, CAN3306DAlquist Kevin B · Edwardsville, KSN3311DPendergrass Joseph M · Wasilla, AKN3320DPara Tactics LLC · Shelton, WAN3321DWood Steveno · Morgan, UTN3322DObrien Aviation LLC · Moreno Valley, CA
Back to Cessna 180