OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

N711NCHussey Aviation LLC · Clear Lake, IAS/N D-9776N711PAKimball Spruce L · Hampton, GABuilt 1957 · S/N D-5206N711PRDaniel Dewey · Okeechobee, FLBuilt 1974 · S/N E-608N711PZOffroute Aero LLC · Lake Oswego, ORBuilt 1973 · S/N TC-1491N711RBMorris John C III · Rochester, MNBuilt 1969 · S/N D-9015N711SLAbc Leasing Inc · Oakdale, LABuilt 1978 · S/N CE-773N711THTri-County Sprayers Inc · Hamlin, TXS/N E-246N711TKClass Cockpits Co · Prior Lake, MNBuilt 1954 · S/N CH-81N711TRAtomic Cat LLC · Hamilton, MTS/N TE-350N711TVRepko Ventures LLC · Logan, UTBuilt 1965 · S/N D-7931N711VSMilne Jeff J · Lake Geneva, WIBuilt 1975 · S/N E-756N711XVeetail LLC · Land O Lakes, FLBuilt 1964 · S/N D-7732N711ZZGoodman Michael K · Brooksville, FLBuilt 1943 · S/N 4811N7121NLockbaum Jim · Oconomowoc, WIBuilt 1967 · S/N D-8674N7123NLarson Sven E · Newport Coast, CABuilt 1967 · S/N TC-1046N7124NClifton Fred R Jr · Fredericksburg, TXBuilt 1967 · S/N D-8677N7127NGraber Loren · Lake Tapps, WABuilt 1968 · S/N TE-516N7128NMartin Automatic Inc · Rockford, ILBuilt 1967 · S/N D-8675N712BBates John W · Westerly, RIBuilt 1948 · S/N D-1717N712BPPearson Matthew G · Wickenburg, AZBuilt 1973 · S/N TC-1520N712J4j Aviation LLC · Perryton, TXBuilt 1975 · S/N P-327N712JSBeechcraft Heritage Museum · Tullahoma, TNBuilt 1959 · S/N BA-453N712LSDwyer Stephen C · The Woodlands, TXBuilt 1979 · S/N TJ-192N7130NBlake Charles L · Woodstock, GABuilt 1968 · S/N TC-1059N7131Van Dyke Bryan C · Wichita, KSBuilt 1997 · S/N E-3093N713JKelly Dent LLC · Wilmington, DEBuilt 1966 · S/N TE-75N713MGMy Multifamily Investments LLC · Dallas, TXS/N D-10285N713PLSbw Aircraft Group LLC · Lewes, DEBuilt 1968 · S/N TE-506N713PVHodges Marion D · Princeton, KYBuilt 1990 · S/N CE-1515N713TTAbe Air LLC · Salinas, CABuilt 1975 · S/N D-9806N713WBJohnston William J · New Castle, COBuilt 1962 · S/N D-7074N7141NSlowikowski Jr Daniel F · Pensacola, FLBuilt 1968 · S/N D-8713N7145NOklahoma Beech Boys LLC · Weatherford, OKBuilt 2016 · S/N D-8682N7146NEdmundson George · Hood River, ORBuilt 1968 · S/N D-8680N7147NHall Michael W · Olivehurst, CABuilt 1967 · S/N D-8681N7149NLind Dale A · Lewisburg, PABuilt 1968 · S/N D-8686N714BMMurphy Randall · Ruston, LABuilt 2000 · S/N E-3345N714DBIpiranga Inc · Houston, TXBuilt 1996 · S/N EA-585N714JRShafer Benjamin · Riverside, CABuilt 1964 · S/N D-7504N714UZwicker Brian A · Richmond Hill, GABuilt 1968 · S/N TC-1188N7151NStroope Rhea H · Campbell, TXBuilt 1968 · S/N TC-1062N7152NChilian Cort · Roanoke, INBuilt 1968 · S/N TE-512N7153NHardy Douglas · Eureka, MTBuilt 1968 · S/N TE-513N7156NDouglas Charles M · Queen Creek, AZBuilt 1968 · S/N D-8687N7157NPardo Carlos A · Nashville, NCBuilt 1968 · S/N D-8690N7159NRomeo Bravo Aviation LLC · Russellville, KYBuilt 1968 · S/N D-8814N715BCSkinner Edward Mcgregor · LondonBuilt 1975 · S/N E782N715JWBlack Forest Applications LLC · Mckinney, TXBuilt 1966 · S/N TE-69N715LTTraveler LLC · Fort Stockton, TXBuilt 1998 · S/N E-3205N715RGReynolds Jeffery A · Amarillo, TXS/N D1718
Back to AD 99-05-13 R1 WD