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.

N15846Sullivan Michael A · Reno, NVBuilt 1936 · S/N 89N1585ZKnoche Matthew · Clarkston, MIBuilt 1961 · S/N D-6883N1586ZJoe L Fisher · Downers Grove, ILBuilt 1961 · S/N D-6882N1587SGabay William G · Cocoa, FLBuilt 1962 · S/N TC-322N1587ZGlittenberg Bryson · Flower Mound, TXBuilt 1961 · S/N D-6876N1588Indianhead Aviation LLC · Polk City, IABuilt 1978 · S/N E-1290N1589LCain James W · Big Rapids, MIS/N D-9866N158KSBowerman Marvin · Montgomery, TXBuilt 1982 · S/N TJ-419N158NRoss Adam · Texarkana, TXBuilt 1981 · S/N EA-197N158PBBarnett Paul S · Brookhaven, MSBuilt 1961 · S/N TD-485N158RSRegistration Pending · Wallace, CARegistration pendingBuilt 1981 · S/N TJ-359N158SHoffman Eric M · Kerman, CABuilt 1953 · S/N D-3568N158SQGriffith Aviation Inc · Griffith, INBuilt 1978 · S/N ME-86N158TCBoyd Brent · Fort Worth, TXBuilt 1978 · S/N TK-68N158ZLOlds Curtis J Jr · Elizabeth City, NCBuilt 1957 · S/N BG-344N1591WMuraszko Raymond P · Monroe, NJBuilt 1972 · S/N CE-381N1592LLwcr Transportation Inc · Minot, NDBuilt 1976 · S/N E-832N1592WDebonair Flying Club Inc · Medon, TNBuilt 1972 · S/N CE-383N1593LBurr Walter E · Tecumseh, MIBuilt 1976 · S/N CE-637N1593SHoward Paul D Jr · Williamson, WVS/N D-7013N1593ZButler Richard Austin · Gatesville, TXBuilt 1961 · S/N D-6885N1594LIntermill Alice R · Volga, SDBuilt 1976 · S/N E-833N1594ZWondra Wayne L · Friendswood, TXBuilt 1961 · S/N D-6886N1595LClemens Jerry W · Parsons, KSBuilt 1976 · S/N D-9869N1595WHope John W · Greeneville, TNFirst renewal noticeS/N TC-1448N1596ZBarnett Paul S · Brookhaven, MSBuilt 1961 · S/N D-6887N1597LTougas John D · Huntingtown, MDS/N CE-638N1597WSmith William J · Wichita Falls, TXBuilt 1972 · S/N D-9359N1598SDougherty William G · Hacksneck, VABuilt 1962 · S/N D-7008N1598TRegistered aircraftBuilt 1981 · S/N EA-263N1598WCanvasback Investments LLC · Kerrville, TXBuilt 1972 · S/N D-9356N1598ZMitchell Lester L · Okmulgee, OKBuilt 1961 · S/N D-6889N1599ZBurks Aviation Inc · Hattiesburg, MSBuilt 1962 · S/N TC-216N159AMakray Joseph C · Port Charlotte, FLBuilt 1958 · S/N D-5598N159AARegistered aircraftBuilt 1975 · S/N E-765N159GMArmy Air Corps LLC · Wilmington, DEBuilt 1978 · S/N CE-765N159MDLaw Offices Of Shawn A Mcmillan Apc · San Diego, CABuilt 1959 · S/N D-5849N159PKRegistered aircraftBuilt 1957 · S/N D-5363N159ZIdaho State University · Pocatello, IDBuilt 1978 · S/N TJ-178N15ADoug Harris Aviation LLC · Pryor, OKBuilt 1966 · S/N TE-172N15CGJwe Aviation LLC · Sugar Hill, GABuilt 1964 · S/N TC-568N15CLDoran Jeffrey T · Westerville, OHS/N TC-818N15DMFowler Bruce Jr · Cedar Park, TXBuilt 1955 · S/N G-702N15DNSnowflake Aircraft LLC · Fayetteville, NYBuilt 1989 · S/N E-2472N15DTBernal Cresencio · Pittsburg, CABuilt 1968 · S/N D-8725N15FMErda LLC · Wilmington, DEBuilt 1979 · S/N P-522N15GK427 Siera Lima LLC · Ponte Vedra, FLBuilt 1974 · S/N TC-1681N15GMBristol Aviation De LLC · Wilmington, DEBuilt 1995 · S/N E2977N15JAAdams Harry Jay · New Waverly, TXBuilt 1979 · S/N TK95N15JFHumanitarian Airlift International · Owasso, OKS/N D-3095
Back to AD 99-05-13 R1 WD