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.

N7121ZQuality Aviation Inc · Marana, AZS/N 25-2920N7122BCgu Aviation LLC · Naples, FLBuilt 1956 · S/N 22-4340N7122KMacleod Gary G · Valentine, NES/N 18-335N7124KBlackburn Douglas W · Auke Bay, AKBuilt 1950 · S/N 18-342N7126DKintner Daniel S · Conyers, GABuilt 1957 · S/N 22-4986N7126KWaller David · Carthage, MOBuilt 1958 · S/N 18-344N7127BGeorge William A · Denton, TXBuilt 1956 · S/N 22-4345N7128BNitchie George · Ray, MIBuilt 1956 · S/N 22-4346N7129DBusse Charles U · Cary, ILBuilt 1959 · S/N 22-4989N7129ZBlue Ridge Soaring Society Inc · New Castle, VABuilt 1964 · S/N 25-2947N712LDia Development LLC · Mesa, AZBuilt 1956 · S/N 18-5082N712PJason Schwitters Farm Inc · Clara City, MNBuilt 1947 · S/N 12-1670N712RFix Wing LLC · Fort Lauderdale, FLBuilt 1967 · S/N 18-8556N7130DSorenson Gregory John · Hope, AKBuilt 1957 · S/N 22-4992N7131BWeisel Jeffrey W · Prescott, AZBuilt 1956 · S/N 22-4350N7132BConsolini Joseph · Driggs, IDBuilt 1964 · S/N 22-4351N7134DSprenger Mark R · Eagle River, AKBuilt 1957 · S/N 22-4997N7134KMcalister Mark H · Medford, ORBuilt 1950 · S/N 18-352N7135BHillegeist Tracy L · Beverly, KSS/N 22-4354N7138BJlg3 LLC · Wentworth, SDBuilt 1956 · S/N 22-4358N7138DFiebig Joel · Sebewaing, MIBuilt 1957 · S/N 22-5001N7139KCool Tail Draggers LLC · Red Oak, IABuilt 1950 · S/N 18-356N713CGDarrow John Kenneth · Soldotna, AKBuilt 1979 · S/N 18-7909179N713CMLevy Jeremy · Apopka, FLBuilt 1947 · S/N 12-3915N713WKLegends Air Center LLC · Bentonville, ARBuilt 1959 · S/N 18-7182N7140DRiedeman Thomas D · Genoa, OHBuilt 1957 · S/N 22-5003N7140KChandelle Ltd · Brighton, COBuilt 1950 · S/N 18-358N7141BPatterson Brent E · East Aurora, NYBuilt 1956 · S/N 22-4361N7142DHarper Michael E · Cloquet, MNBuilt 1957 · S/N 22-5005N7142KHogan Mark C · Bend, ORBuilt 1950 · S/N 18-360N7144DRichardson James G · Fremont, CAFirst renewal noticeBuilt 1957 · S/N 22-5007N7145KBurg Robert L · Fairbanks, AKBuilt 1950 · S/N 18-365N7145ZSkyberg Jeffrey A · Circle, MTBuilt 1965 · S/N 18-8263N7148KNormark Ronald L · Weirsdale, FLBuilt 1950 · S/N 18-367N7149KMichel Daniel T · Sterling, AKBuilt 1950 · S/N 18-369N714DJKodiak Aviation LLC · Kodiak, AKBuilt 1959 · S/N 18-7106N7150KEmerson Bryan T · Willow, AKBuilt 1951 · S/N 20-689N7152BKing Robert · Brush Prairie, WAS/N 22-4376N7152DWiese David · Ash Grove, MOBuilt 1957 · S/N 22-5016N7152KWheeler Donald C · Eureka, CABuilt 1950 · S/N 18-373N7153KTallgrass Aviation LLC · Sharon Springs, KSBuilt 1950 · S/N 18-372N7153ZCarson Cubs LLC · Yelm, WABuilt 1965 · S/N 18-8266N7154KSwanson Gc · Valentine, NES/N 18-374N7154ZCopper River Airmotive LLC · Copper Center, AKBuilt 1965 · S/N 18-8268N7155DTetzlaff Christian D · Athens, GAS/N 22-5019N7155KSheffels L And Son · Wilbur, WABuilt 1950 · S/N 18-375N7156BJstream Lc · Sheridan, WYS/N 22-4381N7156DWilliams Eron T · Overbrook, KSBuilt 1957 · S/N 22-5020N7156KAttwood Nona M · Fairbanks, AKS/N 18-377N7156ZClum David V · Anchorage, AKBuilt 1965 · S/N 18-8270
Back to AD 99-01-05 R1