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.

N7733GWashingtons Mt St Helens Co Inc · Mill Creek, WAS/N 17259433N7733NS Dacy Enterprises Inc · Harvard, ILBuilt 1968 · S/N 28-5176N7733PKeller Kevin M · Sylvania, OHBuilt 1961 · S/N 24-2947N7733WSwyers Stinson R · Ottsville, PABuilt 1964 · S/N 28-1741N77340Slikker Enterprises Inc · Bakersfield, CABuilt 1972 · S/N 16-72N7734CAstillero Ricardo · Northfield, NJS/N 28-7690079N7734DPurcell Michael F · Ashfield, MABuilt 1957 · S/N 22-5411N7734JB & B Aviation LLC · Wilmington, DES/N 32-1137N7734NStewart Duncan · Long Beach, CABuilt 1968 · S/N 28-5177N7734WBrown Tyler M · Cary, NCBuilt 1964 · S/N 28-1742N7734YRussell R Bruce · Clayton, GABuilt 1965 · S/N 30-824N7735BEvergreen Investments LLC · Big Lake, AKBuilt 2005 · S/N 10863N7735DSmith Aviation LLC · Springer, OKS/N 22-5412N7735NMelanson Wayne L · Liberal, KSBuilt 1968 · S/N 28-5180N7735PVickers Tim F · Huntingdon, TNBuilt 1961 · S/N 24-2949N7735ZRonald W Gray DBA · Hooker, OKBuilt 1966 · S/N 25-3911N7736CSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1975 · S/N 28R-7635116N7736GKnudson Aviation LLC · Bozeman, MTS/N 17259436N7736LSimmons David · Fremont, NEBuilt 1976 · S/N 17702603N7736PJmj Aviation LLC · Kalispell, MTS/N 24-2950N7737DRinker Kraig G · Winlock, WABuilt 1957 · S/N 22-5414N7737JVir Inc · West Bend, WIS/N 32-1140N7737NKoch Michael R · Nemo, SDBuilt 1968 · S/N 28-5181N7737PFlying Ankers LLC · Saint Marys, OHS/N 24-2951N7737WGt Air LLC · Burton, OHBuilt 1964 · S/N 28-1745N7738GCurioso Enrique Martin · Irvine, CAFirst renewal noticeS/N 17259438N7738JAzuyak Tony Jr · Kodiak, AKS/N 32-1141N7738NBluegrass Aviation LLC · Springdale, ARBuilt 1968 · S/N 28-5182N7738WFlying Turtle Management LLC · Ellicott City, MDBuilt 1965 · S/N 28-2915N7738YAristizabal Leonardo · Van Nuys, CABuilt 1965 · S/N 30-828N7739GFlyguys 172 LLC · Liberty, NCBuilt 1970 · S/N 17259439N7739NSenia John A · Berlin, CTBuilt 1968 · S/N 28-5183N7739PBloom James R · Port Matilda, PABuilt 1961 · S/N 24-2953N773ACDuke Anthony Jr · Alvin, TXBuilt 1997 · S/N 1229-97N773AKKlausler Andrew T · New Market, MNBuilt 1972 · S/N 17260810N773BAMustang Sally Aviation LLC · Camden, SCBuilt 2001 · S/N 172S8773N773GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881221N773HDWare Joseph B · Angleton, TXS/N 07DBN773HPFlorida Highway Patrol · Tallahassee, FLBuilt 2000 · S/N T20608180N773JSRjb Aviation LLC · Newark, DEBuilt 1989 · S/N 4622073N773NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881038N773PTRegent Trust Co Trustee · Wichita, KSBuilt 1973 · S/N 27-7305144N773RFLoper Scotty L · Midlothian, TXBuilt 1992 · S/N 674N773RVPearson Mark · Goodyear, AZBuilt 2020 · S/N 773N773SPFox Flying Club Inc · Wheaton, ILBuilt 2001 · S/N 172S8702N773WGower Scott B · Shelbyville, KYBuilt 2009 · S/N 90664N7740JEbm Management LLC · Canadian, TXBuilt 1969 · S/N 32-1143N7740MMason Graham E · Olympia, WABuilt 1974 · S/N 20-0010N7740NLenderman Steven E · Sharpsburg, GABuilt 1968 · S/N 28-5184N7740UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020279
Back to AD 87-10-06 R1