OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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
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:99-01-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:99-01-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.

N3435MJanson Matthew G · Midland, MIBuilt 1947 · S/N 12-2273N3436ZRasch Bernard A · Benton City, WABuilt 1960 · S/N 22-7351N3438MClark Stanley E Trustee · Redmond, ORBuilt 1947 · S/N 12-2276N3439ASellers William R · Parker City, INBuilt 1953 · S/N 22-1707N3439MRetzlaff Chris · Ripon, WIBuilt 1947 · S/N 12-2279N343AAAnding Paige E · Bryan, TXBuilt 1963 · S/N 18-7947N3440MNaples Seaplane Adventures LLC · Denmark, MES/N 12-2287N3441ZVan Devander Herman C · Wetumpka, ALBuilt 1960 · S/N 22-7360N3442MPierson Brett · Eagle River, AKBuilt 1947 · S/N 12-2283N3444ZLewanski Richard B · Sheridan, ILS/N 22-7363N3445APennington Airmed Logistics LLC · Calhoun, LABuilt 1953 · S/N 22-1715N3446AAshby Natasha E · Winnemucca, NVBuilt 1953 · S/N 22-1716N3447MRegistration Pending · Marstons Mills, MARegistration pendingBuilt 1947 · S/N 12-2065N3448ABacklund Scott W · Greybull, WYBuilt 1953 · S/N 22-1706N3448MCannell Kirby B · Salome, AZBuilt 1947 · S/N 12-2344N344WBeck Tom E · Homer, AKBuilt 1946 · S/N 12-775N3450AScootair LLC · Alburgh, VTBuilt 1953 · S/N 22-1719N3451MWilliamson Gary T · Ashmore, ILBuilt 1947 · S/N 12-2342N3451ZHarris Michael E · Greenville, SCS/N 22-7370N3452AMolek Jon · Warren, OHS/N 22-1725N3452ZChief LLC · Du Quoin, ILBuilt 1960 · S/N 22-7371N3453MSmith Matthew M · Anchorage, AKBuilt 1947 · S/N 12-2340N3454ABasler Leon E · Sainte Genevieve, MOBuilt 1953 · S/N 22-1723N3455AKoelsch Benjamin · Nome, AKBuilt 1956 · S/N 22-3875N3455MHall II Darryl Wayne · Wasilla, AKS/N 12-2324N3457ZHanus Phillip J · Ashley, MIBuilt 1960 · S/N 22-7378N3458AWilliams Kenneth R · Pendleton, ORBuilt 1953 · S/N 22-1727N3459ADejesus Kennet J · Troy, OHBuilt 1953 · S/N 22-1734N3461AAviation Developers Inc · Highlandville, MOBuilt 1953 · S/N 22-1735N3461MGrass Brian Shane · Ocala, FLBuilt 1947 · S/N 12-2316N3462ZWilson Anthony J · Bartlett, TNBuilt 1960 · S/N 22-7384N3463ZJordan Dalton · Pataskala, OHBuilt 1960 · S/N 22-7385N3464AIrwin William L · Colleyville, TXS/N 22-1737N3465ZLutter Trent L · Hoven, SDBuilt 1960 · S/N 22-7387N3466AClark Charles R · Mansfield, MOBuilt 1953 · S/N 22-1731N3466MLutes Ralph E · Shipshewana, INBuilt 1947 · S/N 12-1900N3467ARay William R · Pasadena, CAS/N 22-1736N3467Z67 Zulu LLC · Cherry Hill, NJBuilt 1960 · S/N 22-7391N3468ASteffen Zacharey P · Lincoln, NEBuilt 1953 · S/N 22-1755N3469MHoogeveen Douglas F · Clifton, COBuilt 1947 · S/N 12-2347N3469ZBerger Joyce F · Reno, NVBuilt 1960 · S/N 22-7394N3470MThoensen Thomas R · Delta, COBuilt 1947 · S/N 12-2348N3471ZWyly Billy W · Okaton, SDBuilt 1960 · S/N 18-7291N3472ZRubbert Randy C · Reynolds, NDS/N 18-7048N3473EVenture North Aviation LLC · Cloquet, MNBuilt 1955 · S/N 18-4262N3473MDavis Glenn A · Fair Oaks, CABuilt 1947 · S/N 12-2335N3473ZHanson John G · Marion, MTBuilt 1960 · S/N 18-7298N3474AHerring Adam · Navarre, FLBuilt 1953 · S/N 22-1750N3475ZReynolds Clark L · Rozet, WYS/N 18-7300N3478AVanmeter Ted A · Pleasanton, KSS/N 22-1747
Back to AD 99-01-05 R1