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.

N8288FAtwood Jason P · La Porte, INBuilt 1976 · S/N 28-7790237N8288JRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1979 · S/N VAC-134-79N8288LFrenzel Aviation Investments LLC · Brentwood, TNBuilt 1980 · S/N 28R-8118011N8288PStelter John · Clancy, MTBuilt 1963 · S/N 24-3540N8288ZPabon Hugo · Granada Hills, CABuilt 1980 · S/N 28-8116071N8289AAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 28-8116072N8289JCummings Steven R · League City, TXS/N VAC-135-79N8289XSheitelman Mitchell · Warren, NJBuilt 1980 · S/N 28-8190080N828AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2007 · S/N 1689N828BCFitzdam Justin D · Franklin, TNBuilt 1979 · S/N R18200975N828BDEchols Mill Aviation LLC · Elberton, GABuilt 1982 · S/N 31-8212017N828BLHartt Greg M · Fairfield, CABuilt 2025 · S/N 001N828BMChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280134N828BNTravelaire Service Inc · Pueblo, COBuilt 2004 · S/N 82058N828CBStokes Robert J Jr · Queen Creek, AZBuilt 2018 · S/N 132-257/258-1175N828CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281272N828CRRegistration Pending · East Greenwich, RIRegistration pendingBuilt 1981 · S/N 28-8111087N828EJWhirld Helicopters Inc · Sevierville, TNS/N 10457N828FSPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1999 · S/N 17280794N828HJPegasus Air Charter LLC · Hartford, CTBuilt 1980 · S/N 31-8052160N828JMJr Aviation LLC · Tulsa, OKBuilt 1979 · S/N 28-7911126N828JPCarney William F · Gallatin, TNBuilt 1957 · S/N 185460N828KTJones Larry · Anchorage, AKBuilt 1980 · S/N 318052098N828LBBeraut Olivier Trustee · Scotts Valley, CABuilt 1972 · S/N 32-7240077N828LPFlying Twenties Inc · San Jose, CABuilt 2001 · S/N 172S8828N828LSKelly Ryan · New York, NYBuilt 1977 · S/N AA5A-0406N828LUMuldrow Erik · Newport, KYBuilt 1958 · S/N 23-1373N828MCHub City Aviation Academy LLC · Lubbock, TXBuilt 1968 · S/N 28-4615N828PDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1991 · S/N 1085N828PLGrosso Michael F · Charleston, SCS/N TD-549N828RDCedar Ridge Aviation LLC · Knox City, TXBuilt 2002 · S/N 1254N828RVNewman Charles W · Petaluma, CABuilt 2001 · S/N 80959N828RWStankie Alexander M · Cocoa Beach, FLBuilt 2004 · S/N 24461N828SPVista Aviation Inc · Pacoima, CABuilt 2001 · S/N 172S8741N828SRGulfcoast Aviation Inc · Wilmington, DEBuilt 1978 · S/N 32R-7887169N828TSPlane Fun Inc Tr Trustee · Snellville, GABuilt 1988 · S/N 828N828YLong Island Aviators LLC · Seaford, NYBuilt 1976 · S/N 17268168N82905Reese Melissa A · Soldotna, AKBuilt 1977 · S/N 18-7709197N82907Law Offices Of David Henderson · Anchorage, AKBuilt 1978 · S/N 18-7909031N82908Hall Charles R · Leawood, KSBuilt 1982 · S/N 32-8324001N8290HSchildberg Gregory · Casey, IABuilt 1965 · S/N 1232N8290JSchaaf Rodney B · Bowman, NDBuilt 1979 · S/N VAC-136-79N8290NHorne Larry E · Suffolk, VABuilt 1969 · S/N 28-25508N8290PEmge Douglas W · Albertville, ALBuilt 1963 · S/N 24-3543N8290SNewsome Jeff · Blackwell, OKBuilt 1965 · S/N 15061890N8290WCastles James D · Portland, ORBuilt 1965 · S/N 28-2452N8290XMorrison Preston L · Findlay, OHBuilt 1980 · S/N 32-8106007N82910Great Bay Air LLC · North Hampton, NHBuilt 1982 · S/N 32R-8313006N82912Barrows Stuart L · Eagle River, AKBuilt 1977 · S/N 18-7709195N82918Herman Brant · Fairbanks, AKBuilt 1977 · S/N 18-7809024
Back to AD 87-10-06 R1