OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N2727URoy Justin C · Georgetown, OHBuilt 1963 · S/N 17250327N2727VFitzgerald Kevin C · College Station, TXS/N 177RG0674N2728BBig Island Gravity LLC · Kapaau, HIBuilt 1959 · S/N 52028N2728CMeidl Jared · Crivitz, WIS/N 26272N2728JWahlberg · Pearland, TXBuilt 1974 · S/N A1500573N2728LPotter Mark H · Santa Rosa, CABuilt 1967 · S/N 17255928N2728UCatsakis Andrew W · Lovettsville, VABuilt 1963 · S/N 17250328N2728XUsda Forest Service Fepp · Trenton, NJBuilt 1965 · S/N 18051528N2729FSexton & Sanders Law Firm Pa · Fort Smith, ARBuilt 1965 · S/N 18256829N2729QCraft Phyllis C · Damascus, GABuilt 1967 · S/N 18257929N2729SDates Lauren C · Red Creek, NYBuilt 1967 · S/N 15066629N2729UDenair Inc · Canandaigua, NYBuilt 1963 · S/N 17250329N272BBearair II LLC · Libertyville, ILBuilt 1975 · S/N 18264193N272CGStrickland Luther J Jr · San Luis Obispo, CABuilt 1949 · S/N 7301N272DBBrock Dean R · Hawthorne, FLBuilt 1973 · S/N 17261821N272DKKroutil David W · Hilmar, CABuilt 1978 · S/N 17271857N272JAGold Coast Aviation LLC · Oxnard, CABuilt 1976 · S/N 17267439N272NSKroeber Thomas · Pawlet, VTBuilt 1980 · S/N 18267402N272RARomeo Alpha Flyers Inc · Nashville, TNBuilt 1974 · S/N 17263700N272RRGray Kerry · Monterey, CABuilt 1973 · S/N 17261914N272SCRobert Gardner Enterprises LLC · Mercer, MEBuilt 1977 · S/N 18052939N272TLSanders Flight Training Center · Jasper, ALS/N 17270719N272TNReed Perry L · Mooresville, NCBuilt 1977 · S/N 17268803N272VWigley Ben Jr · Huntington, ORBuilt 1956 · S/N 33362N272WCCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272677N2730EOew Aviation LLC · Sumter, SCBuilt 1978 · S/N 17271309N2730QSkylane Corp · Pittston, PABuilt 1967 · S/N 18257930N2730XSmith Daniel E · Anchorage, AKBuilt 1965 · S/N 18051530N2731DVoegeli Nathan · Sacramento, CAS/N 25273N2731JPatry Aeronautical Institute · Kalispell, MTBuilt 1974 · S/N A1500574N2731KYoung Aviation LLC · Oshkosh, WIBuilt 1979 · S/N 18053045N2731Q31q LLC · Boise, IDBuilt 1967 · S/N 18257931N2731UKemp Gilbert A · Waterville, NYBuilt 1963 · S/N 17250331N2732DYounger Cody M · Shedd, ORBuilt 1952 · S/N 25274N2732GPrince Benjamin D · Lincoln, MTS/N 52032N2732KDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1979 · S/N 18053046N2732LGlenndale LLC · Jackson, MOBuilt 1967 · S/N 17255932N2732UDavenport Jimmy J · Hayesville, NCS/N 17250332N27339Rice John G · Craig, AKBuilt 1970 · S/N 18052140N2733CYurechko Philip Jr · Jewett City, CTBuilt 1954 · S/N 26277N2733FMetzger William M · Boonville, INBuilt 1965 · S/N 18256833N2733GSkydive Ky LLC · Cecilia, KYS/N 52033N2733LHugelman Frank J III · Waynesville, MOBuilt 1967 · S/N 17255933N2733VOlson Kirk · Dickinson, NDBuilt 1975 · S/N 177RG0676N2734CRegistered aircraftS/N 26278N2734FWard Christopher C · Lufkin, TXBuilt 1965 · S/N 18256834N2734HGriebel Kyle L · Lafayette, COBuilt 1959 · S/N 52034N2734JHelbig Frederick E · Oakland, MDBuilt 1974 · S/N A1500576N2734Q1175 Bangtail Way LLC · Greycliff, MTBuilt 1967 · S/N 18257934N2734URegistered aircraftBuilt 1963 · S/N 17250334
Back to AD 87-20-03 R2