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.

N3053ZSonntag Franklin T · Stevensville, MDBuilt 1959 · S/N 22-7007N3054ZSandall Brian E · Lake Stevens, WABuilt 1959 · S/N 22-7008N30558Cardan Aircraft Services Inc · Red Bluff, CAS/N 4928N3056MGrald Jonathan A · New Hampton, NYS/N 12-1744N30589Heichel Philip D · Marquette, MIS/N 4957N3058MMcguire Patrick · Greenleaf, WIS/N 12-1585N3058ZLove Glen L · Poplar Grove, ILBuilt 1959 · S/N 22-7013N30595Edwards Brian L · Decatur, ILBuilt 1940 · S/N 4962N3061MSchmidt Anthony D Jr · Jordan, MNBuilt 1947 · S/N 12-1749N3061ZKell Thomas G · Anchorage, AKS/N 22-7016N30622Money Aerial Media LLC · San Diego, CABuilt 1940 · S/N 5-223N3062MRegistered aircraftS/N 12-1583N3062ZSchofield Wayne D · Polson, MTBuilt 1959 · S/N 22-7017N30633Ramin Reuben F · Tomball, TXBuilt 1940 · S/N 4984N3063ZSeiter Randy R · Lake Isabella, MIBuilt 1959 · S/N 22-7018N30648Bongard Fred · Torrance, CABuilt 1940 · S/N 5-227N3064ZReichlin Richard S · Traverse City, MIBuilt 1959 · S/N 22-7019N30658Mcmahan Jerry · Watson, ARBuilt 1940 · S/N 5-228N30679Inman Michael D · Raeford, NCBuilt 1940 · S/N 5-234N3067MKing Nolan · River Falls, WIBuilt 1947 · S/N 12-1754N30681Miller Lowell R · Budd Lake, NJBuilt 1940 · S/N 5-235N30688Taylor Steven L · Cerritos, CABuilt 1940 · S/N 5022N30690Melchiorre Joseph G · Lewes, DEBuilt 1940 · S/N 5238N3069MBrons Andrew S · Newfolden, MNBuilt 1947 · S/N 12-1755N306TWulle Bernard W · Battle Ground, INBuilt 1953 · S/N 18-2420N30704Martini Alan F · Boulder, MTBuilt 1940 · S/N 5-240N30705Gaya Shawn A · Wonder Lake, ILBuilt 1940 · S/N 5-241N3071MTraverse Air Inc · Traverse City, MIBuilt 1947 · S/N 12-1757N3072MMunter Craig A · Fontana, WIBuilt 1947 · S/N 12-1758N30736Kiss George C · Bangor, PABuilt 1940 · S/N 5076N3073ZStrid Julius M · Winlock, WABuilt 1959 · S/N 22-7030N30766Scotton Bradley D · Galena, AKBuilt 1940 · S/N 5098N30768Sheldon Jeffrey C · Hastings, NYBuilt 1940 · S/N 5253N3076MMckinney Leonard F Co Ow · Anchorage, AKBuilt 1947 · S/N 12-1762N30773Nc30773 LLC · Fishers, INBuilt 1940 · S/N 5-254N30776Jackson James E · Brainerd, MNBuilt 1940 · S/N 5108N3078ZSeiter Randy R · Lake Isabella, MIBuilt 1959 · S/N 22-7035N30795Atmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CAS/N 5-261N307WYCuruchet Shay F · Kaycee, WYS/N 18-7208N30808Newberry Daniel W · Kevil, KYFirst renewal noticeS/N 4-1242N3080MSuper Cruiser LLC · Palm City, FLS/N 12-1768N3080ZEriksson Kurt R · Soldotna, AKBuilt 1959 · S/N 18-7131N30821Kramer Peter W · Copper Center, AKBuilt 1940 · S/N 5-262N3082XJet X Leasing Inc · Johnson, KSBuilt 1957 · S/N 18-4668N3082ZRagwing Aero LLC · Brooksville, MSBuilt 1959 · S/N 18-7135N30838Evans Tyler A D · Muskogee, OKS/N 5138N3083MWeakley Companies LLC · Poland, NYBuilt 1947 · S/N 12-1771N3083XDenton Seth A · Oakesdale, WAS/N 2963N30842Wisler Donald J · Tampa, FLBuilt 1940 · S/N 5142N30848Graham Mt Ranch Inc · Broadus, MTBuilt 1940 · S/N 5-267
Back to AD 99-01-05 R1