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.

N684TSpa N684t LLC · Titusville, FLS/N D-5892N684WTMaxwell Duane T Trustee · Visalia, CABuilt 1979 · S/N E1533N6853QValley Air Service Inc · Wayne, ILBuilt 1964 · S/N TC-675N6855QPlehn Thomas R Trustee · Las Vegas, NVBuilt 1964 · S/N D-7464N685BWeeks Stanley III · Taneyville, MOBuilt 1948 · S/N D-1688N685TBYankee Flyers Inc · Mount Vernon, IABuilt 1973 · S/N E-469N6860QEschenbach Ralph · San Jose, CABuilt 1964 · S/N D-7475N6861PFullerton Robert D · Houston, TXS/N EA-686N686AURocket City Aviation LLC · Huntsville, ALBuilt 1979 · S/N MC-686N686BParsley Randy H · Mc Kenzie, TNBuilt 1948 · S/N D-1689N686DCMedbery Nathan J · Minto, NDBuilt 1956 · S/N D-4748N686MEMachined Fixture Fabrication LLC · Burnsville, MNS/N E-3593N686PSFolly Crew Aviation LLC · Folly Beach, SCS/N M1686N6878LMurawski Todd · Port Austin, MIBuilt 1988 · S/N CE1279N687DRiffenburgh Walter V · Big Bear Lake, CAS/N D2963N687SAGerstein Lee · Park City, UTBuilt 2001 · S/N EA-687N687SSSciscoe William D · Dish, TXS/N MB-675N688BBellas Business LLC · Amarillo, TXS/N D-1691N688MLeading Edge Aviation Inc · Bend, ORBuilt 1972 · S/N CE-391N688VBonanza Flyers LLC · Newport News, VABuilt 1960 · S/N D-6393N6890QSoest Dean · Quartz Hill, CABuilt 1965 · S/N LD-224N689ABCharney Air Inc · Wilmington, DES/N E2513N689BRichter Lawrence J · Lake City, FLBuilt 1948 · S/N D-1692N689CAir Mt A36 LLC · Lake Havasu City, AZBuilt 2002 · S/N E-3461N689DShue Robert R Jr · Easley, SCBuilt 1951 · S/N D-2965N689TNunez Manuel · Mcallen, TXS/N D-7408N68APAbecca Corporation · Jackson, MIBuilt 1968 · S/N D-8899N68BBKorney Eugene A Trustee · Los Angeles, CABuilt 1981 · S/N TJ-317N68CRAeronation Aircrft & Exotics LLC · Lewes, DEBuilt 1972 · S/N P-211N68CTSilver Arrow LLC · Alvin, TXBuilt 1980 · S/N TE-1174N68DLAsap Flying Service Inc · Hermiston, ORS/N D-5118N68EBGayler Larry G · Thermal, CABuilt 1972 · S/N P-207N68FLCoach Aviation LLC · Williston, NDBuilt 1968 · S/N TG63N68FSPeck James A · Lago Vista, TXBuilt 1968 · S/N TC-1054N68JGH & M Aviation · Hazelton, NDBuilt 1957 · S/N D-4977N68JNSalt Corporation · Wilmington, DEBuilt 1968 · S/N TC-1189N68JPDocs Aviation LLC · Saint Peters, MOS/N TE-854N68MMLetters Inc · Santa Maria, CABuilt 1979 · S/N EA-5N68MP920 Redmond Leasing LLC · Wilmington, DEBuilt 1986 · S/N E-2320N68RTWrye David · Kevil, KYBuilt 1991 · S/N CE1629N68SMSimms Richard J · Shady Shores, TXBuilt 1968 · S/N D-8779N68TTStanley Scott C · Winston Salem, NCBuilt 1953 · S/N D-3563N6900QBailey Brad R · Madill, OKS/N M-1068N6900VYoungs William D Jr · Moravia, NYBuilt 1957 · S/N D-4955N6901QCbus Flight LLC · Pickerington, OHBuilt 1967 · S/N MB-265N6903QSullivan Lynford M · Hernando, MSBuilt 1967 · S/N MB-267N6906QFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1967 · S/N MB-283N6909QHuston Lee E · Graham, WABuilt 1967 · S/N MB-281N690DPRiegel Frederick E · Houston, OHBuilt 1980 · S/N TC-2347N690FSYork Randal G · Cullman, ALBuilt 1969 · S/N TE-710
Back to AD 99-05-13 R1 WD