OpenAirDocs.org
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.

N6619ECutrubus C Nina DBA · Ogden, UTBuilt 1959 · S/N 56119N6619GKlenptner Lori Jo · Henderson, NVS/N 15072119N6619SFun Flight Training LLC · Bartow, FLS/N 15067419N6619THolmes Geoffrey B · Santa Cruz, CABuilt 1960 · S/N 15059019N6619XMartin Kevin · New Carlisle, OHBuilt 1960 · S/N 21057619N661DDHanisko Thomas F · Mount Shasta, CAS/N 15067508N661KFurrow Terry · Hinton, OKBuilt 1978 · S/N 177RG1311N661KBBaldeo Kessho I · Bay Shore, NYBuilt 1974 · S/N 21060292N661SFSierra Foxtrot Ltd · Glen Ellyn, ILBuilt 1979 · S/N 18267049N66202Biggerstaff Connie J · Stanford, MTBuilt 1977 · S/N 18052926N6620AAviation Services Of Tn Inc · Sparta, TNS/N 28720N6620DPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 17272907N6620EMccauley Billy R · Cliff, NMBuilt 1959 · S/N 56120N6620FHole In The Clouds Rentals LLC · Montgomery, ALBuilt 1966 · S/N 15063220N6620GN6620g LLC · Monticello, INBuilt 1970 · S/N 15072120N6620RWhite Richard C · Tracy, CABuilt 1979 · S/N 172RG0217N6620SFellegy James M · Mauston, WIBuilt 1967 · S/N 15067420N6620VHall Steven R · Cambridge, MABuilt 1980 · S/N 172RG0784N66213Global Adventures N66213 LLC · Hollywood, FLBuilt 1983 · S/N 17275980N66215Channel Islands Aviation Inc · Camarillo, CABuilt 1983 · S/N 17275982N6621AJc Investors Group LLC · Coral Springs, FLBuilt 1979 · S/N 21063559N6621DCosta Air Service LLC · Painted Post, NYBuilt 1979 · S/N 17272908N6621ERoy Henry M · Carson, CABuilt 1959 · S/N 56121N66221Anderson Michael · Newbury, MABuilt 1974 · S/N 15075929N66226St Cyr Shane · Plattsburgh, NYS/N 18052928N66229Biggs Craig C · Severna Park, MDBuilt 1974 · S/N 15075936N6622CMidnight Flight LLC · Wells, TXBuilt 1980 · S/N 21063936N6622DArq Aviation LLC · Wilmington, NCBuilt 1979 · S/N 17272909N6622GSky High Adventures LLC · Wilmington, DES/N 15072122N6622YSierrakilo LLC Trustee · Lewes, DES/N 21064464N66230East Hill Flying Club Inc · Ithaca, NYBuilt 1983 · S/N 17275985N66231Taylor Daniel L · Shakopee, MNBuilt 1974 · S/N 15075937N66237Agri-Systems Aviation LLC · Litchfield, MNBuilt 1977 · S/N 18052930N66238Boggs William · Gurnee, ILFirst renewal noticeBuilt 1974 · S/N 15075942N66239Star Air Group LLC · Anchorage, AKBuilt 1974 · S/N 15075943N6623APardo Lawrence A · Tucson, AZBuilt 1956 · S/N 28723N6623GMehling Robert C · Hardin, MTS/N 18801208N6623MBrodack Bruce A · Pipersville, PABuilt 1975 · S/N 18263784N6623SWilliams Nathan · Von Ormy, TXBuilt 1967 · S/N 15067423N6623TSchultz Matthew T · Britton, MIBuilt 1960 · S/N 15059023N6623ZMage Aircraft Leasing LLC · San Antonio, TXBuilt 1980 · S/N 172RG0240N66243Wainfan Barnaby S · Independence, ORBuilt 1974 · S/N 15075947N66244Gray Robert B · Amherst, MABuilt 1974 · S/N 15075948N66245Rio Concho Aviation Inc · Aledo, TXBuilt 1974 · S/N 15075949N66247Nunley Joe · Holt, FLS/N 15075951N66248Jeffery Anne Kuba · Godley, TXBuilt 1975 · S/N 15075952N66249Erickson Keith E · Anchorage, AKS/N 15075953N6624EKunzmann Robert · Prescott, AZS/N 56124N6624FJackson Jeffrey G · Kingsport, TNBuilt 1966 · S/N 15063224N6624GBob Hoover Academy · Salinas, CABuilt 1979 · S/N 17273611
Back to AD 87-20-03 R2