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.

N9012HLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 17265899N9012MMutchler Joseph T · Billings, MTS/N 18052112N9012XGone Flying LLC · Bartlesville, OKS/N 18253412N9013CMarch David H · Lincoln, CABuilt 1954 · S/N 31061N9013TLamb Aaron C · Vail, AZBuilt 1960 · S/N 52913N9013XSpooner Brian P · Poway, CABuilt 1961 · S/N 18253413N9014HFlex Air Holdings Inc · Manhattan, KSBuilt 1975 · S/N 17265900N9014MAvery John W · Fergus Falls, MNBuilt 1970 · S/N 18052114N9014XSudoh Kenji · Duluth, MNBuilt 1961 · S/N 18253414N9016CLindblom Carl O · Saxon, WIBuilt 1954 · S/N 31064N9016GSkydive Duluth Superior LLC · Superior, WIBuilt 1971 · S/N 18260556N9016MKinslow Aviation LLC · Prague, OKBuilt 1976 · S/N 18264644N9016TDiaz Mark Adba · Madera, CABuilt 1960 · S/N 52916N9016XWolfe John G · Tooele, UTS/N 18253416N9017HMeece Harvey T · Somerset, KYBuilt 1975 · S/N 17265901N9017TCombs Ryan W · Carson City, NVBuilt 1960 · S/N 52917N9018AGodbold Robert L · Apex, NCBuilt 1949 · S/N 18773N9018GSimpkins Lynn DBA · Costa Mesa, CABuilt 1971 · S/N 18260558N9018MMclain Daniel E · Baden, PABuilt 1976 · S/N 18264646N90193Renfro Michael W · Bethel, AKBuilt 1969 · S/N 20700007N9019CHanks Don N · Eagle River, AKBuilt 1954 · S/N 31067N9019XJudah LLC · Springdale, ARBuilt 1961 · S/N 18253419N901JWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258779N901JGWestland Aviation LLC · Lake Havasu City, AZBuilt 1979 · S/N R18201120N901JMGuderjahn Raymond · Garden Plain, KSBuilt 1962 · S/N 18253901N901KSMbk Leasing And Consulting LLC · Lakeland, FLBuilt 1985 · S/N 17276273N901LJPegasus Flight Resources LLC · Charlotte, VTS/N 6715191N901MPMccole Kevin · Brookline, NHS/N 17259565N901PWFlywerx LLC · Anchor Point, AKBuilt 1969 · S/N 18259980N901RJMiller James A · Granada Hills, CABuilt 1965 · S/N 17253429N901SWWilson Paul C · Jefferson, GABuilt 1964 · S/N 15060734N901TGWestland Aviation LLC · Lake Havasu City, AZBuilt 1968 · S/N 17257312N901UBowling Robert E · Argillite, KYBuilt 1974 · S/N 15076038N9020GAmeritek LLC · Tuttle, OKBuilt 1971 · S/N 18260560N9020XBrackett Clayton J · Coopersville, MIBuilt 1961 · S/N 18253420N9021GRector Edward L · Nederland, TXBuilt 1971 · S/N 18260561N9022CBarber Theodore C Trustee · Spanish Fork, UTBuilt 1954 · S/N 31070N9022MDaytona Beach Aero Club Inc · Ormond Beach, FLBuilt 1976 · S/N 18264647N9022THale O'Lele Corp · Honolulu, HIBuilt 1960 · S/N 52922N9022XPartner 91 LLC · Scottsdale, AZBuilt 1961 · S/N 18253422N9023CAinsworth Warren B · Vestavia Hills, ALBuilt 1954 · S/N 31071N9023GBull Bren C · Kingsville, TXBuilt 1971 · S/N 18260563N9023TBauer John P · Medford, WIBuilt 1960 · S/N 52923N9023XBlue Skies Matter LLC · Spokane, WABuilt 1961 · S/N 18253423N9024AHarbick Joshua W · Bend, ORBuilt 1949 · S/N 18779N9024CBaker Lewis E Jr Trustee · Anchorage, AKBuilt 1954 · S/N 31072N9024GJessop Jacob N · Cedar City, UTBuilt 1971 · S/N 18260564N9024MDamianov Venko · Dallas, TXBuilt 1970 · S/N 18052124N90252Weigman Michael S · Altamonte Springs, FLBuilt 1967 · S/N R1720191N9025GN9025g LLC · Indianapolis, INBuilt 1971 · S/N 18260565
Back to AD 87-20-03 R2