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 ('2073709', '2073710')
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 ('2073709', '2073710')
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.
N7574VWild Angels Aviation LLC · Lascassas, TNN7575VMcbride Daryn T · Huntsville, TXN7577VPerkins Ralph Trent · Rockwall, TXN7578VWillis Daniel M · Shelbyville, TNN7579VSteenson James H Jr · Hudson, NHN7580VBinzel Charles P · Bristol, WIN7581VJacoby Billy L · The Villages, FLN7582VKlebanoff Mark · Worthington, OHN7585VMollahan Joseph P · Yamhill, ORN7586VSchroeder Terry E · Tuscola, ILN7587VBradley Vaylan L · Keller, TXN7589VCorwin Lloyd D · Idaho Falls, IDN7591VHallack Daniel Edwin · Hart, MIN7592VMisener Richard H · Hermiston, ORN7593VBlanzy Paul J · Highland, MIN7594VSilly Boy Aviation LLC · Moses Lake, WAN7600VRegistration Pending · Phillipsburg, KSRegistration pendingN7614VTucker Aviation LLC · Kalispell, MTN76177Brown Emily D · Niceville, FLN7623VGove Richard · Riverside, CAFirst renewal noticeN7637VRamsey Brian S · Monument, CON7645VBig Sky Aviation Leasing LLC · Helena, MTN7694VMarkowski John J · Guilford, CTN7702VBrown Warren C · Pasadena, CAN77177Nazario Caleb R · Orlando, FLN7731VDedmon Stephen V · Fleming Island, FLN7733VLong Final LLC · Clay, NYN7751VGoodman Matthew R · Kenly, NCN7778Carpenter Darrell W · Midland City, ALN7818VGlide Slope Aviation LLC · Flagstaff, AZN7895VCleared For Takeoff LLC · Katonah, NYN7903VQuintas Frank · Palm City, FLN7972VDionisio John · West Covina, CAN799THeinimann Markus B · Latrobe, PAN7VJM E L LLC · Wilmington, DEN7ZXRobinson Leslie C · Colorado Springs, CON8001GWilliams Matthew L · Longview, TXN8005GBertolino Vincent · Canton, CTN8006GGecin Taner · Wallingford, CTN8007GBradford Steven M · Muscatine, IAN8008GMentgen William P · Greencastle, INN8011GLadner Marvin D · Sidney, NYN8022GAaron Arthur Harrison · Gold River, CAN8024GRedwing Aviation LLC · San Antonio, TXN8025GN8025g C177rg LLC · Jeffersonville, INN8027GBas Part Sales LLC · Greeley, CON8028GAndersen Timothy R · Elizabeth City, NCN8029GIndy Air Sales LLC · Anderson, INN8031GFletcher Craig B · Willis, TXN8033GStoltz Curtis · Winter Haven, FL
Back to Cessna 177RG