OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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.

N2340CWilliam J Davis · Bismarck, NDS/N R18200155N2340DWojtowicz Tomasz · Bronx, NYBuilt 1992 · S/N 2174N2340LRegistration Pending · San Antonio, TXRegistration pendingBuilt 1962 · S/N M-171N2340QRegistration Pending · Lewisville, TXRegistration pendingBuilt 1963 · S/N M-411N2340SWhalen Patrick M · Anchorage, AKBuilt 1979 · S/N 18-7909134N2340TGrillo Donald · Green Cove Springs, FLBuilt 1971 · S/N 28R-7135228N23412Performance Sanitation Of Mississippi LLC · Deland, FLBuilt 1995 · S/N 23412N2341TSky King Aviation LLC · Kearney, MOBuilt 1971 · S/N 28-7225048N2341YFlying G Aviation Inc · Drayton, NDBuilt 1981 · S/N 36-8160010N2342AThomas Todd · Sandy Hook, MSBuilt 1952 · S/N 22-732N2342EWolf John J · Mooresville, NCBuilt 1978 · S/N 17271245N2342LWilliams James W · Brush Prairie, WABuilt 1963 · S/N M-173N2342UAdvanced Helicopter Concepts Inc · Frederick, MDFirst renewal noticeBuilt 1992 · S/N 2181N2343HAerobinninger LLC · Mccall, IDBuilt 1979 · S/N 18-7909173N2343LBailey Paul W II · Hilton Head, SCBuilt 1963 · S/N M-174N2343PStalder Fredrick Bleu · Magnolia, TXBuilt 1955 · S/N 22-2754N2343RSkyhawk Aviation LLC · Rutherfordton, NCBuilt 1969 · S/N 28-5495N2343TManire Christine D · Ruidoso, NMBuilt 1971 · S/N 28-7225049N2343ULanning Dwight V · Thaxton, VAS/N 28-7911301N2344LSpargo Lyle R · Tonopah, AZBuilt 1963 · S/N M-175N2344PVieaux James M · Park Forest, ILBuilt 1955 · S/N 22-2755N2345LD&S Development LLC · Spring, TXS/N M-177N2345PSpitzer Helicopter LLC · Woodland Hills, CABuilt 1991 · S/N 1991N2345QPrunier Phillip M · Kokomo, INBuilt 1963 · S/N M-416N2345RBlue Wave Air LLC · Huntsville, ALBuilt 1981 · S/N 27-8154019N2345YJackson Shaun K · Tyler, TXBuilt 1967 · S/N 17700145N2345ZRegistered aircraftBuilt 1977 · S/N 17270190N2346QBurt Marcus D · Pendleton, ORS/N M-425N2346TBailey Benjamin J · Lincolnton, GABuilt 1971 · S/N 28-7225050N2346ZSoutheast Equipment LLC · Sheridan, WYS/N M-65N2347QBefumo Joesph M · Manchester, CTS/N M-451N2347ZZaitsev Saba A · Brooklyn, NYBuilt 1962 · S/N M-59N23480Pkp Aviation LLC · Alexandria, VABuilt 1999 · S/N 18280412N2348JArensmeyer Daniel D · Weybridge, VTBuilt 1963 · S/N M-303N2348SGeorgia Forestry Commission · Macon, GABuilt 1999 · S/N 18280411N2348ZHerrick Herbert D · Flint, MIBuilt 1962 · S/N M-60N23490Lg Mcdonald Enterprises Inc · Rose Bud, ARBuilt 1992 · S/N 2223N2349QLedford Russell R III · Swansea, SCBuilt 1963 · S/N M-417N2349RSalser Aviation LLC · Ocala, FLBuilt 1998 · S/N 18280413N2349XNorris James A · Export, PABuilt 1998 · S/N 18280414N2349ZUnderwood Richard R · Armuchee, GABuilt 1962 · S/N M-61N234AJMullins Land Co Inc · Aiken, SCBuilt 1995 · S/N 3246008N234AMMondkar Avinash M · Payson, AZBuilt 2003 · S/N 051N234ARHague Arsh · Orangeburg, NYBuilt 1977 · S/N AA5B0452N234BAJohnson Alan Lee · Pikeville, KYBuilt 2000 · S/N 869-2000N234BGLangeland Thomas Arthur · San Antonio, TXBuilt 1965 · S/N 30-909N234BLSullivan Leo W · O Fallon, ILBuilt 1997 · S/N 27-0234N234BMHickey John W · Monterey, CABuilt 1985 · S/N 1330N234BPYoung Tim M Trustee · Edmond, OKBuilt 1992 · S/N 24-3283N234CSundquist Steven A · Yakima, WABuilt 2006 · S/N 72406
Back to AD 87-10-06 R1