OpenAirDocs.org
AD 87-11-01 R1

Registered aircraft · 630

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-11-01-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-11-01-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.

N27LEQuality Feed Grains · Harrison, ARBuilt 2000 · S/N 00-301030N28009Merritt Lisa Lawrence · Liberty, TXBuilt 1978 · S/N 78-30878N28010Myers Charles G · Portland, ORBuilt 1978 · S/N 79-30908N28012Carlton William A · Flower Mound, TXBuilt 1978 · S/N 78-30873N28013Selzer Scott · Anchorage, AKBuilt 1979 · S/N 79-30955N28018Hoeschen Derek R · West Fargo, NDS/N 78-31141N28021Prieto David · Fair Lawn, NJBuilt 1979 · S/N 79-30958N28022Selck Frederic W · Washington, DCBuilt 1978 · S/N 78-30881N28025Registered aircraftBuilt 1979 · S/N 79-30953N28026Atwood Grace · Minneapolis, MNBuilt 1980 · S/N 80-30979N28028Mitzoom Enterprises LLC · Minneapolis, MNBuilt 1979 · S/N 79-30948N280314s Holdings LLC · Wilmington, DEBuilt 1979 · S/N 79-30926N28035Stockton Robert R · Fort Worth, TXBuilt 1979 · S/N 79-30951N28039Evavold Brett D · Alexandria, MNBuilt 1978 · S/N 78-30892N28041Taylor Aviation Inc · Montgomery, NYBuilt 1978 · S/N 78-30872N28047Tredway Robert · Prescott, AZBuilt 1979 · S/N 79-30943N28054Lemmerbrock Carl E · Northport, ALBuilt 1977 · S/N 78-30859N28055Anthony Piccione LLC · Belleview, FLS/N 79-30961N28056Locker Dan L · Early, TXBuilt 1979 · S/N 79-30962N28057Christensen John C · Livermore, CABuilt 1979 · S/N 79-30963N28058Warren Rex E · Bolivar, MOS/N 78-30879N28059Ruiz Marcos · Bradenton, FLBuilt 1979 · S/N 79-30964N28060S & D Stevens Farms LLC · Tillar, ARBuilt 1978 · S/N 78-30904N28061Jug Aviation Inc · Detroit, MIBuilt 1978 · S/N 78-30864N28062Alger Mark D · Friday Harbor, WABuilt 1978 · S/N 79-30906N28064Reis Darrin C · Fort Myers, FLBuilt 1979 · S/N 79-30965N28066Usher Carolyn L · San Bernardino, CABuilt 1978 · S/N 78-30901N28067Gifford Craig E · Minneapolis, MNBuilt 1979 · S/N 79-30966N28068Jeffrey V Clark · Libertyville, ILBuilt 1979 · S/N 79-30967N28073Lindinger John I · Auburn, NEBuilt 1979 · S/N 79-30917N28078Stabs Aviation Enterprises LLC · Tulsa, OKBuilt 1979 · S/N 79-30922N28081Hardin David A · Tukwila, WABuilt 1979 · S/N 79-30924N28082Torrey Daniel B · Santa Paula, CABuilt 1979 · S/N 79-30968N28085Sale Reported · Falcon Heights, MNSale reportedBuilt 1978 · S/N 78-30894N28091Skinner David W · Georgetown, TXBuilt 1977 · S/N 77-30857N28093Ceynowa Wayne S · Opelika, ALBuilt 1979 · S/N 80-30974N28097Long Gordon W · Fort Wayne, INBuilt 1979 · S/N 79-30940N28103Hawksyntketics LLC · Jacksonville, FLS/N 78-31150N28106Adams Charles J · Santa Maria, CAS/N 78-30874N28111Truair LLC · Shady Shores, TXBuilt 1978 · S/N 79-30909N281123b Aviation LLC · Tyler, TXBuilt 1978 · S/N 78-30889N28119Page Gregory G · Roosevelt, UTBuilt 1978 · S/N 78-31146N28127Ultimate Derby LLC · Celina, TXBuilt 1979 · S/N 80-30972N28128Wolf Bernhard J · Plainview, TXBuilt 1979 · S/N 80-30978N28129Niles Aviation Of Kansas LLC · Arkansas City, KSBuilt 1979 · S/N 80-30970N28130Gorman Neal H · Bend, ORBuilt 1980 · S/N 80-30981N28131Kaczmarek John F · Weatherford, TXBuilt 1978 · S/N 78-30870N28134Rowand Kent · Powell, OHBuilt 1979 · S/N 80-30975N28135Bffe Inc · Homestead, FLS/N 80-30976N28138Todd Jared · Victoria, TXBuilt 1977 · S/N 78-31142
Back to AD 87-11-01 R1