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.

N2399LMsd Aviation Of Seymour LLC · Seymour, INBuilt 1963 · S/N M-244N2399WHudson Shayne · Victorville, CABuilt 1966 · S/N MA-13N239AASlabach Jason M · Winston Salem, NCBuilt 1961 · S/N D-6763N239DGTabares Alain · Zephyrhills, FLBuilt 1968 · S/N TC-1187N239ESundale Aviation Inc · Erwinna, PABuilt 1943 · S/N 4916N239SMelton Michael D · Afton, VABuilt 1965 · S/N D-7893N23AGParker Robert B · Trussville, ALBuilt 1975 · S/N D-9834N23BRDakota Express LLC · Wilmington, DES/N BA-159N23CLRsr Medical Inc · Wilmington, DEBuilt 1995 · S/N E-2969N23DLKnight Robert T · Baton Rouge, LAS/N D-7363N23ECDenver Aero Service Marine Inc · Wilmington, DEBuilt 1975 · S/N TC-1894N23EPErid Air LLC · Blackfoot, IDBuilt 1954 · S/N D-3858N23FDBas Part Sales LLC · Greeley, COS/N M-1663N23GHKnuth Dean · Lincoln, NEBuilt 1950 · S/N D-2435N23HKMaine Instrument Flight · Augusta, MEBuilt 1977 · S/N M-1911N23HLWood Douglas K · Martinez, CABuilt 1979 · S/N E-1509N23MFTriay Services LLC · Metairie, LABuilt 1974 · S/N TC-1684N23NYKahn Mitch · Scarsdale, NYBuilt 1987 · S/N E-2359N23PDHigh Sierra Flying LLC · Incline Village, NVBuilt 1976 · S/N MC-408N23PGPettis Dale R · Farmington, MNBuilt 1986 · S/N E-2324N23PLNewsome Jeff · Blackwell, OKBuilt 1970 · S/N P-128N23PXSum Beech LLC · Ball, LABuilt 1978 · S/N MC-554N23RMMurray Michael G · Olathe, KSBuilt 1964 · S/N D-7311N23SJRatnikov Dmitry · Jay, NYBuilt 1981 · S/N EA-222N23SZHaynes Kevin · Pompano Beach, FLBuilt 1966 · S/N M-990N23TDPetrie Claire Trustee · Sparks, NVS/N M-1785N23TPKarel Benjamin · Stillwater, MNS/N CE-870N23VVRoberts Daniel L · Westerville, OHBuilt 1990 · S/N CE1490N23WRCraft Enterprises IV LLC · Beavercreek, OHBuilt 1981 · S/N E-1827N24005Tigerdawg Aviation LLC · Dawson, GABuilt 1977 · S/N M-1920N24006Keiper Mark D · Spring, TXBuilt 1977 · S/N MB-835N24009Business Aviation Insurance Services Inc · Concord, CABuilt 1977 · S/N MC-496N2400XThomas Tyler N · Lake Havasu City, AZFirst renewal noticeBuilt 1981 · S/N MC-768N2400ZDerr Douglas N · Woodlands, TXBuilt 1957 · S/N DH-137N24017Anderson Jeffrey L · Townsend, GABuilt 1977 · S/N MC-478N24018Schulte David L · State College, PABuilt 1977 · S/N M-1926N24019Orr Stevan J · West Bloomfield, MIBuilt 1977 · S/N M-1924N24020Maine Instrument Flight · Augusta, MEBuilt 1977 · S/N MB-838N24025Birx Ethan S · Piedmont, SCBuilt 1977 · S/N MB-839N24026Albion-Edgerton Flyers Inc · Fort Atkinson, WIBuilt 1977 · S/N M-1922N24027Wilson Dwayne L · Arlington, TXBuilt 1977 · S/N M-1929N24028Weitzner Russell Scott · Virginia Beach, VABuilt 1977 · S/N MC-486N24029Bindas Ronald · Georgetown, TXBuilt 1977 · S/N MB-840N2402ALaurelton Village Inc · Alamance, NCS/N TC-1931N24055Shipley Larry W · Corsicana, TXS/N MC-492N24057Macaluso Raymond A · Sweetwater, TNBuilt 1977 · S/N M-1937N240HCBlodgett James R · Walnut Creek, CABuilt 1979 · S/N TJ-221N240MBail Air LLC · Port Saint Lucie, FLBuilt 1970 · S/N D-9211N2411Custom Flight Rnh · New Richmond, WIBuilt 1955 · S/N D-4282N24131Hicks Chad A · Dalhart, TXBuilt 1978 · S/N D-10117
Back to AD 99-05-13 R1 WD