OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N4093DZito Nick D · Ellensburg, WABuilt 1957 · S/N 34793N4093JGarcia Joseph Donald · Okeana, OHS/N 15065393N4094DManker Lance M · North Platte, NEBuilt 1957 · S/N 34794N4094FSchupbach Robert D · Clearwater, FLS/N 36994N4094JSquires Janis R · Amherst, OHBuilt 1966 · S/N 15065394N4094VGoodwin Jefferson J · Dolan Springs, AZS/N 18426N4095AValiair Limited Company Trustee · Casper, WYBuilt 1979 · S/N 18503910N4095DRedfern Ronnie M · Fairbanks, AKBuilt 1957 · S/N 34795N4095JParks Richard C · Salem, MOBuilt 1966 · S/N 15065395N4096DSkydive Cape Cod Inc · Caddo Mills, TXBuilt 1958 · S/N 34796N4096FGood John G · Weatherford, TXBuilt 1958 · S/N 36996N4096VWtw Air LLC · Houston, TXBuilt 1977 · S/N R1722272N4097FWadsworth Tom R · Roswell, NMBuilt 1958 · S/N 36997N4097UJ & K Flying LLC · Marengo, OHBuilt 1965 · S/N 15061497N4098DAspegren Robert N · Vacaville, CABuilt 1958 · S/N 34798N4098JFrench Darrell L · Easton, MDS/N 15065398N4098VQualitair LLC Trustee · MichelstadtBuilt 1948 · S/N 18430N409PKSky Cowboy Supply Co LLC · Cape Elizabeth, MEBuilt 1978 · S/N 18503721N409SPTzerefos Lambros P · Mathews, VAS/N 177RG0493N40AESchwartz Michael · Missoula, MTBuilt 1964 · S/N 18255664N40ATN40at LLC · Lewis Center, OHBuilt 1978 · S/N R18200527N40BBPawlak Jakub Piotr · Lafayette, INBuilt 1977 · S/N 18265944N40BLK & B Real Estate Holdings LLC · Huntley, MTS/N 18264088N40CKDcy Aviation Group LLC · Linton, INBuilt 1977 · S/N 17269264N40DVNordstrom Eric Trustee · Anchorage, AKBuilt 1982 · S/N U20606493N40ECHill Richard C · Buckeye, AZS/N 18256692N40ERFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17269569N40GVHauser Paul J · Longmont, COBuilt 1976 · S/N U20603438N40HFVogel Essex Nathaniel B · Berkeley, CAS/N 15072309N40LSFenhaus Jason · Billings, MTBuilt 1973 · S/N 18262242N40LTNilsson Winston · Merrill, ORBuilt 1953 · S/N 30527N40LYAsh Gary W · Houston, TXBuilt 1978 · S/N 17270900N40MTLudden Bradford R · Whitefish, MTS/N 32681N40MUOracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264170N40RBKmg Aviation Holdings LLC · Hartville, OHBuilt 1976 · S/N 177RG1071N40RGDovy Aviation LLC · Houston, TXBuilt 1974 · S/N 17263241N40SPSmith Terry G · Liberty Twp, OHBuilt 1980 · S/N 17274099N40TPDraco Flight School DBA · Chino, CABuilt 1981 · S/N 17274723N40WABergstedt Yvonne · Anchorage, AKBuilt 1956 · S/N 32588N40WLBentley Thomas F · Lockport, ILBuilt 1976 · S/N 15078056N40WNRider Rebecca L · Hyde Park, NYBuilt 1968 · S/N 17700829N40WTPritchett Thomas A · Covington, GABuilt 1953 · S/N 30324N4100VSanders Keith · Palm Bay, FLS/N 15076701N4101FHanson Kathleen A · Wasilla, AKS/N 46001N4102FAdams Samuel M · Anna, TXBuilt 1958 · S/N 46002N4102LWiplinger Robert D · Inver Grove Height, MNBuilt 1973 · S/N U20602093N4102UHartpence Damian K · Newcastle, OKS/N 15060102N4103A501st Flight Solutions LLC · Kaysville, UTBuilt 1966 · S/N 15063859N4103VMoore Israel · Pasco, WABuilt 1975 · S/N 15076702N4104FMcmahon William F · Westville, INS/N 46004
Back to AD 87-20-03 R2