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.
N2439DN2439d LLC · Oklahoma City, OKN2439RAdams Aviation Services Inc Trustee · Wilmington, DEN2439SBright Scott Devin · Platteville, CON243MCRankin John · Nokomis, FLN2444ETm Pilots LLC · Mc Clelland, IAN2447EWingnut Aviation LLC · Fort Lupton, CON246SECannavair Inc · Seattle, WAN24747Peachey Farms LLC · Decatur, IAN2474VRbj Ranch LLC · Elroy, WIN2478DAircraft Guaranty Corp Trustee · Oklahoma City, OKN251DWWallin Aviation LLC · Taylorsville, UTN269SHDan Julian LLC · Woodway, TXN26KMPerformance Aviation Solutions LLC · Meridian, IDN272ARWinging It Inc · Stephenson, MIN273TCStanford Doug · Oak Harbor, WAN2740K2740k LLC · Prospect, KYN274DGBourne Michael Paul · Crystal Bay, NVN279TWPresotto David L Trustee · Palo Alto, CAN282AUNeice Russell G · Shreveport, LAN282JSLego Paul Gregory · Watsonville, CAN285CPCivil Air Patrol · Maxwell Afb, ALN286CPCivil Air Patrol · Montgomery, ALN28EBCohen David A · Charlotte, VTN291FRCon Air Aviation LLC · Borger, TXN303KATjs3 Aviation LLC · Wilmington, DEN3064CN3064c LLC · San Tan Valley, AZN308CLRodoni William · Santa Cruz, CAN313ECCunha Properties Management LLC · Miami, FLN313RMVan Bortel Aircraft Inc · Arlington, TXN316RBRbp Management LLC · Franklin, NCN321PWSquaw Valley Air Force LLC · Reno, NVN322MMRiver Transport LLC · Redlands, CAN323JHThree Juliet Hotel LLC · Los Altos Hills, CAN327STBeach Cities Real Property Holdings LLC · Hermosa Beach, CAN329KBMagee Brad D · Durango, CON333PFDennis Bruce · Hesperus, CON336CPCivil Air Patrol · Montgomery, ALN337CRElder Bruce W · Farmington, NMN342TSDaniels Law · Sherman Oaks, CAN343TCTwo Rivers Aircraft Managmenet LLC · Williamsburg, VAN345CMScherson David Alejandro · Folsom, CAN345RKButler Management LLC · Sherman Oaks, CAN3469246dk LLC · Ramona, CAN347LSEuroaviation Inc · KematenN347SACoastal Carolina Helicopters LLC · Burgaw, NCN349CPCivil Air Patrol · Maxwell Afb, ALN34UMMarathon Skylane LLC · West Palm Beach, FLN3500RSystems Research Corp · Wilmington, DEN3500TSusanville Aviation LLC · Susanville, CAN3502JAv Solutions Inc · Flint, MI
Back to Cessna T182T