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.
N756XPMorton James D · Littleton, CON756YLTwo Ten LLC · Joshua Tree, CAN756ZCSkinner Leasing LLC · Medford, ORN757CRRegistered aircraftN757EUB2b Services LLC · Lincoln, CAN757EZXtratech Corp · Davie, FLN757HFG & T Associates · Bellevue, WAN757JFBoykin Randy K · Aguila, AZN757JLPalmer Travis S · Maupin, ORN757LKNuckolls Douglas W · Lancaster, CAN757PDLeavitt Erin G · Lewiston, IDN757PEMoretti Luigi U Ricci · Swarthmore, PAN757QTMoxley Equipment Co Inc · Council Grove, KSN757RYSale Reported · Corona, CASale reportedN757SP4e Aviation LLC · Alpine, UTN757SQByrne Sarah Boltz · Dallas, TXN757WBReineke John S · Powell, OHN757WTElectrical Management Services · North Andover, MAN757XDSouth Texas War Birds LLC · Santa Fe, TXN7592RInternational Security Network Inc · Pahrump, NVN759EEAcadiana Technical College · Lafayette, LAN7685MLazy Double Air LLC · Bloomer, WIN775MSSkinner Leasing LLC · Medford, ORN783SCWeiblen Glenn P · Castroville, TXN787PCLivingtofly1 LLC · Ball Ground, GAN787RGCareer Aviation Company Inc · Wilmington, DEN799AMLdd Construction Inc · Dupont, CON79MJ79mj LLC · Mercer Island, WAN79MRMarbes Daniel · De Pere, WIN7KSilverman Kenneth Lack · Jefferson, NCN812DDcc Aero LLC · Alamosa, CON812LDRegistered aircraftN826CVScott Roger A · Saint Croix Falls, WIN827LBCapital Consulting LLC · Newport Beach, CAN828BCFitzdam Justin D · Franklin, TNN8293RPanterra Aviation LLC · Mountain Green, UTN83SWRogers Gary A · Novi, MIN851DEO'Neal Sean M · Santa Cruz, CAN857DKKnight Kevin · Dallas, TXN8KLWiebe Joerg · Sarasota, FLN9007RWill Michael · Mukilteo, WAN901JGWestland Aviation LLC · Lake Havasu City, AZN9036RBaltz David M · Superior, CON9066RForage Jean Pierre Md · Lakeway, TXN90DZPjm Aviation LLC · Labelle, FLN9233RBlash Gregory J · Corona, CAN9253RDr Equipment LLC · Ackerly, TXN927MPPrebish Matthew · Heath, TXN9281RBmg Aviation Leasing LLC · Bloomington, INN9288RShane Wilson Pa · Fort Myers, FL
Back to Cessna TR182