AD 2012-03-52

Registered aircraft · 522

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:2012-03-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:2012-03-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.

N50ECPremier Wireless LLC · Kalispell, MTBuilt 1998 · S/N 29-0169N511CZFisher Stephen C · Clarksville, ARBuilt 2006 · S/N 31-0009N512AGJuliet Leasing Inc · Austin, TXBuilt 2008 · S/N 31-0118N513CZZiebarth Charles M · Darien, ILBuilt 2006 · S/N 29-0435N513DRSternhagen Richard · Sweetwater, TNBuilt 2005 · S/N 29-0407N513ZMBullard Aerospace Corp · Boston, MABuilt 1999 · S/N 29-0202N514SGBorland Equipment Leasing LLC · Midland, TXBuilt 2000 · S/N 29-0257N5151FAoa Capital LLC · Missoula, MTBuilt 2006 · S/N 29-0433N516EFEckinger Construction Co · Canton, OHBuilt 2008 · S/N 29-0516N517CBDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 2006 · S/N 29-0466N517PSLuna Volantis II LLC · Lewes, DEBuilt 2008 · S/N 29-0517N51XMT Bone Flight Services LLC · Santa Monica, CABuilt 2015 · S/N 31-0135N521FHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 29-0521N521SGPerfect Landing Aviation LLC · Highlands Ranch, COS/N 29-0362N523JTAircraft Partner Holdings Inc Trustee · BerlinBuilt 2005 · S/N 29-0380N5251FWaypoint Services LLC · Missoula, MTBuilt 2016 · S/N 29-0525N525VTDsvt Management LLC · Northvale, NJBuilt 2008 · S/N 31-0098N527TMCampbell Air Services Inc · Roseville, CABuilt 2006 · S/N 29-0451N527WMitchell Grayson · Milledgeville, GABuilt 2000 · S/N 29-0224N5285PFrank Investments Inc · Austin, TXBuilt 1996 · S/N 29-0081N5293BBas Part Sales LLC · Greeley, COBuilt 1996 · S/N 29-0080N5295MPrough Aviation LLC · Stephenville, TXS/N 29-0076N52KWFreedom Aviation LLC · Alexander, ARBuilt 2005 · S/N 29-0375N52TFAs The Crow Flies LLC · Belmont, WIBuilt 1998 · S/N 29-0154N533LJHazelhurst Inc · Middletown, DEBuilt 2006 · S/N 29-0443N535CCrystal John · Las Vegas, NVBuilt 1998 · S/N 29-0146N535RFlight Training Pro LLC · Nashville, TNBuilt 2005 · S/N 29-0381N53WMBurns Ivan · Concord, MABuilt 1999 · S/N 29-0191N5515BTwist Air Inc · Overland Park, KSBuilt 2007 · S/N 29-0484N551USFar Side Aero LLC · Santa Maria, CABuilt 2005 · S/N 29-0351N555TJRegistered aircraftBuilt 2000 · S/N 29-0217N557RMWest Street Partners Ltd · Litchfield, CTBuilt 2000 · S/N 29-0210N558RMHoffman Aircraft Sales Corp · Wilmington, DEBuilt 2006 · S/N 29-0474N558USNorth Central Dakota Partners LLC · West Fargo, NDBuilt 2005 · S/N 290358N5611FAdrenaline Airlines LLC · Dallas, TXBuilt 2007 · S/N 31-0043N562BGFalcon Air LLC · Casper, WYBuilt 2007 · S/N 31-0031N565PAJim Mardis Aviation LLC · Mount Dora, FLBuilt 2007 · S/N 31-0056N567RDFranks Properties LLC · Kisciusko, MSBuilt 2008 · S/N 29-0510N571LLDavis Thomas B · Greensboro, NCBuilt 2008 · S/N 31-0080N578TAWag Aviation LLC · Billings, MTFirst renewal noticeS/N 29-0153N57GXJfp Aviation Inc · North Fort Myers, FLBuilt 2005 · S/N 29-0357N57NGAir 500 LLC · Bastrop, TXBuilt 2008 · S/N 31-0119N5816PWolf Michael A · Rutledge, TNBuilt 1996 · S/N 29-0087N595RWCarlgren Jenson E F · Santa Fe, NMBuilt 2005 · S/N 29-0349N59FMCallison Rodney J · Tucson, AZBuilt 1999 · S/N 29-0177N606MRAba Aviation LLC · Navasota, TXBuilt 2015 · S/N 31-0131N606WMHolt Timothy L · Foristell, MOBuilt 1995 · S/N 29-0070N60GXRepp Roger · Aptos, CABuilt 2006 · S/N 29-0440N60TYInternational Air Services Inc Trustee · Carson City, NVS/N 29-0438N611MSSamuel Timothy · Kent, WABuilt 2007 · S/N 31-0016
Back to AD 2012-03-52