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 ('2073303')
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 ('2073303')
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.
N206MFMission Aviation Fellowship · Nampa, IDN206MNMartin Nelson & Co Inc · Seattle, WAN206MTBlue Spruce LLC · Bigfork, MTN206MWZaludy Aviation LLC · Paynesville, MNN206MZKtbr Holdings LLC · Statesboro, GAN206PJIllingworth Paul John · Georgetown, TXN206PMTunnel Aviation LLC · Tunnel Hill, GAN206PQHogue LLC · Paso Robles, CAN206RPFinley Aviation LLC · Fort Worth, TXN206RR206 Adventures LLC · San Juan, PRN206SJUrbana Aviation LLC · Woodstock, OHN206UESmith Peter I Trustee DBA · Ocala, FLN206VBN206vb LLC · Batavia, OHN206VSBos Ranch LLC · Reno, NVN206WKKaw Corp · Mcallen, TXN206WYAerotrust Services Corp Owner Trustee · Wilmington, DEN207ALU S Imaging Flight Ops LLC · Bartow, FLN208DGDelta Golf Aviation LLC · Pompton Plains, NJN208FT423 East Young LLC · Warrensburg, MON2095JAviation Trust Co LLC Trustee · Oklahoma City, OKN2095SMrk Aviation LLC · Delray Beach, FLN2099YThompson And Harvey Holdings LLC · Orcutt, CAN209CSMat Air LLC · Bridgeport, TXN2101ZPico'S Plane LLC · Rockport, MEN2109JRaf Ks LLC · Wichita, KSN2118ASouth Dakota Highway Patrol · Pierre, SDN211FJFox Point Airways LLC · Sheridan, WYN211GTB & B Crane Service LLC · North Myrtle Beach, SCN2137H3 Pandas LLC · Farmington, NMN2138BSouthwest Aviation Enterprises · Haslet, TXN2145RCabernet To Cactus LLC · Scottsdale, AZN2148WSav LLC · Shelton, WAN21493Macmillan Robert J · Merritt Island, FLN214MHShadow Ventures LLC · Chesapeake, VAN214VWMilford Aviation LLC · Greensburg, INN2150KCarey David John II · Mccall, IDN2156NTerryair LLC · Missoula, MTN2159PKiehn Real Estate LLC · Santa Barbara, CAN2162WHelicopter Applicators LLC · Pembroke, NHN216CPCivil Air Patrol · Maxwell Afb, ALN216SBMorotti John M · Las Vegas, NVN217DLValiair Lc Trustee · Casper, WYN2186ZNational Products Inc · Seattle, WAN2202NAlcyone Trust Corp Trustee · Wichita, KSN222FGoddspeed LLC · Encinitas, CAN22412Time Flies LLC · Oak Brook, ILN2241XMandes George · Homer, AKN2255HWinged Vision Inc · Gaithersburg, MDN2255MCooper Gary D · Fayetteville, ARN225METvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to Cessna T206H