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.

N9835GPiedmont Flight Inc · Winston Salem, NCBuilt 1971 · S/N 17259735N9835JCrooks Curtis L · Truckee, CABuilt 1975 · S/N A1500644N9835TVfr Ltd · Wilmington, DEBuilt 1960 · S/N 47635N9836AMabry Dale C · San Antonio, TXBuilt 1950 · S/N 7529N9836BSoulek Paul A · Spearfish, SDBuilt 1982 · S/N 172RG1051N9836CDominguez Robert R · Temecula, CABuilt 1978 · S/N R18200456N9836GSchafhausen Mark G · Spokane, WABuilt 1971 · S/N 17259736N9836HDouglas County Land Title Co · Douglasville, GABuilt 1981 · S/N 18268057N9837GSouther Field Aviation Inc · Americus, GAFirst renewal noticeBuilt 1974 · S/N 18801613TN9837HChristmas Aviation LLC · Pace, FLBuilt 1981 · S/N 18268058N9837LIal Corp · Wilmington, DEBuilt 1986 · S/N 17276629N9837TSmith Robert M III · Taft, CABuilt 1960 · S/N 47637N98381Central Air Parts Inc · Staunton, ILBuilt 1985 · S/N 17276284N9838BJacks Charles D · Morse, LABuilt 1982 · S/N 172RG1052N9838CWellman A Ryan · San Jose, CABuilt 1978 · S/N R18200458N9838GMcdonald James E · Harleyville, SCS/N 17259738N9838HBaeder Mark A · Mesa, AZBuilt 1981 · S/N 18268059N9838VWaypoint Equipment LLC · Mckinney, TXBuilt 1974 · S/N 17264524N98395Dury Aviation Services Inc · De Soto, ILBuilt 1985 · S/N 17276285N9839GLong William F · Belton, TXBuilt 1979 · S/N 17273638N9839JDarling Dudley W · Northborough, MABuilt 1975 · S/N A1500648N983AWGuthrie Robert Paul · Joiner, ARBuilt 1963 · S/N 18254914N983VBKaufman Jeffrey Robert · Chapel Hill, NCBuilt 1978 · S/N R18200202N98407Choice Aviation LLC · Hamilton, MTBuilt 1985 · S/N 17276287N9840ABrentco Aerial Patrol Inc · Canton, OHBuilt 1984 · S/N 18268409N9840CMid Atlantic Ag LLC · Nassau, DEBuilt 1978 · S/N R18200460N9840ELjmf17 LLC · Hayes, KSBuilt 1975 · S/N 18263926N9840JBean James P · Tulsa, OKBuilt 1975 · S/N A1500649N98410Mbk Leasing And Consulting LLC · Lakeland, FLBuilt 1984 · S/N 17276288N9841GYoxall Jennifer S · Guilford, CTBuilt 1971 · S/N 17259741N9841HItd Services LLC · Clarendon, TXS/N 18268062N9841LHalsmer Ann Lucille · Lafayette, INBuilt 1986 · S/N 17276632N9841YBaker Joseph M Trustee · Overland Park, KSBuilt 1981 · S/N 21064615N98424Pfister Thomas K · Minneapolis, MNBuilt 1985 · S/N 17276289N98426Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276290N98428T&W Aviation LLC · Pinehurst, TXBuilt 1984 · S/N 17276291N9842CSale Reported · Belgrade, MTSale reportedBuilt 1978 · S/N R18200462N9842ESopko Michael C · Bonita, CABuilt 1975 · S/N 17702328N9842GNighthawk N8231g LLC · Pompano Beach, FLBuilt 1971 · S/N 17259742N9842HStewart John D · Slatington, PABuilt 1981 · S/N 18268063N9843HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N 18268064N9843TPrzygoda Raymond C · Pinckneyville, ILBuilt 1960 · S/N 47643N9843VAnderson Erik H · Trinity Center, CABuilt 1974 · S/N 17264527N9843XTidwell Gregery D · Modesto, CAS/N 17255656N9843YCavu Solutions LLC · Renton, WABuilt 1981 · S/N 21064616N9844BRegistration Pending · Mount Pleasant, UTRegistration pendingBuilt 1982 · S/N 172RG1054N9844EKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1985 · S/N 18268453N9844VKorte Daniel J · Marlette, MIBuilt 1974 · S/N 17264528N98456Civil Air Patrol Inc · Maxwell Afb, ALS/N 17276293N9845HAaa Sales LLC · Apple Valley, MNBuilt 1981 · S/N 18268065
Back to AD 87-20-03 R2