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.

N92059Scott Donald · Bend, ORBuilt 1969 · S/N 18260025N9205RRegistration Pending · Manito, ILRegistration pendingBuilt 1975 · S/N 18802150TN92061Wright Frederick L · Rosamond, CABuilt 1969 · S/N 18260026N92065Meyer Ronald W · Carleton, MIBuilt 1969 · S/N 18260030N92068Lovas Thomas A · Anchorage, AKBuilt 1969 · S/N 18260031N92069Registration Pending · Redding, CARegistration pendingBuilt 1969 · S/N 18260032N9206ACurrie Andrew C · Oscoda, MIBuilt 1949 · S/N 18967N9206CFontenot Mitchell · Kalispell, MTBuilt 1955 · S/N 31305N9206TZack Colson L · Hood River, ORBuilt 1960 · S/N 50706N92074Franz Donald A · Sidney, MTBuilt 1969 · S/N 18260035N9207CRadford Kathleen E · Anchorage, AKS/N 31306N9207GSundin James B · Kahului, HIBuilt 1971 · S/N 18260747N9207TRed Olive Bashir LLC · Spencerville, OHBuilt 1960 · S/N 50707N9207XHegge Darren S · Priest River, IDBuilt 1961 · S/N 18253607N92089Alves Randy J · Lakeview, ORBuilt 1969 · S/N 18260039N9208BYoung James A · Toledo, WABuilt 1958 · S/N 55008N9208CKinzie Hon K · Anchorage, AKBuilt 1954 · S/N 31307N9208GAdams Shane M · Jonesborough, TNBuilt 1971 · S/N 18260748N9208TLund Philip Carl Trustee · Fort Mcdowell, AZBuilt 1960 · S/N 50708N9208UEllefson Nicholas · Duluth, MNBuilt 1976 · S/N 15078159N92098Valburg Bill J · Draper, SDBuilt 1969 · S/N 18260042N92099Jiang Jacky · Riverside, CABuilt 1969 · S/N 18260043N9209CTuckfield Brent M · Monroe, WAS/N 31308N9209HUnited States Air Force Owner · Elmendorf Afb, AKBuilt 1981 · S/N 18267927N9209TTop Hand Inc · Laurel, MTBuilt 1960 · S/N 50709N920AJAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263234N920BEGalaxy Aviation LLC · Nantucket, MABuilt 1979 · S/N 15283538N920GBales Don · Oakhurst, CABuilt 1981 · S/N 172RG0901N920GGAbbott Air Inc · Hydro, OKBuilt 1976 · S/N 21061545N920JMSkysurfer Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 18075N920NWDavis Theodore T · Lake Oswego, ORBuilt 1977 · S/N 18265594N920NZAltura Aviation 3-Nz LLC · Waxhaw, NCS/N P21000309N920SBDream Cloud Aviation LLC · Saint Marys, PABuilt 1978 · S/N R18200444N92103Pgd Flyers Inc · Cape Coral, FLBuilt 1973 · S/N 17261545N92106Reese Karl J · Salome, AZBuilt 1969 · S/N 18260047N9210ASmith Ted · Grant Park, ILBuilt 1949 · S/N 18971N9210HFlex Air Holdings Inc · Wilmington, DEBuilt 1975 · S/N 17266017N9210UKing Bill R · Cadillac, MIBuilt 1976 · S/N 15078161N92112N92112 LLC · Litchfield Park, AZBuilt 1969 · S/N 18260049N92114Schwantz Sharee M · Azle, TXBuilt 1969 · S/N 18260050N92116Dickens Henry V · Morganton, NCS/N 18260051N92119Albin Robert D · Santa Rosa, CABuilt 1969 · S/N 18260053N9211TSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 50711N9211UMaster Gregory A · Mesa, AZBuilt 1976 · S/N 15078162N9211XSalter 11x LLC · Duluth, MNS/N 18253611N92120Westlund Jason Wade · Seattle, WABuilt 1969 · S/N 18260054N92125Seemann James P · Dade City, FLFirst renewal noticeBuilt 1969 · S/N 18260055N9212AMills Byron K · Harrison, ARBuilt 1949 · S/N 18973N9212BRegistration Pending · Campbellsville, KYRegistration pendingBuilt 1958 · S/N 55012N9212CMyers Kenneth O · Niskayuna, NYBuilt 1978 · S/N R18200445
Back to AD 87-20-03 R2