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.

N9941MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1982 · S/N 20700748N9941VMorris Gray S · Chugiak, AKS/N 18051793N9941ZParagon Air Group · Fort Worth, TXBuilt 1983 · S/N U20606760N9942MAlaska Aircraft Leasing LLC · Silverdale, WAFirst renewal noticeBuilt 1982 · S/N 20700756N9942QWarren John Russell · Los Alamos, NMBuilt 1975 · S/N 17265886N9943ASipple Ronald W Jr · Gardner, KSBuilt 1950 · S/N 19303N9943ELerud Peder E · Stockton, CABuilt 1979 · S/N 17272294N9943MBristol Bay Air Service Inc · Dillingham, AKBuilt 1982 · S/N 20700757N9943QGrove Todd M · Lake Stevens, WABuilt 1976 · S/N 17265887N9943VNewsom John · Lubbock, TXBuilt 1966 · S/N 18051797N9943XN63e LLC · Fallon, NVS/N 185-0143N9943ZState Of Maine Department Of Agriculture · Old Town, MEBuilt 1983 · S/N U20606762N99442Sale Reported · Kissimmee, FLSale reported, pending cancellationS/N 17276447N9944ESw Aviation LLC · Norman, OKBuilt 1975 · S/N 18264004N9944NJungclaus Karl F · Piedmont, SDBuilt 1975 · S/N 18052599N9944QSkywarrior Flight Training Inc · Pensacola, FLBuilt 1975 · S/N 17265888N9944RCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1986 · S/N U20606993N9944VHinkes Michael T · Fairbanks, AKBuilt 1966 · S/N 18051798N9944XChristian Dana J · Bozeman, MTBuilt 1961 · S/N 185-0144N9944ZChaparral Air Group · Grapevine, TXS/N U20606763N9945EWilcox John C · Aurora, NEBuilt 1979 · S/N 17272295N9945HCbw Holdings LLC · Columbia, TNBuilt 1981 · S/N 18268133N9945QClassic Air Aviation LLC · Mesa, AZBuilt 1975 · S/N 17265889N99465Farzam Hamid · Newington, CTBuilt 1985 · S/N 17276450N99467Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276451N9946BFuehrer John G II · Ephrata, PABuilt 1957 · S/N 34346N9946ELorenz Gary W · La Mesa, CABuilt 1975 · S/N 18264006N9946MGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700588N9946QHorizon Aviation LLC · Sinclair, MEBuilt 1975 · S/N 17265890N9946TKruger Matthew J · Pine Island, MNBuilt 1960 · S/N 18253046N9946XBarber Edward G Jr · Anchorage, AKBuilt 1961 · S/N 185-0146N9947BClarke Adam M · Lompoc, CAS/N 34347N9947CLoftin Aviation Group LLC · Suwanee, GABuilt 1978 · S/N R18200489N9947EAstle James H · St John, KSBuilt 1975 · S/N 18264007N9947GArthur Aviation LLC · Arthur, NDBuilt 1971 · S/N 18800747N9948Barron Jon M · Perry, MOS/N 7815N9948AHoatson Larry · Yucaipa, CABuilt 1950 · S/N 19308N9948MGrant Aviation Inc · Anchorage, AKBuilt 1982 · S/N 20700759N9948TMoulton Robert J · Filer, IDBuilt 1960 · S/N 18253048N9948VSchultz Vaughn P · Marysville, CABuilt 1977 · S/N R1722356N9948ZAlien Invaders LLC · Medina, WABuilt 1983 · S/N U20606767N9949NFox Heather J · Bettles Field, AKBuilt 1975 · S/N 18052604N994CDNavair LLC · Mount Vernon, OHBuilt 1979 · S/N 21063312N994JPHinen Paul H · Soap Lake, WABuilt 1973 · S/N 15074483N994NACurry Lloyd F · Karnack, TXBuilt 1966 · S/N 17254820N994NZFrakes Stephen A · Frisco, COBuilt 1978 · S/N 21062470N994RJAirline Pilot Careers LLC · Champlin, MNBuilt 1977 · S/N 18503260N994RSShane Richard D · Canandaigua, NYBuilt 1978 · S/N 15282505N99501Bennett Gary R · Anchorage, AKBuilt 1971 · S/N 18260598N99508Lee Randall Ross · Houston, TXBuilt 1985 · S/N 17276456
Back to AD 87-20-03 R2