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.

N8045QEcho Bay Corporation · Bow, WABuilt 1978 · S/N 18503632N8045UCox Clifford J · Armada, MIBuilt 1990 · S/N E-2570N8046GPoupard Chris Steven · Celina, TXBuilt 1992 · S/N CE-1646N8046JSgl Aero LLC · Alpine, WYBuilt 1990 · S/N CE-1527N8046ZBest Auto Sales LLC · Plummer, IDS/N U206-0446N8047KVan Dinter Mike · Post Falls, IDS/N CE-1648N8047PThompson Craig A · Dallas, TXBuilt 1992 · S/N CE-1660N8047QAir Boys Inc · Hayward, WIBuilt 1970 · S/N 421B0047N8048ZWalker John A · Kotzebue, AKS/N U206-0448N80499Srf · Waterloo, IABuilt 1976 · S/N 18503123N804MMVan Treese Kole S · Anchorage, AKBuilt 1975 · S/N 18502724N804WRWindecker Aircraft Inc · Mooresville, NCBuilt 1970 · S/N 003N8050NWillard Scott E · Mount Pleasant, SCBuilt 1992 · S/N CE-1650N8051UChandler Christian J · Ashfield, MABuilt 1990 · S/N TH-1607N8051ZN8051z LLC · Anchorage, AKBuilt 1965 · S/N U206-0451N80520Olson Roger R · Winter Haven, FLBuilt 1976 · S/N 18503125N8052MEcho Romeo LLC · Stamford, CTBuilt 1977 · S/N 21062031N8055UJones Kyle M · Kerrville, TXBuilt 1992 · S/N CE-1664N8055ZAir Hatzis LLC · Baton Rouge, LABuilt 1990 · S/N E-2572N805AJMoyer Aviation Inc · Ulysses, KSS/N 20601769N805JCBig Sky Baron Lc · Missoula, MTBuilt 1980 · S/N TJ-253N805LLAerojet USA LLC · Knox, INBuilt 2003 · S/N 0741N805NHT-Bone Truck Stop Inc · Columbus, NEBuilt 1992 · S/N E-2699N805NRState Of Minnesota · Grand Rapids, MNBuilt 1981 · S/N 18504197N805PMColwell Blue Berry Farm LLC · Ellsworth, MEBuilt 2005 · S/N 29-0391N805PRValiair Lc Trustee · Casper, WYBuilt 1985 · S/N 414A1206N805SERc Electronics Inc · Helena, MTBuilt 2002 · S/N 0430N8061VCheairs William T · Covington, TNBuilt 2003 · S/N 0649N8061ZCarter Kristopher W · Bellingham, WABuilt 1965 · S/N U206-0461N80629Registered aircraftBuilt 1976 · S/N 18503131N80633Rockalong Holdings LLC · Stanton, TXBuilt 1976 · S/N 18503132N8063EHale Mitchell D · Chugiak, AKS/N U2060926N8064MTeam Financial Inc · Birmingham, ALBuilt 1992 · S/N CE-1674N8064NSierra Hotel Aviation LLC · Spartanburg, SCBuilt 1990 · S/N E-2578N8064UCommercial Flight Services Inc · West Chester, PABuilt 1992 · S/N CE-1673N8065ZZulu Forty One LLC · Anchorage, AKS/N U206-0465N8066ZTevik Michael A · Provo, UTBuilt 1965 · S/N U206-0466N8067UPalmer Eric E · Tucson, AZBuilt 1992 · S/N EA-536N8068QCreative Consulting Partners LLC · Fargo, NDBuilt 1974 · S/N 414-0503N8068USan Diego Flight Corp · San Diego, CABuilt 1992 · S/N E-2725N8069GR B Hanson Equipment LLC · Clancy, MTBuilt 1992 · S/N CE-1677N8069RDouble R Farm Inc · Clayton, NMBuilt 1969 · S/N D-9019N8069UV115 Aviation LLC · Mount Juliet, TNBuilt 1992 · S/N E-2727N806CDLewis Melvin Lee Jr · Fisk, MOBuilt 2001 · S/N 0106N806CTCt Air LLC · Clovis, NMBuilt 1975 · S/N 18502573N806ECFlynn Development Corp · Clearwater, FLBuilt 2004 · S/N 0839N806HUAstra Engineering LLC · Twin Falls, IDBuilt 1979 · S/N U20605215N806NHWes Electric LLC · Lafayette, LABuilt 1992 · S/N E-2702N806TPickering Jeff C · Paris, TXBuilt 1973 · S/N E-423N8070ZRivers Larry R · Talkeetna, AKBuilt 1965 · S/N U206-0470
Back to AD 86-13-04 R3