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 ('2072434')
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 ('2072434')
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.
N8293EFiorini Anthony Wayne · Tuttle, OKN8295EFrump Leasing Inc · Newburgh Heights, OHN8296EMosbach Rene A · Sandia, TXN8297EConaway Scott J · Traverse City, MIN8298EAberdeen Flying Service · Aberdeen, SDN8299ELondon Corbin Airport Board · London, KYN82EPPosav Holdings LLC · Zephyrhills, FLN8317GEagle Simulator LLC · Lake Oswego, ORN8318EJust Planes Inc · Hobbs, NMFirst renewal noticeN8324EGc Aviation Services-1 LLC · Miamisburg, OHN832DCCase Daniel J · Spokane, WAN833CBDehaan David J · San Diego, CAN8349EArment C Randall · Valentine, NEN8356ESky West Aviation Inc Trustee · Albuquerque, NMN83FPPhillips Tom Scott · Beach City, TXN8410ETito Hector · Fayetteville, GAN8435EZeller Ray G · Brookings, ORN8449EJprg Aviation Inc · Orlando, FLN8450EWings Over Texas Holdings LLC · Denton, TXN8466EGoldstein Allan · Elk Grove Village, ILN8473EBeck Roger M Trustee · Goode, VAN8477EVestasur LLC · Chauvin, LAN84DLAirplanes And Helicopters Of Oregon LLC · Sisters, ORN858ERKgw Holdings LLC · Peoria, AZN85JAFrequency Change Aviation Services Inc · Nashville, TNN862TWTailwinds LLC · Ewing, NJN86FPGateway Flight Center LLC · Port Lavaca, TXN872FCBlackhawk Holding Corp · Wilmington, DEN873TWN873tw LLC · Hurricane, WVN874JSchoenmann James · Jackman, MEN879WHHumphrey Ronald D · Pace, FLN884CAColeman Aero Club · Apo AeN888GACain Philip K · Escondido, CAN9002EWisconsin Aviation Inc · Watertown, WIN9003EBermuda Dunes Flight Training LLC · Palm Desert, CAN902FAVero Technical Support Inc · Pensacola, FLN9042QTumbleweed Leasing Co Inc · Salt Lake City, UTN905WAMy Way Aviation LLC · Weston, FLN906KSKingsky Flight Academy LLC · Lakeland, FLN906MDFive Rivers Flight Training LLC · Livermore, CAN906WAPea-Wayman Flight LLC · Daytona Beach, FLN907KSKingsky Flight Academy LLC · Lakeland, FLN907WAPea-Wayman Flight LLC · Daytona Beach, FLN90FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN90HAGarzony Anthony · Toledo, OHN9105Stoyanov Nikolay S · Jersey City, NJN916AVLopez Virgilio D · Brookshire, TXN916SEEiland James · Phenix City, ALN917GKAmdel Holding LLC · Houston, TXN9188GAircraft Management Services Inc · Milton, FL
Back to Cessna 172N