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 ('2072420')
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 ('2072420')
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.
N4634LGs Family Holdings LLC · Middletown, DEN4639LHalle Michael P · Livingston, TXN4641LRegistration Pending · El Reno, OKRegistration pendingN4642LJordan Jason A · Portland, MEN4647LTerrel Mitchell · Alva, OKN4656LRegistered aircraftN4658LHarrison Doug A · Yellville, ARN4659LTalcorp Inc · Justin, TXN4660LSitton Wyatt D · Washtucna, WAN4661LMccall Thomas A · Glen Saint Mary, FLN4662LD R Tripp Enterprises LLC · Omaha, NEN4663LSwanson Daniel · Wasilla, AKN4664LThrasher Jody R · Mesquite, TXN4666LBrewster Cynthia R · Friendswood, TXN4667LRebel Road Customs LLC · Yuma, AZN4671LCraft William J · New Baltimore, MIN4677LJet Airways Express Inc · Aventura, FLN4679LFitting Solutions Lc · Chester, NJN4680LWasilowski Steven P · Elgin, ILN4681LOmer Syeda · Gilroy, CAN4682LJones Carl R · Little Rock, ARN4683LLawson Seth A · Morgantown, WVN4684LHowell Tyler L · Romoland, CAN4685LEsquilin Steven C · Poway, CAN4687LKful Inc · Fullerton, CAN4688LFas Aircraft Aerowork Corp · Miami, FLN4692LBravo Aviation LLC · Rexburg, IDN4693LEmerald Air LLC · Snohomish, WAN4694LSky Tours LLC · Port Clinton, OHN4695LRoss Richard R · Mckinney, TXN4696LKoontz Marina M · Seattle, WAN4697LTverberg Justin T · Omak, WAN476DTTallarita Domenic A · Palm Springs, CAN555WBCosta Air Service LLC · Painted Post, NYN5724RMartindale Bryan T · Springfield, ILN5727RBiederman Scott · Pompano Beach, FLN5729RMarreno Eddie J · Green Cove Springs, FLN5731RGoward Steven Lee · Oakley, MIN5733RWarren Jeffrey · Omaha, NEN5734RZ&H Aviation · Portage, MIN5735RDavis Richard B · Reno, NVFirst renewal noticeN5737RRegistration Pending · Chatham, NYRegistration pendingN5738RKury Ernest A · Centerville, IAN5741RJungman Jensen David A · Adel, IAN5744RBrown Dallin N · Scipio, UTN5746RKrawietz William L · Bulverde, TXN5747RLehmer Jereme D · Oxford, NYN5748RStanley David W · Burleson, TXN5749RMerrill Robert · Plymouth, MAN5750RPeters Tricia S · Columbia City, IN
Back to Cessna 172G