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.

N840ABDiamond Group Holdings LLC · Greenville, NCBuilt 2005 · S/N 40.478N840CSMiller Ashley M · Lima, OHBuilt 1997 · S/N 0326N840DWKoesy Gregory W · Pembroke Pines, FLBuilt 1999 · S/N 18280464N840LPMys Aviation LLC · Rockford, ILBuilt 2004 · S/N 18281483N840TCNorth Star Aviation Inc · Mankato, MNBuilt 2016 · S/N 2842416N840UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020194N840WMKunzelmann Christopher E · Weatogue, CTBuilt 1966 · S/N 32-711N84104Morris Daniel B · Ankeny, IABuilt 1969 · S/N 17258334N84105Jost Jared D · Hillsboro, KSS/N 17258335N84108Bramblett John S · Russellville, ARBuilt 1969 · S/N 17258337N84109Bielak Donald · Louisburg, KSBuilt 1981 · S/N 28-8290034N8410CLevel Up Aviation LLC · Newton, ALBuilt 1976 · S/N 28-7615105N8410ETito Hector · Fayetteville, GABuilt 1979 · S/N 17272196N8410LVictory Lane Aviation LLC · Concord, NCBuilt 1968 · S/N 17256610N8410SNorth Shelby Aviation LLC · Wilmington, DEBuilt 1981 · S/N 28-8116263N8410WRenegade6 Aviation LLC · Woodbridge, VABuilt 1965 · S/N 28-2629N84114Miami Seaplane Tours Inc · Miami, FLBuilt 1969 · S/N 17258339N84117Mendez Arturo · Addison, ILBuilt 1969 · S/N 17258340N8411BGrohs Dihl J · Wessington Springs, SDBuilt 1981 · S/N 28-8190275N8411CRtb Aviation LLC · Jurupa Valley, CABuilt 1976 · S/N 28-7690136N8411DElliott Frank F · Mojave, CABuilt 1957 · S/N 22-5664N8411REleven Romeo LLC · Golden, COBuilt 1966 · S/N 28-22288N8411WHiggins Timothy Owen · Axtell, TXS/N 28-2635N84122Millican Marc J · Anchorage, AKBuilt 1969 · S/N 17258342N84125Koenig Aircraft Restoration Inc · Loranger, LABuilt 1969 · S/N 17258343N84129Petschow Kenneth W · Upland, CABuilt 1969 · S/N 17258344N8412CEiler Marc · Seattle, WAS/N 28-7690137N8412LAddison Flying LLC · Addison, NYBuilt 1968 · S/N 17256612N8412PCoastal Air LLC · Naknek, AKS/N 32-8106079N8412RChamberlain Richard T · Collinsville, ILBuilt 1966 · S/N 28-22289N8412WSutton Timothy A · Glencoe, ALS/N 28-2636N8412ZVan Deman Frank L · Virginia Beach, VABuilt 1981 · S/N 32R-8113086N84130Gutierrez Sergio E · Pharr, TXBuilt 1969 · S/N 17258345N84133Registration Pending · Bowman, NDRegistration pendingS/N 17258347N8413CBrown Lawrence L · Millington, TNBuilt 1976 · S/N 28R-7635159N8413LRussell Adam G · Easton, MES/N 17256613N8413RZuniga Hector Javier · Mission, TXBuilt 1966 · S/N 28-22290N8413WHollier Gregory J · Arnaudville, LABuilt 1965 · S/N 28-2637N8413YReinbold Frederick K · Anchorage, AKBuilt 1969 · S/N 18-8858N84140Kaiser Joe E · Anchorage, AKBuilt 1969 · S/N 17258351N84141Registration Pending · Mansfield, OHRegistration pendingBuilt 1969 · S/N 17258352N84143Jones Donald T · Barrigada, GUS/N 17258353N84146Stone Air LLC · Carrollton, GABuilt 1969 · S/N 17258354N84147Cox James O II · Shady Shores, TXBuilt 1969 · S/N 17258355N8414CInternational Flying Club Inc · Winfield, ILBuilt 1976 · S/N 28R-7635160N8414FPenley Robert G · Corinth, TXBuilt 1976 · S/N 28-7725111N8414LMorris Christopher J · Manor, TXBuilt 1968 · S/N 17256614N8414M8414m LLC · Nunica, MIBuilt 1981 · S/N 28-8190276N8414NAirlake Aero Inc · Lakeville, MNBuilt 1981 · S/N 28-8190278N8414RVick Justin M · Morton Grove, ILBuilt 1966 · S/N 28-22291
Back to AD 87-10-06 R1