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.

N909CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8909N909CQVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281618N909EZWilliford David E · The Colony, TXBuilt 2003 · S/N SLW-2N909JHShean Thomas R · Santa Ynez, CABuilt 2008 · S/N 91305N909JLAims Community College · Greeley, COBuilt 2019 · S/N 2881184N909MAKenzy 2022 LLC · Castle Rock, COBuilt 2019 · S/N 2881186N909MPSky Guy LLC · Frankenmuth, MIBuilt 1972 · S/N 291-72N909RBFagan Gerald J · Sleepy Hollow, ILBuilt 2015 · S/N 70909N909RDPontix Consulting Inc · Hercules, CABuilt 1990 · S/N 1038N909RKFisher Garrett L · Sheridan, WYBuilt 1965 · S/N 18-8328N909TClaus Donna E · Chitina, AKBuilt 1965 · S/N 18-8305N909VCSan Bernardino Community College District · San Bernardino, CAS/N 17261045N909VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1978 · S/N 895N90ACKing Charles E · Sequim, WAS/N 90627N90AGEuroaviation Inc Trustee · KematenBuilt 1990 · S/N 11066CN90AVCag Aircraft Holdings LLC · Crystal River, FLBuilt 1974 · S/N 462-74N90BWSalter Scott A · Moscow, TNBuilt 1981 · S/N 32R-8129006N90BZMirand Alexander A · Huntington Beach, CAS/N 408N90CABlue Max Aviation LLC · El Cajon, CABuilt 1976 · S/N 93376N90CKHodack Steven J · Burton, MIBuilt 1959 · S/N 46063N90CRAllen Scott P · Wellington, NVBuilt 1993 · S/N 1053N90DDBas Part Sales LLC · Greeley, COS/N 32-7940072N90DHFielden Donald W · Granbury, TXBuilt 1994 · S/N 473-320-218FBN90DRRobinson Brian D · Centennial, COBuilt 1999 · S/N 24113N90DZPjm Aviation LLC · Labelle, FLBuilt 1979 · S/N R18200711N90ECCarris Edgar C · Jupiter, FLBuilt 1999 · S/N EC-2N90EFBardoo Sean L · Massapequa, NYBuilt 1976 · S/N 27-7654081N90ENWiggins Gene S · Americus, GAS/N 28-1219N90ERSkyes Aviation Outfitters LLC · Laguna Vista, TXBuilt 1999 · S/N 4636243N90ESTodd Donnie D Jr · Pell City, ALBuilt 1997 · S/N 1352N90EXLane Jim · Seeley Lake, MTBuilt 2026 · S/N CCK-1865-1101N90FEPasley Michael Cole · Niceville, FLBuilt 1969 · S/N 28R-35121N90FHBaker Farming Co · Fresno, CAS/N 1149N90FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 17273139N90GBEdtl David · Woodburn, ORBuilt 2011 · S/N 90192N90GRAerospace Trust Management LLC Trustee · Wilmington, DES/N 72N90HAGarzony Anthony · Toledo, OHBuilt 1979 · S/N 17272658N90HTGambrill Lucas W · Athol, IDBuilt 1990 · S/N 679N90HULenaerts-Bergmans Bart · Jefferson, MABuilt 1996 · S/N 1317N90JABuehler Andrew · Eatonville, WABuilt 1992 · S/N 1651N90JMNoriega Air Holdings LLC · Tampa, FLBuilt 1965 · S/N 747N90JPAec Shrike LLC · Barrington, ILBuilt 1970 · S/N 3078N90KKTroutman Alan D · Springtown, PABuilt 1991 · S/N KRASKA 0002N90LALakeside Aerodome Ltd · Clermont, FLBuilt 1995 · S/N 1207-95N90LSNielsen Eric R Trustee · Anthem, AZBuilt 1978 · S/N 18-7909025N90LTBorder Zachary J · Molalla, ORS/N 2027-LN90MHMooers Michael T · Hagerstown, MDBuilt 1976 · S/N 28R-7635158N90RVTrue Carl B · Avalon, CABuilt 1994 · S/N 21815N90SEKelly James D II · San Francisco, CABuilt 1989 · S/N 4622041N90SLHo Ming-Hang · Hayward, CABuilt 1995 · S/N 2077
Back to AD 87-10-06 R1