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.
N6329CUnited Indian Mission DBA · Tucson, AZN6352ZSale Reported · Anchorage, AKSale reportedN6391UGimli Son LLC · Fort Lauderdale, FLN6395ZN Berk Consultant Inc · Greenwich, CTN6419XPernat Frank J Trustee · Chaska, MNN6428ZDv Aviation Inc · Brainerd, MNN6433XRand Carl · Durango, CON6447XSteller Air Service LLC · Homer, AKN6461ZJav Air Services LLC · Anchorage, AKN6506ZAf Auto Group · San Jose, CAN6568XBarnes Inc · Lewiston, IDN6582XMclean Bruce R · Napa, CAN6588XPc Rental LLC · Ely, MNN713TGSelway Construction Group LLC · Moscow, IDN721Department Of The Interior · Boise, IDN7257NPeterson Winston Roy II · Arbuckle, CAN726HSSpmhrt 206 LLC · East Bernard, TXN732HRBowdle Ricke H · San Dimas, CAN7334NRobles James J · Oro Valley, AZN733EHSherwood Aviation Consultants Inc · Redondo Beach, CAN7347NAv8 LLC · Boise, IDN734TMCorporate Air Service Inc · North Salt Lake, UTN734WXRegistration Pending · Kodiak, AKRegistration pending, pending cancellationN7359CAhlem Charles D · Hilmar, CAN735BTPtmm LLC · Columbus, OHN7361CFocused Holdings LLC · Wellsville, UTN7386CAgro Engineering Inc · Alamosa, CON73CYRti Fabrication Inc · Plains, MTN750NTEle Motorsports LLC · Dover, DEN7532NEagle Air LLC · Morgantown, WVN7551ZKustatan Leasing LLC · Kenai, AKN7561NPierce County Sheriffs Department · South Hill, WAN756AVSmith Air LLC · Cascade, IDN756CRConnell Donna M · Belton, TXN756DHDorothy M Walker Family Lp · Idaho Falls, IDN756DQBurgett Judson B · Fowler, INN756DWManos Con Alas Aviation · Stateline, NVN756ENU206 Sky LLC · Pompano Beach, FLN756EYHeartland Aviation Inc · Alliance, NEN756FUElyria Airport Partnership · Jensen Beach, FLN756HUReynolds Richard A · Marco Island, FLN756JAGv Air Inc · Medford, ORN756JTRackley Co Inc · Orland, CAN756JZBrowne Thomas J · Grass Valley, CAN756MYRegistered aircraftN756NDRegistered aircraftN756QVAms Aviation LLC · South Bend, INN756UJMydive Aviation LLC · Denver, CON756WGRood Charles · Vancouver, WAN756YCMb Aviation LLC · Ridgefield, WA
Back to Cessna TU206G