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.

N8435FRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1981 · S/N 28-8290002N8435G303 LLC · Beaumont, TXBuilt 1981 · S/N 28-8290003N8435HKadac LLC · Shawano, WIS/N 102N8435LAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1968 · S/N 17256635N8435UMayotte Robert · Boynton Beach, FLS/N 28-8290005N8435YGlobal Aviators Academy Inc · Claremont, CAS/N 30-1595N84364Innovated Control Systems Inc · Watsonville, CABuilt 1981 · S/N 28-8290008N84365Abbott Troy D · Hollywood, MDBuilt 1969 · S/N 17258441N84366Noeldner Pamela Ann · Lansdale, PABuilt 1981 · S/N 32R-8113113N84367Martin Arthur D · New Market, VABuilt 1969 · S/N 17258442N84368N84368 LLC · Colorado Springs, COBuilt 1981 · S/N 32R-8129105N84369Ulrich Casey M · Waldo, KSBuilt 1969 · S/N 17258444N8436JMarshall Lee C · Hartsville, SCBuilt 1981 · S/N 28-8116320N8436RRegistration Pending · Riverton, KSRegistration pending, pending cancellationBuilt 1966 · S/N 28-22316N8436TElias Akal Aviation LLC · Deering, NHBuilt 1981 · S/N 28-8116321N8436WHidalgo Robert J · El Paso, TXS/N 28-2667N8437CRobert Price Smith · Hodgenville, KYBuilt 1976 · S/N 28-7690141N8437DClark Donald S · Atlantic Beach, FLBuilt 1957 · S/N 22-5692N8437WThomas Eric D · Placerville, CABuilt 1965 · S/N 28-2668N84386Bell Motor Co · Cut Bank, MTBuilt 1969 · S/N 17258454N8438EBohlen Terry A · Cameron Park, CABuilt 1982 · S/N 28-8211001N8438HPitt Ian · Bergenfield, NJS/N 28-8290009N8438RMorrison Doyle T · Goldthwaite, TXBuilt 1966 · S/N 28-22319N8438YJohnson Aaron D · Colfax, WABuilt 1969 · S/N 18-8864N84390Butts Desmon D · New Waverly, TXBuilt 1969 · S/N 17258456N84391Vicknair Michael N · Owasso, OKBuilt 1969 · S/N 17258457N84392Romeo Flying Club LLC · Leonard, MIBuilt 1969 · S/N 17258458N84397Hernandez Karen K · Garden Valley, CABuilt 1969 · S/N 17258459N8439EManchin Joseph III · Charleston, WVBuilt 1981 · S/N 32R-8113115N8439MSteel Supply Co · Rolling Meadows, ILS/N 0371N8439TFly Quest Aviation LLC · Pomona, CAFirst renewal noticeBuilt 1981 · S/N 28-8290012N8439WPace Andrea · Homosassa, FLBuilt 1965 · S/N 28-2670N8439YTracy Bill E · Leoti, KSBuilt 1970 · S/N 18-8866N8439ZSyracuse Flying Club Inc · Fayetteville, NYBuilt 1981 · S/N 28-8190313N843DCJuliet Echo LLC · Sheridan, WYBuilt 1965 · S/N 30-967N843DPChoice Aviation LLC · Hamilton, MTBuilt 1969 · S/N 17258431N843FRC4l Helicopters LLC · Myrtle Beach, SCBuilt 1999 · S/N 0562N843GR & B Aircraft Holdings LLC · Denham Springs, LABuilt 1969 · S/N 30-1766N843RFConner Patsy L · Kerrville, TXBuilt 1997 · S/N 22843N843SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881717N843SDAftab Younus · Pleasanton, CABuilt 2006 · S/N 001N843TCLegends Air Center LLC · Bentonville, ARBuilt 2000 · S/N 18280843N844Ross George W DBA · Boise, IDS/N 709N84400N84400 LLC · Chamblee, GABuilt 1981 · S/N 28-8216004N84408Miyamoto Edward · Rio Vista, CABuilt 1969 · S/N 17258462N8440BKoon Anthony Scott · Kokomo, INBuilt 1981 · S/N 28-8290013N8440DAkn Inc · Crystal, MNBuilt 1957 · S/N 22-5695N8440HMeyer Anthony R · Whittemore, IABuilt 1981 · S/N 28-8216001N8440LRoot William L Trustee · Scotia, NEBuilt 1968 · S/N 17256640N8440MAirflair Inc · Maurice, IABuilt 1981 · S/N 28-8216002
Back to AD 87-10-06 R1