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.

N6970HPerella James C · Cub Run, KYBuilt 1975 · S/N 17265671N6970QWalker Joshua D · Denison, TXBuilt 1968 · S/N MB-317N6970UCampbell Steven D · Henderson, NVBuilt 1964 · S/N 330N6970YBell Daniel E · Alexandria, KYBuilt 1969 · S/N 27-4337N6971DVan Wagner Aerial Media LLC · Hollywood, FLS/N 18-5497N6971JMurphy David Charles · Rancho Cucamonga, CABuilt 1976 · S/N 28-7625263N6971QRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1968 · S/N MB-318N6971TTodaro Rodney F · Tullahoma, TNBuilt 2004 · S/N SRE041N6971WPop-A-Top Corp · Nashville, MIBuilt 1965 · S/N 28-21169N6971YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1969 · S/N 27-4338N6972JBicker Farms Lllp · Tioga, NDBuilt 1976 · S/N 28-7690445N6972UAyres Floyd Dean · Leavenworth, KSBuilt 1964 · S/N 422N6972WPryce James T · Ebensburg, PABuilt 1965 · S/N 28-21170N6973HScheerer Jill · Sag Harbor, NYBuilt 1975 · S/N 17265673N6973JStracener Adam · Pittsburg, TXBuilt 1976 · S/N 28R-7635369N6974BHill Karl D · Igiugig, AKBuilt 1957 · S/N 18-5095N6974HWatsonair LLC · Carlsbad, CABuilt 1975 · S/N 17265674N6974PLiske Robert R · Chesterfield, MIBuilt 1960 · S/N 24-2116N6974RPaulsen David · Danville, CABuilt 1974 · S/N M-1587N6974VRegistered aircraftBuilt 1976 · S/N 22-1341N6974WRolland Jason J · Plumas Lake, CABuilt 1965 · S/N 28-21172N6975HRoot Shane G · Dighton, KSBuilt 1975 · S/N 17265675N6975QWeber Mark J · Hoven, SDBuilt 1968 · S/N MA-338N6975UBallou-Crawford Terry · Savannah, MOBuilt 1964 · S/N 335N6975VRodmark Aviation LLC · Jupiter, FLBuilt 1976 · S/N 22-1342N6976QBeech 76q LLC · Englewood, FLBuilt 1968 · S/N MA-339N6976UHumble Enterprises Inc · Valley Head, ALBuilt 1964 · S/N 336N6976WHorst Paul N · Lebanon, PAFirst renewal noticeBuilt 1965 · S/N 28-21174N6977QAnderson Gary D · Mechanicsville, MDBuilt 1968 · S/N MB-325N6977RSundowner Aviation Inc · Blaine, MNBuilt 1974 · S/N M-1620N6977UPoss Alexander C · Del Rio, TXBuilt 1964 · S/N 337N6978BVantrease Jerold Lee · Homer, AKS/N 18-5100N6978PGallego Victor · Matawan, NJBuilt 1960 · S/N 24-2121N6978RDodson International Parts Inc · Rantoul, KSS/N MC-324N6978UDouglass Rick C · Bakersfield, CABuilt 1964 · S/N 338N6979DKohlhase Amy M · Anchorage, AKBuilt 1957 · S/N 18-5507N6979HWhitaker Ian S · Fort Mohave, AZBuilt 1975 · S/N 17265678N6979JImani Cameron · Lexington, KYS/N 28-7690446N6979QShlomo Yaron · Honolulu, HIBuilt 1969 · S/N MB-403N6979UGiles Forrest D · Springtown, TXBuilt 1964 · S/N 339N6979WCzygan Noel · Rapid River, MIBuilt 1965 · S/N 28-21177N697CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881133N697FLAeroflyin Corp · Pembroke Pines, FLS/N 17276100N697FTSilvey Michael Duane · Newhall, CABuilt 1973 · S/N 28R-7335140N697LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881686N697NDSouth Dakota State University · Brookings, SDBuilt 2015 · S/N 4496385N697RBAerospace Trust Management LLC Trustee · Wilmington, DES/N 1042N697SUSouthern Utah University · Cedar City, UTFirst renewal noticeBuilt 2005 · S/N 10736N697WHAgri Enterprises LLC · Hopkinsville, KYBuilt 1983 · S/N 31-8352008N697YAHorizon Flyers LLC · Kingsford, MIBuilt 1971 · S/N 28-7125636
Back to AD 87-10-06 R1