OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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-05-13-R1-WD')
    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-05-13-R1-WD')
  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.

N4091SBeechcraft Heritage Museum · Tullahoma, TNBuilt 1975 · S/N CE-556N4092TEnnyx LLC · Clermont, FLBuilt 1974 · S/N E-556N4093EDmkr LLC · Coronado, CABuilt 1999 · S/N E-3293N4094S4094s LLC · Holly, MIBuilt 1975 · S/N TC-1840N4096SSmith Timothy M · Mount Pleasant, WIBuilt 1975 · S/N TC-1842N4099SDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N TE-1037N409MFenton Richard O · Weatherford, TXBuilt 1969 · S/N D-8981N409PDIowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1973 · S/N CE-450N409RCrawford Russell W · Hurricane, UTS/N D-6011N409SSBlackwell Aviation Inc · Bell Vernon, PABuilt 1965 · S/N D-7952N409VRegistered aircraftBuilt 1965 · S/N TE-7N40ABSchumacher Steven Joseph · Fayetteville, ARBuilt 1983 · S/N CE-1020N40DDReceptacle Ministries · Blackshear, GABuilt 1973 · S/N P-239N40EShackelford John S Jr · Roanoke, TXBuilt 1944 · S/N 6685N40FJbk I LLC · Wayne, ILBuilt 1993 · S/N E-2793N40GHagerty Environmental LLC · Kennett Square, PABuilt 1972 · S/N D-9342N40GMSteven E Cox · Bend, ORBuilt 1964 · S/N D-7343N40JHJohnson Sean M · Martinez, CABuilt 1975 · S/N E-772N40KGFour Stars Aviation Inc · Mclean, VABuilt 1983 · S/N E-2067N40KTDemuth Gabriel J · Jackson Springs, NCBuilt 1968 · S/N D-8717N40MMChupp Family Trust LLC · Kalispell, MTBuilt 1964 · S/N TC-740N40MWCarbone Peter E Jr · Hopkinton, MAFirst renewal noticeBuilt 1980 · S/N E-1708N40NLVetter Brent E · Helena, MTBuilt 1958 · S/N D-5743N40PGFunanich Jon J Trustee · Fairfield, CABuilt 1980 · S/N TJ-309N40TEWild Warbirds LLC · Uvalde, TXS/N CE577N40TRKwong Elwood · Foothill Ranch, CABuilt 1977 · S/N E-1190N40VKelly Donald William Jr · Roswell, GABuilt 1971 · S/N TE-799N40XSSasser F Michael · Cedar Park, TXBuilt 1978 · S/N E-1278N4101PKnepp Terry Wayne · Montgomery, INBuilt 1977 · S/N E-1026N4102SFlying Drahthaar LLC · Billings, MTBuilt 1975 · S/N TE-1038N4103SSky High Aviation LLC · Fishers, INBuilt 1975 · S/N TE-1039N4104SSky West Aviation Inc Trustee · Albuquerque, NMS/N CE-558N4104T4a Legacy Enterprises LLC · Mcallen, TXBuilt 2001 · S/N E-3411N4105SAxis Aviation Group Inc · Sacramento, CABuilt 1975 · S/N TC-1845N4106SCompnet Solutions Inc · Dallas, TXBuilt 1975 · S/N CE-559N4107SAnnamar LLC · Wilmington, DEBuilt 1975 · S/N D-9735N410BWright Samuel B · Haines, AKBuilt 1948 · S/N D-1607N410DRJmsat Corp · Moneta, VABuilt 1977 · S/N TK52N410GBeechcraft Heritage Museum · Tullahoma, TNBuilt 1982 · S/N P-596N410HAWalega Jane Ellen · Essex, MDBuilt 1982 · S/N E-2035N410LJBednar David · Norwalk, IABuilt 1982 · S/N EA293N410PCBohnert Matthew · Bend, ORBuilt 1976 · S/N TJ-48N410RWButler National Inc · New Century, KSBuilt 1982 · S/N E-2031N410T410t LLC · Kennett Square, PABuilt 1988 · S/N CE-1239N4111SKnowles Warren R · Ocean City, NJS/N TJ-4N4112Feltmann Dean A · North Charleston, SCBuilt 1966 · S/N TE-159N4114SHeffernan Duane C · Moravia, NYS/N CE-434N4118SStevens Ronald D · Boise, IDFirst renewal noticeBuilt 1975 · S/N CE-563N411EGCompton William C · Anchorage, AKBuilt 1966 · S/N D-8184N411GJGuardian Jet LLC · Guilford, CTBuilt 1990 · S/N E-2586
Back to AD 99-05-13 R1 WD