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.

N53KFHaynes Robert Kent · Pilot Point, TXBuilt 1996 · S/N S1738N556BKd Helicopters Inc · Shingleton, MIBuilt 1986 · S/N S1235N557DCJoslyn Larry J · Las Vegas, NVBuilt 1993 · S/N S1630N5594YWdw Aviation Leasing Inc · Knoxville, TNBuilt 1964 · S/N 1140329N55PHElectrical Design Consultants Group LLC · Pepper Pike, OHBuilt 2002 · S/N 0145N58160Brb Flight Services LLC · Laguna Beach, CABuilt 1974 · S/N 740324N58174Castle Farms Inc · Sunnyside, WAS/N 480685N58206Kiwi Choppers LLC · Hillsboro, ORBuilt 1978 · S/N 190768N58208Smith Helicopter Inc · Cotulla, TXBuilt 1979 · S/N 390780N58281Lueck Thomas J · Cedar Rapids, IABuilt 1978 · S/N 1180734N58319Schweizer Rsg LLC · Fort Worth, TXBuilt 1979 · S/N 390761N58344Wolff Scott A · Missoula, MTS/N 1090836N58359Warner Robert G Jr · Broomall, PABuilt 1979 · S/N 1290861N58363Hartle Aaron Duane · Vicksburg, MIBuilt 1979 · S/N 690796N58371Bilton Aircraft Management Inc · Umatilla, FLBuilt 1979 · S/N 690794N58384Sonnichsen Landen D · Delta Junction, AKS/N 990829N58397Frost Darrell G · Atlanta, TXBuilt 1979 · S/N 1090833N6120ABrabeck Mark F · Glasgow, MTBuilt 1991 · S/N S1520N6126TGuida Associates Consulting Inc · Sandpoint, IDS/N S1496N6128UJoslyn Larry J · Las Vegas, NVBuilt 1993 · S/N S1655N6136KAll On Black LLC · Mount Nebo, WVBuilt 1994 · S/N S1672N61447Overton Tommy · Cumberland Gap, TNBuilt 1995 · S/N 0007N6144VAir Flite Inc · Shawnee, OKBuilt 1996 · S/N 0037N61458Dls Holdings Inc · Lewes, DEBuilt 1995 · S/N 0008N6145VMarshall University · Huntington, WVBuilt 1996 · S/N 0045N6147EBuckley Michael J · Billings, MTBuilt 1995 · S/N S1707N61486Johnson Gary R · Carthage, NYBuilt 1998 · S/N 0084N6148VChupp Aaron · Gallipolis, OHBuilt 1998 · S/N 0086N614TVDurmisevich Dean J · Carnation, WABuilt 1996 · S/N 0035N6163EPrice Keith E · Ossian, INS/N 720151N61MJSnell Matthew Lea · Ackerly, TXBuilt 1990 · S/N S1483N62269Ashcraft Matthew · Abbott, TXS/N 160449N62273Mundell Terry Trustee · Rosston, OKBuilt 1969 · S/N 291096N62293Bilsky William E · Titusville, FLS/N 88-0939N6258BA&A Conveyor And Equipement Inc · Pennington Gap, VAS/N 67-16812N626LHHeli-Tech Inc · Panama City, FLFirst renewal noticeBuilt 2008 · S/N S1917N637WSGulf Coast Helicopters Inc · Pearland, TXBuilt 2000 · S/N 0117N645KAHelocraft Holding Co Inc · Pembroke Pines, FLBuilt 2009 · S/N S1931N64732A And J Aviation Services LLC · Okeechobee, FLBuilt 1974 · S/N 840341N653CHKelley Aviation Consultants LLC · S Williamsport, PABuilt 1965 · S/N 96-0653N656RBBas Part Sales LLC · Greeley, COBuilt 1997 · S/N S1744N662RSBender Jeff L · Canal Winchester, OHBuilt 2005 · S/N 0222N67TKBuckley Michael J · Billings, MTS/N S1838N691RRAnderson Stuart R Jr · Sahuarita, AZS/N 124-0143N699LCAero Management LLC · Austin, TXBuilt 1999 · S/N S1775N7032ZJones James William III · Lebanon, VAS/N 1040325N7050DFoster David S · Justin, TXS/N 56-0551N7057LTri County Rentals And Sales Inc · Chiefland, FLBuilt 1967 · S/N 1281052N705RMReynolds Darryl G · Wills Point, TXS/N S1504N711CHYoung Vernon P · Metter, GAS/N 560531
Back to AD 2011-01-52