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 ('2073357')
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 ('2073357')
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.
N756YHGroundhog Mining And Milling Co LLC · Dillon, MTN756ZHHeartland Aviation Inc · Alliance, NEN7576NHusum Charles · Redmond, WAN7584NCarto Flight Inc · Willoughby, OHN7590NIventosch Leonard · Mccall, IDN7600NKeller Douglas O · West Linn, ORN7610CSawtooth Flying Service Inc · Mccall, IDN764SAerotrans Management LLC · Mercer Island, WAN770CFKopp Adrian D · Brookville, INN778CWGarbati Thomas Jr · Waterford, CTN7798NGebhard John M · Hartland, WIN799KTAdams Aviation Services Inc Trustee · Wilmington, DEN806HUAstra Engineering LLC · Twin Falls, IDN80CRRdp Construction LLC · Sitka, AKN80MTMeloche Michael S Trustee · Hamilton, MTN813SWWolff Scott · Missoula, MTN820AHBuffaloe Thomas N · Mancos, CON8263GFitzpatrick Dennis B · Mccall, IDN8281ZSpearfish Aviation Inc · Summerset, SDN8352QUnited Indian Missions DBA · Tucson, AZN8386M213tz LLC · Hailey, IDN8439GSmith Air LLC · Cascade, IDN859ALAms Aviation LLC · South Bend, INN8898QNorthrop Grumman Systems Corp · El Segundo, CAN899RCOsprey Aviation LLC · Hamilton, MTN916WCBarr Air Patrol LLC · Mesquite, TXN925WMHoward Charles M · Pittsburg, TXN9338ZBarr Air Patrol LLC · Mesquite, TXN93ETGhatan Farhad · Friday Harbor, WAN9438MIdaho Transportation Department · Boise, IDN9475RVon Imhof Rudi F · Anchorage, AKN9493ZCcf Ventures Inc · Bangor, MEN949LHappy Mangos LLC · Anchorage, AKN954PWWeckbacher Paul J Jr · Inverness, FLN9556ZIsland Aircraft LLC · Anchorage, AKN95TFSage Mgmt LLC · Carefree, AZN9632ZAngelone Inc · Elkhart, INN9643ZAdams Aviation Services Inc Trustee · Wilmington, DEN9649GAllen Todd N · Mccall, IDN9691ZSouth America Mission Inc · Fort Mill, SCN9770MStr Holdings LLC · Lafayette, INN9774ZFlying Fortress Of Swfl LLC · Fort Myers, FLN981AKState Of Alaska · Anchorage, AKN981RDSunrise Adventures LLC · Stillwater, MNN981WBFlying Fortress Of Swfl LLC · Fort Myers, FLN9848MCovington Aircraft Engines Inc · Okmulgee, OKN9876ZGv Air Inc · Medford, ORN990VPValenzuela Pedro · Douglas, AZN9916ZWings Of Wisconsin LLC · New Richmond, WIN9923ZChena River Aviation Inc · Fairbanks, AK
Back to Cessna TU206G