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.

N969JHJls Aviation LLC DBA · Fredericksburg, VABuilt 1979 · S/N 17273547N969KMSk Aircraft LLC · Anchorage, AKBuilt 1961 · S/N 185-0024N969RBK Fortner LLC · San Marcos, TXBuilt 1968 · S/N U206-1061N969RM182 LLC · Battle Ground, WABuilt 1974 · S/N 18263050N969RRDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 17275850N969SBBostyancic Stanley J · Cohasset, MNBuilt 1975 · S/N U20602724N969SLWojcik Bart C · Kimberly, IDBuilt 1975 · S/N 21060915N969TTSmoketown Flight Center LLC · Smoketown, PABuilt 1973 · S/N 17261635N969TXMowata Farms LLC · Mamou, LAS/N P21000145N969WMCrank Kim · Little Rock, ARBuilt 1962 · S/N 1850506N96ACaldwell Mark K · Bunker Hill, INBuilt 1950 · S/N 7500N96AKRenfro Michael W · Bethel, AKBuilt 1984 · S/N 20700782N96CCInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 21062787N96CNNearburg Charles E · Creede, COBuilt 1979 · S/N 18266868N96FRWoodward-Davis LLC · Nacogdoches, TXBuilt 1980 · S/N 17274184N96LGTaildragger LLC · San Ramon, CABuilt 1965 · S/N 18051517N96LLHuck-Mag LLC · Plano, TXBuilt 1974 · S/N 21060361N96RHAtlanta Aircraft Group LLC · Atlanta, GABuilt 1981 · S/N P21000720N96RRDocter David Alan · New Braunfels, TXBuilt 1959 · S/N 47025N96SJCavender Rick · Yorba Linda, CABuilt 1979 · S/N 18266888N96WPVanneman William M · Ludlow, VTBuilt 1978 · S/N R182-00216N97004Yogi Air LLC · Medina, OHBuilt 1979 · S/N 18266932N97007Tindle Robert Brian · Waco, TXBuilt 1979 · S/N 18266933N9700HBrutko Barry J · Lebanon, PABuilt 1975 · S/N 17266323N9700JCrux Logistics & Consulting Ltd · Las Vegas, NVBuilt 1981 · S/N T18803840TN9700VStencel Lawrence E · Palm Coast, FLBuilt 1974 · S/N 17264479N9700ZHubbard Tyler · Atlanta, GABuilt 1982 · S/N U20606613N97012Debourbon Michael · Pikeville, KYBuilt 1979 · S/N 18266935N97018Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 18266936N97019Mccreery Aviation Co Inc · Mcallen, TXBuilt 1984 · S/N 17276146N97021Bcks Aviation LLC · Kiefer, OKBuilt 1979 · S/N 18266938N97024Alton Parts Supply Inc · Cottage Hills, ILS/N 18266941N9702GZulu LLC · Blaine, MNBuilt 1971 · S/N 18052202N9702LFlying Dreams One LLC · Louisville, KYBuilt 1986 · S/N 17276600N9702TStricklin Lance A · Fort Greely, AKS/N 47502N9702XPilot Mountain Aviation LLC · Pilot Mountain, NCBuilt 1962 · S/N 21058002N9703APease Matthew · Belgrade, MEBuilt 1949 · S/N 19164N9703JSchmitt Rudy · Brookshire, TXBuilt 1981 · S/N 18803841TN9703TBlock Douglas · Pearl City, ILBuilt 1960 · S/N 47503N9703XSalsa De Tomate Inc · Craig, COS/N 21058003N97041Paine Bruce G · Brainerd, MNBuilt 1979 · S/N 18266949N97042Bid Systems LLC · Huntsville, ALBuilt 1979 · S/N 18266950N97045Smith Brandon J · Casselton, NDBuilt 1984 · S/N 17276148N97046Falcon Aviation Inc · Farmington Hills, MIS/N 18266952N97049Tepper Jeremy A · Vail, AZS/N 18266954N9704ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268439N9704GJohnsons Aero Ag Inc · Box Elder, SDBuilt 1971 · S/N 18052204N97051White Stephen M · Tempe, AZBuilt 1979 · S/N 18266955N97052Atnip James L · Cody, WYBuilt 1979 · S/N 18266956N97055Skaya Aircraft LLC · Kalispell, MTBuilt 1984 · S/N 17276149
Back to AD 87-20-03 R2