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.
N378SStarr William E · Eagle River, AKN384MGMissionary Air Group Inc · Burlington, NCN393DW3 Delta Whiskey LLC · Superior, WIN39501Jw & Jl Aviation LLC · Phoenix, AZN422RKGulf Coast Aerial Mapping Co Inc · Gonzales, LAN4414RKirk Ledoux · Stanwood, WAN458DJSurvey America Inc · Rancho Cordova, CAN4609UJerden Corp · Overland Park, KSN4651TUnited Indian Missions Inc DBA · Tucson, AZN4665CKrissman Ryan · Gallup, NMN4690UKim Hansen Co · Burley, IDN4716XJessup Sheila · Dublin, CAN4743XAerotech Mapping Inc · Las Vegas, NVN4746U4746u LLC · Sherman Oaks, CAN4760CJaars Inc · Waxhaw, NCN4776UHabberstad John L · Rathdrum, IDN4791UAerialtraders LLC · Fort Myers, FLN4797UPhilbrick Rodney C DBA · Bishop, CAN47MBBjerke Michael · Boise, IDN4827UHagen Rainer · Irving, TXN4853CIdaho Flying Service LLC · Kamiah, IDN4881U270 W Pearl LLC · Jackson, WYN4887ZJav Air Services LLC · Anchorage, AKN488RHI F Rooks & Associates LLC · Memphis, TNN4918UMission Aviation Fellowship · Nampa, IDN4923UUnited Indian Missions Inc DBA · Tucson, AZN4950UAerotech Mapping Inc · Las Vegas, NVN4957ZGuinasso Kimberly Marsh · Reno, NVN4978UKempf Rodney G · Eugene, ORN4AHHand Kevin D · Anchorage, AKN4LFMacys Flying Service Inc · Tulelake, CAN5119XMission Aviation Fellowship · Nampa, IDN5203XMike & Critter LLC · Mccall, IDN5244ZRobinson Levi B · Anchorage, AKN5314XMoody Bible Institute Of Chicago · Spokane, WAN5315XAtarah LLC · Tucson, AZN5363ULefore Jeffry Thomas · Milton Freewater, ORN5394XL K Hollenbeak Logging Inc · Hayfork, CAN5401XBarbera Frank M · Edgewood, NMN5424UWsol Michael P DBA · Huntington Beach, CAN545PSUnited States Department Of The Interior · Boise, IDN54KDSawtooth Flying Service Inc · Mccall, IDN589JSWings West Consulting LLC · Mesa, AZN602YMSawtooth Aviation Resources LLC · Ketchum, IDN6192UKings Nw LLC · Lakewood, WAN61DWZandri Stefano A · Ridgefield, CTN6233ZMission Aviation Fellowship · Nampa, IDN6270XLees Robert A II · Mesa, AZN6277ZAircraft Guaranty Corp Trustee · Oklahoma City, OKN6305UMission Aviation Fellowship · Nampa, ID
Back to Cessna TU206G