OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N32GSZeigler Corey M · Harrisville, NYBuilt 1993 · S/N 0016N32GUKerzen Properties LLC · Fayetteville, ARBuilt 2016 · S/N 1N32GVEastern Cincinnati Aviation Inc · Batavia, OHS/N 17267026N32HHagaman John G Trustee · Alexandria, VABuilt 1967 · S/N 1512N32HLSmith Elmer A · Rancho Cucamonga, CAS/N 176N32HUMdc Aviation Corp Inc · Amsterdam, NYS/N 1402N32HYRunzel Brothers Aviation LLC · Bensenville, ILBuilt 2000 · S/N 2102N32JBHeimat Corp · Lincoln, NEBuilt 1971 · S/N 473N32JCMelton Charles Robert · Alexandria, VABuilt 1977 · S/N 24-0120N32JDDuflo Spray Chemical Inc · Bremen, NYS/N 27-372N32JLSanson William P Jr · Dodge Center, MNBuilt 1967 · S/N 28-4391N32JMMiller Biplane LLC · Moberly, MOBuilt 1973 · S/N JM001N32JVChrapczynski Daniel T · Sheffield Village, OHBuilt 1993 · S/N M-II-001N32JWDeach Michael · Lopez Island, WABuilt 2013 · S/N 3367N32KAFowlkes Preston L · Marfa, TXBuilt 2002 · S/N 2193N32KHN32kh LLC · Quincy, WAS/N 287790384N32KTDyson Raymond E · Vero Beach, FLBuilt 2024 · S/N 711N32LDms Aviation Services LLC · Wildwood, MOBuilt 1991 · S/N 654-91N32LACircle S Aviation LLC · Starkville, MSBuilt 1972 · S/N 17260454N32LKMorrow Gregory A · Box Elder, SDBuilt 2007 · S/N 91199N32LSPerhach Andrew J · Seattle, WABuilt 1989 · S/N 1208N32MEHarris Steve V · Springtown, TXBuilt 1984 · S/N 1733N32MGPoor Boy Aero LLC · Seminole, TXBuilt 1982 · S/N 32R-8329003N32MPAshford Aviation Inc · Dothan, ALBuilt 1981 · S/N 172RG1019N32NAHampden Aviation Services Inc · Northampton, MABuilt 1982 · S/N 28-8316023N32NCEcho 7 Systems LLC · Lewes, DEBuilt 1999 · S/N 21989N32PBLease One LLC · Lafayette, INBuilt 1981 · S/N 31-8212006N32PDAsp Victor · Shoreline, WABuilt 1973 · S/N 28R-7435091N32QXSpacewalker 2 LLC · Ocala, FLS/N 32091N32RFPulford Robert A · Barkhamsted, CTBuilt 1978 · S/N 32-7800001N32RQI C Aviation LLC · Birmingham, ALBuilt 1975 · S/N 692N32RTKnop Jeffrey Brian · Mount Juliet, TNBuilt 1978 · S/N 32R7987008N32RVTimbie Peter W · Palatka, FLBuilt 1997 · S/N 22253N32RWSkylens LLC · Hammond, LABuilt 1971 · S/N 27-4667N32SAAmoretti Remor Vinicius · Gardena, CABuilt 1977 · S/N 28-7725174N32SBCook Robert W · Belair, MDBuilt 1976 · S/N 31-7612098N32SHFuller Jon A · Goliad, TXS/N 0599N32SKKukolich Stephen G · Tuscon, AZBuilt 1977 · S/N AA5A0492N32SPCochran Gene P · Silverdale, WABuilt 1976 · S/N 28-7690199N32SRBadenhope John R · Greeneville, TNBuilt 1983 · S/N RDS-01N32SXDorans Aviation LLC · Yardley, PABuilt 2004 · S/N 3232022N32TEBlue Line Aviation LLC · Dunbar, NEBuilt 1999 · S/N 3257112N32THKrakeel James A · Mount Pleasant, SCBuilt 1990 · S/N TH101N32VGRegistered aircraftBuilt 1997 · S/N 2773N32VTWinging It LLC · Louisville, KYBuilt 1979 · S/N 32-7940029N32WFN32wf LLC · Muscatine, IAS/N 3246026N32WTEdwards Anthony C · Weaverville, CABuilt 1990 · S/N 1495N32WWOcchipinti Mark A · Springdale, ARBuilt 2008 · S/N 72384N32YAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1980 · S/N 17273862N32YBHjelle Mark L · Barrett, MNBuilt 2000 · S/N 80613
Back to AD 87-10-06 R1