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.

N715RHAyers Christopher C · San Marcos, CAS/N D-7063N7163NMullaly Sean M · Haslett, MIBuilt 1968 · S/N D-8689N7164NFrancis Jesse R · Fort Worth, TXBuilt 1968 · S/N D-8691N7165NRegistered aircraftBuilt 1968 · S/N D-8692N716DSSheppard Daniel · Cochranville, PAS/N CE-458N716JFAlexander Aviation LLC · Ellisville, MSBuilt 1977 · S/N E-954N716RJHenson Walter L · Quitaque, TXBuilt 1973 · S/N CE-441N7170NDemio Douglas · Westbrook, CTBuilt 1968 · S/N D-8696N7172NCourtney Mccutchen Insurance Agency Inc · Mertzon, TXBuilt 1968 · S/N D-8697N7173NVajdos Robert C Jr · Louise, TXBuilt 1968 · S/N D-8698N7176NSpeidel Jake P · Carmel, CABuilt 1968 · S/N TE-522N7177NStutz Jeffrey R · Redondo Beach, CABuilt 1968 · S/N D-8702N7178NMcgehee Dennis · Idalou, TXBuilt 1968 · S/N TE-594N717BCarmickle Patrick M · Tekonsha, MIS/N D-1724N717KHTrevino Alejandro B · Gibsonia, PABuilt 1989 · S/N CE-1308N717LN717l LLC · Toledo, WABuilt 1973 · S/N TC-1495N717MMWalker Brian K Trustee · Novato, CABuilt 1978 · S/N CE-831N717TMulti Engine Flight Time LLC · St George, UTBuilt 1962 · S/N TC-321N717VSJacobs John D · Chicago, ILBuilt 1977 · S/N P-433N7185NNovac Consulting Group LLC · Scottsdale, AZBuilt 1968 · S/N D-8705N718HSWinnlu Aviation LLC · Greenwich, CTS/N E-3462N718JMPage Field Aviation LLC · Fort Myers, FLBuilt 1979 · S/N TC-2257N7193NGeier Michael J · Newport, RIS/N D-8704N7194NGazda Jerry V · Granbury, TXFirst renewal noticeBuilt 1968 · S/N D-8711N7195NNaylor James M · Clinton, NCBuilt 1968 · S/N D-8712N7196NWilliams Johnny Dewayne · Colbert, OKBuilt 1968 · S/N D-8706N719SGMaisel Chad L · Plano, TXS/N D-8714N71BEMartin Thomas R · Anna, TXBuilt 1960 · S/N TC-20N71BKSelect Aerospace Industries Inc · Weyers Cave, VABuilt 1955 · S/N D-4401N71DLRegistration Pending · Poughkeepsie, NYRegistration pendingS/N D-7027N71GGTrans-Exec Air Service Inc · Van Nuys, CABuilt 1971 · S/N TE-835N71HZYoung David K · Anna, TXBuilt 1964 · S/N D-7714N71JLSheets Terrell P · Duplessis, LABuilt 1965 · S/N TC-973N71KWAcuff Joseph · Mooresville, NCBuilt 1977 · S/N E-1144N71LMHirshik Larry E · Center Harbor, NHBuilt 1989 · S/N CE-1424N71VKV1 Real Estate LLC · Pittsburg, TXS/N TE-387N71WWLarson Christopher L · Sheboygan, WIBuilt 1981 · S/N P-567N71YLN825fg Corp Trustee · Wilmington, DES/N D-9468N72006Detmer Darren D · Chappell Hill, TXBuilt 1984 · S/N TJ-460N72007Garvey James T · Dallas, TXS/N E-2170N7200CCaccavale John J · Oakdale, NYBuilt 1983 · S/N E-2122N7200HHefelfinger James F · Port Orange, FLBuilt 1984 · S/N EA-426N7201NWilliams Evan H · Sebastopol, CABuilt 1968 · S/N D-8815N7201RWaltz John · Tampa, FLBuilt 1974 · S/N TC-1813N7202BRegistration Pending · Peyton, CORegistration pendingBuilt 1958 · S/N D-5501N7202MG&M Baron Aviation LLC · Bradenton, FLS/N TJ-456N7202NBowers Enterprises LLC · Peachtree City, GABuilt 1968 · S/N D-8710N7202RHughbanks Matthew L · Evergreen, COBuilt 1975 · S/N TC-1819N7203BBradley Albert B · Vacaville, CAS/N D-5507N7203NGrey Hairs LLC · Lake Saint Louis, MOBuilt 1968 · S/N D-8716
Back to AD 99-05-13 R1 WD