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.

N6548JInspire Aviation LLC · Magnolia, TXBuilt 1968 · S/N 28-4992N6548PPettus Gary A · Fort Mill, SCS/N 24-1670N6548VMaxwell Frank R · Fairbanks, AKBuilt 1980 · S/N 172RG0771N6548ZKingsley Kiman J · Miller, MOBuilt 1962 · S/N 25-2090N6549AGregory P Cook LLC · Spokane, WABuilt 1978 · S/N 27-7954006N6549DBbjs Investments LLC · Waukesha, WIBuilt 1979 · S/N 17272858N6549JHuff Glenn N · Hackettstown, NJFirst renewal noticeBuilt 1968 · S/N 28-4993N6549ZRivers Larry R · Talkeetna, AKBuilt 1962 · S/N 18-7879N654ALMoore Howard · Camden, TNBuilt 1977 · S/N 17269033N654BCCobb Charles J · Fallbrook, CABuilt 1969 · S/N 28-5335N654CRLinde Rodney C · Weatherford, TXBuilt 2003 · S/N 80734N654EZN654ez LLC · Oyster Bay, NYBuilt 2006 · S/N 1741N654FKimmel John · Milwaukie, ORBuilt 1991 · S/N 7-0065N654FLRoca Roja Y Caballo Gris De Idaho LLC · Meridian, IDBuilt 1971 · S/N 28-7125569N654FTFlorida Institute Of Technology Inc · Melbourne, FLS/N 28020172N654JFFreele James E · Rio Rancho, NMBuilt 1999 · S/N 4116N654JWWilson Jared D · Midway, UTBuilt 2019 · S/N 40470N654MRlw Wholesale LLC · Myrtle Beach, SCBuilt 2004 · S/N 40.412N654MDProfessional Storage Inc · Hobe Sound, FLBuilt 1976 · S/N 27-7754018N654NSElks Stephen A · Mountain City, TNBuilt 1974 · S/N 133N654PJPajak Paul J · Groveland, FLBuilt 2006 · S/N 72216N654PTAnerv6a LLC · Minneapolis, MNBuilt 2012 · S/N 60557N654PVHouston Traville S · Granbury, TXBuilt 2011 · S/N 41035N654RTKonrad Melvin J · Cumming, IABuilt 1999 · S/N 24776N654RVVan Hoff Eric J · Gunter, TXBuilt 2003 · S/N 1898N654SHHutcherson David R · Gretna, VABuilt 2003 · S/N 3505N654SPJm Air Holdings LLC · Stevensburg, VABuilt 1998 · S/N 172S8060N654WMMillar Rick A · Anchorage, AKBuilt 2012 · S/N 001N654YRVet Air LLC · San Juan, PRBuilt 1964 · S/N 28-1867N654ZZarmada LLC · Issaquah, WABuilt 2006 · S/N T18208627N65503Bentz Andreas · Falls Church, VABuilt 1983 · S/N M2378N65507Cora & Associates LLC · Norcross, GABuilt 2004 · S/N 18281454N6550JJans Stanley E · Dakota City, NEBuilt 1968 · S/N 28-4994N6550PLux Kevin C · Vancouver, WABuilt 1960 · S/N 24-1672N6550UGeorge Ladelle L · Ashley, NDBuilt 1963 · S/N 2333N65512Wiebe Van Michael · Filer, IDBuilt 2004 · S/N 18281457N65514Vogt Gregory A · Broken Arrow, OKBuilt 2004 · S/N 18281458N65515Peterson Darren · Janesville, WIBuilt 2004 · S/N T18208325N65516J-Airco LLC · Nashville, TNBuilt 1982 · S/N 17275769N65518Tk Equipment LLC · Brownsburg, INBuilt 1982 · S/N 17275771N6551LParker Kerry · Hobbs, NMBuilt 1974 · S/N AA5-0651N6551PWsv Aero Inc · Wilmington, DEBuilt 1959 · S/N 24-1673N6551UAuker Donald · Lebanon, PABuilt 1962 · S/N 2334N6551WThull Stanley B · Freeport, MNBuilt 1965 · S/N 28-20631N65525Sinha Nanda K · Benicia, CABuilt 1982 · S/N 17275774N65528Jacks Charles D · Crowley, LABuilt 1983 · S/N 17275775N6552FAir Planes LLC · Soddy Daisy, TNBuilt 1979 · S/N 17273239N6552JCherokee Flyers Inc · Phoenixville, PABuilt 1968 · S/N 28-4997N6552PSyc Holdings LLC · Missoula, MTBuilt 1960 · S/N 24-1674N6552UGoldstein Meyer · Underwood, WABuilt 1962 · S/N 2335
Back to AD 87-10-06 R1