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.

N41594Butler John P · Hazelhurst, WIBuilt 1994 · S/N 1809113N4159AHauser Associates Inc · Coral Gables, FLBuilt 1994 · S/N 1809106N4159DBachman Aviation LLC · Independence, IAS/N 1809110N4159HSponsler Frederic L · Fox River Grove, ILBuilt 1948 · S/N 15-42N4159MShapnek Lawrence R · Cedar Crest, NMBuilt 1947 · S/N 12-3058N4159SCrew Marshall D · Spokane, WABuilt 1994 · S/N 1809109N4161HMintkenbaugh Russell Robert · West Chester, OHBuilt 1948 · S/N 15-43N4163HPetro Jerry R · Williamsburg, VABuilt 1948 · S/N 15-47N4165HPokki Thomas B · East Templeton, MABuilt 1948 · S/N 15-48N4165MJones Donald T · Barrigada, GUS/N 12-3066N4165ZHollingsworth Lloyd Dan · Anchorage, AKBuilt 1965 · S/N 18-8346N4166MWoolace James L · North Pole, AKBuilt 1947 · S/N 12-3065N4167ZGolden Arrow Aviation Inc · Wilmington, DEBuilt 1965 · S/N 18-8349N4169MHaroldson Tyler J · Wasilla, AKBuilt 1947 · S/N 12-3063N416GASugden William H · Alexandria, MNBuilt 1954 · S/N 121108N416RKWindyfork LLC · Black Mountain, NCBuilt 1966 · S/N 18-8434N416SMCentral Valley Air LLC · Logan, UTS/N 18-8109061N4172HMckinney James V · Yucaipa, CABuilt 1948 · S/N 15-55N4172MWeber Keith T · Rubicon, WIBuilt 1947 · S/N 12-3073N4173HJenkins James L · Lake Stevens, WAS/N 15-56N4173MReints Rydell J · Wasilla, AKBuilt 1947 · S/N 12-3072N4173ZHelmericks Aaron W · Wasilla, AKBuilt 1965 · S/N 18-8351N4175HWhitford John A II · Weedsport, NYBuilt 1948 · S/N 15-57N4176GSchott Milbert F · Richland Center, WIBuilt 1948 · S/N 15-309N4177EAerial Banners North Inc · Pembroke Pines, FLBuilt 1978 · S/N 25-7856059N4177HEiden Carson J · Central, AKBuilt 1948 · S/N 15-59N4177ZCruiser LLC · Munger, MIBuilt 1966 · S/N 18-8355N4178HColomello Charles P · Tillson, NYBuilt 1948 · S/N 15-61N4179ZTnt Farms · Marana, AZBuilt 1966 · S/N 18-8359N4180MFast Mover Aviation LLC · Fort Smith, ARBuilt 1947 · S/N 12-3084N4180ZSale Reported · Abilene, TXSale reportedBuilt 1966 · S/N 18-8360N4181HBarnett Keith T · Holmes, NYS/N 15-64N4181ZBraswell William J · Belzoni, MSBuilt 1966 · S/N 18-8365N4182MGreer Guy A · Wasilla, AKBuilt 1947 · S/N 12-3089N4182ZKing Air Inc · Naknek, AKBuilt 1966 · S/N 18-8367N4183HLazor Ronald E · Middlefield, CTBuilt 1948 · S/N 15-66N4183ZTirrell Troy L · Cordova, AKBuilt 1966 · S/N 18-8368N4184HArrow Alan B · Magnolia, TXBuilt 1948 · S/N 15-67N4184ZCross L Ranch Inc · Cohagen, MTBuilt 1966 · S/N 18-8369N4185HColton F D · Canby, ORS/N 15-68N4185ZHill Leslie E · Patten, MEBuilt 1966 · S/N 18-8370N4186HMiller Paul D · Sterling, VABuilt 1948 · S/N 15-69N4186ZSturgeon Ronald A · Anchorage, AKBuilt 1966 · S/N 18-8371N4187ZPickus Norman F · Fairbanks, AKBuilt 1966 · S/N 18-8372N4188MLindholm Michael D · Anchorage, AKBuilt 1947 · S/N 12-3078N4188ZDanielson Debra · Skillman, NJBuilt 1966 · S/N 18-8373N4189HDouble D Aircraft LLC · Sergeant Bluff, IABuilt 1948 · S/N 15-72N4189MSchettler Patrick J · Garnett, KSBuilt 1947 · S/N 12-3090N418BSNorton Ranch LLC · Baker City, ORBuilt 1947 · S/N 12-2831N4190ZWinn Derek H · Joseph, ORBuilt 1966 · S/N 18-8374
Back to AD 99-01-05 R1