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.

N7157DNewgent Isaac T · Westminster, MDBuilt 1957 · S/N 22-5021N7157ZUrstadt Christopher M · Girdwood, AKS/N 18-1066N7158KDoody James P · South Glens Falls, NYBuilt 1950 · S/N 18-378N7159BHightower Michael L · Eureka, MTS/N 22-4384N715JYAirspace Aviation LLC · Valleyford, WABuilt 1951 · S/N 20-595N715RBFirst Love LLC · Sterling, AKBuilt 1977 · S/N 18-7709198N7160DDrain Alan K · Columbus, MTBuilt 1957 · S/N 18-5610N7161DOdegaard Wings Inc · Kindred, NDS/N 18-5611N7161KFleehearty Aaron T · Mooresville, INBuilt 1951 · S/N 20-682N7163DLaub-Elkins Jessie · Wasilla, AKS/N 18-5617N7164BRobinson Eric C · Palmer, AKBuilt 1956 · S/N 18-5190N7164KSwanson Thomas J · Pukwana, SDBuilt 1950 · S/N 18-382N7166BWard Joseph C · Anchorage, AKBuilt 1956 · S/N 18-5193N7166DHewko Murray L · Ely, NVFirst renewal noticeBuilt 1957 · S/N 18-5624N7167BEsmailka Harold E · Ruby, AKS/N 18-5196N7168KDotzenroth David A · Watertown, MNBuilt 1950 · S/N 18-388N7169BNorthern Peaks Flight Training LLC · Wasilla, AKS/N 18-5198N7170BZimniewicz Matthew J · River Falls, WIBuilt 1956 · S/N 18-5200N7171DClement Aircraft LLC · Anchorage, AKBuilt 1957 · S/N 18-5629N7172KMeader Derek S · Marfa, TXBuilt 1950 · S/N 18-396N7173BEavenson Daniel Scott · Ripon, CAS/N 18-5203N7173ZAir Kraft Spraying Inc · Timber Lake, SDBuilt 1964 · S/N 25-3041N7174ABertrand Jeff J · Willow, AKBuilt 1940 · S/N 5908N7174BMercil Richard · Grand Forks, NDBuilt 1956 · S/N 18-5205N7174KBracarelli Lisa A · Big Lake, AKBuilt 1951 · S/N 18-393N7175DSale Reported · Brainerd, MNSale reportedBuilt 1957 · S/N 18-5634N7175KTaildragger Aero LLC · Saint John, WABuilt 1951 · S/N 20-677N7177DMurphy Brandon M · Edinburg, PAS/N 18-5636N7178KPavlus Igor V · Wasilla, AKBuilt 1950 · S/N 18-549N7179BBue B G · Palmer, AKBuilt 1957 · S/N 18-5222N7179DLeggett Bryce L · Eola, TXBuilt 1957 · S/N 18-5638N717JDKerr Ryan R · Mora, MNS/N 18-7798N7180BMcelhaney Robert L · Anchorage, AKBuilt 1956 · S/N 18-5219N7180WButler Blake B · Shelbyville, TNS/N 11-955N7181BSkelton Stanford J DBA · Ely, MNBuilt 1956 · S/N 18-5220N7182BAbbott Barry · Sterling, AKBuilt 1956 · S/N 18-5221N7183DFedorko Michael III · Spearfish, SDS/N 18-5647N7184BBaldwin C R · Kenai, AKBuilt 1956 · S/N 18-5224N7184DWinters Jack F Jr · Fairbanks, AKBuilt 1957 · S/N 18-5649N7185BKistler Mark A · Wasilla, AKBuilt 1956 · S/N 18-5226N7186BSims William E · Anchorage, AKBuilt 1956 · S/N 18-5229N7186DHollingsworth Lloyd D · Anchorage, AKBuilt 1957 · S/N 18-5651N7187ZFlight Tech LLC · Prosser, WAS/N 18-8299N718EBerry Darrel · Camden, TNBuilt 1943 · S/N 30280N718HRMiller Glenn E · Albany, ORBuilt 1967 · S/N 18-8500N7190BKing Tyler Brooks · Saint Stephen, SCBuilt 1956 · S/N 22-4385N7190DWard Ben N · Salcha, AKBuilt 1957 · S/N 18-5657N7191DDahlen Bear A · Eugene, ORBuilt 1957 · S/N 18-5658N7191ZDunn Blake C · Bristol, COBuilt 1964 · S/N 25-3076N7192ZAce Aeromotive Inc · Miami, FLS/N 25-3079
Back to AD 99-01-05 R1