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.

N4609QN4609q LLC · Opa-Locka, FLBuilt 1973 · S/N 17261724N4609SN4609s LLC · Verona, WIBuilt 1979 · S/N R18201355N4609UJerden Corp · Overland Park, KSBuilt 1979 · S/N U20605000N460AHensley Scott · Elbert, COS/N 7553N460CBScott Ts Ag-Flyin Inc · Colquitt, GABuilt 1966 · S/N P206-0206N460CCAmerican Falconry Inc · Dayton, WYBuilt 1966 · S/N 185-0993N460GPage Robert · Santaquin, UTBuilt 1964 · S/N 17251567N460RWicklund Gerald G · Liberty, MOS/N 18267786N460WPoling Barry · Texline, TXBuilt 1965 · S/N 18256773N46100Aerflow Inc · Jersey City, NJBuilt 1968 · S/N 17257041N46101Patel Aman · Wesley Chapel, FLBuilt 1968 · S/N 17257042N46107Trieber Steven M · Eastport, MEBuilt 1968 · S/N 17257046N46109Pray Aviation Inc · Augusta, KSBuilt 1968 · S/N 17257047N4610AHorn Paul · Kodiak, AKBuilt 1955 · S/N 32208N4610BHuber Gregory A · Medina, OHBuilt 1955 · S/N 31508N4610CShepard Brandon H · Tyler, TXBuilt 1953 · S/N 25554N4610KAvag Inc · Richvale, CABuilt 1979 · S/N P21000235N4610LIson Ronald B · New Braunfels, TXBuilt 1966 · S/N 17254605N4610QBlaire William C · Rch Palos Vrd, CABuilt 1973 · S/N 17261725N46115Capri Aircraft LLC · Madison, VABuilt 1968 · S/N 17257049N46118Epiphany Software Co · Wilmington, NCBuilt 1968 · S/N 17257051N46119Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257052N4611EFife Jeffrey Ryan · Seminole, FLS/N 18503813N4611FRandall Jason · Woodstock, ILBuilt 1966 · S/N P206-0211N4611LNutsch.Com LLC · Independence, ORBuilt 1966 · S/N 17254606N46122Martin Gregory C Jr · Homer, AKFirst renewal noticeBuilt 1968 · S/N 17257054N46125East Carolina Aviation LLC · Camden, NCBuilt 1968 · S/N 17257056N46126Knight Kenneth D · Stoneville, NCBuilt 1968 · S/N 17257057N46128Meridian Aircraft Leasing LLC · Anniston, ALBuilt 1968 · S/N 17257059N4612BBenson Ian M · Portland, ORBuilt 1955 · S/N 31510N4612DPrecision Flight Training Inc · Newberg, ORBuilt 1979 · S/N 17272315N4612KChitiea Andrew D · Centennial, COBuilt 1979 · S/N P21000236N4612LGrayson Clayton C · Hillsboro, TXBuilt 1966 · S/N 17254607N4612UBauman Raymond S · Douglas, WYS/N 18051312N46130Waltzer Eric · Riverside, CABuilt 1968 · S/N 17257061N46132N46132 Leasing LLC · Kalispell, MTBuilt 1968 · S/N 17257063N46133Baham Daniel R · Eunice, LAS/N 17257064N46134Training Planes LLC · Tampa, FLBuilt 1978 · S/N 15283003N46135Mc Masters James I · Springfield, VABuilt 1978 · S/N 15283004N46138Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15283005N4613BSutter Richard J · Kooskia, IDBuilt 1955 · S/N 31511N4613LMcalpin Timothy P · Phoenix, AZBuilt 1966 · S/N 17254608N4613QSouth Seattle College · Seattle, WABuilt 1973 · S/N 17261727N46143Stromme Shawn · Hazen, NDBuilt 1968 · S/N 17257070N46144Bhm Corp · Claverack, NYBuilt 1968 · S/N 17257071N46146Skylink Xpress Inc · San Bernardino, CABuilt 1978 · S/N 15283007N4614BUniversity Of Michigan Flyers · Ann Arbor, MIBuilt 1979 · S/N 15283552N4614CLinfield William K · South Lyon, MIBuilt 1953 · S/N 25558N4614LDowell Roy · Burns, ORS/N 17254609N4614RAltair Aircraft LLC · Gainesville, FLBuilt 1979 · S/N 172RG0004
Back to AD 87-20-03 R2