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.

N2592SSchaller Lee · New Athens, ILS/N 18-7909166N2594MBertke Matthew B · Anchorage, AKS/N 12-1037N2596ARoach Wesley R · Marietta, GABuilt 1952 · S/N 22-875N2596JMarkshausen Zeke R · Santa Paula, CABuilt 1979 · S/N 18-7909121N25977Kilburn Terry L · Edinboro, PABuilt 1939 · S/N 3920N25986Douglas R Herlihy LLC · Goldendale, WABuilt 1939 · S/N 3934N2598PLeonard David J · Bettles Field, AKBuilt 1955 · S/N 18-4346N25994Myrick Richard L · Williamson, GABuilt 1939 · S/N 3952N25KMMacdonald Kenneth A · Willow, AKBuilt 1979 · S/N 188009017N25TJFerraro Thomas P · Mckinney, TXBuilt 1959 · S/N 22-6676N2600ZShort Seth J · Liberty Lake, WABuilt 1969 · S/N 18-8844N2601SHcs Air LLC · Devalls Bluff, ARBuilt 1979 · S/N 18-7909167N26053Duck Donald · Edwardsburg, MIBuilt 1939 · S/N 3991N26058Clifton Ronald L · Circleville, OHBuilt 1941 · S/N 6612N2607PFattrusso Louis Anthony · South Chesterfield, VAS/N 22-2942N26085Van Nostran Seth A · Doylestown, OHS/N 4023N2608MEhrenfelt Linda Mae · Pierre, SDBuilt 1946 · S/N 12-1074N2610AGreen-Way Essentials LLC · Arkansas City, KSBuilt 1952 · S/N 22-891N2612MGreenhalgh Janna L · Caldwell, IDBuilt 1946 · S/N 12-964N2613PBraun Daniel R · Damascus, ORS/N 22-2948N26144Jackson Robert L · Leesburg, VABuilt 1940 · S/N 4-843N2614ADixon Eric A · Salado, TXBuilt 1952 · S/N 22-896N26154J4 Cub Partners LLC · Highwood, ILBuilt 1940 · S/N 4-855N2615MKelsey Mike · Carey, IDBuilt 1946 · S/N 12-1079N2616ARegistration Pending · Aleknagik, AKRegistration pendingBuilt 1952 · S/N 22-895N26170Figure I Foundation · Los Angeles, CABuilt 1940 · S/N 4102N26173Beaver Perry L · Vienna, OHBuilt 1940 · S/N 4100N26188Johnson Michael W · Youngsville, LABuilt 1940 · S/N 4865N26189Vanderbeek Robert K · Plainfield, ILBuilt 1940 · S/N 4108N2618ALevin Henry · Medford, ORS/N 22-902N2618PHenningson Terry · Centennial, COBuilt 1955 · S/N 22-2954N26196Schildberg Gregory M · Casey, IABuilt 1940 · S/N 4-872N26197Roberts Bruce D · New London, PABuilt 1941 · S/N 7076N2619PColdsmith Steven L · Chambersburg, PABuilt 1955 · S/N 22-2955N2620MBooth Chance · Wasilla, AKBuilt 1946 · S/N 12-1091N2621AFox Jeff R · Soldotna, AKBuilt 1952 · S/N 18-2168N2623MRegistration Pending · Anchorage, AKRegistration pendingBuilt 1956 · S/N 12-1092N2623PJd Aero LLC · Chester, SDBuilt 1955 · S/N 22-2959N2624AWsiaki Kenneth J · Northridge, CABuilt 1953 · S/N 22-1091N2624PRobinson Eric C · Palmer, AKS/N 22-2960N2625AGundersen James I · Townsend, MTBuilt 1952 · S/N 18-2170N2626PLeguia Augusto A · Kathleen, GABuilt 1955 · S/N 22-2963N2628PCraig Richard L · Sonoma, CAS/N 22-2965N262TBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCBuilt 1953 · S/N 18-2376N2631AHarper Clayton E · Seabrook, TXBuilt 1952 · S/N 22-903N2631PFriebel Mark A · Shelby, OHBuilt 1955 · S/N 22-2968N2632JDevries Mark R · Eagle River, AKBuilt 1957 · S/N 18-5858N2633AReich Dan E · Walla Walla, WABuilt 1952 · S/N 22-905N2635PSchuller Henry Michael · Arlington, WABuilt 1955 · S/N 22-2973N2637PMurray James A · Wasilla, AKBuilt 1955 · S/N 22-2975
Back to AD 99-01-05 R1