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.

N78799Aerolanding LLC · Enterprise, ALS/N 17257768N7879GComposite Systems Inc · Lake Worth, FLBuilt 1970 · S/N 17259579N7879PKeenan Matthew J · Clearwater, FLBuilt 1962 · S/N 24-3105N7879VRowan James T Jr · Silver City, NMBuilt 1964 · S/N 471N7879WFlyhome One LLC · Chandler, AZBuilt 1964 · S/N 28-1903N787ANDixon Richard W · Laytonsville, MDBuilt 1962 · S/N 24-3308N787ARLeung Ka Hung · Apple Valley, CABuilt 1980 · S/N 32R-8029083N787ATCentral Virginia Flyers Flying Club Inc · Glen Allen, VABuilt 1976 · S/N 17267881N787BKAmeri Aircraft Sales And Service LLC · Champaign, ILBuilt 2021 · S/N BCV 21006N787BRNaron Robert W · Poolville, TXBuilt 1965 · S/N 28-2091N787CJInternational Air Services Inc Trustee · Carson City, NVBuilt 2010 · S/N 2843679N787CPArnett Wallace · Sullivan, INBuilt 1968 · S/N 17257760N787DHHodge Stephen E · Tipp City, OHBuilt 2017 · S/N 91514N787DJDgj Tex LLC DBA · Cleburne, TXBuilt 1977 · S/N 28-7816014N787EBStith Michael P · Boiling Springs, SCS/N AA5-0819N787ECSky Safety Inc · San Antonio, TXBuilt 2005 · S/N 40.529N787EMHughes David R Trustee · Fort Knox, KYS/N 1616N787FBHot Wings Aviation LLC · Fishers, INBuilt 2025 · S/N 28020210N787GWRegent Trust Corp Trustee · Wichita, KSBuilt 2004 · S/N 25101CN787HPHolt Gary L · Ventura, CABuilt 1995 · S/N 4636013N787KSWalden Franklin S · Southern Pines, NCBuilt 1964 · S/N 24-3644N787LHLawyers Real Estate Services LLC · Roswell, NMBuilt 2018 · S/N 001N787MTHeppe Andrew S DBA · Turner, MTFirst renewal noticeBuilt 1966 · S/N 18-8425N787NDuenas Carlos · Hurricane, UTBuilt 2007 · S/N 2123N787PCLivingtofly1 LLC · Ball Ground, GABuilt 1979 · S/N R18200867N787PDDougherty Paul · Bethel, PAS/N 5318N787PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350033N787PMJacobs Philip · Dickson, TNBuilt 2005 · S/N T18208429N787RGCareer Aviation Company Inc · Wilmington, DEBuilt 1978 · S/N R18200816N787RHRushing Christian W · Savannah, GABuilt 1978 · S/N 435-78N787RKEpitrop Foundation · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1968 · S/N 1832-29N787RPSilver Fox Aircraft LLC · Queen Creek, AZBuilt 1985 · S/N 28-8690025N787RSJjd Holdings LLC · Fort Madison, IABuilt 2005 · S/N 3232040N787RWJw Venture Aviation LLC · Concord, NCS/N 31-7652087N787SDDornberger Eric A · Aurora, COBuilt 2016 · S/N 91472N787SPSierra Tango Ventures LLC · Monte Sereno, CABuilt 2001 · S/N 172S8714N787STCitabria N787st LLC · Reno, NVS/N 486-2004N787TKennedy Thomas M · Long Beach, CABuilt 2015 · S/N 0248N787TBWoods Phillip A · Cimarron, KSBuilt 1996 · S/N 22127N787TFAir Fleet Holdings LLC · Missoula, MTBuilt 2022 · S/N 2881555N787TJTate John D · Roseville, CABuilt 2019 · S/N 60124N787TKIal Corp · Lewes, DES/N 2881144N787WAnequim LLC · Omaha, NEBuilt 2000 · S/N 1107N787WTSemper Supra Air LLC · Ashland City, TNBuilt 1978 · S/N 17271319N78804Whitt James M · Meadowview, VABuilt 1968 · S/N 17257772N78805Fugleberg Richard H · Mayville, NDBuilt 1968 · S/N 17257773N78808Ginter Michael J · Oakland, MDBuilt 1968 · S/N 17257774N7880GGhegan John · Wilmer, ALBuilt 1970 · S/N 17259580N7880WSefinas Avir LLC · Brooklyn, NYBuilt 1964 · S/N 28-1904N7881GSmith John T · Greenfield, INBuilt 1970 · S/N 17259581
Back to AD 87-10-06 R1