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.

N2457DSpindler Michael A · Fairbanks, AKBuilt 1952 · S/N 20609N2457ERegistered aircraftBuilt 1982 · S/N 18268205N2457FPettyjohn Nancy Paulette Sautebien · Dearborn, MIBuilt 1973 · S/N A1500402N2457RPicotte Paul C · Fallon, NVBuilt 1964 · S/N 18255557N2457SAviation Specialty Services LLC · Beaufort, NCBuilt 1967 · S/N 337-0757N2457UBurr Ronald E · Anchorage, AKBuilt 1974 · S/N U20602378N2457YGhost Rider Aviation LLC · Yuma, AZS/N 17249757N2458CGant Dallas C Jr · Wickenburg, AZBuilt 1954 · S/N 30758N2458DKasica Stanley J · New Britain, CTBuilt 1952 · S/N 20610N2458FErickson Timothy M · Mead, NEBuilt 1973 · S/N A1500403N2458LBowman Joseph F · Flora, MSBuilt 1966 · S/N 17255658N2458UEversoll Dennis D · Petersburg, INBuilt 1963 · S/N 17250058N2458XMountain City Flying Club Inc · Hazle Township, PABuilt 1965 · S/N 18256358N2458YArdmore Aviation LLC · Novelty, OHBuilt 1962 · S/N 17249758N2459CAkchak Air LLC · Leeds, UTS/N 30759N2459DShaw Brian W · Bemidji, MNS/N 20611N2459LMedia Stew LLC · Carson City, NVBuilt 1966 · S/N 17255659N2459RGardiner Timothy M · Gardendale, ALBuilt 1964 · S/N 18255559N2459UHaynes Harrison F · Gainesville, GABuilt 1963 · S/N 17250059N245FRChupito Sabrocito LLC · Paso Robles, CABuilt 1977 · S/N 17269686N2460FRead Colin L · Plattsburgh, NYBuilt 1966 · S/N 18051662N2460JSmith Harry N · Glendale, AZBuilt 1966 · S/N 15065560N2460XHardy Gareld L · Rimrock, AZS/N 18256360N2461GSeven Hi Flying Club · Saratoga, CABuilt 1959 · S/N 51761N2461JWeidemann Wendell S · Madison, WIBuilt 1966 · S/N 15065561N2461RFx Mining LLC · Haines, AKBuilt 1964 · S/N 18255561N2461UHansen Aviation LLC · Savannah, GABuilt 1963 · S/N 17250061N2461XBallard Devin J · Quail, TXBuilt 1965 · S/N 18256361N2461YIbx Living LLC · Wake Forest, NCBuilt 1962 · S/N 17249761N2462EFive Six Zero One LLC · Orange, CABuilt 1978 · S/N 17271291N2462JBercaw Vaughn L · Beach City, TXBuilt 1966 · S/N 15065562N2462LSneed Associates LLC · Fort Morgan, COBuilt 1966 · S/N 17255662N2462SLyon Joseph K · Mccall, IDBuilt 1967 · S/N 337-0762N2462UBixler Timothy · Wildwood, FLS/N 17250062N2463CWofford Johnny A · Fort Davis, TXBuilt 1963 · S/N 17250569N2463JTony Noyes · Lewisville, TXS/N 15065563N2463ULively Matt E · Aledo, TXBuilt 1963 · S/N 17250063N2463YCaylin LLC · Wilmington, DEBuilt 1962 · S/N 17249763N2464RStoffers William · Samoa, CABuilt 1964 · S/N 18255564N2464UFly By Faith LLC · Laurel Springs, NCBuilt 1963 · S/N 17250064N2464YHogan Dale R · Monterey, CABuilt 1962 · S/N 17249764N2465CToal Timothy R · Milan, ILBuilt 1954 · S/N 30765N2465ELeal Felipe · Missouri City, TXBuilt 1978 · S/N 17271292N2465GMunson Darrel L · Ogallala, NEBuilt 1959 · S/N 51765N2465JWalther Nora P · Ocala, FLBuilt 1966 · S/N 15065565N2465XK4 Land And Grain Co · Lothair, MTBuilt 1965 · S/N 18256365N2466EMarkham Dean F Jr · Greenville, NCBuilt 1978 · S/N 17271293N2466QWentworth Douglas G · Simpsonville, KYBuilt 1966 · S/N 18257666N2466RToland Beldon T · Dodge City, KSBuilt 1964 · S/N 18255566N2466UHolloway Andrew · David City, NEBuilt 1963 · S/N 17250066
Back to AD 87-20-03 R2