OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N170AGHuber David C · Victoria, TXBuilt 1949 · S/N 18975N170AKPerry John E · Kenai, AKBuilt 1953 · S/N 25431N170ARSmith Edward T · Bradenton, FLBuilt 1952 · S/N 20604N170ASBowe Rick J Trustee · Chippewa Falls, WIBuilt 1950 · S/N 19824N170ATVan Anda Aviation LLC · Apopka, FLBuilt 1966 · S/N 17254850N170AWAir Alaska Properties · Wasilla, AKBuilt 1955 · S/N 26805N170BRegistered aircraftBuilt 1952 · S/N 20944N170BBSmothers Joey D · Dwight, ILS/N 26297N170BESmith Michael E · Willits, CAS/N 25752N170BGFinley Rory P · Loon Lake, WABuilt 1952 · S/N 25392N170BHAero-Mobil Inc · Wilmington, DEBuilt 1956 · S/N 27107N170BKDugan Robert J · Boulder City, NVBuilt 1952 · S/N 20839N170BSMcintyre James C · Bethlehem, PABuilt 1954 · S/N 26214N170BTSparks Richard M · Wasilla, AKBuilt 1954 · S/N 26162N170CFAbes Erika · El Paso, TXBuilt 1953 · S/N 25904N170CLHickle William H · Inyokern, CABuilt 1952 · S/N 20699N170CPLawrence Wyatt · White House, TNBuilt 1955 · S/N 26986N170CWHohmann Courtney P · Jacksonville, FLBuilt 1952 · S/N 20411N170DWarr Victor L · Star, IDBuilt 1951 · S/N 20194N170DFWilliams John S · Cleveland, TXBuilt 1950 · S/N 19519N170DGBush Horizon Inc Trustee · Wilmington, DEBuilt 1954 · S/N 26539N170DMBarnstorm/T-34 LLC · Jacksonville, FLBuilt 1952 · S/N 20803N170DPLeingang Mark J · Olympia, WABuilt 1955 · S/N 26716N170DWBelden George B · Sonoma, CABuilt 1949 · S/N 19154N170ECMueller Brent · Saint Maries, IDBuilt 1952 · S/N 20800N170EEDowd Darin R · Gainesville, TXBuilt 1948 · S/N 18063N170ERBowles Brent J · Iraan, TXBuilt 1948 · S/N 18328N170ETPalmatier Harry C III · Volant, PAS/N 19641N170FGs Aviation Inc · Stilwell, KSBuilt 1952 · S/N 25149N170FMMain Freddie L II · Trophy Club, TXBuilt 1957 · S/N 25246N170FSShe-Rat Aviation Inc · Wilmington, DEBuilt 1956 · S/N 27126N170GKipp Robert C · Woodinville, WABuilt 1952 · S/N 20456N170GAOtey Neil F · White Bear Lake, MNBuilt 1951 · S/N 19948N170GCWiley Calvin B · Summer Shade, KYBuilt 1950 · S/N 19442N170HTJon Gibson Co · Cameron Park, CAS/N 20347N170JGivens Steve W · Pendleton, INBuilt 1948 · S/N 18471N170JACrosby Kenneth R · Trapper Creek, AKBuilt 1952 · S/N 25251N170JBEmmons Carl E · Nome, AKBuilt 1955 · S/N 26651N170JEBarrett John E · St Charles, ILBuilt 1953 · S/N 25501N170JGErbey Donald L · Wasilla, AKBuilt 1954 · S/N 26239N170JKSchreier James J · Fort Dodge, IABuilt 1955 · S/N 26948N170JLGodes Terry J · Soldotna, AKBuilt 1953 · S/N 25560N170JRRing John A · La Conner, WABuilt 1952 · S/N 20750N170JSDocjosh Ltd LLC · Essex, NYBuilt 1962 · S/N 15059706N170JTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1953 · S/N 25827N170JWStark David M · Merkel, TXS/N 25973N170KBBecker Kurt G · Dexter, NMBuilt 1956 · S/N 27103N170KHFossa Joseph S · Essex, MABuilt 1952 · S/N 25030N170KMMarlow Properties LLC - Marlow Aviation LLC Series · Knoxville, TNBuilt 1949 · S/N 19166N170KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 15079154
Back to AD 87-20-03 R2