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 ('2073456')
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 ('2073456')
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.
N58TTBank Of Utah Trustee · Salt Lake City, UTN608FDMjd Yuma Enterprises LLC · Yuma, AZN609RLT And B Mgmt LLC · Las Vegas, NVN6100YRamsay Allan Trustee · Modesto, CAN610KCU S Imaging Flight Ops LLC · Bartow, FLN6112ABarreto Manufacturing Inc · La Grande, ORN6116YSaab35 Draken Inc · Pocono Pines, PAN6119ABrender Ronald F Trustee · West Lafayette, INN611CCTjc Productions LLC · Ogden, UTN6126YCruise Flight Aviation Inc · Denver, CON6131AWigen Mary E · Porthill, IDN6151YBulloch Troy P · Cedar City, UTN6155YAl & Zal Corp · Wilmington, DEN6167CSnyder Larry G · Holland, NYN6184CRegistered aircraftN6188YLexington Enterprises Group Inc · San Jose, CAN6192NDolezal Todd R · San Luis Obispo, CAN6196NMccarthy Sean P · Siloam Springs, ARN6209C8 Waters LLC · Goodyear, AZN6218YLucky Star Auto Sales Inc · Grangeville, IDN621AKelsey John · Casa Grande, AZN6227YWest Brook Group Inc · Pleasant Hill, IAN6229CClause James W Trustee · La Quinta, CAN6237YStrategic Sourcing Solutions Inc · Topeka, KSN6239YBlue Horizon Aviation LLC · New Concord, OHN6267YZero Four Twelve LLC · Clovis, NMN6274AA V T210 LLC · Palmdale, CAN6278YTown & Country Aviation LLC · Sunnyvale, CAN628TTTollen Troy J · Austin, TXN6291CSatl Ranch Aviation LLC · Midland, TXN6295YSkydoc LLC · Mokena, ILN6297YL&L Aviation LLC · Baden, PAN6299CCenturion Flight LLC · Auburn, WAN6306CLongs Air Conditioning Inc · Avon Park, FLN6314CC4p LLC · Jackson, TNFirst renewal noticeN6328CArnold Aviation & Thunder Mountain Express Inc · Cascade, IDN6328YKoehn Lacey · Van Horn, TXN6329YDiablo Aviation LLC · Pleasanton, CAN6339CBowles Donald E Jr · Dallas, TXN6344YCole William G · Garner, NCN6355CDutch Air LLC · Kalispell, MTN6362AMillican Clifford A · Burleson, TXN6364CSukhakarta Rentals LLC · Cedar Park, TXN6386CBas Part Sales LLC · Greeley, CON6388YMaclean Kenneth J · Northborough, MAN6392CTretter Nicholas · Holden, MAN6397YAsher James A · Pasadena, CAN6398YSinglepoint Technologies Corp · Richmond, VAN6402NManos Con Alas Aviation · Stateline, NVN6408NBorders Nowell W · Edinburg, TX
Back to Cessna T210N