OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N8119RCarona Robert A Jr Trustee · Oceanside, CABuilt 1974 · S/N D-9655N811CWJ & H Aviation LLC · Lumpkin, GABuilt 1982 · S/N TH-1351N811DCVbp Services LLC · Wainscott, NYBuilt 2010 · S/N TH-2282N811ECChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1975 · S/N 21060702N811ESSalzman Michael L · Hurricane, UTBuilt 2005 · S/N ES-153N811GMEldredge David A · Snohomish, WABuilt 1979 · S/N 18503770N811LAWild Blue Skies LLC · Galena, OHBuilt 1993 · S/N E-2820N811MASale Reported · Newberg, ORSale reportedBuilt 1976 · S/N TJ-75N811NAsplundh Eric P · Bryn Athyn, PAFirst renewal noticeBuilt 1978 · S/N 310R1317N811PBMathis Timber LLC · Corinth, MSFirst renewal noticeBuilt 1972 · S/N TH-194N811PGH&S Aircraft LLC · Lewes, DEBuilt 1984 · S/N 421C1413N811TBM Goss LLC · Vidalia, GABuilt 1990 · S/N TH-1576N811TSManagement Programs Corp · Vero Beach, FLBuilt 2006 · S/N 29-0420N811XArkoma Aviation LLC · Henryetta, OKBuilt 1966 · S/N T210-0068N8121GTwo One Golf Ltd · Waterloo, IABuilt 1971 · S/N 21059421N8121NSnell Services Inc · North Platte, NEBuilt 1991 · S/N CE-1574N8123GBlattmachr Matthew · Anchorage, AKS/N U20603770N8123NReplica Sales & Engineering Inc · Muscatine, IABuilt 1992 · S/N TH-1671N8123Q8123q LLC · Olympia, WABuilt 1975 · S/N U20603093N8124LEliza Air Inc · New Orleans, LABuilt 1991 · S/N TH-1623N8124PClearsky LLC · Missouri City, TXBuilt 2003 · S/N 0651N8125EEmb Aero LLC · Lakeland, FLBuilt 2003 · S/N 0671N8125FMaglaughlin Ronald D · Udall, KSFirst renewal noticeS/N 402-0231N8126GTwylia J Sekavec LLC · Brownell, KSBuilt 2003 · S/N 0672N8126NHyder/Zemke LLC · Albuquerque, NMBuilt 1991 · S/N CE-1607N8127AOpm Partners LLC · Kalispell, MTBuilt 2003 · S/N 0653N8127L2f Trade LLC · Gainesville, TXS/N 21060614N8128LSayco Aviation LLC · Fayetteville, GABuilt 1974 · S/N 21060615N8128NCloudstreet Investments LLC · San Antonio, TXBuilt 1991 · S/N CE-1596N8129GJohnson Richard A Trustee · Chandler, AZBuilt 1971 · S/N 21059429N812BGGallo Robert L · Palm Beach Garden, FLS/N E-2960N812DMRomanair Wdr Inc · Winder, GABuilt 2004 · S/N 0863N812DWAir/Land Ventures Two LLC · Hamilton, MTBuilt 2001 · S/N 0124N812ELLambard Luke G · Bossier City, LABuilt 1975 · S/N E-774N812FPeter Kevin · Hermon, MEBuilt 1977 · S/N 18503277N812JCLfgsgb LLC · Greenville, SCBuilt 1992 · S/N TH-1676N812SRVantage Point Northwest Aviation LLC · Sheridan, WYBuilt 1979 · S/N 414A0326N812VLa Plane LLC · Fort Thomas, AZBuilt 1972 · S/N 340-0157N812WPMerrell Clayton Lee · Amarillo, TXBuilt 1975 · S/N E-669N8130GBank Of Utah Trustee · Salt Lake City, UTBuilt 1973 · S/N 18801243TN8130LPerfect 10 Roofing · Billings, MTS/N 21060617N8130RGaines Robert G · Howell, MIBuilt 1991 · S/N EA-518N8131GTalley Edward P · San Jose, CABuilt 1971 · S/N 21059431N8131NArgus Lester M · Margate City, NJBuilt 1991 · S/N CE-1584N8131QClub Jet Investments LLC · Wilmington, DES/N 414-0031N8132NBeechit LLC · Prescott, AZBuilt 1991 · S/N CE-1585N8133RAero Tex LLC · Jacksonville, FLBuilt 1974 · S/N CE-543N8133VN8133v LLC · Greenville, NCBuilt 1991 · S/N CE-1569N8133ZLupa Holdings LLC · New York, NYBuilt 2003 · S/N 0673N8134QPaul Morrill Excavating Inc · Newcastle, CABuilt 1969 · S/N 414-0034
Back to AD 86-13-04 R3