AD 94-01-06

Registered aircraft · 4,801

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:94-01-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-01-06')
  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.

N107USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1052N1083SGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1443N1088Fmc Corp · Philadelphia, PABuilt 2009 · S/N 5798N108ADMarquez Padilla Inc · Bonita, CABuilt 1983 · S/N 1080N108BKKent Aviation LLC · Midland, TXBuilt 2001 · S/N 305N108FJBuffalo Valley Ventures Of Tn LLC · Cookeville, TNBuilt 1991 · S/N 108N108PHYoung Family Aviation LLC · Sugar Grove, ILBuilt 1990 · S/N 87N108RJDixon John W · Aurora, ORBuilt 2002 · S/N BB-1801N108UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1061N1095WEaglemed LLC · Wichita, KSBuilt 1996 · S/N LJ-1456N109BGAviation Leasing Group Inc · Wilmington, DEBuilt 1982 · S/N NA0310N109MDM B Duncan Inc · Bakersfield, CABuilt 1985 · S/N BB-1213N109UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1065N10CW911 Aviation LLC · Durant, OKBuilt 1985 · S/N BB-1211N10KJKtkj Challenger LLC · Houston, TXBuilt 2020 · S/N 6155N10MBAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1999 · S/N 176N10MMSarma Aviation LLC · Fort Wayne, INBuilt 1988 · S/N 5033N10QWBlackhawk 04 LLC · Portland, ORS/N BB-1846N10TNPacific Rim Management LLC · Downey, CAS/N 257085N10VJVenture Jets LLC · Lititz, PABuilt 1990 · S/N 018N10XBmd Leasing LLC · Portland, ORBuilt 2001 · S/N 190N1101AHeritage Aviation Services LLC · Dallas, TXBuilt 1997 · S/N 5354N1103GMcn-Air LLC · Macon, GABuilt 1997 · S/N LJ-1475N110CPPruitt Corp · Leesburg, VABuilt 2024 · S/N 6211N110PMCcp Air LLC · Norwalk, OHBuilt 1997 · S/N LJ-1481N110UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1112N1110KPeach Air Corporation · Wilmington, DEBuilt 1997 · S/N LJ-1486N1114KRogers John Stuart Trustee · Hughson, CABuilt 1997 · S/N BB-1559N1114ZCarefree Air LLC · San Jose, CABuilt 1998 · S/N LJ-1514N1116RCtb Inc · Milford, INFirst renewal noticeBuilt 1996 · S/N RK-116N111CCWilmington Trust Co Trustee · Wilmington, DEBuilt 1996 · S/N 5192N111FJJfm Air LLC · Wilton Manors, FLBuilt 1993 · S/N 128N111FWAcme Management Co · Fort Worth, TXS/N RK-102N111KCSherrmore LLC · Winter Park, FLBuilt 1990 · S/N LJ-1258N111MQBismarck Air Medical LLC · Bismarck, NDBuilt 1999 · S/N BB-1665N111PJG&L Aviation Services LLC · Las Vegas, NVBuilt 1981 · S/N 340A1234N111RBClear Skies LLC · Allentown, PABuilt 1978 · S/N 340A0545N111REX Aviation Group LLC · Beverly Hills, CABuilt 1988 · S/N 49670N111RZMetropolitan Telecommunications Corp Of De LLC · Holmdel, NJBuilt 2009 · S/N 5792N111SSFamily Time Machine LLC · Stuart, FLBuilt 1984 · S/N FA-4N111USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1114N1125AAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1990 · S/N 051N1126JBbc Air LLC · Macon, GABuilt 1997 · S/N LJ-1483N112BJDg Group Aviation LLC · Bloomfield Hills, MIBuilt 1996 · S/N RK-112N112EDE D Santos & Associates LLC Trustee · Wilmington, DES/N 258048N112EMRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1988 · S/N 023N112PSFrontera Flight Holdings Inc · Dover, DEBuilt 1967 · S/N 47013N112USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1134N1130JN1130j LLC · Huntsville, TXBuilt 1997 · S/N LJ-1467N113DJ3d Jets LLC · Orchard Park, NYBuilt 2007 · S/N 307
Back to AD 94-01-06