OpenAirDocs.org
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.

N5357EHoffman Dennis M · Winchester, VABuilt 1978 · S/N 17271840N5357JArizona Bravo Lima LLC · Phoenix, AZBuilt 1980 · S/N 17273762N5357KAir Hammer Two LLC · Gulf Breeze, FLBuilt 1951 · S/N 2257BN5357WJones Michael A · Greer, SCBuilt 1962 · S/N 28-421N5357XFirn Line Aviation Inc · Wasilla, AKS/N 18-7391N53588Davis Charles · Sanford, FLBuilt 1981 · S/N 17274782N5358DXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 17272543N5358FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 3257312N5358LTwidwell Jon J · Olathe, KSS/N 28-4661N5358PWilliams George A · Bonifay, FLBuilt 1958 · S/N 24-306N5358TCarr Jon C · Shell Knob, MOBuilt 1982 · S/N R18201860N53592Gulfstream Design Associates Inc · Delray Beach, FLBuilt 2003 · S/N 3257317N5359FWashington Fliers Club Inc · Washington, IABuilt 1976 · S/N 28-7790098N5359LFirst Flight Corp · San Diego, CABuilt 1968 · S/N 28-4663N5359PPanhandle Groundwater Conservation District · White Deer, TXBuilt 1958 · S/N 24-408N5359SRegistered aircraftBuilt 1980 · S/N R18201554N5359YMajeste Air LLC · Loveland, COBuilt 1963 · S/N 27-2432N535AZBuzz Rickson Aviation LLC · Wilmington, DEBuilt 1997 · S/N 1AP002-02N535CAHanson Robert M · Riverside, CABuilt 1977 · S/N 14293N535HFPars Avn Corp · Wilmington, DEBuilt 2000 · S/N 17280926N535LEAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2026 · S/N 2857N535LMMillcopter LLC · Wahpeton, NDBuilt 2007 · S/N 1790N535RHHarkness Richard · Hanahan, SCBuilt 2017 · S/N 7087N535TKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 14025CN535TWJohnson William · New Wilmington, PABuilt 1973 · S/N 28R-7335381N535WPMcmillin Robert E · Wampum, PABuilt 2007 · S/N 90825N53600Kdrd Holdings LLC · Texas City, TXS/N 17272544N53603Wings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17274786N5360JFly Montana LLC · Miles City, MTBuilt 1980 · S/N 17273763N5360KN5360k LLC · Lebanon, MOBuilt 2002 · S/N 3246207N5360LKitzmiller Peter Charles · Seattle, WAS/N 28-4664N5360PN5360p LLC · Blacklick, OHBuilt 1958 · S/N 24-409N5360WShaffer Thomas D · Round Rock, TXS/N 28-425N53611Aero Mobil Inc · Wilmington, DEBuilt 1981 · S/N 17274787N5361KLong Island Soaring Association · Shirley, NYBuilt 1980 · S/N 17274080N5361NKdb LLC · Underwood, IABuilt 2003 · S/N 2843549N5361WRoberts Misty L · Fountain Hills, AZBuilt 1962 · S/N 28-426N53622Mc Air LLC · Miami Beach, FLBuilt 1981 · S/N 17274788N5362FPetros Michael · Chandler, AZBuilt 1976 · S/N 32-7600024N5362HMccue Tedd R · Eveleth, MNBuilt 1975 · S/N 17265412N5362LTiedemann Douglas A · Skaneateles, NYBuilt 1968 · S/N 28-4667N5362UHebert Loree W Jr · Saint Francisville, LABuilt 2003 · S/N 2843555N5362XSky West Aviation Inc Trustee · Albuquerque, NMS/N 18-6685N53630Arlington Flight Services Inc · Arlington, WABuilt 1981 · S/N 17274789N53632Siple Aviation LLC · Kalispell, MTS/N 17274791N5363JPulliam Joe Clinton Jr Trustee · Pilot Point, TXBuilt 2003 · S/N 2843559N5363KMission Aviation Training Academy · Arlington, WABuilt 1980 · S/N 17274081N5363LTeehee Max L · Searcy, ARBuilt 1968 · S/N 28-4668N5363QCary Gosney Crna Inc · Sonora, CABuilt 2003 · S/N T18208203N5363SOwens Scotty · Crofton, KYBuilt 1970 · S/N 28-7125104
Back to AD 87-10-06 R1