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.

N62969Ls Aviation LLC · Searcy, ARBuilt 1958 · S/N 23-1392N6296FCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17273185N6296NBurg Clinton A · Creswell, ORBuilt 1957 · S/N 18-5696N6296WBarthell Frederick · Sun City West, AZS/N 28-20341N62979Cummings Roy E · Fort Scott, KSBuilt 1972 · S/N 36-72N6297JYale Aviation Inc · New Haven, CTBuilt 1976 · S/N 28-7690394N6297UBeasley Curtis L · Kennewick, WABuilt 1962 · S/N 2136N6297WDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1964 · S/N 28-20342N62982Peterson Derek R · Kenmare, NDBuilt 1972 · S/N 361-72N62984Hopkins George · Chippewa Falls, WIBuilt 1972 · S/N 363-72N6298JPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 28R-7635334N6298PN6298p Inc · Okeechobee, FLBuilt 1959 · S/N 24-1278N62992Light & Variable LLC · Arlington, VABuilt 1976 · S/N 31-7712013N6299DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272704N6299UKeelin Freddie B · Sagle, IDBuilt 1975 · S/N AA5-0782N6299YT&T Aviation LLC · Clarksville, TNBuilt 1966 · S/N 27-3550N629AKCloward Marc D · Cordova, AKBuilt 1951 · S/N 18-122N629APThomas Lucas G · Beebe, ARBuilt 1978 · S/N 266-78N629BWagner Nathan D · Dane, WIBuilt 1997 · S/N 5108N629CDrc Aviation Of Stuart LLC · Palm City, FLBuilt 2003 · S/N 3257331N629CGC-4 Aviation LLC · Fruitland Park, FLFirst renewal noticeBuilt 1981 · S/N 32-8106094N629DKUnited Steel Erectors Corp · Atlantic, IABuilt 1998 · S/N 4636158N629EMMelendez Carlos M · Saint Petersburg, FLBuilt 2018 · S/N 001N629ESKorenek Michael A · Houston, TXBuilt 2002 · S/N 18281163N629FCDoherty Paul A · Van Buren, ARBuilt 1979 · S/N 32-7940182N629FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842132N629GKTumenas Daniel E · Girdwood, AKS/N 001N629GWPage Cathleen A · Tucson, AZBuilt 1994 · S/N 23072N629HBBattle Creek Powersports LLC · Jasper, TNBuilt 1958 · S/N 23-1527N629JCCzachorowski Joseph · Wilmington, DEBuilt 2022 · S/N 41729N629JMWebster Bart H · Queen Creek, AZFirst renewal noticeBuilt 2003 · S/N 2232N629KHarrill Roy K · Columbia, SCBuilt 2002 · S/N 23917N629MBBelleau Clifford D · Anchorage, AKBuilt 2000 · S/N TRB-003N629MMMcgraw Michael T · Gainesville, GABuilt 1973 · S/N 17262164N629NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881148N629PKJones John Michael · Oologah, OKBuilt 2002 · S/N 1326-2002N629RMW J Halberstadt Transportation Inc · Hartland, WIBuilt 1980 · S/N 31-8052197N629RWDrew Helicopters LLC · Annona, TXBuilt 1998 · S/N 0520N629TCAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2005 · S/N 18281629N62ADHawkins Flight Academy LLC · Shelbyville, TNBuilt 1973 · S/N 27-7305070N62AMOlson Ronnie E · Palmer, AKBuilt 1991 · S/N 002AMN62ATSelby Kevin L · Stark City, MOBuilt 1980 · S/N 1013N62AWDirty Side Down Aviation LLC · Georgetown, TXBuilt 1998 · S/N 17280504N62BHHennings Bobbie J · Fort Valley, GABuilt 1994 · S/N 20752N62BKHarrington Patrick M · Clinton, MSBuilt 2000 · S/N 2909N62BPPecan Aviation LLC · Granbury, TXBuilt 1980 · S/N 32-8024041N62BRRudolph Robert E · Martinez, CABuilt 2011 · S/N 03-1017N62BVTichy John M · Long Bch Twp, NJBuilt 1979 · S/N MC-649N62BZRobinson John L · Fredericksburg, TXBuilt 2011 · S/N DMO 344N62CASchoenle Paul D · South Bend, INBuilt 1996 · S/N 4636025
Back to AD 87-10-06 R1