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.

N6992KGeser Ryan · Newberg, ORBuilt 1949 · S/N 20-99N6992ZSoaring Club Of Houston Inc · Waller, TXBuilt 1964 · S/N 25-2742N6993BFarneski Robert B · Fairbanks, AKBuilt 1956 · S/N 18-5115N6993KHudock Cody Jacob · Kill Devil Hills, NCBuilt 1950 · S/N 20-100N6994KGarfield Joe · Morgan, UTBuilt 1950 · S/N 20-102N6995BChase Kenneth W · Anvik, AKS/N 18-5123N6995DZimmerman Christian · Anchorage, AKBuilt 1957 · S/N 18-5526N6995KShuey Kenny L · Neosho, MOBuilt 1950 · S/N 20-104N6996BAafedt Aaron B · Belgrade, MTBuilt 1956 · S/N 18-5124N6996DByrd David P · King Salmon, AKS/N 18-5527N6997DM & M Farms · Fowler, KSBuilt 1957 · S/N 18-5528N6998BKoch Michael L · Neosho, WIBuilt 1956 · S/N 18-5074N6999Mccown Robert D · Eagle River, AKBuilt 1970 · S/N 18-8881N69997Mckenney Bret · Billings, MTBuilt 1966 · S/N 18-8418N6999BGochenour Tim B · Macy, INBuilt 1956 · S/N 22-4139N6999KHalpin William J · Eden Prairie, MNBuilt 1950 · S/N 20-106N6999VBredthauer Glen E · Hastings, NEBuilt 1961 · S/N 18-7603N699AClifford Wiliam J · Williston Park, NYBuilt 1951 · S/N 22-102N699DSNimer David K · Malad City, IDBuilt 1953 · S/N 20-951N69FABeaumont James F · Caldwell, IDS/N 20-139N6ADBurchinal Issac Newton · Paris, TXS/N 12-730N6DSSmith Dwight K · Canby, ORBuilt 1961 · S/N 22-8898N6LFBeltz Richard D · Lehighton, PAS/N 17-134N6MXHale Mitchell D · Palmer, AKS/N 18-6650N6PFSoplanda Matthew J · Willow, AKBuilt 1952 · S/N 18-2007N6TDCapouch Michael J · Medaryville, INBuilt 1975 · S/N 18-7509108N6ZTLewis Eddy L · Cortez, COBuilt 1957 · S/N 18-5824N7001DOwens Eldon J · Arimo, IDS/N 22-4894N7001KJersey Devil Dusters LLC · Southampton, NJBuilt 1950 · S/N 20-108N7002KHeinze Gregory L · Little Rock, ARBuilt 1950 · S/N 20-107N7002ZKistler Michael J · Wasilla, AKS/N 18-8180N7003BByrd Kyle E · Unionville, MOBuilt 1956 · S/N 22-4253N7007KJackson Gary Lynn · Simms, TXBuilt 1950 · S/N 20-112N7007TAnderson Karen Lynn · Wasilla, AKBuilt 1960 · S/N 18-7322N7008BMayes Russell F · Farmersville, ILBuilt 1956 · S/N 22-4258N7009DRegistration Pending · Waupaca, WIRegistration pending, pending cancellationBuilt 1957 · S/N 22-4902N7009KRay Tyler D · Wasilla, AKBuilt 1950 · S/N 20-115N700PAW Patrick Enterprises Inc · Wilmington, DEBuilt 1946 · S/N 12-1400N7010BDurfee Tristan O · Duluth, MNBuilt 1956 · S/N 22-4260N7010KWiechmann Caleb · Prairie City, SDBuilt 1950 · S/N 20-116N7011BFuller Eddy A · Madras, ORBuilt 1956 · S/N 22-4262N7011DAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1957 · S/N 22-4904N7011KYoung Carl Jason · Lubbock, TXBuilt 1950 · S/N 20-117N7012DBarlow Jason P · Brighton, COBuilt 1957 · S/N 22-4905N7012KBoggasch Marie Sophie · Anchorage, AKS/N 20-118N7014ZBarrett Jane T · Tehachapi, CABuilt 1964 · S/N 25-2768N7016BUnable Direct LLC · Kalispell, MTS/N 22-4267N7017ZZimmer Chris P · Upham, NDBuilt 1964 · S/N 25-2772N7018DHoeksel Michael J · Poplar Grove, ILBuilt 1957 · S/N 22-4911N7018KWilliams Kiplin S · Midland, NCS/N 20-123
Back to AD 99-01-05 R1