AD 2011-01-52

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

N71SLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N S1468N721CBLung Brian · Williamsburg, OHBuilt 1995 · S/N 0021N721SPSchweizer Rsg LLC · Fort Worth, TXBuilt 1986 · S/N S1232N7233USuttle Joseph S · Moody, ALBuilt 1964 · S/N 16-0447N725AN725a LLC · Manassas, VABuilt 2000 · S/N 0105N72LPRavens Rebuilders Inc · Ellenboro, WVBuilt 2003 · S/N 0152N72LTReynolds Cindy L · Wills Point, TXBuilt 1968 · S/N 580863N731TATomlinson Aviation Inc · Ormond Beach, FLBuilt 2006 · S/N 0236N7364HReam Aviation LLC · York, PABuilt 2010 · S/N S1938N7419FSmith Helicopters Inc · Cotulla, TXBuilt 1977 · S/N 670606N7446FAir Sprayers Inc · Two Buttes, COS/N 560504N7452FReep Nic K · Yakima, WAS/N 760522N7463FWendling Mark A · Bryant, SDBuilt 1976 · S/N 860534N7465FSmith Norman L · Houston, TXS/N 860530N7482FSchweizer Rsg LLC · Fort Worth, TXS/N 170576N7489FColdwell Jerry Lee · Jordan, MTBuilt 1977 · S/N 570595N7490FDodson International Parts Inc · Rantoul, KSS/N 570596N7492FHouston Police Dept · Houston, TXBuilt 2008 · S/N S1920N7493FHouston Police Dept · Houston, TXBuilt 2008 · S/N S1921N74LTDevor Aviation Support Services LLC · Chambersburg, PABuilt 1968 · S/N 1270740N7504SAirczar LLC DBA · Corpus Christi, TXBuilt 1987 · S/N S1260N7504ZMid Pacific Aero Services LLC · Honolulu, HIS/N S1266N7505BSilver Wings Inc Trustee · Wilmington, DEBuilt 1985 · S/N S1205N75068Kinzie Industries Inc · Erie, COExpired dealerBuilt 1988 · S/N S1323N7506NMeshoppen Air LLC · Tunkhannock, PABuilt 1988 · S/N S1305N75070Mansfield Heliflight Inc · Milton, VTS/N S1404N7507CBlair & Son Inc · Fleetwood, PABuilt 1988 · S/N S1349N7507MWeststar Ventures LLC · Cannon Falls, MNBuilt 1989 · S/N S1365N7507USierra Sky Aviation LLC · Kalispell, MTBuilt 1989 · S/N S1393N7508HSons Aviation LLC · Moody, ALBuilt 1992 · S/N S1628N7508LBruegger Shannon B · Lance Creek, WYBuilt 1989 · S/N S1417N75105Mitchell Maverick LLC · Mitchell, SDBuilt 1994 · S/N S1677N7511ACouch Construction Co LLC · Palestine, TXBuilt 1994 · S/N S1685N767LHJones Aircraft Co LLC · Cross Plains, TNBuilt 2007 · S/N S1905N771AAJones Aircraft Co LLC · Cross Plains, TNBuilt 2008 · S/N 0325N776LHJones Aircraft Company LLC · Cross Plains, TNBuilt 2002 · S/N S1841N789LHJones Aircraft Company LLC · Cross Plains, TNBuilt 2008 · S/N S1911N801CPMoore Bradley J · Logsden, ORBuilt 1968 · S/N 980965N801SLZadow Ryszard Jerzy · Waller, TXBuilt 1968 · S/N 880954N8045SHenry Mark A · Dickinson, TXBuilt 1964 · S/N 85-0365N8047LHolmes Frank L · Enterprise, ALBuilt 1967 · S/N 47-0699N8049PFranklin Ricky L · Glade Hill, VAS/N 56-0535N8049WTennis Gayland L · Bath, MIBuilt 1965 · S/N 75-0349N811TTJordison Investments LLC · Auburn, WAS/N S1835N8135LTri County Rentals And Sales Inc · Bell, FLS/N 580847N815SGGierisch Frederick · Utopia, TXBuilt 2003 · S/N 0158N817BWWalker Baylor L · Big Spring, TXBuilt 2001 · S/N S1813N826JWWills John L · Jasper, ALBuilt 2001 · S/N S1826N8363CNelson William J · Citrus Heights, CABuilt 2010 · S/N S1939N8377FScott Shawn D · Darrington, WAS/N 480680
Back to AD 2011-01-52