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.
N5481SPlumb Ray A · Salida, CON5486SPlane Fun Inc Tr Trustee · Snellville, GAN5494TCampbell Barry E · Prescott, AZN5497SVerbovskiy Vitaliy Viktorovich · Clovis, NMN54RAAshlock Mark L · Loomis, CAN5518TBlue Sky Group Inc · Wilmington, DEN5523TCantrup Peter H · White Rock, NMN5524SStellon Eugene A Jr · Burlington, CTN5527SSilver State Aero Group LLC · Discovery Bay, CAN5528SCenturion N761lu LLC · Mukilteo, WAN5532SAks Aviation LLC · Arroyo Grande, CAN5533SNgb Construction Inc · Ceres, CAN5537SMcpeak Alan W · Colorado Springs, CON5544SLobitz James R Co Trustee · Oak Park, CAN5546SChoice Vc LLC · Oakland, MIN5548SGardner Timothy J · Gardnerville, NVN555VKChet W Fortney LLC · Helena, MTN5599KDayton Walter S · Napa, CAN55KHDietle Kurt · Valley Springs, CAN55SFRegistered aircraftN6097TDuffy Thomas J · Hollis, NHN6114SGoral William W · Redlands, CAN6115SGan Specialties Inc · Pocatello, IDN6121TMcalilly Stephen L · Tupelo, MSN6141TMilligan David L · Fresno, CAFirst renewal noticeN6143TWong Antonio L · Santa Rosa, CAN6151SEllis Thomas Troy · Slidell, LAN6152SN6152s LLC · Sheldon, NDN6153SDanicic Sinisa · Jacksonville, FLN6168SFerrell William W II · Flagstaff, AZN6170SNice Flight LLC · Medford, ORN6173SRet Gianni · Kerrville, TXN6181TFree Theta Aeronauctics LLC · Sacramento, CAN6188TVargon LLC · Towson, MDN6191SSky King Aviation Services LLC · Lakeside, AZN619MWMw Price Corp · San Diego, CAN61VAChristensen Rand V Trustee · Encinitas, CAN6209TGordon Gregory J · Bay Village, OHN6227TCarpenter Cattle Co Inc · Brewster, KSN6252TVenkataswamy Lakshmi · Doylestown, PAN625PMLewis Michael T Sr · Oxford, MSN6273TLandair Bovinae LLC · Canyon, TXN6276TFinn Steven F · El Paso, TXN6317TShaffer Dyke T · Santa Rosa, CAN6318TPollock John · Cleburne, TXN6324TRegistered aircraftN6339TRj Aircraft LLC · Vandling, PAN6341SPradels Karis J · Murrieta, CAN6350TDallob Seth · Reno, NVN635MMHsp Holdings LLC · Farmington, NM
Back to Cessna TR182