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 ('2072708')
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 ('2072708')
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.
N8854TMcgillivray Sean P · Grants Pass, ORN8855THolm Brian N · Buckley, WAN8858TGranger Bryce W · Ravenna, OHN8859TBooth Jesse R · Alamosa, CON8864TRegistration Pending · Murdo, SDRegistration pendingN8866TTrachta Stanley J · Tucson, AZN8867TCusimano Louis C · Montauk, NYN8868TKlein Ryan L · Tijeras, NMN8869TDonaldson Lucas Paul · Owyhee, NVN8874TFletcher Edwin R Jr · Flowery Branch, GAFirst renewal noticeN8875TDelahunty Brian E · Ocala, FLN8877TAnderson Robert M · Merritt Island, FLN8880TAltitude Air LLC · Sheboygan Falls, WIN8882TWarrington Christopher · Indn Hbr Bch, FLN8883TBishop Nicholas Edward · Ukiah, CAN8888TKraus Paul B · Fort Bragg, CAN8892TOzair LLC · Manhattan, KSN8893TBend Aircraft Rentals LLC · Bend, ORN8896TMayer John B · Benson, AZN8897TZweigle Zachary John · Redding, CAN8900TSkyote LLC · Boise, IDN8902TShort Steven A · Neillsville, WIN8906TTln Aviation LLC · Stanwood, WAN8908TWinit Matthew C · Woodland, WAN8909TFinley Steven V · Fort Collins, CON8910TSaa Enrique A · Lubbock, TXN8918TAirtime LLC · Wilmington, DEN8919TUllmann Wilmer R · Fairview, TXN8921TRoberts Marty · Mount Hermon, LAN8926TBowlin George E · Roanoke, INN8927TRockfish Ventures LLC · Wilmington, NCN8939TFeeny Daniel J · Townsend, MTN8941TGeco Inc · Wilmington, DEN8942TMonger Curtis V · Bend, ORN8945TLumpkin Ed · Rosie, ARN8950TGribi Daniel M · Miranda, CAN8952TNorthwest Exteriors Inc · Rancho Cordova, CAN8956TBrown Donald L · Peoria, AZN8965TRoberts Coleen M · Roseburg, ORN8970TLamle Eric W · Okeene, OKN8976TKumm John J · Clarkston, WAN8977TAllsup Delmar D III · Oakhurst, CAN8979TNardi Patty K · Missoula, MTFirst renewal noticeN8980TN8980t LLC · Dallas, TXN8981TCharlie Tango LLC · Rapid City, SDN8982TLarson Lynn R · Casselton, NDN8985TDonald V Johns Jr · Rush, CON8987TPeavy Magnus Delacy IV · Crawfordville, FLN8990TPoulter Michael D · San Angelo, TXN8993TCoughran Aviation LLC · Rio Vista, CA
Back to Cessna 182C