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.

N29YCAg One Aviation LLC · Villa Grove, ILS/N 1809068N2AYLawrence Brant E · Paulden, AZS/N 12-1038N2BEGiber Sharon G · New Port Richey, FLS/N 15-162N2GVKubecka Daniel P · Edna, TXBuilt 1946 · S/N 12-824N2JPeracca Sam J · Orland, CABuilt 1946 · S/N 12-778N2KAMorinaka Noble Jr · Nyssa, ORBuilt 1978 · S/N 18-7809116N2LBSemler Jason S · Wasilla, AKBuilt 1961 · S/N 18-7532N2NYBoyle Frederick W Sr · Cape May, NJBuilt 1956 · S/N 22-3822N2PTWiger Theodore L · Falcon Heights, MNBuilt 1959 · S/N 22-6814N2QHOconnor Lloyd T · Dillingham, AKBuilt 1957 · S/N 22-5780N30002Drean Gary T · Rancho Santa Fe, CABuilt 1963 · S/N 187998N3000MLong Verl L · Lewiston, IDBuilt 1947 · S/N 12-1568N3000ZRegistered aircraftBuilt 1959 · S/N 22-6950N3001MBlank Slate Enterprises LLC · Pendleton, ORS/N 12-1718N3002ZKirkendall James Allen · N Richland Hills, TXBuilt 1959 · S/N 22-6953N3003ZPennewell Ollie L III · Monroe City, MOBuilt 1959 · S/N 22-6954N3004MPieper Jeffrey L · York, NEBuilt 1947 · S/N 12-1569N3004ZNantz William G · Raleigh, NCBuilt 1959 · S/N 22-6955N3005ZStamp Christopher L · Rock Stream, NYBuilt 1959 · S/N 22-6956N3007MThomas Avery · Bellemont, AZBuilt 1947 · S/N 12-1706N3009MBeebe Randolph G · Duluth, MNBuilt 1947 · S/N 12-1708N300JFKempf Chris J · Kenai, AKBuilt 1977 · S/N 18-7709136N300TOlsen M Lindsay · Prairie Village, KSBuilt 1953 · S/N 18-2414N3010MAtlseimer John C · Ione, CABuilt 1947 · S/N 12-1709N3010ZClemente Matthew J · Troy, NYBuilt 1959 · S/N 22-6961N3011CMatthews Franklin L · Mc Alpin, FLFirst renewal noticeS/N 4-571N3012MWatkins Brian D · Vancouver, WAS/N 12-1571N3012ZChase 13 LLC · Wilmington, DEBuilt 1959 · S/N 22-6963N3013MDavis David N · Haskell, OKBuilt 1947 · S/N 12-1573N3014MBaum James L Trustee · Anchorage, AKBuilt 1947 · S/N 12-1572N3015ZPittman Leo B · Stanfield, AZBuilt 1959 · S/N 22-6966N3017MRwm Aviation LLC · Kalispell, MTBuilt 1947 · S/N 12-1714N3020ZCapece Richard N · Leonardtown, MDS/N 22-6972N3021MNelson William R · Caldwell, IDBuilt 1947 · S/N 12-1576N3021ZRichard Harold L Jr · Greencastle, PABuilt 1959 · S/N 22-6974N3022MEllis Darry Lynn · Wasilla, AKBuilt 1946 · S/N 12-1722N3022ZVan Helsdingen Riaan · Rapid City, SDS/N 22-6975N3025MStevenson Jack G III · Cordova, AKBuilt 1947 · S/N 12-1723N3026MBailey Damion H · Sutton, AKBuilt 1947 · S/N 12-1731N30270Luminair Inc · Ashland, ORBuilt 1940 · S/N 5-162N30272James Rick L · Fort Wayne, INBuilt 1940 · S/N 4751N30279Smith Daniel Bruce · Boonville, NCBuilt 1940 · S/N 5163N3027MBuck Timothy A · Howland, MEBuilt 1947 · S/N 12-1741N3027ZDavis Robert · Wasilla, AKBuilt 1958 · S/N 22-6248N3028ZDavis Robert L · Wasilla, AKS/N 22-6982N3029MBaumgartner Rhone J · Mc Grath, AKS/N 12-1720N3029ZSuper 20 LLC · Brandon, SDBuilt 1959 · S/N 22-6983N302CBGordon David W · Saint Louis, MOBuilt 1940 · S/N 4104N302SHPaola Brett · Anchorage, AKS/N 18-2679N30312Phillips Philip J · Monticello, MNBuilt 1940 · S/N 5-169
Back to AD 99-01-05 R1