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.

N5054XBlackmon Tommy J · Abilene, TXS/N 18393N50550Registered aircraftS/N 15069391N50551Barreto Daniel · Enterprise, ALBuilt 1968 · S/N 15069392N50555Whalen John · West Ossipee, NHBuilt 1968 · S/N 15069396N5055AN5055a LLC · Clayton, GABuilt 1955 · S/N 28055N5055DBurns Greg K · Pataskala, OHBuilt 1958 · S/N 51155N5055HShaka Skies LLC · Kihei, HIBuilt 1975 · S/N 17265321N5055RGreat Lakes Air Ventures LLC · Mason, MIBuilt 1974 · S/N 17263295N5056EHill Kelly · Bagdad, AZBuilt 1958 · S/N 50356N50574Pope Gregory S · Jacksonville, ILBuilt 1968 · S/N 15069405N50577Diaz Ernesto · Oxnard, CABuilt 1968 · S/N 15069408N50578Mccann Michael H · Springfield, ORBuilt 1968 · S/N 15069409N5057ASoar Above Flight Solutions LLC · Englewood, TNBuilt 1955 · S/N 28057N5057DLatham Travis W · Round Rock, TXBuilt 1958 · S/N 51157N5057HAjf Enterprises LLC · Des Moines, IABuilt 1975 · S/N 17265322N5057RHeise Roger H · Clayton, NYBuilt 1974 · S/N 17263296N50580Freeman Jeffrey E · Iron Mountain, MIBuilt 1968 · S/N 15069411N50581Pritchett Otis R · Avery, TXS/N 15069412N50583Registration Pending · Bentonville, ARRegistration pendingBuilt 1968 · S/N 15069414N5058ABeiter John A · Cle Elum, WABuilt 1955 · S/N 28058N5058USkyler Aviation Inc · San Diego, CABuilt 1963 · S/N 206-0058N50590Usaeroflight LLC · Greenville, SCBuilt 1974 · S/N 17264212N50596Phillips John H · Vernal, UTBuilt 1968 · S/N 15069423N5059ASmith Rickey A · Divernon, ILS/N 28059N5059DJk Aviations LLC · Yardley, PABuilt 1958 · S/N 51159N505ABFredrickson Kenneth · Port Angeles, WABuilt 1974 · S/N 18263391N505CACarver David N · Sanger, CABuilt 1975 · S/N 15076821N505FNovotny Paul A · Elk River, MNBuilt 1964 · S/N 17251911N505JJAero Davis LLC · Camden, DEBuilt 1958 · S/N 46086N505JRParker Matthew · Cloudcroft, NMS/N 18253919N505LMKennicott Wilderness Air LLC · Glennallen, AKS/N 31267N505PDSargent Evan · Camas, WABuilt 1971 · S/N 18260611N505SWBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 21061185N505WAAtlanta Technical College · Atlanta, GABuilt 1976 · S/N 15077942N50606Siderwicz Christopher J · Marstons Mills, MABuilt 1968 · S/N 15069429N5060RBristow Brent L · Anchorage, AKFirst renewal noticeBuilt 1976 · S/N 18502992N50610Henry Mark Alan · Dickinson, TXS/N 15069431N50614Walker William G Jr · Scottsdale, AZBuilt 1968 · S/N 15069434N50617Adventist World Aviation · Wilson, NCS/N 15069436N50618Clark Christopher W · Fallon, NVBuilt 1968 · S/N 15069437N5061ASmith Aviation LLC · Springer, OKS/N 28061N50621Slade Michael · Lakeville, MABuilt 1968 · S/N 15069439N50624Davis Clint A · Fairland, INBuilt 1968 · S/N 15069442N50628Padgett Justin S · Fruithurst, ALBuilt 1968 · S/N 15069445N50629Boshart Stanley J · Albany, ORBuilt 1968 · S/N 15069446N5062RRichland County Finance Department · Columbia, SCBuilt 1974 · S/N 17263300N5062UEnglish Ryan E · Henderson, NVBuilt 1964 · S/N 206-0062N50633Sherwood Ronald R · Kathleen, GABuilt 1968 · S/N 15069449N5063EAdams James R · Prescott, AZS/N 50363N5063HParsons William L · Harrogate, TNBuilt 1975 · S/N 17265324
Back to AD 87-20-03 R2