OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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-08-08-R3')
    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-08-08-R3')
  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.

N7378WTribuno Michael G · Rosamond, CABuilt 1963 · S/N 28-1360N737CFZia Air 7cf LLC · Redwood City, CABuilt 1975 · S/N 28-7510047N7380JBednarek Michael H · Centerville, OHBuilt 1968 · S/N 28-24742N7380WRohlfes David M · Newcastle, CABuilt 1963 · S/N 28-1263N7381WTogliatti Robert A · Lakewood, OHBuilt 1963 · S/N 28-1265N7382JMinor Air LLC · Joplin, MOS/N 28-24744N7383JCox Jakori Akeem · Las Vegas, NVBuilt 1968 · S/N 28-24745N7383WRed Rock Flying School LLC · Mesa, AZBuilt 1963 · S/N 28-1267N7384WRader Kyle L · Hutto, TXBuilt 1963 · S/N 28-1268N7385JGardner Chuck R · Estherville, IABuilt 1968 · S/N 28-24747N7388WLiebsack Steven G · Torrance, CABuilt 1966 · S/N 28-3757N7389WMcnulty Ian M · Willis, TXS/N 28-1274N738CFishgold Valerie Trustee · Scottsdale, AZBuilt 2005 · S/N 3255028N7390JViets Richard C · Bloomer, WIBuilt 1968 · S/N 28-24752N7390WRegistration Pending · Concord, NCRegistration pendingBuilt 1963 · S/N 28-1275N7391JDenke Larry · Long Valley, SDBuilt 1968 · S/N 28-24754N7391WDippolito Mario M · Sherwood, ARBuilt 1963 · S/N 28-1276N7392J33 Global LLC · Potomac Falls, VABuilt 1968 · S/N 28-24755N7393JSale Reported · Tyler, TXSale reportedBuilt 1968 · S/N 28-24756N7394JHorizon Aviation LLC · Brooks, GAS/N 28-22785N7395JOhm Aviation LLC · Wmca, NVS/N 28-24758N7395WHuckfeldt Owen D · Alliance, NEBuilt 1963 · S/N 28-1283N7396JBurns Preston T · Spruce Pine, ALBuilt 1968 · S/N 28-24759N7396WN7396w LLC · Coeymans Hollow, NYBuilt 1963 · S/N 28-1284N7397JJmk Repair · Lone Oak, TXBuilt 1968 · S/N 28-24760N7398JGreat Lakes Aviation Services LLC · Kimball, MIBuilt 1968 · S/N 28-24761N7398WJil Aviation Inc · La Coste, TXS/N 28-1286N7399JGordon Jacob M · Tega Cay, SCBuilt 1968 · S/N 28-24762N7399WI Was Inverted LLC · Fort Myers, FLS/N 28-1287N739CAChristiansen Aviation LLC · Wilmington, DES/N 2881737N739FLArrowking Inc · Edmond, OKBuilt 1972 · S/N 28-7225562N739NDAir Shares LLC · Casper, WYBuilt 2017 · S/N 2843888N73BCVnk Sky Inc · Dover, DEBuilt 1973 · S/N 28-7305263N73BLSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 3257450N73BWBravo Whiskey Holdings LLC · Lewis Center, OHBuilt 1977 · S/N 28-7816102N73CPQuality Concrete LLC · Brentwood, TNBuilt 2003 · S/N 3232004N73FQAlaska Island Air Inc · Togiak, AKBuilt 1981 · S/N 32-8206007N73GSHill Gregory A · Romeo, MIBuilt 1973 · S/N 28-7305573N73KLTanych Tyler · Inverness, FLS/N 28-7125169N73LNHelzer Jarrod · Antioch, CABuilt 1973 · S/N 28-7305481N73PFSinor Delbert · Ozark, MOBuilt 1981 · S/N 28-8216092N73RWSeppala Joel H · Taylors, SCBuilt 1971 · S/N 32-7240039N73STClearskys Aero LLC · Seneca, SCBuilt 1962 · S/N 28-937N73TSWeene Michael L · Moultonborough, NHBuilt 1985 · S/N 28-8590064N7400RHambey Eric M · Walnut Grove, MOBuilt 1966 · S/N 28-21916N7402RReynolds Gary W · Forest, VAFirst renewal noticeBuilt 1966 · S/N 28-21918N7403JMejia Ramirez Martin E · Perth Amboy, NJBuilt 1969 · S/N 28-25182N7404RT&G Aviation Services LLC · Temple, TXBuilt 1966 · S/N 28-21921N7405JMills Bailey J · Salem, ALBuilt 1968 · S/N 28-24770N7405WGo Fly Az LLC · Gilbert, AZBuilt 1963 · S/N 28-1291
Back to AD 87-08-08 R3