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.

N32642Connor Terence J · West Chester, PABuilt 1940 · S/N 5511N3264PMoore Jeffrey · Cleveland, NYBuilt 1958 · S/N 18-6768N3264ZRyd Jan M · Lakewood, COS/N 22-7213N32651Classic Aircraft Restoration LLC · Gladstone, MIS/N 5354N32660Bendickson Carrie J · Garrison, NDS/N 5521N32664American Aviation II LLC · Peyton, COS/N 5523N32671Ricca Gregory F · Jonesboro, ARS/N 5530N32673Autry Lonnie E · San Jose, CABuilt 1940 · S/N 5532N3267BHilgendorf Ross E · Welcome, MNBuilt 1954 · S/N 22-2088N32686Fortney Deborah S · Union City, CABuilt 1940 · S/N 5374N3268AKistler Michael J · Wasilla, AKS/N 18-1986N3268BJohnson Randall A · Anaconda, MTBuilt 1954 · S/N 22-2089N3268NBenninger Timothy A · Cobleskill, NYBuilt 1952 · S/N 18-2014N32694Clements Cameron J · Beardstown, ILBuilt 1940 · S/N 4-1298N32698Similly Cyrus A · Hernando, FLS/N 4-1301N3269MMichael J Schwankl · Wasilla, AKBuilt 1947 · S/N 12-2127N326PCChristensen Darrel W Jr · Soldotna, AKBuilt 1958 · S/N 18-6554N326TYouth And Aviation Inc. · Thiensville, WIBuilt 1953 · S/N 18-2440N326TLCristal Air Inc · Wilmington, DEBuilt 1953 · S/N 18-2442N3270MWilde Air Service Huron LLC · Volga, SDS/N 12-2128N3270ZWhite Glenn A · Timber, ORS/N 22-7221N32710Nelson Larry Trustee · Almena, KSBuilt 1940 · S/N 5542N3271BOchs Robert D · Saint Louis, MOBuilt 1954 · S/N 22-2092N3271ZModra Anthony K · Fredonia, WIS/N 22-7222N32737Baker Ronald D · Scranton, KSBuilt 1940 · S/N 5569N3273BHultsch Kevin C · Lockport, ILS/N 22-2094N3273ZWeber John D · Shelbyville, ILBuilt 1960 · S/N 22-7224N3274ZHeide Jeffrey J · Kenosha, WIBuilt 1960 · S/N 22-7226N32754Maierhoffer Henry F Jr · Sylvania, GABuilt 1940 · S/N 5589N32758Sides Fred W · Medina, TXBuilt 1940 · S/N 5593N32775Jewell Aviation Inc · Kennett, MOBuilt 1940 · S/N 4-1308N3277MSmith Carmen Marie · Juneau, AKBuilt 1947 · S/N 12-2134N3277ZBacklund Scott W · Greybull, WYFirst renewal noticeS/N 22-7229N32788Soden Laurence L · Fairbanks, AKBuilt 1940 · S/N 5-384N3278BAllen Craig S · Hico, TXBuilt 1954 · S/N 22-2099N32791Nc32791 LLC · Colleyville, TXBuilt 1940 · S/N 5-385N32792Spear Mike J · Sandpoint, IDBuilt 1940 · S/N 5-386N3279ZLay Lawrence W · Douglass, KSS/N 18-7199N327AKPearce David W Trustee · Anchorage, AKBuilt 1981 · S/N 18-8109034N327TBuerk Christian E · West Ossipee, NHBuilt 1953 · S/N 18-2441N32809Kane Thomas Edward · Mc Alpin, FLBuilt 1945 · S/N 5618N32811Jennings Herschel Todd · Stone Mountain, GABuilt 1940 · S/N 5621N32814Greene Garry D · Clermont, GAS/N 5624N3281MSomerville Airport LLC · Grand Rapids, MIBuilt 1947 · S/N 12-2140N3282MLiddel Bruce N Trustee · Lawrence, KSBuilt 1947 · S/N 12-2137N3282ZWallace Aviation Inc · Wallace, NEBuilt 1959 · S/N 18-7204N32835Kolb Austin · Phoenixville, PAS/N 5646N32839Jastram Daniel P · White, GABuilt 1955 · S/N 5649N3283BGay Morgan C · Tunkhannock, PABuilt 1954 · S/N 20-1096N32848Mcgreevy Michael G · Brookline, MOBuilt 1940 · S/N 5656
Back to AD 99-01-05 R1