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.
N2456HPappusgrass Aviation LLC · San Antonio, TXN2456LNew West Ventures II Inc · Rancho Santa Fe, CAN24607Fey Properties LLC · Pleasanton, CAN2461FDietz Thomas · Mill Valley, CAN2464CCantera La Rita Inc · San Juan, PRN2468YGv Air Inc · Medford, ORN246MEWyoming Seaplanes LLC · Alpine, WYN2477XLecce Aviation LLC · Williamsport, PAN2478AEnnair LLC · Kalispell, MTN248RCMckinley I Blake Jr · Spokane Valley, WAFirst renewal noticeN248RRWalter Air Co LLC · Oakdale, CAN249FMValiair Limited Co Trustee · Casper, WYN250MELake Superior Aviation Llp · Duluth, MNN252CPCivil Air Patrol · Maxwell Afb, ALN255TMGiles Durham K · Davis, CAN256MBMunobraca LLC · Mcallen, TXN2588TAircraft Trustee Services Inc Trustee · Dover, DEN259BWPinal County Sheriffs Office · Florence, AZN261CPCivil Air Patrol · Maxwell Afb, ALN2626ZJf Aviation LLC · Minot, NDN2638ULindsey Aviation Services · Haslet, TXN263MECommercial Aerial Images Inc · Costa Mesa, CAN263RCRichland County Sheriffs Department · Columbia, SCN264ME618 Aviation LLC · Kosse, TXN26509Bell Air LLC · Belleville, KSN2650VSampson Merle A · Inver Grove Height, MNN266BBJk Air LLC · Duncan, OKN267ABConcrete Experts LLC · Colorado Springs, CON267JMMathews Development Co · Santa Rosa Beach, FLN268HPFlorida Highway Patrol · Tampa, FLN26NZBank Of Utah Trustee · Salt Lake City, UTN26VRReed Edward · Marcellus, MIN270MEMm Aviation LLC · Casa Grande, AZN271LDVan Well Trucking LLC · Dallas, ORN273METopel Holdings LLC · Scottsdale, AZN274CPCivil Air Patrol · Maxwell Afb, ALN278JHRaytheon Co · Tucson, AZN27DVDodson International Parts Inc · Rantoul, KSN27VANorton Mark H Trustee · Stateline, NVN281WSWight David · Alvin, TXN28206Huey David G · Sumas, WAN2829JSunrise Aviation LLC · Las Vegas, NVN285DVJohnson Jeffrey L · Fargo, NDN285JLLink Air Service LLC · Minong, WIN288JYNational Aircraft Leasing Corp · Greenville, DEN296PBChurch Aviation LLC · Christmas Valley, ORN297BCUnderwood David · Sarasota, FLFirst renewal noticeN298PN206 Cat Air LLC · Salem, ORN299KCKings County Sheriff'S Office · Hanford, CAN299MCN299mc LLC · Auburn, WA
Back to Cessna T206H