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.

N9370GCorredoira Carlos A · Mcallen, TXBuilt 1971 · S/N 18260910N9370XRnb Aviation LLC · Montgomery, TXBuilt 1985 · S/N 18268504N9371ACosper Rodney S · Killeen, TXS/N 7450N9371XAdventure Aircraft And Equipment LLC · Chelan, WABuilt 1962 · S/N 18253771N9372BTomlin Trevor C · Huber Height, OHBuilt 1958 · S/N 55172N9372GAcosta Gregory P · Mandeville, LABuilt 1971 · S/N 18260912N9372HN9372h LLC · Wilmington, DEBuilt 1975 · S/N 17266123N9372XSleeping Giant Flying Club Inc · Helena, MTBuilt 1962 · S/N 18253772N93730Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1982 · S/N 15285543N9373AAlis Russell D · Fairbanks, AKBuilt 1949 · S/N 7452N9373TAf&S LLC · Anchorage, AKBuilt 1960 · S/N 50873N9374GPreston Jonathan · Murrieta, CABuilt 1971 · S/N 18260914N9374HBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N 18267939N9374UWest Harold · Ozark, ALBuilt 1976 · S/N 15078323N9375AGillam Donald E · Lafayette, LABuilt 1949 · S/N 7454N9375BVinland Aerodrome Inc · Baldwin City, KSBuilt 1958 · S/N 55175N9375XRubber Chicken Airlines LLC · Kalispell, MTS/N 18253775N93769Sourdough Air Service Inc · Fairbanks, AKBuilt 1977 · S/N 18503241N9376CNicholas Adam Ferraro · Benson, AZBuilt 1955 · S/N 31774N9376MBeans James B IV · Camas Valley, ORBuilt 1972 · S/N 17260576N93777Arbach Enterprises Inc · Watertown, SDBuilt 1977 · S/N 18503243N9377AHawkins Bobby J · Greybull, WYBuilt 1949 · S/N 7456N9377BShanholtzer Shawn T · Palisade, MNBuilt 1958 · S/N 55177N9377HAir Advantage Inc · Mount Pleasant, IABuilt 1975 · S/N 17266126N9377UDepue Amanda N · Wasilla, AKBuilt 1976 · S/N 15078326N9378BKiser Courtney A · Woodbury, TNBuilt 1958 · S/N 55178N9378DAndden Aviation LLC · Santa Monica, CABuilt 1983 · S/N 172RG1143N9378ULrh Equipment LLC · Pendleton, ORBuilt 1976 · S/N 15078327N9378XWhitewater Aviation LLC · Lansing, WVBuilt 1985 · S/N 18268505N93797Lattin Travis W · Beloit, KSBuilt 1976 · S/N 18503247N9379BBravo Aviation LLC · Jasper, TXBuilt 1958 · S/N 55179N9379CWestern Pilot Service Inc · Phoenix, AZBuilt 1955 · S/N 31777N9379HCitizen Air LLC · Port Angeles, WABuilt 1975 · S/N 17266128N9379TTracer LLC · Arkadelphia, ARBuilt 1960 · S/N 50879N9379XFoster Hartford L · Whitefield, MEBuilt 1962 · S/N 18253779N9379YFitzgerald Aviation LLC · Bluffton, SCBuilt 1981 · S/N 21064491N937ASGc Aviation Services-1 LLC · Miamisburg, OHS/N 172RG1178N9380BHarper Clayton E · Seabrook, TXBuilt 1958 · S/N 55180N9380GSclafami Michael · New Waverly, TXBuilt 1971 · S/N 18260920N9380NAlaska Department Of Public Safety · Anchorage, AKBuilt 1981 · S/N 18504344N9380RFarm Air Inc · Astoria, ILBuilt 1975 · S/N 18802268N9380UForsberg Johnny L · Meridian, IDBuilt 1976 · S/N 15078329N9380XJacobi Gregory A · Alex, OKBuilt 1962 · S/N 18253780N93814Haltmann Sven · Fairbanks, AKS/N 18503250N9381XLazy Eight Flying Club LLC · New Richmond, WIBuilt 1962 · S/N 18253781N93827State Of Colorado Department Of Natural Resources · Denver, COBuilt 1977 · S/N 18503253N9382ASeniw Alan G · Bonfield, ILBuilt 1949 · S/N 7461N9382DN9382d LLC · Wake Forest, NCBuilt 1983 · S/N 172RG1145N9382HDhc Aviation LLC · Toccoa, GABuilt 1981 · S/N 18267941N9382XBoyd David · West Creek, NJBuilt 1985 · S/N 18268506
Back to AD 87-20-03 R2