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 ('2073449')
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 ('2073449')
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.
N37PB37pb Inc · Seattle, WAN381DSFlightpath Investments LLC · Ottumwa, IAN390RSSchoene Edward C · Springfield Center, NYN391PT7640 Drilling LLC · Amarillo, TXN399KMCustodio Olga · San Antonio, TXN411TTRambod Marc · Taos Ski Valley, NMN43KYPinto Carlos Eduardo · Tucson, AZN44WHKelly Sean R · Bozeman, MTN4604QBas Part Sales LLC · Greeley, CON4607QSerrano Lynn A · Casa Grande, AZN4627QMassey Larry A · New Braunfels, TXN4653Q53 Quebec LLC · El Dorado, CAN4678QPrairie Dog Aviation LLC · Sioux Falls, SDN4682QHangar 27 LLC · Bountiful, UTN46MRDavin Matthew · Ridgecrest, CAN483DMN483dm LLC · Hummelstown, PAN4885XEggleston Kevin M · Moore, OKN4VWPronk Glen R · Crittenden, KYN5026VPiland Kenneth Eldon Jr · Carlsbad, CAN503ATRegistered aircraftN505SWBas Part Sales LLC · Greeley, CON5109QRmcb LLC · Kalispell, MTN5114QJ&A Air · Richfield, UTN5122QPyxis LLC · Cheyenne, WYN5127QRegistered aircraftN512GTBarron Thomas Aviation Inc · Scottsdale, AZN5131QLeavitt Craig S · Spicewood, TXN5141QImagination Publications Inc DBA · Saratoga, WYN5151QNotsa LLC · Morrison, CON5156QN5156q Inc · Elmhurst, ILFirst renewal noticeN515RTCemco Industrial Park LLC · Belen, NMN5191VTrue Drilling LLC · Casper, WYN5225VKuhn Chad · Boulder, WYN5228VDynamite Marketing Inc · Meridian, IDN523RCS W Air Travel Inc · Parshall, CON525KWFuller Thomas R · Scottsdale, AZN5263VMccullough James M · Monte Vista, CON5267VN5267v LLC · Northbrook, ILN5275VViatrans LLC · Pryor, OKN5276VSky West Aviation Inc Trustee · Albuquerque, NMN5302VSniader David J · Miami, FLFirst renewal noticeN5314VBurke Sterling M · Olympia Fields, ILN5395VCortez Flying Service Inc · Cortez, CON53TMSmith Douglas M · Hackettstown, NJN5464VLivingood Richard A · Tucson, AZN5495VPhillips Ruffin P Jr · Lexington, NCN5555GSinton Frank J · Durango, CON555RCCaron Robert M · Fort Pierce, FLN57977Denney Dennis · New Port Richey, FLN59007Hang On LLC · Montrose, CO
Back to Cessna T210L