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.

N815RLCraig Travis J · Lawton, OKS/N D-5958N815RSCurtis Carter LLC · Prior Lake, MNS/N E-3573N8162DWc&R LLC · Austin, TXBuilt 1991 · S/N E-2589N8163FCalugar Ronald C · Bunnell, FLBuilt 1991 · S/N E-2590N81640Miller Ralph G Trustee · Napa, CABuilt 1991 · S/N CE-1591N8165EWw Air LLC · Templeton, CABuilt 1998 · S/N E-3193N8165QStewart Robert Page · Monroe, NCS/N E-2592N8166GRohrer John D · Belmont, CABuilt 1993 · S/N EA-546N8166RJmac Aviation Services LLC · Andalusia, ALBuilt 1974 · S/N D-9666N8166WScope Leasing Inc · Columbus, OHBuilt 1991 · S/N E-2593N8167AMagic Aviation LLC · Joplin, MOBuilt 1991 · S/N E-2594N8167KHues Oulton A · Norwood, MABuilt 1993 · S/N EA-547N8168FSnyder Jeffrey L · Clarkston, MIBuilt 1991 · S/N E-2596N8169RPreister Properties LLC · Norfolk, NEBuilt 1974 · S/N D-9668N816DBBaugh Deborah F · Lebanon, TNBuilt 1956 · S/N BG 150N816DSAdcock Raymond D · Cabot, ARBuilt 1955 · S/N CH-300N816GHolland Travel Air LLC · Holmen, WIBuilt 1964 · S/N TD-562N816JBSea Blue Sales & Leasing LLC · Lebanon, TNS/N BG-176N816LATipuani Corp · Dover, DEBuilt 1994 · S/N E-2851N816NMidwest Aircraft Inc · Wilmington, DES/N D-8963N816UMcmullen Gerald W Trustee · Spokane, WABuilt 1970 · S/N D-9161N816VBrawler Aviation LLC · Edmond, OKBuilt 1971 · S/N D-9266N8170DWagner Dairy Lp · Escalon, CAS/N E-2600N8171RYankee Air Pirate LLC · Memphis, TNBuilt 1974 · S/N D-9669N8171ZRidgeline LLC · Helena, MTBuilt 1993 · S/N E-2785N8173CJet Pros LLC · Scottsdale, AZBuilt 1990 · S/N CE-1541N8173RAdkins Douglas E · Klamath Falls, ORBuilt 1974 · S/N E-593N8175RShilling Aeronautical Holdings LLC · Bradenton, FLBuilt 1974 · S/N TC-1754N8176REpps Elaine · Atlanta, GABuilt 1974 · S/N CJ-53N8178RW L Landess LLC · Guymon, OKBuilt 1974 · S/N E-594N817CAFaze3 Partners LLC · Kalispell, MTS/N E-1724N817LAUnger William · Missouri City, TXBuilt 1994 · S/N E-2852N817MWWright Mark A · Willingboro, NJBuilt 1964 · S/N D-7381N817NMWest Bound Hound LLC · Sheridan, WYBuilt 1979 · S/N EA-27N817RMOmega Metals Inc · Douglasville, GABuilt 1981 · S/N EA-203N8181VPebble Alternative LLC · Harahan, LABuilt 1991 · S/N E-2610N8183EGuardado Rodolfo · Sun Valley, CABuilt 1991 · S/N E-2612N8183RFerriolo Donald J · Greer, SCBuilt 1974 · S/N D-9671N8184NB & S Holdings LLC · Augusta, GABuilt 1991 · S/N E-2648N8185RMiles Timothy Neil · Tampa, FLBuilt 1974 · S/N E-595N8187RFleck Richard N Trustee · Camarillo, CABuilt 1974 · S/N D-9673N8189RMayer Bari S · Austin, TXBuilt 1974 · S/N CJ-56N818DBBluebird Holdings LLC · Morris, MNFirst renewal noticeBuilt 1978 · S/N E-1342N818KTEid Enterprises Inc · Houston, TXBuilt 1979 · S/N P508N818LARegistered aircraftBuilt 1994 · S/N E-2868N818PDesmet Paul F · Mercersburg, PABuilt 1986 · S/N E-2352N818PRMalus Flyers LLC · Henderson, NVBuilt 2001 · S/N E-3397N818RMB And D Solutions LLC · Billings, MTBuilt 1978 · S/N TE-1150N818RRRich Thomas M · Pittsboro, INS/N E-3543N818SDGerges Ebraim · Riverside, CAS/N D-7480
Back to AD 99-05-13 R1 WD