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 ('2072738', '2072739')
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 ('2072738', '2072739')
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.
N1FRApex Aero LLC · Kalispell, MTN202SPColorado State Patrol · Denver, CON203SPColorado State Patrol · Denver, CON2047CPropp & Wings LLC · Missoula, MTN20489Lone Oak Properties LLC · Flagstaff, AZN2049PVan Bortel Aircraft Inc · Arlington, TXN2054ZRp3 LLC · Boise, IDN2057PBullock Gary · Saint Regis, MTN206WEM&B Holdings LLC · Verdi, NVN2077NLilylands Aviation LLC · Redvale, CON207CDCheek Gary L · Chandler, AZN2080QHyperion Enterprises LLC · Warrenton, VAN20887N20887 LLC · Augusta, GAN2098CLynch Stephen J · Stamford, CTN20APF & M Holdings LLC · Goshen, ALN20DBLsn Air LLC · Morrison, CON21002Gr Aircraft LLC · Rancho Mirage, CAN2101GCarter James E · Thornville, OHN2101VWell Hung Metal LLC · Sulphur, LAN21147Woolf Sarah Clark · Fresno, CAN2114RPower Michael L · Bend, ORN2118JLamb Chops Inc · Bakersfield, CAN2122ZObrien Air LLC · Prescott, AZN2128YE-Cubed Industries LLC · Big Piney, WYN21359Aircraft Guaranty Corp Trustee · Oklahoma City, OKN2142SDbm Farms Inc · Clarksdale, MSN2145ZTextron Aviation Inc · Wichita, KSN2146CVan Bortel Aircraft Inc · Arlington, TXN2151YMtjc Services LLC · Chester, WVN21547Heaton Troy W · Pasco, WAN2154VMidwest Laser Service Inc · Janesville, WIN2155JSlickhorns LLC · Reno, NVN2164YGolden Eagle Aviation LLC · Park Ridge, ILN216ADDiscofly LLC · Bernardsville, NJN2170WSacks Martin · Mill Valley, CAN21722Western Properties Investors And Advisors LLC · Laguna Niguel, CAN2172JTaylor A Pharr Esq LLC · Alexander City, ALN2172WGo Around LLC · Elburn, ILN21733Bradley Ralph W Jr · Newbury Park, CAN21744Oatdog Aviation LLC · Atlanta, GAN21746Sky West Aviation Inc Trustee · Albuquerque, NMN2175WIndustry Machine Design & Automation Inc · Camarillo, CAN2176STango-Alpha LLC · Saint Charles, MON21796Seegmiller Geoffrey · Houston, TXN2179MKairez Carolyn E · Punta Gorda, FLN2181AL&C Ventures LLC · Clovis, NMN2182KDura Built LLC · Greensburg, KYN2183PBarney Northcote Inc · Riverside, CAN2196LAerolisse LLC · Chouteau, OKN21971Mp Aviation LLC · Buffalo, NY
Back to Cessna T182T