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 ('2072735')
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 ('2072735')
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.
N6372SHolt Richard M · Sierra Vista, AZN6382SNichols Daniel Alan · Haymarket, VAN6383TLetourneau David · Valencia, CAN6386TPaul Taylor Consulting LLC · Albuquerque, NMN6388TLuribay Corp · Wilmington, DEN6391SWest Steven A Jr · San Angelo, TXN6397TJetran LLC · Horseshoe Bay, TXN63BDCampbell Joseph H · Jeffersonville, INN6413TCaraway James T · Milwaukee, WIN6445TCarver James Kevin · Durango, CON6449TPelayo Fernando · La Puente, CAN6453TVandermay Monty K · Santa Fe, NMN6460TDavey Douglas H · Worley, IDN682APFlipside Aviation LLC · Berthoud, CON7049RSegerstrom Ricky G Trustee · Grandview, TXN705CGLewis Scott M · Youngstown, OHN711PDBrown Richard K · East Falmouth, MAN713BMMathieu Robert B · Delhi, LAN7188CUniversity Of Kansas · Lawrence, KSN729SCCole Michael J · Ginnison, CON7300SHerring Alan T · Laredo, TXN7325SVineyard View Aviation Inc · Napa, CAN7361RMcafee Scott A Trustee · Clifton, TXN73622Dove Kenneth F · Danville, CAN736BABest Aviation LLC · Hoxie, KSN736DZDogwood Memorial LLC · Grapevine, TXN736ERButton Duane D · Lone Tree, CON736HFStoklosa Michael · Miami, FLN736NGCatcu Aviation LLC · Edinburg, TXN736QUCloudstreet Partnership · Albuquerque, NMN736QXTeets Trent D · West Fargo, NDN736RGRegistered aircraftN736RQKisic Michael L · Rector, PAN736TSRose Clarence E III · Grove, OKN736UDSeven Ranges Mfg Corp · Carrollton, OHN736VFEdgar Warren · Granite Bay, CAN736VTRucker William C Trustee · Sanger, TXN736WHB&B Island Aviation LLC · Sylvania, OHN736YQZupanick Joseph A · Montevallo, ALN736YWInvestments Property Holdings Aviation LLC · Jonesboro, GAN736ZDEllis Jack E Trustee · Tahoe City, CAN736ZJO'Connell Patrick J · Henderson, NVN736ZNTakemori Gil M · San Jose, CAN736ZTAircraft Structural Repair Inc · Hamilton, MTN737AQDebalco Enterprises Inc DBA · Colorado Springs, CON737CEScanlan Michael · Carmel Valley, CAN737FFWorley Donald E Jr · Rocky Mount, VAN737FRShepard Christopher N · Westerville, OHN737FXZborowski Ronald W · Eighty Four, PAN737HUBerry William J · Troy, MI
Back to Cessna TR182