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 ('2071402')
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 ('2071402')
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.
N73094Denouden Ronn · Rochester, MNN76000Crabb Ernest P · Fairbanks, AKN76028Registration Pending · Backus, MNRegistration pendingN76040Argo Timothy D · Stewartville, MNN76048Larson Lee · Yuma, AZN76060Parker Boston R · Saint Joseph, MON76093Summers Dennis · Perry, OKN76113Denison Aviation Inc · Atlantic, IAN76117Miller Mason Keith · Tyler, TXN76121Bolton Derwin B · Jacksonville, TXN76129Ziegler Corbyn Rose · Post Falls, IDN76137Casson Thomas · Jacksonville, ILN76149Pallas Justin · Portage, MIN76169Mccann Michael Patrick · Daytona Beach, FLN76189Westrum Durl Troy · Norwalk, IAN76196Johnson Harry L · Live Oak, CAN76203Durand Gregory M · Marquette, MIN76207Pruitt Jamon R · Springdale, ARN76219Haas Michael S · Richmond, VAN76239Robinson William A · Franklin, TNN76253Colwell Jeffrey J · Tipp City, OHN76257Weston Jeff A · Port Saint Lucie, FLN76278Yeazel Matthew A · Seattle, WAN76282Helquist Carl A · Fort Wainwright, AKN76284Boss Christopher S · East Newport, MEN76292Goold Arthur M · Chesterfield, INN76304Johnson John P A · Hayden Lake, IDN76324Hettmann Jeffrey J · De Pere, WIN76345Fugate Terry L · Atoka, OKN76365Whitcraft James R · Olympia, WAN76369Wilson Colin J · Farmers Branch, TXN76377Klutts Jerry · Rockwall, TXN76381Leonard Timothy M · Tijeras, NMN76385Howard James Trustee · Cloudcroft, NMN76412Raymond Steve · Malone, TXN76420Registered aircraftN76428Spivey Kenneth R Jr · Vestavia, ALN76450Grenseman Timothy R · Glenrock, WYN76458Seale Leon C III · Mulberry, FLN76470Sheaffer Bruce R Jr · Lititz, PAN76482St Louis Soaring Association · Saint Louis, MON76506Zucker Paul A · Cloverdale, CAN76510Scoma Steven G · Rhome, TXN76518Lux David J · Edgeley, NDN76530Bagley Shaun R · Chapman, MEN76534Shilling Eric · La Quinta, CAN76542Spence Matthew V · Fort Myers, FLN76546Frey Kirk D · Corcoran, CAN76550Cebelak William G · Kent City, MIN76558Parr William R Jr · Mason, TX
Back to Cessna 120