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 ('2072439', '2072442')
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 ('2072439', '2072442')
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.
N816SWUniversity Of Alaska Anchorage · Anchorage, AKN818SPN818xp LLC · Charleston, SCN81KSChristiansen Aviation LLC · Wilmington, DEN820JANutac Leasing LLC · Deland, FLN822MNLucky B Aviation LLC · Wilmington, DEN823MCN823mc LLC · Kennesaw, GAN824MCMidwest Aviation Services Inc · West Paducah, KYN826SPGalaxy Aviation LLC · Nantucket, MAN826SWSouthwest Flying Club Inc · The Woodlands, TXN827BWWhitby Aviation Inc · Athol, IDN827ESAtp Aircraft 1 LLC · Wilmington, DEN827PAJa Flight Services LLC · Sugar Grove, ILN828LPFlying Twenties Inc · San Jose, CAN828SPVista Aviation Inc · Pacoima, CAN82LTRegistered aircraftN830KXHillsboro Aero Academy LLC · Hillsboro, ORN830MAFlying Technologies LLC · Wilmington, DEN831BRAir Future Airways Corp · Miami, FLN831KXRkm Leasing LLC · Greenwich, CTN831MAState Of Wisconsin · Madison, WIN832KXHillsboro Aero Academy LLC · Hillsboro, ORN832MAState Of Wisconsin · Madison, WIN833KXHillsboro Aero Academy LLC · Hillsboro, ORN833MAState Of Wisconsin · Madison, WIN834KXHillsboro Aero Academy LLC · Hillsboro, ORN836SPArmadillo Too LLC · Owensboro, KYN837CPCivil Air Patrol · Maxwell Afb, ALN837LAVolar Xi LLC · Edmond, OKN837SPIsrani Vijay · Cupertino, CAN838SPEdb Air Inc · Wilsonville, ORN839CPCivil Air Patrol · Maxwell Afb, ALN839SPHillsboro Aero Academy LLC · Hillsboro, ORN83SFChristiansen Aviation LLC · Wilmington, DEN840MCLegends Air Center LLC · Bentonville, ARN840PAChristiansen Aviation LLC · Wilmington, DEN841SPRandolph Macon Academy · Front Royal, VAN842KPLewis University · Romeoville, ILN842LPJet Air Inc · Iowa City, IAN842SAJet Air Inc · Iowa City, IAN842SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN845ZDornoch Services LLC · Dover, DEN846SPSky Cag LLC · Hermosa Beach, CAN847EAEagle Aviation Columbia LLC · West Columbia, SCN850FGMustang Sally Aviation LLC · Camden, SCN850SPAviolease LLC · Vancouver, WAN851SPLegends Air Center LLC · Bentonville, ARN854GWCondair Flyers Inc · Latham, NYN857SPSoutheastern Oklahoma State University · Durant, OKN859SPJet Air Inc · Iowa City, IAN860SASaint Clair Flight Academy Inc · Richmond, MI
Back to Cessna 172S