OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N2344GJones Alva L · Craig, COBuilt 1958 · S/N 51644N2344SAnderas Per R · Green Bay, WIBuilt 1967 · S/N 337-0644N2345Riotte Frederick · Suffield, CTS/N 17266419N23453Harrier Aviation LLC · South Saint Paul, MNBuilt 1968 · S/N 15068957N23458Blue Skies Aircraft LLC · Kalispell, MTBuilt 1968 · S/N 15068961N2345DTravelaire Service Inc · Pueblo, COBuilt 1952 · S/N 20497N2345SSummers Jeffrey L · Pekin, INBuilt 1967 · S/N 337-0645N2345URenkel Albert D · Las Vegas, NVBuilt 1962 · S/N 17249945N2345VEder Samuel A · Fayetteville, NCS/N 25056N2345YJackson Shaun K · Tyler, TXBuilt 1967 · S/N 17700145N2345ZRegistered aircraftBuilt 1977 · S/N 17270190N23460Clark Johnathan W · Coventry, CTBuilt 1968 · S/N 15068963N23461Egipciaco Jeffrey · Hampstead, NCBuilt 1968 · S/N 15068964N23469N23469 LLC · Rehoboth Beach, DEBuilt 1968 · S/N 15068970N2346DSasser Bradley B · Cumming, GABuilt 1952 · S/N 20498N2346FNavion Holdings LLC · Boise, IDBuilt 1964 · S/N 21058546N23473G Force Advantage LLC · Lewes, DEBuilt 1968 · S/N 15068973N23476Horizon Flight Center LLC · Chesapeake, VABuilt 1968 · S/N 15068976N2347RDillon John C · Flagstaff, AZBuilt 1964 · S/N 18255447N2347XRegistered aircraftS/N 18256247N2347YProctor Keith E · Paint Lick, KYBuilt 1968 · S/N 17700147N23486Hite Michael B · Martinsburg, WVBuilt 1968 · S/N 15068983N23489Knebel Chris DBA · Boston, VABuilt 1968 · S/N 15068985N2348DNorthern Aviation LLC · Palmer, AKBuilt 1955 · S/N 20500N2348GWright Michael Lee · Isanti, MNBuilt 1959 · S/N 51648N2348RMiller Robert S · Laurel Springs, NCBuilt 1964 · S/N 18255448N2348UWojnar Ronald T · East Troy, WIBuilt 1962 · S/N 17249948N2348XChessman H Ross · Erie, COBuilt 1965 · S/N 18256248N23491Mcintosh Dyllon J · Anchorage, AKBuilt 1968 · S/N 15068987N23492Roller Michael J · Gassville, ARBuilt 1968 · S/N 15068988N2349CSchwend Brian · Forsyth, MTBuilt 1953 · S/N 30649N2349DFedorka Paul R Trustee · Soldotna, AKBuilt 1952 · S/N 20501N2349FMilutinovic Christain · Marengo, ILBuilt 1964 · S/N 21058549N2349GRegistration Pending · Buckley, WARegistration pendingBuilt 1958 · S/N 51649N234BWWaring Marvin Barton · Anacortes, WABuilt 1979 · S/N P21000290N234CMTallman Donald Depaul · Venice, FLBuilt 1966 · S/N 18257696N234FNelson Graig M · Eastsound, WABuilt 1955 · S/N 32142N234GMCunningham Hal A · Standard, CABuilt 1976 · S/N 17266438N234GTAny Border LLC · Yankton, SDBuilt 1977 · S/N 21062155N234JGBartlett William F · Jackson, WYBuilt 1975 · S/N 17265225N234JSOcean Blue Aviation LLC · Farmingdale, NYBuilt 1976 · S/N 18502956N234PCCaldwell Larry R · Florence, KYBuilt 1985 · S/N 17276321N234PEDunn Linwood B · Franklin, TNBuilt 1968 · S/N 17701078N234PKHintz Courtney N · San Antonio, TXBuilt 1963 · S/N 18254645N234PWRight Rudder LLC · Sapulpa, OKBuilt 1978 · S/N 18266103N234QASteinke Mark · Camas, WABuilt 1959 · S/N 52409N234RCRonnie G Crider Pa · Clearwater, FLBuilt 1985 · S/N R18202012N234RKShelton Raymond O · Jeanerette, LABuilt 1968 · S/N 15068893N234RMWilliams Walt A · Mena, ARBuilt 1964 · S/N 17252230N234SBDaly Arthur P · El Paso, TXBuilt 1981 · S/N P21000673
Back to AD 87-20-03 R2