AD 87-20-03 R2

Registered aircraft · 54,015

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.

N8942BBishops Sky Cam LLC · Jonesburg, MOBuilt 1958 · S/N 36642N8942GSale Reported · Stevensville, MTSale reported, canceledBuilt 1970 · S/N 18260482N8942TMonger Curtis V · Bend, ORS/N 52842N8942VPilots Flying School LLC · Englishtown, NJS/N 17264299N8942XBlb Group LLC · Lake Havasu City, AZBuilt 1961 · S/N 18253342N89430Flabob Airport LLC · Jurupa Valley, CAS/N 15282741N89433Chapel Hill Flying Club Inc · Sanford, NCBuilt 1978 · S/N 15282743N89438Sun Aircraft Management LLC · Ormond Beach, FLBuilt 1978 · S/N 15282747N8943BHarris David B III · Parlier, CAS/N 36643N8943GTruyaert Ivan R Jr · New Carlisle, INBuilt 1970 · S/N 18260483N8943VZiegler Aviation LLC · Minneapolis, MNBuilt 1974 · S/N 17264300N8944GSagra Nw LLC · Ronan, MTBuilt 1970 · S/N 18260484N89456Czyzewski Justin · East Brunswick, NJBuilt 1978 · S/N 15282755N8945TLumpkin Ed · Rosie, ARS/N 52845N8945XHarty Arthur · Acampo, CABuilt 1961 · S/N 18253345N89464Freeway Airport Inc · Mitchellville, MDBuilt 1983 · S/N 17276006N89469Hershberger David A · Unionville, INBuilt 1978 · S/N 15282759N8946BLumberjack LLC · Flagstaff, AZBuilt 1958 · S/N 36646N8946VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264302N8946XKennedy Dennis R Trustee · Westlake Village, CABuilt 1961 · S/N 18253346N8947BKaczmarek Richard G · Sandersville, GAS/N 36647N8947SMatyas Aviation Inc · Sugarloaf, PABuilt 1965 · S/N 15062247N8947VMills Alan F · Chatom, ALBuilt 1974 · S/N 17264303N8947XN8947x LLC · Middletown, DEBuilt 1961 · S/N 18253347N8948GWilbur-Ellis Co · Salinas, CABuilt 1970 · S/N 18260488N8948VPlain Company Ltd · Bloomfield Hills, MIBuilt 1974 · S/N 17264304N8948XRhodes Steven D · Anchorage, AKBuilt 1961 · S/N 18253348N8949GChuckanut Flying Club Inc · Bellingham, WABuilt 1970 · S/N 18260489N894AHAerospace Asset Holdings LLC · Wilmington, DEBuilt 1977 · S/N U20604061N89503Menne Aviation LLC · Brooklyn Park, MNBuilt 1983 · S/N 17276007N8950BPeppers Denise S · Centre, ALBuilt 1958 · S/N 36650N8950TGribi Daniel M · Miranda, CAS/N 52850N8950XAnderson Craig M · Barron, WIBuilt 1961 · S/N 18253350N8951GThrash Helen · Pelahatchie, MSS/N 18260491N8952TNorthwest Exteriors Inc · Rancho Cordova, CABuilt 1960 · S/N 52852N89531Glynco Manning Aviation Inc · Brunswick, GABuilt 1978 · S/N 15282771N89533Ashby Shawn Alan · San Luis Obispo, CABuilt 1978 · S/N 15282773N89539Jkg LLC · Murfreesboro, TNBuilt 1978 · S/N 15282775N8953GAirfleet Solutions LLC · Newark, DEBuilt 1970 · S/N 18260493N8953TDouglass Jason E · Friday Harbor, WABuilt 1959 · S/N 47158N8953XHenning Jeffrey Carl · Prescott, AZBuilt 1961 · S/N 18253353N89549Jodkin Jason J · Confluence, PAFirst renewal noticeBuilt 1978 · S/N 15282781N8954URausch John H · Fairport, NYBuilt 1976 · S/N 15078026N8954XGansz Kenneth L · Clare, IABuilt 1961 · S/N 18253354N8955SHewett Donnie · Little River, SCS/N 15062255N8955XPampa Office Supply · Elk City, OKBuilt 1961 · S/N 18253355N8956TBrown Donald L · Peoria, AZS/N 52856N8956XLove Brandon · Big Sandy, TXS/N 18253356N8957BScott Larry R · Hobbs, NMS/N 36657N8957SMiller Andy · Marana, AZBuilt 1965 · S/N 15062257
Back to AD 87-20-03 R2