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.

N92866Green Edward L · Chico, TXBuilt 1970 · S/N 18260403N9286ASimon Theodore E · Richmond, MIBuilt 1949 · S/N 19048N9286BHall Leslie E · Lubbock, TXS/N 55086N9286CQueen City Flying LLC · Helena, MTBuilt 1955 · S/N 31385N9286RWiebe Aerial Applications LLC · Peabody, KSBuilt 1975 · S/N 18802212N9286XRogne Fred A · Fallon, NVBuilt 1961 · S/N 18253686N92873Sonday Terrance P · Spring, TXBuilt 1973 · S/N 17261636N92878Jackson Richard L · Indianapolis, INBuilt 1973 · S/N 17261638N9287GCook Lynn H · Highland, UTBuilt 1971 · S/N 18260827N92881Patton Aviation LLC · Billings, MTBuilt 1970 · S/N 18260409N92886Lewis John E · Clayton, NJBuilt 1973 · S/N 17261640N92887Butler Aircraft Company · Walla Walla, WABuilt 1971 · S/N 18260413N92888Knudsen Wayne D · Dakota City, NEBuilt 1973 · S/N 17261641N92889Miller Andy · Marana, AZBuilt 1973 · S/N 17261642N9288CChase Michael D · Albuquerque, NMBuilt 1955 · S/N 31387N9288GPupkar Stephen B · Brookeville, MDS/N 18260828N9288RShane Wilson Pa · Fort Myers, FLBuilt 1978 · S/N R18200679N92894Smith Rex H · Fort Bragg, CABuilt 1973 · S/N 17261644N92895Dana Eric B · Davidson, NCBuilt 1970 · S/N 18260418N9289BWoodstock Aircraft Services Inc · White Lake, NYBuilt 1958 · S/N 55089N9289GBolands North Inc · Binghamton, NYBuilt 1971 · S/N 18260829N9289XFull Send Aviation LLC · Fairview, TNS/N 18253689N928ASA2g International LLC · San Juan Capo, CABuilt 1979 · S/N 33701904N928HPeterson Michael A · White Salmon, WABuilt 1964 · S/N 17251734N928JCLatimer Nelson R · Oxnard, CABuilt 1977 · S/N 18265616N92908C-140 Company LLC · Pensacola, FLBuilt 1973 · S/N 17261647N9290BFitts Roger W · Independence, ORBuilt 1958 · S/N 55090N9290GPhillips Richard L · Vienna, OHBuilt 1971 · S/N 18260830N9290XPetrich John W · Metaline Falls, WABuilt 1961 · S/N 18253690N9291Henderson Charles B · Houston, TXBuilt 1980 · S/N 18265332N92912Hill Charles W · Russellville, ARBuilt 1970 · S/N 18260426N9291AEvans James · Tuolumne, CABuilt 1949 · S/N 19052N9291BVan Meerveld Dwight E · Poplar Grove, ILBuilt 1958 · S/N 55091N9291CMadland Patrick S · Anchorage, AKBuilt 1955 · S/N 31390N9291HDawson William F Jr · Port Hueneme, CABuilt 1975 · S/N 17266071N9291RBobo Richard H · Okolona, MSBuilt 1978 · S/N R18200680N92922Perron Matthew B · West St Paul, MNBuilt 1970 · S/N 18260429N9292GDarter Lloyd R · Mountain Grove, MOBuilt 1973 · S/N 18801448N9292HBlackhawk Flying Club Inc · Rockford, ILBuilt 1975 · S/N 17266072N92934Service Oriented Aviation Readiness (Soar) · Bolivar, MOBuilt 1973 · S/N 17261650N92938Haney Christopher · Murrieta, CABuilt 1970 · S/N 18260435N9293CHayes Dennis Paul · Des Moines, IABuilt 1955 · S/N 31392N9293XRod Ricky L · El Cajon, CABuilt 1961 · S/N 18253693N92945Fla Inc · Wilmington, DEBuilt 1973 · S/N 17261655N9294BHall Justin E · York, NEBuilt 1958 · S/N 55094N9294CBoulder Valley Aviation Inc · Boulder, COS/N 31393N9294HWet Dreams LLC · Erwinna, PABuilt 1977 · S/N 18503428N9295BTow Dogs LLC · Kingman, AZS/N 55095N9295CLesmeister Dean J · Kindred, NDBuilt 1955 · S/N 31394N9295HMiami Seaplane Tours Inc · Miami, FLBuilt 1975 · S/N 17266075
Back to AD 87-20-03 R2