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.

N9623VSchreder Peter T · Joseph, ORS/N 17264403N9624EA & I Aviator Investments LLC · La Habra, CABuilt 1984 · S/N 18268432N9625QMars Aerospace Inc · Bay Shore, NYBuilt 1975 · S/N 17265709N9625VFlight Time Builders Inc · Memphis, TNBuilt 1974 · S/N 17264405N9626BAirgo Inc · Centralia, ILBuilt 1981 · S/N 172RG0927N9626GFly 2 Crp LLC · Cleveland, TXBuilt 1972 · S/N U20601826N9626HRenfro Jacqueline L · Bethel, AKBuilt 1975 · S/N 17266274N9626QChambers Matthew A · Tehachapi, CABuilt 1975 · S/N 17265710N9626XPortman Joe · Elmendorf, TXBuilt 1962 · S/N 21057926N9627HSuperbuyer Inc · San Jose, CABuilt 1975 · S/N 17266275N9627XW J Bolton Farms LLC · Marked Tree, ARBuilt 1962 · S/N 21057927N9628BBryan Kirk J · Big Timber, MTBuilt 1957 · S/N 32925N9628GNicols Bruce D · Titusville, PABuilt 1974 · S/N 18263410N9628HT3 Aerosports LLC · Vian, OKBuilt 1975 · S/N 17266276N96299Djm Aviation LLC · Rhome, TXS/N 17276054N9629BVisser Ag Inc · Rigby, IDBuilt 1957 · S/N 32926N9629GSchmitt Rudy · Brookshire, TXBuilt 1974 · S/N 18801570N9629TBramlett Russell · Winder, GABuilt 1960 · S/N 57429N962AFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N 177RG0464N962AMInternational Air Services Inc · Carson City, NVBuilt 1976 · S/N 177RG1054N962RGBoucher John C · Lakeside, AZBuilt 1967 · S/N U206-0957N962SHObermeier Scott D · Manchester, CTBuilt 1961 · S/N 17248864N9630QKelley Aircraft LLC · Weyers Cave, VABuilt 1975 · S/N 17265714N9630TBridgford Bruce H · Anaheim, CABuilt 1960 · S/N 57430N9630VN275508 LLC · Margate, FLBuilt 1974 · S/N 17264410N9630XSea-S-Ta Aviation LLC · Alexandria, VABuilt 1986 · S/N 18268568N9631BPercy Flyers LLC · Dexter, MIBuilt 1981 · S/N 172RG0930N9631QHuntsman Ferral Don · Juneau, AKBuilt 1975 · S/N 17265715N9631VHarrold Bruce E · Greybull, WYBuilt 1974 · S/N 17264411N9632BDbstd LLC · Nickerson, NEBuilt 1957 · S/N 32929N9632HSweitz-Air Inc · Stewartstown, PAS/N 17266279N9632ZAngelone Inc · Elkhart, INS/N U20606585N9633HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266280N9633XCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 18268570N9634QDubois County Flight Services Inc · Huntingburg, INBuilt 1975 · S/N 17265718N9634XScoggin Gerald William III · Port Saint Lucie, FLBuilt 1962 · S/N 21057934N9635BFisher Frank L · San Diego, CABuilt 1981 · S/N 172RG0933N9635CAirmans Aviation Co Ltd · Fort Smith, ARBuilt 1983 · S/N T30300196N9635HArizona Aircraft Leasing LLC · Mesa, AZBuilt 1975 · S/N 17266282N9635LAcme Club Training Inc · Anchorage, AKBuilt 1986 · S/N 17276592N9635QRozynski Jason K · Malabar, FLBuilt 1975 · S/N 17265719N9635V35 Victor LLC · Decatur, GABuilt 1974 · S/N 17264415N9636HMontanez Orlando · Guaynabo, PRBuilt 1975 · S/N 17266283N9636VNaperville Flying Club · Woodridge, ILBuilt 1974 · S/N 17264416N9636YCarranza Chris J · Stanfield, AZBuilt 1981 · S/N 21064566N9637QWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17265721N9637VAllen Linda M · Amarillo, TXBuilt 1977 · S/N R1722339N9637XCypress Peak LLC · Pickens, MSBuilt 1962 · S/N 21057937N9638HHatbright Farm LLC · Wilmington, DEBuilt 1975 · S/N 17266285N9638QPeterson John E · Benton, KSBuilt 1975 · S/N 17265722
Back to AD 87-20-03 R2