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.

N888MZM-Z Aviation LLC · Birmingham, ALBuilt 1988 · S/N E-2417N888NEFarmex Land Mgmt Inc · Sanger, CABuilt 1981 · S/N D-10367N888RMMikmot LLC · Elk Point, SDS/N D-7270N888SK5 Aviation LLC · Las Vegas, NVBuilt 1976 · S/N D-9937N888SHLopez Benjamin · Batavia, OHBuilt 1969 · S/N D-9066N8890ALangley Troy C · Newport, WAS/N D-2545N8890MShake Justin N · Johnson City, TNBuilt 1964 · S/N M-641N8892MTaylor Charles D · Dillon, SCBuilt 1965 · S/N M-643N8893ATurbine Financial Group LLC · Ogden, UTBuilt 1950 · S/N D-2591N8894MGarcia Luis · Plantation, FLS/N M-645N8895MMejias Seth · Astoria, NYBuilt 1964 · S/N M-647N8897MAlmeter Francis J · Lebanon, ILFirst renewal noticeBuilt 1965 · S/N M-648N889JBJjj Aviation LLC · Newport, NCBuilt 1974 · S/N P-270N889JSMoran Consulting Corp · Long Beach, CABuilt 1974 · S/N D-9579N889RQualitair LLC Trustee · MichelstadtBuilt 1960 · S/N D-6366N889SEasy Air LLC · Wilmington, DEBuilt 1984 · S/N E-2138N889TSQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N TJ281N88ACSegerstrom William C · Sunriver, ORBuilt 1965 · S/N TD-621N88ANJk Manufacturing Co · Wilmington, DES/N CE-1700N88BAir Taco LLC · Virginia Beach, VABuilt 1982 · S/N E-2036N88BPPlane LLC · Worcester, MABuilt 1993 · S/N E-2780N88BVCarr Phillip E · Cave Creek, AZBuilt 1977 · S/N D10060N88CJLyman Michael R · Lake Oswego, ORBuilt 1977 · S/N E-1042N88CLHarp Robert P · Houston, TXBuilt 1988 · S/N CE-1225N88ESChapman Kevin J · Williston, NDBuilt 1975 · S/N E-758N88EZMusack Randy A · Butternut, WIBuilt 2000 · S/N E-3364N88JTKimberlin Mark · Indio, CABuilt 1974 · S/N TC-1753N88JWHawk Aviation LLC · Burlington, WIBuilt 1955 · S/N D-4409N88MBLebanon Aviation Inc · Mount Juliet, TNBuilt 1971 · S/N TE844N88PFScrump Aero LLC · Oakland, CABuilt 1956 · S/N G772N88PMPrvny Pluk L L C · Houston, TXBuilt 1952 · S/N 34-48N88PRValley River Leasing Inc · Murphy, NCBuilt 1995 · S/N E-2982N88RRegistration Pending · Wilmington, DERegistration pendingBuilt 1973 · S/N D-9475N88RMAmerican Airpower Heritage Flying Museum · Dallas, TXS/N G-752N88SWBoline Lonny R · Lincoln, MEBuilt 1970 · S/N MB-500N88TJCooley Bridget A · Seattle, WABuilt 1988 · S/N CE-1256N88TSWrb Aircraft LLC · New York, NYBuilt 1988 · S/N E-2409N8900AHooker Robert Edwin · Hamer, SCBuilt 1950 · S/N D-2598N8902ULusby II Dale · Garden Valley, CABuilt 1965 · S/N D-7902N8903UMartin William C · Middleville, MIBuilt 1965 · S/N D-7903N8905AGalliart Herb · Anthony, NMFirst renewal noticeBuilt 1950 · S/N D-2603N8906APierce Phillip · Ashville, ALBuilt 1950 · S/N D-2604N8906MSaindon Michael R · Cypress, TXBuilt 1963 · S/N D-7304N8906UKelley William · Springtown, TXS/N D-7906N8907MWarden Richard L · Canby, ORBuilt 1963 · S/N TC-541N8907USprague Allen T · Warrenton, ORBuilt 1965 · S/N D-7907N8908AMclenaghan Alvin N · Phoenix, AZBuilt 1950 · S/N D-2606N8908MKeyes Richard A · Port Saint Lucie, FLBuilt 1963 · S/N D-7305N8908UFly Buys Too LLC · Wilmington, DEBuilt 1965 · S/N D-7908N8909ATowery Daniel T III · Dover, DES/N D-2683
Back to AD 99-05-13 R1 WD