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.

N9552VRico Aviation Services Inc · Miami, FLBuilt 1974 · S/N 17264354N9553ATitusville Aero Club Inc · Titusville, PABuilt 1998 · S/N 17280376N9553JStanley James C · Farmington, NMBuilt 1966 · S/N 28-3683N9553MLolob Llp · Bozeman, MTBuilt 1966 · S/N 670130N9553SHunters Adventures LLC · Kennesaw, GABuilt 1998 · S/N 18280254N9553WRich Harold W · Fort Worth, TXBuilt 1967 · S/N 28-22989N9554DChase 13 LLC · Wilmington, DES/N 22-6471N9554LWilson Tyler · Blooming Prairie, MNBuilt 1974 · S/N AA5-0676N9554MJohnson Kevin L · Bowling Green, KYS/N 670131N9554TOceanic Airlines LLC · Portsmouth, NHBuilt 1999 · S/N T20608003N9554VCavu LLC · Fort Collins, COBuilt 1974 · S/N 17264356N9555CVimana LLC · Chandler, AZBuilt 1978 · S/N 28-7816491N9555DGehring Robert A · Rubicon, WIBuilt 1958 · S/N 22-6472N9555HWilkinson William · Anchorage, AKBuilt 1975 · S/N 17266226N9555JPaper Airplane Club LLC · Hillsdale, MIBuilt 1966 · S/N 28-3685N9555KHiggins Donald Aubrey Sr · Cornelia, GAS/N 28R-7635249N9555LSouth Co Flyers Inc · Cranston, RIBuilt 1974 · S/N AA5-0555N9555MCarroll Brendan O · Aloha, ORS/N 670132N9556DHanderson Ronald J Sr · Sitka, AKBuilt 1958 · S/N 22-6473N9556MVictory Lane Aviation LLC · Concord, NCBuilt 1966 · S/N 670133N9556VMiles James D · Memphis, TNBuilt 1974 · S/N 17264358N9556WMathison John M · Fernley, NVS/N 28-22993N9557BGibson Robert B · Los Alamos, NMBuilt 1981 · S/N 172RG0879N9557KCook Walter T · Centerville, TNBuilt 1976 · S/N 28-7690260N9557LFarrar Curtis L · Pryor, OKBuilt 1974 · S/N AA5-0557N9557VSkyhawk 57v Inc · Pittsburgh, PABuilt 1974 · S/N 17264359N9557WBowles Dan S · Wichita, KSBuilt 1967 · S/N 28-22994N95583Reynolds Darryl G · Wills Point, TXS/N 191068N9558DMadison James Edward · Concord, CAS/N 22-6475N9558PStevens Raymond W · Norfolk, VABuilt 1974 · S/N 25-7405673N95594Sale Reported · Smyrna, GASale reported, pending cancellationBuilt 1965 · S/N 24-4188N9559DChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280488N9559FGeco Inc · Wilmington, DEBuilt 1969 · S/N 890443N9559MPerez Hector R · Orange Park, FLBuilt 1966 · S/N 670136N9559SElizabeth Dloda LLC · Hilton Head Island, SCBuilt 1998 · S/N 17280490N9559VOcm Aviation LLC · Buckeye, AZBuilt 1998 · S/N 17280491N9559WRickman Kevin A · Brownville, NYBuilt 1967 · S/N 28-22996N955BJFulfer Richard S · Applegate, CABuilt 2001 · S/N 23192N955CCN955cc LLC · Estero, FLBuilt 1969 · S/N 17258826N955CTTennis Caleb J · San Mateo, CABuilt 2020 · S/N 41897N955DDRegistration Pending · Fort Wayne, INRegistration pendingBuilt 1977 · S/N 28-7725206N955DGSuperior Aero & Marine LLC · Bolivar, MOBuilt 1996 · S/N 4636039N955DQWeber Charles · Dubuque, IABuilt 2016 · S/N 41578N955JPHassan Sibte · Brooklyn, NYBuilt 2009 · S/N 91416N955LCSewell Michael D DBA · Russellville, ALBuilt 1974 · S/N 17264572N955MATaylor Christopher B · Vacaville, CABuilt 1966 · S/N 3384N955PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264573N955SEmge Douglas W · Albertville, ALBuilt 1979 · S/N 287990385N955SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881875N955SHInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 4636339
Back to AD 87-10-06 R1