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.

N2434MSky'S The Limit Flying Club Inc · Findlay, OHBuilt 1977 · S/N 28-7890251N2434YRegistration Pending · Cedar Falls, IARegistration pendingBuilt 2000 · S/N 20608078N2435CAzure Skies LLC · Bloomington, INBuilt 1999 · S/N 18280644N2435DThibodeau Dean U · North Pole, AKBuilt 1952 · S/N 20587N2435MBrolan Aviation LLC · Kansas City, MOBuilt 1977 · S/N 28-7890253N2435PGarst William P · Johnson City, TNBuilt 1955 · S/N 22-2806N2436MVenture Aviation Inc · Arlington, MABuilt 1977 · S/N 28R-7837089N2436NThunderbird Aviation · Bloomington, MNBuilt 2000 · S/N 17280842N2436WThunderbird Aviation · Bloomington, MNFirst renewal noticeBuilt 2000 · S/N 17280841N2436YAlpha Flight Academy · Concord, CANon-citizen corporation, flight hours not reportedBuilt 1985 · S/N 28-8516056N24372Curns James R · New London, WIBuilt 1970 · S/N 28-5665N24376C R Transport Inc · Wilmington, DEBuilt 2000 · S/N 18280704N2437MRock Full Gospel Church · Parkersburg, WVBuilt 1979 · S/N 27-7954058N24389Way Of The Lord LLC · London, KYBuilt 2000 · S/N 18280708N2438ERainier Flight Service LLC · Renton, WABuilt 2000 · S/N 17280878N2438PDavey Kenneth E · Lake Crystal, MNBuilt 1955 · S/N 22-2809N2438RSpeed Hunter Aviation LLC · Franklin, OHBuilt 1969 · S/N 28-5622N2438SMid-Island Air Service Inc · Ronkonkoma, NYFirst renewal noticeBuilt 2000 · S/N 17280875N2439BVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N 18280955N2439C206 Aircraft Leasing Co Inc · Marathon, FLBuilt 2000 · S/N 20608100N2439PNeal Christopher C · Staples, MNBuilt 1955 · S/N 22-2810N2439TSkylane 2439t Partners LLC · Burlingame, CABuilt 2000 · S/N 18280810N243AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881733N243AKHilwig Kara · Wasilla, AKBuilt 1989 · S/N 1809010N243ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496042N243CGTampa Bay Soaring Society · Zephyrhills, FLBuilt 1972 · S/N 25-5450N243CMRegistered aircraftS/N 545EN243CYHarvey Steven T · Honolulu, HIBuilt 2000 · S/N 2081N243DBMainpro Inc · Alexandria, KYBuilt 2002 · S/N 2315N243EHVeracity Aviation LLC · Seguin, TXS/N 3482N243GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881113N243JAYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 28020019N243JGBateman Scott R · Montrose, CABuilt 2001 · S/N 80669N243JHFlowers Derrick W · San Antonio, TXBuilt 2016 · S/N 20454N243JWUhles Denny · Bakersfield, CABuilt 1983 · S/N 243N243MAJ W Peterson Inc · Warren, MNBuilt 2003 · S/N 479-2003N243MCRankin John · Nokomis, FLBuilt 2004 · S/N T18208243N243MDWhiteis Barnabas G · Apex, NCBuilt 1997 · S/N 20665N243MEMcaleer William V Jr · Milledgeville, GABuilt 2000 · S/N 20608113N243MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881708N243PSN9089 LLC · Lewes, DES/N 3257073N243RVDippel James W · Chandler, TXBuilt 2015 · S/N 11467N243SPBarbers Point Flight School LLC · Kapolei, HIBuilt 1999 · S/N 172S8212N243SWWells Paul L · Whitefish, MTFirst renewal noticeBuilt 1999 · S/N 001SWN243TJJones Helicopters LLC · Villa Rica, GABuilt 2004 · S/N 10239N243WMoore William · Dalhart, TXBuilt 1971 · S/N 17260205N243XWilliamson Lee E · Franklin, KYS/N 160N243XJLoiacono Vincent · Sunfield, MIBuilt 1965 · S/N 28-2095N243YShilt Jerry C · El Dorado Springs, MOBuilt 2005 · S/N 3288N2440DXing Kong Aviation Service LLC · Atwater, CAS/N 4496305
Back to AD 87-10-06 R1