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 ('2072728')
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 ('2072728')
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.
N71118Taf Aerial Services LLC · Beeville, TXN71121Karmy Jeffrey R · Medford, ORN71123Debusk Eric M · Columbus, INN71124N71124 LLC · Waunakee, WIN71126Overturf Andrew · Franklin, WIN71132Neale Bruce G · Joppa, ALN711333 F Aviation LLC · Norwood, LAN71136Jones Harper L II · Pendleton, ORN71149Skydive Harbor Springs Inc · Charlevoix, MIN71164Core Jerry M · Bishop, CAN71165Aggie Aero Enterprises LLC · Cleveland, TXN71178Four Forces Of Flight LLC · Orlando, FLN71187Watermeier Daniel W · Syracuse, NEN71188Youderian Kenneth E · Coupeville, WAN71198Bretschneider Danny · Wichita Falls, TXN71202Anderson Kyle J · Hales Corners, WIN71203Santa Anita Inc · Kaufman, TXN71204Northwest Alabama Aviation LLC · Tuscaloosa, ALN71213Kerr Ryan R · Mora, MNN71216Fly By Night LLC · Tigard, ORN71220Kcsi Aerial Patrol Inc · Bakersfield, CAN71225Timmusair LLC · Jacksonville, FLN71228Ryan David · Warren, OHN71242Abacus Properties Inc · Port Saint Joe, FLN71248Howell Tom F · Roseville, CAN71255Basham Kelly T · Mcminnville, TNN71258Sus Manos Extendidas · Leander, TXN71262Lavin Keith P · Bedford, TXN71279Rlr Investments LLC · Fargo, NDN71286Registered aircraftN71287Bogie Aviation LLC · Newton, NJN71292Registered aircraftN71298Belanger Patrick J Trustee · Gilroy, CAFirst renewal noticeN71300Finch Merry B · Marysville, CAN71305Fisher Vincent E · Burrton, KSN71317Abbatiello Vincent Jr · Cape Coral, FLN71320Wptd Inc · Munster, INN71321Boyle Christopher R · Truckee, CAN71323Air Legacy LLC · Chanhassen, MNN71326Lrc Aero LLC · Jacksonville, TXN71331Baird David W · Kanab, UTN71333Delaney Michael T · Edmonds, WAN71336Aviation Trust Company LLC Trustee · Oklahoma City, OKN71354Willis Enterprises · Enterprise, ORN71355Dal Tex Flyers Inc · Arlington, TXN71359Sparks Fly LLC · Mount Gilead, OHN71369Gosney James R Trustee · Silver City, NMN71374Farmers Supply Corp · Ontario, ORN71378Hanson Jared E · Missoula, MTN71384Neal Donald L · Fresno, CA
Back to Cessna 182M