Skip to content

Registered aircraft · 8,920

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
ORDER BY n_number

Run 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.

N3412ZBeck Gary E · Richlands, NCBuilt 1960 · S/N 22-7325 N3414ANase Jeffrey D · Anchorage, AKBuilt 1953 · S/N 22-1683 N3414ZPulliam Anthony L · Lancaster, CABuilt 1960 · S/N 22-7327 N3416ATysland Lauren W · Madera, CABuilt 1953 · S/N 22-1684 N3417ABishop Thomas W · Decatur, TXBuilt 1953 · S/N 22-1687 N3419APaul Amy K · Anchorage, AKBuilt 1953 · S/N 22-1692 N3419ZVintage Piper LLC · Lexington, KYS/N 22-7332 N341AKGoddard Gary · Ohkay Owingeh, NMS/N 227411 N341CHAce Flight Center Inc · St Thomas, VIBuilt 1980 · S/N 27-8154006 N3420PKeyuravong Pisonth · Anchorage, AKBuilt 1958 · S/N 23-1384 N3424ZSemon Sheldon W · Galt, CABuilt 1960 · S/N 22-7337 N3425AMansell Matthew E · Napoleon, MOBuilt 1953 · S/N 22-1693 N3428AMorrissey Philip A · Templeton, MAS/N 22-1698 N3428ZHefner Ronald J · Plattsmouth, NES/N 22-7341 N3429ZWaters Dwayne R · Merritt Island, FLBuilt 1960 · S/N 22-7343 N3430PChamberlain Paul E · Troup, TXBuilt 1958 · S/N 23-1396 N3432AHolbrook Joel P · Delta Junction, AKBuilt 1953 · S/N 22-1699 N3433ZKitchen Ronald L · Leasburg, MOFirst renewal noticeBuilt 1960 · S/N 22-7347 N3434PNasair LLC · Flower Mound, TXBuilt 1958 · S/N 23-1401 N3436ZRasch Bernard A · Benton City, WABuilt 1960 · S/N 22-7351 N3439ASellers William R · Parker City, INBuilt 1953 · S/N 22-1707 N3441ZVan Devander Herman C · Wetumpka, ALBuilt 1960 · S/N 22-7360 N3442POttmann Robert · Indialantic, FLBuilt 1958 · S/N 23-1410 N3444ZLewanski Richard B · Sheridan, ILS/N 22-7363 N3445APennington Airmed Logistics LLC · Calhoun, LABuilt 1953 · S/N 22-1715 N3446AAshby Natasha E · Winnemucca, NVBuilt 1953 · S/N 22-1716 N3447PSimonovich Sheldon K · Fredericksburg, VABuilt 1958 · S/N 23-1418 N3448ABacklund Scott W · Greybull, WYBuilt 1953 · S/N 22-1706 N3448PDabney Richard W · Tanner, ALBuilt 1958 · S/N 23-1419 N344BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 4496582 N344TXCline Lyndi · Royce City, TXBuilt 1966 · S/N 24-4478 N3450AScootair LLC · Alburgh, VTBuilt 1953 · S/N 22-1719 N3451ZHarris Michael E · Greenville, SCS/N 22-7370 N3452AMolek Jon · Warren, OHS/N 22-1725 N3452ZChief LLC · Du Quoin, ILBuilt 1960 · S/N 22-7371 N3454ABasler Leon E · Sainte Genevieve, MOBuilt 1953 · S/N 22-1723 N3455AKoelsch Benjamin · Nome, AKBuilt 1956 · S/N 22-3875 N3456PBels Holdings LLC · Albert Lea, MNBuilt 1958 · S/N 23-1428 N3457PSewade Dawn M · New River, AZBuilt 1958 · S/N 23-1429 N3457ZHanus Phillip J · Ashley, MIBuilt 1960 · S/N 22-7378 N3458AWilliams Kenneth R · Pendleton, ORBuilt 1953 · S/N 22-1727 N3459ADejesus Kennet J · Troy, OHBuilt 1953 · S/N 22-1734 N345FAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1979 · S/N 44-7995326 N345HPMarek Gary A · Lemont, ILBuilt 1961 · S/N 24-2508 N345JGGo Fly Inc · Spring Hill, FLBuilt 1959 · S/N 23-1825 N3461AAviation Developers Inc · Highlandville, MOBuilt 1953 · S/N 22-1735 N3462ZWilson Anthony J · Bartlett, TNBuilt 1960 · S/N 22-7384 N3463ZJordan Dalton · Pataskala, OHBuilt 1960 · S/N 22-7385 N3464AIrwin William L · Colleyville, TXS/N 22-1737 N3465ZLutter Trent L · Hoven, SDBuilt 1960 · S/N 22-7387

Back to AD 85-02-05 R1