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.

N33403Drag Your Tail LLC · Lewes, DEBuilt 1940 · S/N 5-492N3340BHao Hangar Rats LLC · Fairfield, OHS/N 22-2155N3340MScheer Darin B · Farson, WYBuilt 1947 · S/N 12-2200N33410Newberry Brandon G · Kevil, KYBuilt 1940 · S/N 5-500N33415Million John B · Westminster, MDS/N 5-505N3341AHolbrook Tmothy D · Traverse City, MIS/N 22-1507N3341BPort Townsend Aero Museum · Port Townsend, WABuilt 1954 · S/N 22-2156N3341MShoemaker Taj · Fairbanks, AKBuilt 1947 · S/N 12-2051N33421Koemer Aviation Inc · Kankakee, ILBuilt 1940 · S/N 5-510N33427Bohmer Timothy C · Detroit Lakes, MNBuilt 1940 · S/N 4-1369N3342BAmy Jason R · Minneola, KSBuilt 1954 · S/N 22-2157N3342MMorris John B · Sterling, AKS/N 12-2201N3342ZNies Juergen · Winchester, VABuilt 1960 · S/N 22-7282N33438Roholt Philip C · Canton, OHBuilt 1940 · S/N 5943N3343MJelinski John J · Duluth, MNBuilt 1955 · S/N 12-2206N33442Chinlund Jeffrey B · Greenville, NCBuilt 1940 · S/N 5957N3344BVan Vleet Clifford · Sierra Vista, AZBuilt 1954 · S/N 22-2159N33453Piper Gary S · Hendersonville, TNBuilt 1940 · S/N 5962N33461Bennett Robert M · Felton, DEBuilt 1940 · S/N 5970N33465Mcclintock Matthew Patrick · Oscoda, MIBuilt 1940 · S/N 5976N3346BHospodar Robert P · Georgetown, PAS/N 22-2161N3347ARegistered aircraftBuilt 1953 · S/N 22-1617N33481Christie Ian A H · Limon, COBuilt 1940 · S/N 5991N3348MSpeerstra Adam W · Glennallen, AKBuilt 1947 · S/N 12-2207N33497Cleveland David L · Penn Yan, NYBuilt 1940 · S/N 6029N3349MDunkley Bret Y · Kotzebue, AKBuilt 1947 · S/N 12-2208N3349ZPorter Curtiss L · Woodscross, UTBuilt 1960 · S/N 22-7289N334SSchneider Michael H · Inola, OKBuilt 1938 · S/N 5-218N3350ZKintner Daniel S · Conyers, GAS/N 22-7290N3351BWysocki James E · Somers, CTS/N 18-3304N3352BRey Aviation LLC · Weston, FLBuilt 1954 · S/N 18-3305N3352ZLoppnow Martin L · Yermo, CAS/N 22-7292N3353AKennedy Craig E · Rock River, WYBuilt 1953 · S/N 18-2986N33542Schmidt David L · Wasilla, AKBuilt 1957 · S/N 22-5108N3354ZJohnson Charles D · Benson, AZBuilt 1960 · S/N 22-7294N3355BGar Aviation Inc · Lexington, ORBuilt 1954 · S/N 18-3308N3356MH E P Flying Club Corp · Wyoming, MNBuilt 1947 · S/N 12-2184N3357ABeachum Norman L · Foristell, MOBuilt 1953 · S/N 18-3004N3357MSmith James R · Toney, ALBuilt 1947 · S/N 12-2049N3357ZHannon Harland N · Big Lake, AKBuilt 1960 · S/N 22-7297N3359BWoodman Dwight C · Windham, MES/N 18-3313N3359MWarren Wesley L · Coeur D Alene, IDBuilt 1947 · S/N 12-2216N3359ZKistler Stephen M Trustee · Monument, KSBuilt 1960 · S/N 22-7299N335PABorek Thomas J · Homestead, FLBuilt 1979 · S/N 18-7909158N3360PThomas Lyndon J · Wasilla, AKBuilt 1950 · S/N 18-391N3361ANimmick Robert A · Three Forks, MTFirst renewal noticeS/N 20-1067N3361BSmith Marcus H · Roxboro, NCS/N 22-2166N3361MTrinkle Chris · Heyburn, IDS/N 12-2240N3363A7ac Club Inc · Clearwater, FLBuilt 1953 · S/N 22-1665N3363MGlatt David · Bonita Springs, FLBuilt 1947 · S/N 12-2219
Back to AD 99-01-05 R1