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.

N3683ZBaker Ed A · Newell, SDFirst renewal noticeS/N 18-7415N3684BBetts Brian N · Williamsfield, OHBuilt 1953 · S/N 183050N3684MWood Jeannette C · Raeford, NCBuilt 1947 · S/N 12-2632N3684ZStevenson William E · Sutton, AKBuilt 1960 · S/N 18-7416N3685ABartlett Jeffrey D · Black Diamond, WABuilt 1953 · S/N 18-3033N3685ZMaus Christopher J · Anchorage, AKBuilt 1960 · S/N 18-7417N3686AJohnson Donald E · Dillon, MTFirst renewal noticeBuilt 1953 · S/N 18-3034N3687MBush Pilot Inc · Soldotna, AKS/N 12-2535N3687NYanta Chris J · Rockport, TXBuilt 1947 · S/N 12-1937N3687PSochan Mark G · Gilroy, CAS/N 18-4588N3687ZScott Marilyn F Trustee · Sun City West, AZFirst renewal noticeBuilt 1960 · S/N 18-7420N3688AKjelsrud Gary L · Great Falls, MTBuilt 1953 · S/N 18-3036N3688MHammons Clayton W · Salome, AZBuilt 1946 · S/N 12-2634N3689APrevost Bryan · Lambert, MTBuilt 1953 · S/N 18-3037N3689MBurgan Christopher M · Woods Cross, UTBuilt 1947 · S/N 12-2636N3689PMcaneney Joseph R · Talkeetna, AKS/N 18-4590N3690AJohnson Mandley O Jr · Bismarck, NDBuilt 1953 · S/N 18-3038N3691AClark Clyde E · Naknek, AKBuilt 1953 · S/N 18-3039N3691ZRiedesel Ralph L · Paton, IABuilt 1960 · S/N 18-7426N3692ZRegistered aircraftBuilt 1960 · S/N 18-7427N3693NLucky 20 Gourmet And Adventure Club LLC · Syracuse, INBuilt 1947 · S/N 12-1943N3695ADehart T James Trustee · Kalama, WABuilt 1954 · S/N 18-3044N3695PHanafi Robert A · Wellton, AZBuilt 1955 · S/N 18-4597N3695ZSherrier Mark A · Tehachapi, CABuilt 1961 · S/N 18-7430N3696NCentral Virginia Flyers LLC · Palmyra, VABuilt 1947 · S/N 12-1947N3696ZGardner Thomas G · Lincoln, MEBuilt 1960 · S/N 18-7431N3697MOrtland Tanner Dodd · Anchorage, AKBuilt 1947 · S/N 12-2641N3697ZNorthern Wilderness Aviation LLC · Tok, AKBuilt 1960 · S/N 18-7433N3698APiper Super Cub 3698a LLC · Colorado Springs, COBuilt 1953 · S/N 18-3047N3698MPetersen Mark A · Willow, AKBuilt 1947 · S/N 12-2643N3698ZChippewa Aero LLC · Montevideo, MNBuilt 1960 · S/N 18-7434N3699NHall Darryl Wayne II · Wasilla, AKS/N 12-1949N3699ZWharton Conrad J · Leavenworth, WABuilt 1960 · S/N 18-7435N36KGBarry Robin · Lake Charles, LABuilt 1955 · S/N 18-4586N3700ACall One Inc · Clarinda, IABuilt 1953 · S/N 22-1942N3701PDibbell David L · South New Berlin, NYBuilt 1958 · S/N 22-6184N3702POlson Ezra Ross · Kingman, KSFirst renewal noticeBuilt 1955 · S/N 22-3418N3703PEvans Christopher W · Demotte, INBuilt 1955 · S/N 22-3419N3704PAlderman Mark C · Wasilla, AKBuilt 1955 · S/N 22-3420N3704ZGray Melinda G · Milan, ILBuilt 1960 · S/N 22-7573N3706ZHall John L · Port Angeles, WABuilt 1960 · S/N 22-7575N3707AMorris Charles W · Wasilla, AKFirst renewal noticeBuilt 1958 · S/N 18-3388N3707PHamm Russell K · Owasso, OKBuilt 1955 · S/N 22-3423N3708AFreyburger Paul W · Java Village, NYBuilt 1956 · S/N 18-3389N3708PAeromarine Consulting Inc · Brandon, FLBuilt 1955 · S/N 22-3424N3708ZReisman Richard H · Montrose, COBuilt 1960 · S/N 22-7577N3709AGeorge Daniel F · Seldovia, AKBuilt 1954 · S/N 22-1949N3712MChristy Alan M · Pendleton, ORS/N 12-2658N3712PPtl Endeavors LLC · Deland, FLBuilt 1955 · S/N 22-3430N3713MBurger Craig B · Sisters, ORS/N 12-2539
Back to AD 99-01-05 R1