AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N8291ERangers Flying Club Inc · Eden Prairie, MNBuilt 1979 · S/N 17272177N8291JWorth William A · Anthony, NMBuilt 1979 · S/N VAC-137-79N8291NPeters Rodney A Jr · Hayward, WIBuilt 1969 · S/N 28-25509N8291PWilcher Trevor C · Macungie, PABuilt 1963 · S/N 24-3544N8291WVoll Dorothe A · Corona, CABuilt 1965 · S/N 28-2454N82921New Hampshire Flying Association Inc · Nashua, NHBuilt 1982 · S/N 28-8390007N8292DHuffman Jacob M III · Burleson, TXBuilt 1982 · S/N 28-8316009N8292EP&N Corp · Marion, IAS/N 17272178N8292JBrent Scott Properties Lp · Eagle, COS/N VAC-138-79N8292PCharles City Aeronautics Inc · Charles City, IABuilt 1963 · S/N 24-3545N8292TJames Peterson Sons Inc · Medford, WIBuilt 1982 · S/N 32R-8329001N8292WPinegar Kevin R · Brighton, MIBuilt 1965 · S/N 28-2455N82933Cummings Jake A · Tucson, AZBuilt 1980 · S/N 28-8111023N8293CMcchargue Robert W II · Talkeetna, AKS/N 18-4114N8293EFiorini Anthony Wayne · Tuttle, OKBuilt 1979 · S/N 17272179N8293NPaul Harvey B · Kongiganak, AKBuilt 1969 · S/N 28-25511N8293PGrosshans Inc · Central City, NEBuilt 1980 · S/N 28-8111021N8293RPanterra Aviation LLC · Mountain Green, UTBuilt 1979 · S/N R18200933N82942Kemp Kerm R · Southwest Ranches, FLBuilt 1977 · S/N 18-7809027N82945Brewer William B Jr · Fairbanks, AKBuilt 1977 · S/N 18-7809029N82946Class A Coaches LLC · Missoula, MTBuilt 1977 · S/N 18-7809030N82947Mann Jacob A · Wheatland, WYBuilt 1978 · S/N 18-7909032N82949Mcbride Peter M · Basalt, COBuilt 1978 · S/N 18-7909033N8294HSidney Aviation LLC · Sidney, NEBuilt 1965 · S/N 1163N8294JDowning John T · Tucker, GAFirst renewal noticeBuilt 1979 · S/N VAC-140-79N8294KAdvantage 94 Kilo LLC · Grosse Pointe Park, MIBuilt 1980 · S/N 32R-8113007N8294LAts Tennessee Inc · Oneida, TNBuilt 1982 · S/N 28-8316011N8294YNenno Richard W II · Bothell, WABuilt 1967 · S/N 30-1432N82951Av Enterprises Inc · Bozeman, MTBuilt 1978 · S/N 18-7909035N82953Sky Fox Aircraft LLC · Queen Creek, AZBuilt 1980 · S/N 28-8190088N82956Holmes James E · Klamath Falls, ORBuilt 1979 · S/N 18-7909034N8295EFrump Leasing Inc · Newburgh Heights, OHS/N 17272181N8295HAnywhere Atp LLC · Mt Juliet, TNBuilt 1982 · S/N 28-8316013N8295NMaust Philip J · Hemet, CABuilt 1969 · S/N 28-25514N8295TFlight Services Inc · Headland, ALBuilt 1980 · S/N 28-8116082N8295WHess Stephen L · Millerton, PAFirst renewal noticeBuilt 1965 · S/N 28-2459N8295ZWhitaker Stephen P · Northville, MIBuilt 1980 · S/N 28-8190087N82961Montgomery Daniel G · Wasilla, AKBuilt 1978 · S/N 18-7909036N82962Jacques Jerry J · Iliamna, AKS/N 18-7909037N82965Mockingbird Flying Club · Sioux Falls, SDBuilt 1980 · S/N 32-8106011N82967Spare Joseph T · Waldo, OHBuilt 1980 · S/N 32R-8113013N82968Pulse Jeremy D · Moore, MTS/N 18-7909040N82969Feriani Ralph B · Anchorage, AKBuilt 1978 · S/N 18-7909041N8296EMosbach Rene A · Sandia, TXBuilt 1979 · S/N 17272182N8296JVarga Aircraft Co · Hephzibah, GAS/N VAC-142-79N8296NCline Terence P · Alva, OKBuilt 1969 · S/N 28-25515N8296PBarto Eric K · Kula, HIBuilt 1982 · S/N 32-8206039N8296WAngert Phillip E · New York, NYBuilt 1965 · S/N 28-2460N8296YBl Aviation Services LLC · Camden, DEBuilt 1967 · S/N 30-1435N82972Supercub LLC · Anchorage, AKBuilt 1977 · S/N 18-7809001
Back to AD 87-10-06 R1