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.

N5867Yarbrough Michele E · Vacaville, CABuilt 1957 · S/N BA-333N5867JFlight Guys Baron LLC · Coral Springs, FLBuilt 1965 · S/N TC-922N5868SHolloway John · Blackburn, MOS/N TC-860N586HPBell Design LLC · Atlanta, GABuilt 1981 · S/N P-586N58743Dutchess Community College · Poughkeepsie, NYS/N BG-239N5874JMy Flight LLC · Cypress, TXBuilt 1965 · S/N D-7866N5875JMiller Michael Andrew · Huffman, TXBuilt 1965 · S/N D-7868N5876J76juliet Aviation LLC · Firth, NES/N D-7869N5876SDevine Steven A · Roseville, CABuilt 1965 · S/N D-7822N5877SNguyen Tri Ngoc · Fort Worth, TXBuilt 1965 · S/N D-7758N5878JThomas William S · Casa Grande, AZBuilt 1965 · S/N D-7870N5879CSkeen Nikki B · Redlands, CABuilt 1951 · S/N D-2835N587LBlech Connor N · Chowchilla, CABuilt 1959 · S/N D-6239N587PDTurbulence Inc · Wilmington, DEBuilt 1990 · S/N CE-1461N587RKRegistration Pending · Santa Rosa, CARegistration pendingBuilt 1976 · S/N CE-665N5881JDj&M Aero LLC · Eau Claire, WIBuilt 1965 · S/N D-7871N5883JFaire Kenneth D · La Canada, CABuilt 1965 · S/N D-7874N5884JBge Enterprises LLC · Harrison, ARBuilt 1965 · S/N TC-926N5886SNiles Paul B · Hicksville, NYBuilt 1965 · S/N TC-858N5887SMcmartin Cutler J · Roanoke, TXBuilt 1965 · S/N D-7760N5888SPorterfield James William · Grove City, OHBuilt 1965 · S/N TC-861N5888TWendt Oliver James Jr · Adrian, MIBuilt 1963 · S/N D-7295N5889CHoye Charlie L · Rimrock, AZBuilt 1957 · S/N D-2840N588D588 Delta LLC · Seminole, OKBuilt 1967 · S/N TE-415N588PCAustin Aviation LLC · Santa Ana, CABuilt 1999 · S/N E-3271N5890CHumphrey Gary L · Lake Havasu City, AZBuilt 1951 · S/N D-2842N5890JBengal Lawrence W · Upland, CABuilt 1965 · S/N D-7877N5892CPeter Jesse D · Glendive, MTBuilt 1951 · S/N D-2844N5894SV Tail Therapy LLC · Seattle, WABuilt 1965 · S/N D-7765N5895SBurson Lloyd R · Anthony, NMBuilt 1965 · S/N D-7773N5896CVeal Thomas H · Cocoa Beach, FLS/N D-2849N5896SPreston Robert J · Pittstown, NJBuilt 1965 · S/N D-7826N5897SPrecision Aviation LLC · Califon, NJBuilt 1965 · S/N D-7828N5899JSchuyler Paul E · Morgan Hill, CABuilt 1965 · S/N D-7880N5899SNvl Properties LLC · Wilmington, DEBuilt 1965 · S/N D-7769N589BRyanns Hangar LLC · Sparta, MOS/N D-1608N589CSpringville Flying Club · Spanish Fork, UTBuilt 1988 · S/N CE-1224N589RBDukas Air LLC · Fort Lauderdale, FLBuilt 1977 · S/N TJ-89N58BNMinus 7 Inc · Boulder, COBuilt 1979 · S/N TK-99N58BPN7ss LLC · Nashville, TNBuilt 1978 · S/N TJ-176N58BZMacaluso Robert T Trustee · Livingston, TXBuilt 1958 · S/N D-5423N58CYBenson Eric A · Beulah, COBuilt 1953 · S/N D-3524N58DFB727 LLC · Midland, TXBuilt 1984 · S/N TJ-453N58EJKavalecs Stephen A · Beaver Meadows, PABuilt 1958 · S/N D5458N58HDRoberts John E · Naples, FLBuilt 1979 · S/N TJ-230N58HESoaring Ventures LLC · La Quinta, CABuilt 1977 · S/N TK-59N58HMA Great Bonanza LLC · Manchaca, TXBuilt 1979 · S/N TJ-205N58JDGrossman Kenneth R · Merced, CABuilt 1977 · S/N TK-19N58JGRvr600 Holdings LLC · Mount Dora, FLBuilt 1982 · S/N TJ-416N58JMLucky 7 Operating LLC · Many, LAS/N TK-142
Back to AD 99-05-13 R1 WD