OpenAirDocs.org
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.

N8239FTeeters Larry N · Shreveport, LABuilt 1966 · S/N 15064339N8239LSkys Edge Aviation LLC · Midland, TXBuilt 1967 · S/N 17256439N8239XHess Dan A · Hastings, NEBuilt 1962 · S/N 17248739N8239ZWard James H Jr · Plymouth, NCS/N 205-0239N823BEStanley Joseph A Trustee · Thornville, OHBuilt 1982 · S/N 18268162N823FStout Philip L · Ephrata, WAS/N 15064514N823PWSpradley Jeff D · White Springs, FLBuilt 1964 · S/N 17250896N823SRLandmark Aerial LLC · Metuchen, NJBuilt 1974 · S/N 18263442N823TMMarther Thomas L · Albion, PABuilt 1955 · S/N 32140N823WSMcinturf Paul A Jr · Childress, TXBuilt 1967 · S/N 15066175N8240F14a Flying Club Inc · Mooresville, NCBuilt 1966 · S/N 15064340N8240LCactus To Clouds Aviation LLC · Indio, CABuilt 1967 · S/N 17256440N8240ZSingleton Shermann S · Farmington, NMS/N 205-0240N8241BBalint Jozef · Fort Worth, TXBuilt 1956 · S/N 36041N8241GSilvers Clarence W III · Holden, MOBuilt 1971 · S/N 177RG0141N8241MVenema-Ashmore Karin · East Dixfield, MEBuilt 1969 · S/N 21059241N8241URegistration Pending · Casa Grande, AZRegistration pendingBuilt 1964 · S/N 17252141N8241VAlsworth Glen R · Port Alsworth, AKBuilt 1966 · S/N 18051743N8241XRotormate LLC · Royse City, TXBuilt 1961 · S/N 17248741N8242BLibby Robert E · Windham, MEBuilt 1957 · S/N 36042N8242GValdez Acela Rangel · Maricopa, AZS/N 177RG0142N8242XSadique Said-Hesamadine · Fairfax, VAS/N 17248742N8243EMacon Air LLC · Franklin, NCBuilt 1979 · S/N 17272155N8243GGebauer David Lee · Jackson, CABuilt 1971 · S/N 177RG0143N8243MBundy Holdings LLC · Walnut Grove, MOBuilt 1976 · S/N 18264572N8243XDemetreu Thomas J · Almond, NYBuilt 1961 · S/N 17248743N8243ZHogscanfly LLC · Wagner, SDBuilt 1963 · S/N 205-0243N8244AMiles Robert A · Maupin, ORBuilt 1952 · S/N 25096N8244GHughes Jeffrey D · Roseburg, ORBuilt 1971 · S/N 177RG0144N8245AAdriatic Holdings LLC · Cheyenne, WYBuilt 1952 · S/N 25097N8245FMorisette Michael W · Antelope, CABuilt 1966 · S/N 15064345N8245GSchultz Jeffrey R · Dayton, OHBuilt 1971 · S/N 177RG0145N8245MSea Seven LLC · Weatherford, TXBuilt 1976 · S/N 18264573N8245VFarnsworth James A · Sandy Valley, NVBuilt 1966 · S/N 18051747N8245ZByrum Scott L · Avondale, AZBuilt 1963 · S/N 205-0245N8246BBoyer Christopher · Bozeman, MTBuilt 1957 · S/N 36046N8246FTalikka Todd · Paulding, OHBuilt 1966 · S/N 15064346N8246LPatak Eva L · Ennis, TXBuilt 1967 · S/N 17256446N8246ZChak Chak LLC · White Salmon, WABuilt 1963 · S/N 205-0246N8247BDoughty Robert W · Casa Grande, AZBuilt 1957 · S/N 36047N8247FCarson Leonard H · Chesapeake, VAS/N 15064347N8247LKnepp Terry · Montgomery, INBuilt 1967 · S/N 17256447N8247UComeau Paul D · Walden, NYBuilt 1964 · S/N 17252147N8247ZBeam Troy A Trustee · Shippensburg, PABuilt 1963 · S/N 205-0247N82488Simpson Patrick E · Ketchum, IDBuilt 1964 · S/N 18255745N8248AEllis John D · Hodgenville, KYBuilt 1952 · S/N 25100N8248FLucia Steven R Sr · Agawam, MAS/N 15064348N8248GSchuster Peter E · Dundee, OHBuilt 1971 · S/N 177RG0148N8248LBattleshaw Raymond · Weidman, MIBuilt 1967 · S/N 17256448N8248URobison Wm Lee · Smithville, MOBuilt 1964 · S/N 17252148
Back to AD 87-20-03 R2