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.

N724HRHeller Martin Bruce · Southport, NCBuilt 2011 · S/N 70018N724JMTygielski Brent R · Clarkston, MIBuilt 1963 · S/N 2502N724LPBone Aviation LLC · Calhoun, GABuilt 1968 · S/N 28-4962N724RStardust Aviation LLC · Farmingdale, NYBuilt 2003 · S/N 2843543N724RBBourgeois J Rion · Canby, ORBuilt 2004 · S/N 2790N724RCCavanaugh Air LLC · Addison, TXBuilt 1997 · S/N 002N724RGHeli Guide Leasing Inc · Crystal Beach, FLBuilt 2001 · S/N 1150N724RVPham Brian T · Long Beach, CABuilt 2005 · S/N 1939N724TMiller Neil · Plymouth, MNBuilt 1998 · S/N 18280250N724TMMorcom Aviation Services Inc DBA · Everett, WABuilt 1974 · S/N 17262971N724TXStratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263381N724VSTwin Oaks L & A Ltd · Wilmington, DEBuilt 1957 · S/N 23-869N724WRichard A Klie · Edwardsville, ILS/N 27-0338N724XGuerra Ricardo Jr · Plano, TXBuilt 2001 · S/N 3RX099N7250DTrump Roger L · Greenville, OHBuilt 1957 · S/N 22-5076N7250JBrandenburg Carl A Jr · Goodyear, AZBuilt 1968 · S/N 28-24592N7250PTrayer Kevin B Trustee · Haslet, TXBuilt 1961 · S/N 24-2426N7250QSale Reported · Crystal, MNSale reported, pending cancellationBuilt 1972 · S/N 17260550N7250WHuber Peter Michael · Pulaski, VABuilt 1963 · S/N 28-1078N7251FWright Charles W · Selbyville, DEBuilt 1968 · S/N 28-25168N7251JChapman Michael S · Cardington, OHBuilt 1968 · S/N 28-24593N7251QGarcia Crystal M · Brownsville, ORBuilt 1972 · S/N 17260551N7252GLeaders Flying Service LLC · Clear Lake, MNBuilt 1970 · S/N 17258952N7252JMedina Jose · Spring, TXBuilt 1968 · S/N 28-24594N7252PSchaefer Hugh W · Merrick, NYBuilt 1961 · S/N 24-2428N7252QRobbins Aviation LLC · Scottsbluff, NEBuilt 1972 · S/N 17260552N7252SDorris Joseph · Lewisburg, KYBuilt 1999 · S/N 18280562N7252YGuyer James · Billings, MTBuilt 1964 · S/N 30-277N7252ZAerial Banners Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3184N7253GOne Mile LLC · Canton, GABuilt 1970 · S/N 17258953N7253JLeffler William J · Tucson, AZBuilt 1968 · S/N 28-24595N7253QHarry'S Hawks · Wells, MNBuilt 1972 · S/N 17260553N7253WGross Matthew A · Ridgecrest, CABuilt 1963 · S/N 28-1081N7253YJednacz Scott T · Bixby, OKFirst renewal noticeBuilt 1964 · S/N 30-278N7254FWolf Kim A · East Wenatchee, WAS/N 28-25172N7254JMinkel Chad A · Chanhassen, MNBuilt 1968 · S/N 28-24597N7254QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N 17260554N7254WMonroe County Flyers And Sales LLC · Sweetwater, TNS/N 28-1083N7254YSpldkd LLC · New Richmond, WIBuilt 1964 · S/N 30-280N72551Gonzalez Christian · Manati, PRBuilt 1964 · S/N 28-10230N72553Whittom Ron W Jr · Wasilla, AKS/N 23-1031N72559Welch Paul · Oldsmar, FLBuilt 1999 · S/N 18280654N7255FN7255f LLC · Cedar City, UTBuilt 1968 · S/N 28-25173N7255JRury Bryan · Midlothian, TXBuilt 1968 · S/N 28-24598N7255PKubik Rodrick D · Waukee, IAFirst renewal noticeS/N 24-2431N7255QSierra Sky Aviation LLC · Kalispell, MTS/N 17260555N7255ZCentral Ms Soaring Society LLC · Brandon, MSS/N 25-3189N7256DAir Supremacy LLC · Bend, ORBuilt 1999 · S/N T20608068N7256FZihala William · North Little Rock, ARBuilt 1968 · S/N 28-25174N7256GAvstar Inc · Seattle, WABuilt 1999 · S/N 18280560
Back to AD 87-10-06 R1