AD 87-10-06 R1

Registered aircraft · 72,010

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.

N7938MSanders David D · Alvin, TXBuilt 1966 · S/N TD-666N7938PWardly George A · Ridgewood, NJBuilt 1962 · S/N 24-3174N7938WPiper Club LLC · Atkinson, NEBuilt 1964 · S/N 28-1980N7938YEai Aircraft LLC · Fairbury, NEBuilt 1966 · S/N 30-1029N79390Grass Louis Humberto III · Hanford, CABuilt 1965 · S/N 2929N79391Scott William H · Mount Pleasant, SCS/N 594N79393Frandsen Travis · Rexburg, IDS/N 595N79395Cj Aviation LLC · Phoenix, AZBuilt 1965 · S/N 3049N79397Scholl Aaron K · Abbeville, ALBuilt 1965 · S/N 597N79399Schneider Uwe · Port Orange, FLBuilt 1965 · S/N 598N7939GMilton Alvah E II · Surrency, GABuilt 1970 · S/N 17259639N7939NOrama Jorge H · Fort Myers, FLBuilt 1969 · S/N 28-5351N7939PHarper Hill Investments LLC · Independence, LABuilt 1962 · S/N 24-3175N7939WCaviation LLC · Columbus, NES/N 28-1981N793AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843796N793CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881765N793NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2017 · S/N 4496408N793PTCappe Investment Group LLC · Homestead, FLBuilt 1975 · S/N 17263842N793SPLeading Edge Aviation Inc · Doylestown, PABuilt 2001 · S/N 172S8718N793YPark City Flight Training LLC · Merrill, WIBuilt 1979 · S/N M-2184N7940EAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1960 · S/N 17740N7940NCloudburst Resources Inc · Lavonia, GABuilt 1969 · S/N 28-5355N7940WMurray Air LLC · Patoka, ILS/N 28-2051N7940YN7940y LLC · Eagle Harbor, MIBuilt 1966 · S/N 30-1032N79410N79410 LLC · Tupelo, MSBuilt 1969 · S/N 17258061N79412Talley William B · Bakersfield, MOBuilt 1969 · S/N 17258063N79416Greene Tammy G · Alpharetta, GAS/N 17258067N79417Lhotka Tim · Silver Lake, MNBuilt 1969 · S/N 17258068N79418Lee Steven W · Somerset, KYBuilt 1969 · S/N 17258069N7941GPressley Aviation LLC · New London, NCBuilt 1970 · S/N 17259641N7941NHonke Richard · Lake Andes, SDBuilt 1969 · S/N 28-5356N7941PMcnew Johnnie Daniel · Paris, KYBuilt 1962 · S/N 24-3177N7941WHansen Brandon C · Hyde Park, UTBuilt 1964 · S/N 28-1982N79420Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 17258071N79421Kauer Roy A · Millington, MIBuilt 1969 · S/N 17258072N79428Mindset Dynamics LLC · Las Vegas, NVBuilt 1969 · S/N 17258077N79429Hinds Community College · Bolton, MSBuilt 1969 · S/N 17258078N7942CN4143w LLC · Los Gatos, CABuilt 1975 · S/N 32R-7680069N7942GFlycarolina LLC · Rock Hill, SCBuilt 1970 · S/N 17259642N7942LSpitzer Jimmy J · Waxahachie, TXBuilt 1966 · S/N MA-119N7942YAtlantic Aero Marine Inc · Seaford, DEBuilt 1966 · S/N 30-1035N79431Brown Joshua W · Pomona, ILBuilt 1969 · S/N 17258080N79432N7037g Inc · Wilmington, DEBuilt 1969 · S/N 17258081N79434Gilpin Jeffrey · Portland, ORBuilt 1969 · S/N 17258083N79435Pearce Gregory W · Eagle River, AKBuilt 1969 · S/N 17258084N79436Granskog Gary L · Chico, CABuilt 1969 · S/N 17258085N7943PDavie Andrew S · Stony Point, NYBuilt 1962 · S/N 24-3179N7943WBlue Ridge Aviation Services LLC · Ridgeway, VABuilt 1964 · S/N 28-1985N79440Spatiumtech LLC · Madison, ALBuilt 1969 · S/N 17258089N79442Friedmann David · San Diego, CABuilt 1969 · S/N 17258091
Back to AD 87-10-06 R1