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.

N9180PHughes Travis · Willow Park, TXBuilt 1967 · S/N 24-4670N9180TMcguire Michael D · Lake Stevens, WABuilt 1996 · S/N 3250N9180XInternational Air Services Inc Trustee · Carson City, NVBuilt 1989 · S/N 4622075N91813Fallbrook Fly Girl LLC · Lakeside, ORBuilt 1973 · S/N 17261515N9181DBoehmer Transportation Corporation · Machias, NYBuilt 1989 · S/N 2811029N9181EDonnelly Thomas G · Seattle, WABuilt 1977 · S/N 7132CN9181SFhs Aero Co Ltd · Olathe, KSBuilt 1976 · S/N M-1798N9181WSkyward Horizons LLC · Maumelle, ARBuilt 1966 · S/N 28-10837N91823Perra John James Trustee · Gardnerville, NVBuilt 1973 · S/N 17261516N9182HMouton Charles · Gladewater, TXBuilt 1975 · S/N 17265997N9182JTremblay Christopher A · Albion, MEBuilt 1966 · S/N 28-3250N9182KRoth Howard R · Mott, NDBuilt 1976 · S/N 28-7625169N9182PMonske Nicholas · Austin, TXS/N 24-4672N9182QFox Terrier LLC · Wilmington, DEBuilt 1989 · S/N 3213028N9182SBig Bend Community College · Moses Lake, WABuilt 1975 · S/N MB-786N9182TShortridge Randall R · Mesa, AZBuilt 1978 · S/N 25-7856026N9182WMoyer Aviation Inc · Tobyhanna, PABuilt 1989 · S/N 2841130N91834Skylink Xpress Inc · San Bernardino, CABuilt 1989 · S/N 2841141N9183KKoinzan Flying Service Inc · Elgin, NEBuilt 1996 · S/N 110N9183SToole William Barry · Goochland, VABuilt 1976 · S/N M-1802N9183VBerrong Jimmy L · Dahlonega, GABuilt 1969 · S/N 690039N9184LKindred Champ LLC · Hickson, NDBuilt 1971 · S/N 327-72N9184VCloud Distributing LLC · Austin, TXBuilt 1969 · S/N 690036N91853Eminess Group LLC · Bradenton, FLBuilt 1989 · S/N 3213030N91854Sjostedt Brad D · Cordova, AKS/N 357-72N9185HFlyit LLC · Washougal, WABuilt 1975 · S/N 17265999N9185JRatcliff Dale A · Granville, OHBuilt 1966 · S/N 28-3253N9185LKnighten Ammon J · Gakona, AKBuilt 1971 · S/N 324-72N9185SGrushkin Jon S · Mazon, ILBuilt 1976 · S/N M-1799N9185WFixed Gear Aviation LLC · Eldersburg, MDBuilt 1966 · S/N 28-10842N91862Aire Services LLC · Barrigada, GUBuilt 1973 · S/N 17261519N9186DEckels Daniel R · Centerburg, OHBuilt 1958 · S/N 22-6244N9186KMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7615181N9186LAshby Darrell T · Elko, MNBuilt 1971 · S/N 231-72N9186MBlazer Aviation LLC · Charlotte, NCBuilt 1992 · S/N 10122N9186NShrike One LLC · Deerfield Beach, FLBuilt 1972 · S/N 3131N9186SHigh Flyin LLC · Canton, MSBuilt 1976 · S/N M-1805N9186XRohrbaugh John M Jr · Warrenton, VABuilt 1993 · S/N 2811037N9187CKd3262 LLC · Downers Grove, ILBuilt 1978 · S/N R18200439N9187LGardner James Jr · El Campo, TXBuilt 1971 · S/N 328-72N9187MPhillips Tim · Blair, OKBuilt 2001 · S/N 3418N9187PJapundza Bob · Kokomo, INFirst renewal noticeS/N 24-4677N9187RMih LLC · Birmingham, ALBuilt 1978 · S/N R18200666N9187SCarr Gary · Crestwood, ILBuilt 1976 · S/N MB-790N9188GAircraft Management Services Inc · Milton, FLBuilt 1979 · S/N 17273625N9188JBooth Emmett W · Waitsburg, WAS/N 28-3256N9188PRogermoser Hanspeter · Summerville, SCBuilt 1967 · S/N 24-4678N9188SVanommeren Matthew · Uniondale, NYBuilt 1976 · S/N M-1803N9188TArizona Soaring Inc · Maricopa, AZBuilt 1978 · S/N 25-7856039N9188VValiair Limited Co Trustee · Casper, WYBuilt 1969 · S/N 690049
Back to AD 87-10-06 R1