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.

N988BGMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265795N988CMAvc150 LLC · Carson City, NVBuilt 1973 · S/N P3370008N988MTurecek Peter J · Fairfield, CTS/N R18201357N988MVMiller James A · Granada Hills, CABuilt 1967 · S/N T210-0284N988PSStartz Paul D · Douglasville, GABuilt 1956 · S/N 33749N988PWChristiansen Bruce L · Windham, MEBuilt 1978 · S/N R1722948N9890ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 18268465N9890HDe Rico Nicolas · Tracy, CABuilt 1981 · S/N 18268094N9890JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1976 · S/N A1500699N9890MR & R Brown Inc · Sun Valley, IDBuilt 1977 · S/N 21062085N9890XSelman Jett · Anchorage, AKBuilt 1961 · S/N 1850090N9890YValiair Lc Trustee · Casper, WYS/N 21064630N98913Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276378N9891GOuellette Kevin E · Frederick, OKBuilt 1971 · S/N 17259791N9891TDunkley Bret Y · Kotzebue, AKS/N 47691N98923Costa Flying Service Inc · Painted Post, NYBuilt 1985 · S/N 17276381N9892AMiner Jay G · Seattle, WABuilt 1950 · S/N 7595N9892GFritz John P · Belvidere, NJBuilt 1971 · S/N 17259792N9892MBogner Aviation LLC · Dover, DEBuilt 1976 · S/N 18264789N9892QLytle Jack J · Omaha, NEBuilt 1975 · S/N 17265836N9893HBain Aviation Inc · Weiser, IDBuilt 1981 · S/N 18268095N9893QDougherty Casey · Rock Island, WABuilt 1975 · S/N 17265837N9894AHealdsburg Aviation · Healdsburg, CABuilt 1950 · S/N 7597N9894EDebski Matthew B · Belmont, CABuilt 1975 · S/N 18263955N9894G1s6 Flying Club Inc · Sandpoint, IDS/N 17259794N9894JKosko Stanley G · Seattle, WABuilt 1976 · S/N A1500703N9894QKarpov Konstantin A Trustee · Fort Bragg, CABuilt 1975 · S/N 17265838N9894YRaymond Andy · Council Bluffs, IABuilt 1981 · S/N 21064632N98954Emerson Solutions LLC · Bellingham, WABuilt 1985 · S/N 17276384N9895ETurnkey Aviation LLC · North Las Vegas, NVBuilt 1985 · S/N 18268467N9895GKellerman Roger B · Rockford, ILBuilt 1971 · S/N 17259795N9895QCk Leasing Services LLC · Wilmington, DEBuilt 1975 · S/N 17265839N9895VTogo Aviation Services LLC · Palmer, AKBuilt 1974 · S/N 17264550N98960Buiqui Aerospace Corp · Kissimmee, FLBuilt 1985 · S/N 17276387N9896HHilltop Aviation LLC · Rowlesburg, WVBuilt 1981 · S/N 18268097N9896JVande Berg David M · Sioux Center, IABuilt 1976 · S/N A1500705N9896XKing Kevin J · Angle Inlet, MNBuilt 1961 · S/N 1850096N9897AAero Garage Inc · Fort Myers, FLBuilt 1950 · S/N 7602N9897MAcme Aviation USA LLC · Nashville, TNBuilt 1976 · S/N 18264794N9897QAbove All Aviation Inc · Santa Barbara, CABuilt 1975 · S/N 17265841N98981Airplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 17276390N98987Civil Air Patrol Inc · Maxwell Afb, ALS/N 17276391N9898ELamar Rosa E · Santa Paula, CAS/N 18263958N9898QSecond Wind Aviation Corp · Friday Harbor, WABuilt 1975 · S/N 17265842N9898THumphress John A III · Campbellsville, KYS/N 47698N9899GWings Over Texas LLC · Denton, TXBuilt 1971 · S/N 17259799N9899HCrimson Aircraft Sales LLC · Tuscumbia, ALBuilt 1981 · S/N 18268098N9899QBrown Richard K · East Falmouth, MABuilt 1975 · S/N 17265843N989CWCardinal Wings Aviation LLC · Buckner, KYBuilt 1976 · S/N 17266884N989SDFlyby Equipment LLC · Factoryville, PABuilt 1957 · S/N 34207
Back to AD 87-20-03 R2