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.

N6675ZBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1963 · S/N 25-2280N6676JRozof Chester F · Fort Myers, FLBuilt 1968 · S/N 28-24363N6676RJackson Michael W · Bedford, TXBuilt 1964 · S/N 2866N6676WWorkman Industries Inc · Durant, IABuilt 1965 · S/N 28-20783N6677HPeterson Robert E · Richland, WABuilt 1975 · S/N 17265533N6677WOsgood Darrell F · Watervliet, MIBuilt 1965 · S/N 28-20784N6678FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 28-7715175N6678JWiener Ronald K · Tucson, AZBuilt 1968 · S/N 28-24365N6678WMadison Andrew J · Inver Grove, MNS/N 28-20786N6679PJmj Aviation LLC · Kalispell, MTBuilt 1960 · S/N 24-1803N6679UKimbrough Edward W · Houston, TXS/N 2513N667BAAmendala Brian R · Hillsboro, ORS/N R669N667CHBorders Darin · Center, TXBuilt 1978 · S/N 32R-7887191N667CRKnieling Gene A · Rush Center, KSBuilt 2000 · S/N 25317N667DTGinter Jon A · Marlton, NJBuilt 1972 · S/N 28-7310026N667LBChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843932N667LDLeading Edge Aviation LLC · Manchester, MOS/N 1355N667QTevik Michael A · Provo, UTBuilt 1959 · S/N TD-260N667RHN667rh LLC · Oakdale, NYBuilt 2002 · S/N 3257290N667SAHelicopter N667sa LLC · Lisbon, NDBuilt 2000 · S/N 0726N667SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881435N667SPHindi David · Cupertino, CABuilt 1998 · S/N 172S8070N667TCT J Aviation LLC · Kennesaw, GABuilt 1988 · S/N 960N6680EPrax Philip · Fairbanks, AKBuilt 1959 · S/N 56180N6680JElliott Bryn · Blue Point, NYS/N 28-24368N6680PWilliams Aaron J · Addison, TXBuilt 1960 · S/N 24-1783N6680RWestlake Mark A · Jewett, OHS/N 423N6681PHouse Charles D · Tunkhannock, PABuilt 1960 · S/N 24-1805N6681UGriffin Josh R · Minot, NDS/N 2408N6681XSky Harbor Aviation LLC · Powder Springs, GABuilt 1983 · S/N M-2388N6682LDeyo Kenneth F · Thomaston, CTBuilt 1970 · S/N 445N6682RCavazos Jose Luis Jr · Houston, TXBuilt 1964 · S/N 2867N6682YMcdermott James R · Somerton, AZBuilt 1968 · S/N 27-4003N66836Wolgemuth Jim · Anchorage, AKS/N 18-7709039N6683UReisner Kenneth D · Lecompte, LAS/N 2410N66842Gelvin Stanley M · Central, AKBuilt 1977 · S/N 18-7709140N6684PN6684p LLC · Kalispell, MTBuilt 1960 · S/N 24-1808N6684RRoberts Alec · Boulder, COS/N 427N6684UFowler Kenneth G · Newport, TNBuilt 1976 · S/N 24-0036N6684WWaltman Richard Dean · Moses Lake, WAFirst renewal noticeBuilt 1965 · S/N 28-20790N6685UMccroskey Wesley D · Kingston, TNBuilt 1963 · S/N 2412N6685WZulueta David · Louisville, GAS/N 28-20791N6686LHartmann Peter F · Paulden, AZBuilt 1970 · S/N 449N6686RAnderson Benjamin P · Bellevue, NEBuilt 1964 · S/N 429N6686UNorstegaard Mark A · Sturgis, SDBuilt 1963 · S/N 2413N6687CHurtt Ben J · Mountain Grove, MOBuilt 1947 · S/N 123372N6687JRio Creek Aviators Ltd · Casco, WIBuilt 1968 · S/N 28-24377N6687WHolland William A · Brownwood, TXBuilt 1965 · S/N 28-20794N6687ZCrop Doctor Aviation Inc · Hill City, KSFirst renewal noticeBuilt 1963 · S/N 25-2300N66884Sea2ski Flying Club Inc · Anchorage, AKBuilt 1975 · S/N 18-7509090
Back to AD 87-10-06 R1