OpenAirDocs.org
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.

N517MSJewett John G · Ellensburg, WABuilt 1978 · S/N R18200681N517RLAndrews Mimi M · Hilltop Lakes, TXBuilt 1996 · S/N 22626N517RSGraham Konner T · Pittsburg, TXBuilt 1998 · S/N 21117N517SCSpartan Education LLC · Tulsa, OKBuilt 2019 · S/N 2881264N517SHHelme Stanley B · Lodi, CABuilt 2003 · S/N 70624N517SMMcelvain Pete R · Iowa Park, TXBuilt 1968 · S/N 17257318N517TPAerotrust Services Corp Trustee · Wilmington, DEBuilt 2019 · S/N XL 275N517VBBoudro Vernon G · Greenview, CABuilt 2008 · S/N 70216N517WCFreedom Wings LLC · Parker, COBuilt 1993 · S/N 1809065N517WDAmundson Lee R · Chatfield, MNBuilt 2021 · S/N 02210164N5180LGrogan Timothy · Bradenton, FLBuilt 1967 · S/N 28-4466N5180PN5180p LLC · Willow Springs, MOBuilt 1958 · S/N 24-201N5180RMacdonald Kaitlyn · Dillon, MTS/N 17263397N5180XSouthern Sky Holdings LLC · Macon, GABuilt 1969 · S/N 190N51810Jones David L · Powderly, TXS/N 224N51816Barr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281120N5181HRegistered aircraftBuilt 1975 · S/N 17265363N5181PFritz Joseph L · Eufaula, OKBuilt 1958 · S/N 24-202N5181REdelen Daniel R · Clayton, NCBuilt 1974 · S/N 17263398N5181SHicks Douglas A · Cumming, GABuilt 1970 · S/N 28-7105035N5181WSzymanski Janet M · Alanson, MIBuilt 1961 · S/N 28-216N5181XKummer Nicolas · Wenatchee, WABuilt 1969 · S/N 191N51824US Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608390N51826Van Dyke James C · Pleasant Grove, CABuilt 1980 · S/N 01VDN5182ERegistered aircraftBuilt 1978 · S/N 17271756N5182LGarden City Aviation LLC · Augusta, GABuilt 1967 · S/N 28-4469N5182PThede Dondi I · Marshall, WIBuilt 1958 · S/N 24-203N5182RHalf Wagon Innovations LLC · Cresson, TXBuilt 2000 · S/N 18280707N5182SFoster Tyler R · Levelland, TXS/N 28-7105036N5183LWolstenholme Robert F · Line Lexington, PABuilt 1984 · S/N 0001N5183MGc Aviation Services 1 LLC · Miamisburg, OHBuilt 1978 · S/N ME-13N5183RThompson Aerial Service Inc · Wyndmere, NDBuilt 1974 · S/N 17263400N5183SWestland Aviation LLC · Lake Havasu City, AZBuilt 1970 · S/N 28-7105037N5183TMinier Tryg · Corralitos, CABuilt 1967 · S/N 16N5183XStory James W · Byhalia, MSBuilt 1969 · S/N 170N51840Sky Bubble LLC · Santa Ana, CABuilt 1980 · S/N 17274359N51847Rippe Ryan · Fairbury, NEBuilt 2002 · S/N T20608363N51849O'Ryan Air LLC · Wichita, KSBuilt 2002 · S/N T20608364N5184EStringfellow Timothy C · Maryville, TNBuilt 1978 · S/N 17271758N5184GSicking Ryan · Gainesville, TXBuilt 2002 · S/N 18281104N5184JRiverside Flight Academy LLC · Riverside, CAS/N 17273721N5184LOtt Timothy M · Ida, MIBuilt 1967 · S/N 28-4472N5184PBarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281105N5184S1st Cooling Inc · Rockwall, TXBuilt 1970 · S/N 28-7105038N5184XComstock Derrick B · Salol, MNBuilt 1969 · S/N 173N5185DMartinez Richard Christian · Stockbridge, MIS/N 17272441N5185QRegistered aircraftBuilt 1989 · S/N 300N5185TRomano Serge · Beaverton, ORBuilt 1967 · S/N 15N51863Green Wendell L · Argyle, TXBuilt 1980 · S/N 46N51865Savage Michael B · Lincoln, CABuilt 1981 · S/N 17274362
Back to AD 87-10-06 R1