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.
N1715LValiair Limited Co Trustee · Casper, WYN1727LTexas Department Of Public Safety · Austin, TXFirst renewal noticeN1728LCaldwell Clifton M · Sterling City, TXN17386Oregon State Police · Salem, ORN1740LMidsouth Marketing Inc · Colt, ARN1746LNebraska State Patrol · Lincoln, NEN174STMichigan State Police · Lansing, MIN1756LSan Sophia LLC · West Linn, ORN176CPCivil Air Patrol · Maxwell Afb, ALN179DMNg Research · Bristow, VAN179MEFlight Rt LLC · Thonotosassa, FLN180KHPwx Services · Bristow, VAN181MECoastal Marine Engine Inc · Seattle, WAN18260Atc Trucking Inc · Miami, FLN1834UWirth Rodney A · Greenwood, ARN184SGNby Productions · Bristow, VAN18691869 Leasing LLC · Aurora, ORN188AGRvest Management LLC · Boulder City, NVN188CSJaae Inc · North Miami Beach, FLN189JMJsc Rentals LLC · Missoula, MTN190PDCommonwealth Of Puerto Rico Policia Of Puerto Rico · San Juan, PRN194TWGreenway William Kendal · Greensboro, GAN1962GGr Aviation LLC · Key Biscayne, FLN1962KMria LLC · Albuquerque, NMN196CPCivil Air Patrol · Maxwell Afb, ALN196TWTango Lima Flying LLC · Lawrence, KSN1SLHotel Kilo Aviation LLC · Anchorage, AKN202MCBeemer Companies · Fairmont, MNN204JHLivin The Dream Too LLC · St Paul, MNN204RSKenai Peninsula Air Transportation & Lodging LLC · Lake Havasu, AZN2059U5c Valley Aviation LLC · Sun Valley, IDN206AMLiu Ke · Millburn, NJN206AZGrant Investments LLC · Bakersfield, CAN206CVC & C Transportation Inc · Benton, LAN206DKFly Waveboard Inc Trustee · Wilmington, DEN206DTSchons Jeffrey · Pacific City, ORN206DVBowman And Dehn Enterprises Inc · Georgetown, DEN206DWAlaskan Start Aviation LLC · Midland, TXN206DYMorgan Farms LLC · Nyssa, ORN206EAAbrams Edward L · Roxbury, CTN206EEHastings Ranch Vineyard · Paso Robles, CAN206EMHoopes Turf Farm Inc · Ulysses, PAN206ETTorgerson Eric L · Ethridge, MTN206HGSeecat LLC · Palo Alto, CAN206HJRauch Peter · Austin, TXN206LWestern Air Pilots LLC · Mountain Home, ARN206LEFort Worth And Western Air Express LLC · Southlake, TXN206LGHotel Kilo Aviation LLC · Anchorage, AKN206LLMoondog Motorsports LLC · Missoula, MTN206MDAuction Aviation Inc · Boulder City, NV
Back to Cessna T206H