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.

N8930DBeverly Lester E · Shepherd, TXS/N 22-6088N8930JMccracken Blake R · Lake Havasu City, AZBuilt 1965 · S/N 28-2948N8930MCuratola Bruce J · League City, TXS/N M-318N8930WMaurer Mark · Alamogordo, NMBuilt 1964 · S/N 28-10495N8931PDuncan Michael J · Cordova, TNBuilt 1966 · S/N 24-4387N8931VAeroventures 8 LLC · Mt Carmel, TNS/N 17264288N8932DRegistration Pending · Caldwell, IDRegistration pendingBuilt 1958 · S/N 22-6090N8932MOlivieri Michael R · Wasilla, AKBuilt 2009 · S/N 1-18N8932P260b LLC · San Diego, CABuilt 1966 · S/N 24-4388N8932VEverett William M · Tuscumbia, ALBuilt 1974 · S/N 17264289N8932YStrohmeyer Gregory C · Wasilla, AKBuilt 1974 · S/N 18-7409042N89337Davis Andrea E · Lake Oswego, ORBuilt 1983 · S/N 17276002N8933DGrandy Leland P · Rock Springs, WYS/N 22-6091N8933JQuilling John R · Cannon Falls, MNBuilt 1965 · S/N 28-2950N8933LDuncan Aviation Inc · Lincoln, NEBuilt 1974 · S/N 18-7409128N8933WFlight Time LLC · Portland, ORBuilt 1964 · S/N 28-10500N8934PNermernuh LLC · Chester, CTBuilt 1966 · S/N 24-4390N8934VUniversal Aviators Academy Inc · El Monte, CABuilt 1974 · S/N 17264291N8934WNelson Cy D · Decorah, IABuilt 1964 · S/N 28-10501N8934YFuller John M · Minden, NVBuilt 1971 · S/N 39-95N8935WJudd Ellen K · Burley, IDS/N 28-10502N8936JCloud Niners Inc · Brownsburg, INBuilt 1965 · S/N 28-2953N8936PGesenhues Bernard J · Canton, OHBuilt 1966 · S/N 24-4392N8937DBrunner Steve W · Mission Viejo, CABuilt 1958 · S/N 22-6099N8937LHood River Soaring · Hood River, ORBuilt 1971 · S/N 25-5402N8937NSchewe William M · Greenville, ILFirst renewal noticeBuilt 1969 · S/N 32-40735N8937RBeckett David · Wasilla, AKBuilt 1996 · S/N 0279N8937VCowden Steven B · Bellingham, WABuilt 1974 · S/N 17264294N8937WArmstrong Wanliss E · Jal, NMBuilt 1964 · S/N 28-10504N8938FSouthern Cross Aviation Inc · Wilmington, DEBuilt 1964 · S/N 44-0009N8938JMeier Daniel J · Greenwood, INBuilt 1965 · S/N 28-2955N8938YUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1971 · S/N 39-99N8939CRegistration Pending · Lakota, NDRegistration pendingS/N 28-7615133N8939JEstis Jonathan D · Walden, NYBuilt 1966 · S/N 28-2956N8939LWestern Carolina Ag Air Inc · Catawba, NCBuilt 1971 · S/N 25-5404N8939NOakley William J · Kildeer, ILBuilt 1969 · S/N 32-40741N893ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881412N893CBAec Navajo LLC · Wilmington, DES/N 31-8012007N893DCCorporate Air Charter Inc · Wilmington, DEBuilt 1990 · S/N 5182N893FSSmith Francis H Jr · Lyons, COS/N 893N893LTLamb James R · Hobe Sound, FLBuilt 1996 · S/N 1870LN893SHHowell Steven P · Oklahoma City, OKBuilt 2014 · S/N 25883N894Blanton Aircraft Co Inc · Orlando, FLFirst renewal noticeBuilt 1968 · S/N 17257119N8940JMullins David H · Zebulon, GABuilt 1965 · S/N 28-2958N8940PDavie Andrew S · Stony Point, NYBuilt 1966 · S/N 24-4396N8941DMain David W · Blounts Creek, NCBuilt 1958 · S/N 22-6095N8941JTilghman Michael B · Salisbury, MDBuilt 1965 · S/N 28-2959N8941VSky Castle Aviation LLC · New Castle, INBuilt 1974 · S/N 17264298N8941WSalisbury Airplane Associates Inc · Berlin, MDBuilt 1966 · S/N 28-10809N8942DCwynar Scott L · Toledo, OHFirst renewal noticeBuilt 1958 · S/N 22-6100
Back to AD 87-10-06 R1