OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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-20-03-R2')
    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-20-03-R2')
  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.

N6329AAlpine Medical Services Inc · Hayden, IDBuilt 1956 · S/N 33129N6329BN6329b Flyingclub LLC · Farmington, MNBuilt 1957 · S/N 34229N6329CUnited Indian Mission DBA · Tucson, AZBuilt 1977 · S/N U20603844N6329EFeigl Frederick D · Dallas, TXBuilt 1959 · S/N 46429N6329GRegistration Pending · Brodheadsville, PARegistration pendingS/N 15071829N6329YDiablo Aviation LLC · Pleasanton, CABuilt 1981 · S/N 21064339N632AHWrasse Mark R · Rosholt, WIBuilt 1957 · S/N 34248N632EHHuddleston Edward L · Oaktown, INBuilt 1973 · S/N A1500467N6330BGroup Therapy Enterprises Inc · Claremore, OKBuilt 1957 · S/N 34230N6330CLos Angeles County Sheriffs Department · Long Beach, CABuilt 1980 · S/N 21063866N6330ECollins Anthony W · Bowdoinham, MEBuilt 1959 · S/N 46430N6330FHansen Jodi L E · Farmington, MNBuilt 1975 · S/N 18264162N6330SErnst Albert S III · Buda, TXBuilt 1967 · S/N 15067130N6330VLegacy Lsa LLC · Lubbock, TXS/N 172RG0628N63312Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17275419N6331GSound Flight LLC · Auburn, WAS/N 15071831N6332ASkydive Awesome! LLC · Bend, ORBuilt 1956 · S/N 33132N6332DBlue River Aviation LLC · Wasilla, AKBuilt 1979 · S/N 17272720N6332ERampani Joe J · Sullivan, MOBuilt 1959 · S/N 46432N6332GJr Imaging Logistics Inc · Pasco, WABuilt 1970 · S/N 15071832N6332T32 Tango Aviation LLC · Beaverton, ORBuilt 1984 · S/N R18201984N63332Andavia LLC · Fort Worth, TXBuilt 1975 · S/N 15077241N63336Murry John · Anchorage, AKBuilt 1977 · S/N 18052841N63338Scarbrough Mark B · San Miguel, CAS/N 15077247N6333AHeller Peter C · Denver, COBuilt 1956 · S/N 33133N6333BEspiricueta William L · Denver, COS/N 34233N6333EProstar Flight Services LLC · Bozeman, MTBuilt 1983 · S/N 18268359N6333FMattuski Joseph C Jr · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273193N6333GEule James M · Eagle River, AKS/N 15071833N6333SVano Andrew · Carlos, MNBuilt 1967 · S/N 15067133N63341Puget Sound Flyers Inc · Everett, WAS/N 15077250N63342Vmax Aviation LLC · Uhrichsville, OHBuilt 1975 · S/N 15077251N63346White Thomas L · Willow Springs, MOBuilt 1975 · S/N 15077253N6334BS&D Spraying Service Inc · Panhandle, TXBuilt 1957 · S/N 34234N6334ESrygley Donald E · Muscle Shoals, ALBuilt 1959 · S/N 46434N6334MSundance Flying Club Inc · Palo Alto, CABuilt 1980 · S/N 15284678N63352Carter Flygare Inc · Sacramento, CABuilt 1981 · S/N 17275425N63359Flick Adam C · Findlay, OHBuilt 1975 · S/N 15077261N6335ECorro Lee A · Holden, MES/N 46435N6335GHaslam Russell L · Meeker, OKS/N 15071835N63362Bels Holdings LLC · Albert Lea, MNBuilt 1975 · S/N 15077262N63363Shaner John D · Tallahassee, FLBuilt 1975 · S/N 15077263N63366Purdue Aviation LLC · West Lafayette, INBuilt 1981 · S/N 17275426N63368Lorenzen Kraig Elmer · Pagosa Springs, COBuilt 1977 · S/N 18052842N6336BNorris Donald A III · Edmond, OKBuilt 1957 · S/N 34236N6336KFlanders Steve L · Brea, CAS/N 15077650N6336UBravo Whiskey LLC · Missoula, MTBuilt 1985 · S/N 21064937N6336VKman LLC · Kalispell, MTBuilt 1980 · S/N 172RG0632N63375Pocono Mountains Flying Club Inc · Tobyhanna, PAS/N 15077268N63376Devaney Aviation Inc · Palm City, FLBuilt 1975 · S/N 15077269
Back to AD 87-20-03 R2