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 ('2072434')
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 ('2072434')
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.
N738CXMoses Aviation Services LLC · Uvalde, TXN738CYAmerican Patrols Inc · Midland, TXN738CZWings Over Texas Holdings LLC · Denton, TXN738DEBrookings Flying Club Inc · Brookings, ORN738DFEb Flight Training LLC · Daytona Beach, FLN738DGN122ep LLC · Coushatta, LAN738DJHermes Aviation LLC · Greenville, SCN738DKHarrison Aviators LLC · Goshen, INN738DLWilson Comer · Clinton, CTN738DMBuiqui Aerospace Corp · Kissimmee, FLN738DTHardin John M · Terrell, TXN738DXPlanes Over Plains LLC · Benton, KSN738DYRnb Aviation LLC · Montgomery, TXN738EAMatt Plane One LLC · Gilbert, AZN738EGJeff Air Pilot Services LLC · Shelbyville, INN738EHHills Holding · Newark, DEN738ENKohlhaas Jerome R · Hardy, IAN738EPCommand-Aire LLC · Seattle, WAN738EUGehrke Charles A · Aneta, NDN738EWWasowski Walter J · Riverside, CAN738EYPettyjohn Nancy Paulette Sautebien · Dearborn, MIN738FAFly Maui LLC · Puunene, HIN738FCMontepiedra John Glenn R · Rch Palos Vrd, CAN738FDAero Maintenance Inc · Vancouver, WAN738FFTed Kingston Inc · Strathmere, NJN738FMFinefield James P · Cary, ILN738FYVero Technical Support Inc · Pensacola, FLN738FZSun Aviation Inc · Cambridge, MNN738GACone Ira M · Frazier Park, CAN738GBFlying Grass Hopper LLC · Barrington, ILN738GEPs Aviation Inc · Granada, MNN738GJJlinn Aviation Inc · Quinlan, TXN738GMNesher Aviation II LLC · Jacksonville, FLN738GSWestern Edge Aviation LLC · Dickinson, NDN738GVMolnar Raymond Jr · Ashford, CTN738GWJensen Rodney H · Sandy, UTN738GZPickard Steve H DBA · Louisville, GAN738HATerrill Mary C · Bloomingdale, ILN738HDG&M Aircraft Inc · Wheat Ridge, CON738HHPitre David E · Santa Fe, TXN738HJMcnamara Patrick J · Marstons Mills, MAN738HKEini Yaakov · Valley Glen, CAN738HPNidiffer Alan W · Brookings, ORN738HSFlycarolina LLC · Concord, NCN738HTRucci Daniel C · Saint Cloud, FLN738HXRick Aviation Inc · Newport News, VAN738JDClover Management Systems Inc · Sanford, FLN738JFCopperhead Environmental Consulting Inc · Paint Lick, KYN738JGSullivan James F · Hamilton, ILN738JJGreat Lakes Aviation Inc · Batavia, NY
Back to Cessna 172N