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.

N99FPShort Jon P · Cullman, ALFirst renewal noticeBuilt 1978 · S/N 27-7854119N99GLCristy Daron James · La Jolla, CABuilt 1981 · S/N 1005N99HDRoodvoets Brian A · Lapeer, MIBuilt 1983 · S/N 1012N99HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 1999 · S/N 172S8222N99HGSoutheastern Business Machines Inc · Baxley, GABuilt 1991 · S/N 001N99HLShaw James J · Loranger, LABuilt 1984 · S/N LIPSCOMB-0001N99HYDiamond V Aircraft Interests LLC · Mountain Home, TXBuilt 2002 · S/N 2213N99HZSmoke Master Aero LLC · Tehachapi, CAS/N 23055N99JDBurdette Dan G Trustee · Edmond, OKBuilt 2011 · S/N 91369N99JLMattson Eric J · Saint Paul, MNBuilt 1959 · S/N 24-1579N99JMRebellion Point Aviation LLC · Elizabeth City, NCBuilt 1973 · S/N 28-7325611N99JPCp Aviation Inc · Santa Paula, CAS/N 5101N99JYKimmel Stephen G · Brevard, NCBuilt 2001 · S/N 22746N99KBKeller Bros Airport Inc · Lebanon, PABuilt 1990 · S/N 229N99KKAllen-Shinn Steven M · Larkspur, COBuilt 1980 · S/N 111N99KTColeman Paul Jay · Pace, FLBuilt 2000 · S/N 3RX046N99LBVolz Laura M Trustee · Williamsville, NYBuilt 1960 · S/N 24-2265N99LQTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1959 · S/N 834N99LYKanczuzewski Douglas J · Temecula, CABuilt 2022 · S/N 001N99MDJinkins Richard D · Rewey, WIBuilt 1955 · S/N 23-325N99MFWelkin Aero Inc · Garden Plain, KSBuilt 1982 · S/N 3004N99MGChaffee Michael D · Big Rapids, MIBuilt 1969 · S/N 32-40727N99MTGardner Donald G · Granbury, TXBuilt 1966 · S/N 24-4526N99NAPozzi Andrew E · Crescent City, CABuilt 1977 · S/N 17702697N99NCHrutkay Charles S · Scenery Hill, PABuilt 1968 · S/N 28-5044N99NFFelchner Nikolai · MunichBuilt 2010 · S/N 6088N99NXStewart Shelton O · Godley, TXBuilt 1998 · S/N 966N99PF3g Classic Aviation Inc · Wilmington, DES/N 1-0006N99PGWilliams James R · Batesville, INBuilt 1978 · S/N 17272044N99PJLarose Gary R · Anchorage, AKS/N 18-7509141N99PLFirth Leonard F · Brookshire, TXBuilt 1959 · S/N TD-285N99PRBeale Leonard C · Fort Worth, TXBuilt 1968 · S/N TD-709N99PWHarding Willam R Jr · Quinlan, TXBuilt 1968 · S/N 690016N99PXCeo Flight Inc · Arlington Heights, ILS/N 17702149N99PZWinters Charles B · Farmington, NMBuilt 2000 · S/N 22993N99R206aa LLC · Saint John, INBuilt 1969 · S/N 28R-35160N99RGHorwath Rick · Frankenmuth, MIBuilt 1979 · S/N 70030N99RNCamp Doug A · Starkville, MSS/N 5304N99RRReynolds Darryl G · Wills Point, TXBuilt 1999 · S/N 0653N99RUBold Group Ltd · Englewood, COBuilt 1970 · S/N MY4Q2N99RVReeder Travis · Marana, AZS/N 99N99RXWilson Ronald L · Lake City, FLBuilt 1999 · S/N CC1014N99SQTell Christopher A · Colville, WABuilt 1984 · S/N 10002CN99SSOsprey Holding Company LLC · Foley, ALBuilt 1972 · S/N 331-72N99SWBurnette Preston B · Northport, ALBuilt 1966 · S/N 28-3585N99SXBrummett Barrett D · Columbus, INBuilt 1992 · S/N RG795N99TCUltimate Resort Vacations Inc · Weston, FLBuilt 1980 · S/N 172RG0412N99TJColeman Nick D · Taylorsville, KYBuilt 1995 · S/N 001N99TLRumsey Todd A · Sturgis, MIBuilt 1998 · S/N 1721N99TNHuskey Ryan J · Edmond, OKS/N 17265107
Back to AD 87-10-06 R1