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.

N5920RAmerican Eagle Aviation LLC · Flushing, MIBuilt 1965 · S/N 17253589N5920TLowe David M · Sacramento, KYBuilt 1964 · S/N 15060620N59210Safe Pilots Group LLC · Nyack, NYBuilt 1973 · S/N 21060161N5921EPeterson Dennis L · Daleville, ALS/N 18268338N5922AArmiger Scott L · Holly Springs, NCBuilt 1956 · S/N 28522N5922BLitton John C · Quartz Hill, CABuilt 1956 · S/N 33922N5922EAerial Scouting Solutions LLC · Sioux Center, IABuilt 1978 · S/N 17271963N5922JMerlin Iron Works LLC · Westwood, KSBuilt 1975 · S/N 18263577N5922THamilton David A · Piedmont, OHS/N 15060622N59237Boland Matthew S · Anchorage, AKBuilt 1974 · S/N U20602637N5923ARowlett Glen R · Brookshire, TXBuilt 1956 · S/N 28523N5923BWilson Phillip K · Waukesha, WIBuilt 1956 · S/N 33923N59240Banegas Jose Carlos Zankiz · Flint, TXBuilt 1974 · S/N 21060174N5924BZarinnia Anthony · Chelsea, MIBuilt 1956 · S/N 33924N5924GParsons Roderick L · Ripley, WVBuilt 1969 · S/N 15071424N59258Energy Roofing Technology Se LLC · Lake City, FLS/N 21060180N5925TGrizzle Kenneth A · Jerseyville, ILBuilt 1964 · S/N 15060625N5926GMirandan5926g LLC · Napanoch, NYBuilt 1969 · S/N 15071426N5926JVintage Aviation LLC · Billings, MTBuilt 1975 · S/N 18263581N5926TPalyash Neil J · Wichita, KSBuilt 1964 · S/N 15060626N5927ASamaritans Purse · Boone, NCS/N 28527N5927BEmerson Christopher D · Mount Pleasant, ARS/N 33927N5927RRodrigues Robert R · Cordova, AKS/N 17253596N59286Staley Ronald L · Lebanon, ORBuilt 1974 · S/N U20602643N5928AToribio LLC · San Antonio, TXBuilt 1956 · S/N 28528N5928BSteinhausen Darrell · Torrington, WYBuilt 1956 · S/N 33928N5928EGace Flying Club Inc · Ronkonkoma, NYBuilt 1978 · S/N 17271964N5928FKerr Daniel · Bakersfield, CABuilt 1967 · S/N 21058928N5928JParsons Royson A · Atascadero, CABuilt 1971 · S/N A1500228N59292Cloud Busters LLC · Goodrich, MIBuilt 1974 · S/N 21060196N59294Cornucopia Investment Group LLC · South Jordan, UTBuilt 1974 · S/N U20602645N59299Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 21060199N5929BRegistered aircraftBuilt 1956 · S/N 33929N592HPAeroquest LLC · Olive Branch, MSBuilt 1973 · S/N 15075451N592KBCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601770N592PCFlanagan Geri M · Bandon, ORS/N 15076027N5930AUthe Wendy G · Wellsville, MOBuilt 1956 · S/N 28530N5930FCable Strong Aircraft Holdings LLC · Tyler, TXS/N 21058930N5930RDownwind Corp · Brush Prairie, WAS/N 17253599N5931GOconnor Mary B · Anchorage, AKBuilt 1969 · S/N 15071431N5931TFreitas Durval S · Tulare, CABuilt 1964 · S/N 15060631N59327Smith Steve W · Mackay, IDBuilt 1966 · S/N 337-0373N5932AAquila Aviation LLC · Pompano Beach, FLBuilt 1956 · S/N 28532N5932BAbsolute Altitude LLC · Buena Vista, COBuilt 1956 · S/N 33932N5932GBergen Henry E · Fond Du Lac, WIS/N 15071432N5932JOwen Stephen M · Wiggins, MSBuilt 1975 · S/N 18263583N5932TSmith Jason M · Holland, PABuilt 1964 · S/N 15060632N5933AWicklander Richard O · Spanaway, WABuilt 1956 · S/N 28533N5933BManier Byron K · Houston, MOBuilt 1956 · S/N 33933N5934AJenkins Brian T · Batesville, INBuilt 1956 · S/N 28534
Back to AD 87-20-03 R2