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 ('2072418')
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 ('2072418')
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.
N5152QB & L Property Holdings LLC · Brush Prairie, WAN5152RAero Marine LLC · Denver, NCN5154QDemio Douglas · Westbrook, CTN5154RKakkar Sunit · Buena Park, CAN5156RKookaburra Kiwi LLC · Post Falls, IDN5158QAnglin Cheryl · Jackson, MSN5158RBrandenburg Idu LLC · Brenham, TXN515EDBlue Sky Pilots Inc · Salem, ORN515RDWings Over Texas Holdings LLC · Denton, TXN5160RTownley Wren Adam T · Orwell, VTN5162REllis Harvey Airport Inc · Guthrie, OKN5165RAvocado Air LLC · Perkasie, PAN5166RCrown Flying Club · Overland Park, KSN5167HBest Joseph J · Coldwater, MIN516JWAerostar LLC · Newport Beach, CAN5171HPan Air Flying Club · Miami, FLN5171RSamuels Jay M · East Tawas, MIN5172HMsi Fuel Management Inc · Vacaville, CAN5174HFlying Finn Enterprises LLC · Wilmington, DEN5177HPomeroy Cattle Ranch LLC · Kalispell, MTN5178RHampton Flying Services LLC · Portsmouth, NHN5179HFlight Time Builders Inc · Memphis, TNN5180RMacdonald Kaitlyn · Dillon, MTN5181HRegistered aircraftN5181REdelen Daniel R · Clayton, NCN5183RThompson Aerial Service Inc · Wyndmere, NDN5186HPope Brian B · Coalgate, OKN5187RTke Ltd · Thief River Falls, MNN5191RKlein Alan D · Hudson, WIN5193HClear Skies Avionics Inc · Clearwater, FLN5193RHaralson Aviation Inc · Elberton, GAN5194RFitzke Lee J Trustee · Lakeville, MNN5197HSullivan Edward A · Remsenburg, NYN5197RMedia Stew LLC · Carson City, NVN5198HBranson William E · Stokesdale, NCFirst renewal noticeN5200HIowa Lakes Community College · Estherville, IAN5201HGorge Winds Aviation Inc · Fairview, ORN5201QAdams Clive P · Hendersonville, TNN5201RWest Florida Flying Service LLC · Safety Harbor, FLN5202RHahn Douglas Keith · Waldport, ORN5203RGehman David W · Atmore, ALN5205RValley Pilots Flying Club Inc · Martinez, CAN5206RNewlon Rudolf W · Encinitas, CAFirst renewal noticeN5207QDairy Air Inc · Wyoming, PAN5209RGuyer Kasey A · Billings, MTN5210RPrince Steven S · Westerly, RIN5211MSinger Seth · Suffern, NYN5213HWelding James D · Hilliards, PAN5213RSoco Aero Leasing LLC · Santa Rosa, CAN5217HB&R Aircraft LLC · Wadsworth, OH
Back to Cessna 172M