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.

N78661Niskanen Sam C · Cologne, MNBuilt 1947 · S/N 11-1422N78664Johnson Eric C · Turtle Lake, NDBuilt 1947 · S/N 11-1425N78667Rendel James L · Rock Hill, SCBuilt 1947 · S/N 11-1428N78669Wilken Lance A · Fairmont, MNFirst renewal noticeS/N 11-1430N78673Gollobit Matthew W · Pierce, NEBuilt 1947 · S/N 11-1434N78675Grenier Laurent E · Monmouth, MEBuilt 1947 · S/N 11-1436N78679Azevedo Manuel J · Modesto, CABuilt 1947 · S/N 11-1440N7867DPowell Mark F · Kenai, AKS/N 186021N7867HJenkins Joe C · Wyoming, DEBuilt 1946 · S/N 12-770N78682Daddow And Sons · Nicolaus, CABuilt 1947 · S/N 11-1443N78684Johnson Timothy D · Chapel Hill, NCBuilt 1947 · S/N 11-1445N78685Smith James A · Lyle, WAS/N 111446N78686Deberry Stephen W · Westminster, MDBuilt 1947 · S/N 11-1447N78688Benninger Timothy A · Cobleskill, NYS/N 11-1442N7868DAustin Vernon · Decatur, ALBuilt 1957 · S/N 18-6022N78692Garman Benjamin N · Alzada, MTBuilt 1947 · S/N 11-1459N78696Richardson David H III · Brandon, SDBuilt 1947 · S/N 111460N78697Barnes Robert R · Okeechobee, FLBuilt 1947 · S/N 11-1461N78699King Fitzwilliam W Jr · Marietta, SCBuilt 1947 · S/N 11-1463N7869DThorn Scott E · Eagle River, AKBuilt 1957 · S/N 18-6024N7869HHreshchyshyn Marta S · Eagle River, AKS/N 12-772N786JEEllis James F · Wasilla, AKFirst renewal noticeBuilt 1947 · S/N 12-789N786MMagnuson Robert L Jr · Mc Grath, AKFirst renewal noticeBuilt 1970 · S/N 18-8898N78702Celestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1947 · S/N 12-3981N78704Buhler Brian · Wasilla, AKBuilt 1947 · S/N 12-3963N78705Olsen Victor L · Nome, AKBuilt 1947 · S/N 12-3962N78706Mellor Bradford A · Spanish Fork, UTBuilt 1947 · S/N 12-3982N78708Davies Thomas V · Chula Vista, CABuilt 1947 · S/N 12-3984N7871Aderman Nick · Palmer, AKBuilt 1947 · S/N 12-3986N78714Closson Luke E Jr · Valdosta, GABuilt 1955 · S/N 11-1465N78724Martel Tara M Personal Representative · Friday Harbor, WAS/N 11-1476N78726Petersen Randy N · East Wenatchee, WAS/N 11-1478N78730Stadler David J · Wenatchee, WAFirst renewal noticeBuilt 1947 · S/N 11-1482N78731Griffen Thomas A · Baudette, MNS/N 11-1483N78732Kiehl Dwane · Winnett, MTBuilt 1947 · S/N 11-1484N78735Holt Bill R · Ralph, SDBuilt 1947 · S/N 11-1487N78739Hall Ray · Milton Freewater, ORS/N 11-1511N78740Brown Melvin Wayne Jr Trustee · Shady Shores, TXBuilt 1947 · S/N 11-1512N78741Hayton James B III · Sedro Woolley, WABuilt 1947 · S/N 11-1513N78742Buvens Michael Paul · Walker, LABuilt 1947 · S/N 11-1514N78743Smith Gregory A · Lewistown, MTBuilt 1947 · S/N 11-1515N78749Dillman Donald L · Victor, NYBuilt 1947 · S/N 11-1521N7874DSipes Greg A · North Pole, AKS/N 18-6029N78754Klingenberg Timothy C · Udall, KSBuilt 1955 · S/N 111528N78759Dyer James E Trustee · Brighton, COBuilt 1956 · S/N 11-1533N7875DUnited States Department Of Interior · Boise, IDBuilt 1957 · S/N 18-6030N78762Phillips Sportflyers LLC · Daleville, INS/N 11-1537N78772Egrass Robert Dean · Mc Grath, AKFirst renewal noticeBuilt 1947 · S/N 11-1550N78775Bent James L Jr DBA · Palatine Bridge, NYS/N 11-1553N78780Cook Charles N · Lakeside, TXBuilt 1956 · S/N 11-1558
Back to AD 99-01-05 R1