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.
N7RRTavan Richard M · Saratoga, CAN802MSMarotta Scientific Controls Inc · Montville, NJN80SGFerland Henry L III · Vidalia, GAN81DTKbk Aviation LLC · Youngsville, LAN81KCCraigo Keith A · Addison, TXN828RJNielsen Ron E · Lindon, UTN8424WExtra Equipment Inc · Stuart, FLN843YTTrue Drilling LLC · Casper, WYN84SJLabelle Gregory D Trustee · Newbury Park, CAN858BBEchelon Group Inc · Boise, IDN86DHHolloway'S Tire And Auto Service Inc · Thomaston, GAN888PJPatterson Edward · Midland, TXN898BHPompa Oliver · Tuscon, AZN89KPRegistered aircraftN8CCMag 3 Aviation LLC · Vidor, TXN9046FCenturion Aviation LLC · Lewes, DEN9079HJoey Os LLC · Darlington, PAN907JMWright Flight Inc · Tucson, AZN90MJBlack Alan · Mariposa, CAN90RWWallace Richard · Santa Teresa, NMN9307YRader Drew · Avon, CON9309YYecny Alan K · San Luis Obispo, CAN9353YKovax Aviation LLC · Youngstown, OHN9356YParsons Bruce W Trustee · Costa Mesa, CAN9369YBk Aviation Services LLC · Yorba Linda, CAN9379YFitzgerald Aviation LLC · Bluffton, SCN93HPAxe Capitol Inc · Lake City, FLN9403YFlorida Emergency Management Associations Inc · West Palm Beach, FLN9439YR C S Drilling Company Inc · West Lake Hills, TXN9465YWof Investments LLC · Dover, DEN9483YSioux Falls Technology LLC · Sioux Falls, SDN9498YRamsgate Ltd · Sedalia, CON9499YMilhouse Richard J · Aguila, AZN9502YBci Aviation LLC · Arroyo Grande, CAN950SRAcme Aero LLC · Kingman, KSN9528YHunt William R · Tucson, AZN9531BLash Trucking LLC · Goleta, CAN9533YN9533y Corp Trustee · Wilmington, DEN9535YSpectra Q LLC · Las Vegas, NVN9577YShort Notice Inc · Pensacola, FLN9607YIsn Aviation LLC · Loup City, NEN9636YCarranza Chris J · Stanfield, AZN9746YAircraft Holding Solutions LLC Trustee · Newark, DEN974RCRafael Cisneros LLC · Wilmington, DEN97EKern County Sheriffs Department · Bakersfield, CAN980SCSky Horse LLC · Santa Cruz, CAN9843YCavu Solutions LLC · Renton, WAN9861YRichard I Bennett LLC · San Jose, CAN9870YDejong Arie H · Maricopa, AZFirst renewal noticeN9890YValiair Lc Trustee · Casper, WY
Back to Cessna T210N