JASC 3350
Service difficulty reports · 225,886
Reports filed under 3350 · Emergency Lighting, newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '3350' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '3350' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR SWAA2017103017434Battery Pack · no testBATTERY PACK M1672 FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR AALA201710269020Sign · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN NEAR THE R2 DOOR IS DAMAGED. REMOVED AND REPLACED EXIT SIGN PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201710259028Light · missingMISSING EMERGENCY EXIT LIGHT AT SEAT 11C. REPLACED THE LIGHT IAW AMM 33-51-19.SDR AALA20171024005Light · missingEMERGENCY EXIT, SEAT 11C MOUNTED LIGHT MISSING. REPLACED THE LIGHT IAW AMM 33-51-19.SDR SWAA2017102617412Lens · missingL2 EXIT SIGN COVER LENS MISSING. INSTALLED COVER IAW AMM.SDR SWAA2017102617395Cover · missingMID CABIN EXIT SIGN COVER MISSING. INSTALLED COVER PER AMM.SDR AALA201710269003Cids · malfunctionedAIRCRAFT WAS NOT GROUNDED. EXIT SIGNS "ON" DURING FLT AT 1L, 2R, 3L. ALL OTHERS OFF. RESET CIDS. OK FOR SERVICE.SDR AALA201710259027Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE R2 DOOR HAS A MISSING LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR DALA2017102507778Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 23B. REPLACED THE LENS IAW AMM 33-51.SDR MASA2017102412718Power Supply · inoperativeROW 3 OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED THE HR 2 POWER SUPPLY.SDR FDEA201710243033Lamp · inoperativeR1 EMERGENCY SLIDE LIGHT INOPERATIVE DURING A TEST. REPLACED THE LAMP AND OPS CHECKED NORMAL IAW MM 33-51-06. ACFT OK FOR SERVICE.SDR YENA201710240860Battery Pack · no testEPSU BATTERY 13WL FAILED AN EMERGENCY LIGHT TEST. R & R EPSU BATTERY IAW AMM 33-51-38. BATTERY AND SYSTEM OPS CHECKED GOOD.SDR RAIA201710230001Inverter · inoperativeFWD CEILING EMERGENCY SIGN ADJACENT TO GALLEY INOPERATIVE. SECURED THE CONNECTOR ON THE SIGN, R & R THE NR 1 INVERTER, OPS CHECKED GOOD.SDR ASOA201710232009Power Supply · inoperativeDURING OPS TEST OF THE EMERGENCY POWER SUPPLY UNIT. FOUND THE EPSU FAILED THE OPS CHECK.SDR AALA201710249014Socket · inoperativeAIRCRAFT WAS NOT GROUNDED. EXTERIOR EMERGENCY EXIT LIGHT AT THE LEFT AFT ENTRY DOOR IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY (SOCKET) AT L397 PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20171023006Light · damagedAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT LIGHT AT THE RIGHT AFT OVERWING EXIT ON THE SIDEWALL IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR ASAA2017102322310Lens · detachedEXIT LIGHT LENS DETACHED AT ROW 16 DEF. ACFT GROUNDED. INSTALLED LENS.SDR AALA201710249003Lens · looseR4 DOOR, SMALL PLASTIC EMERGENCY EXIT SIGN BROKEN. SECURED THE EMERGENCY EXIT SIGN GUARD IAW AMM.SDR SWAA0224100117362Cover · unsecureCENTER AISLE EMERGENCY EXIT SIGN COVER FELL OFF. INSTALLED COVER PER SIP.SDR AALA201710249007Light · unsecureLOOSE EMERGENCY LIGHT AT SEAT 11C. SECURED THE EMERGENCY LIGHT IAW AMM 25-62-00.SDR FDEA201710233029Power Supply · failedR1 DOOR EMERGENCY EXIT SIGN INOPERATIVE, AND R1 DOOR EXTERIOR EMERGENCYLIGHT INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY M730 IAW AMM 33-51-07-2-0. ALL EMERGENCY LIGHTS CHECKED NORMAL.SDR DALA2017102407753Battery Pack · inoperativeFWD UPPER EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERIES IAW AMM 33-53-00. CHECKED GOOD.SDR DALA2017102407744Lens · missingR3 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR GTIA2017102302211Epsu · faultyDURING TC 335100-03-1 FOUND EPSU 10WL AND 13WL WITH FAULTS. R&R EPSU 10WL AND 13WL IAW AMM 33-51-38. OPC GOOD.SDR MASA2017102312715Light · inoperativeROW 17 CEILING EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR CALA2017102303769Battery · dischargedFWD L EMER LIGHT BATTERY FAULT. REPLACED BATTERY TEST OK.SDR CALA2017102303765Light · detachedROW 20 EMERG EXIT ROW LITE IS DETACHED. ATTACHED ROW 20 EMERGENCY EXIT LIGHT.SDR CALA2017102303756Light · inoperativeROW 20ABC - EMERGENCY EXIT DOOR LIGHT INOP. RELAMPED - OPS GOOD.SDR CALA2017102303755Light · looseRIGHT SIDE AFT EMERGENCY EXIT DOOR SLIDE LIGHT INOP. SECURED LAMP IN SOCKET. INDICATED SLIDE LIGHT OPS CHECKS GOOD. REF MM 33-51-06.SDR CALA2017102303754Light · inoperativeR1 EMERGENCY SLIDE LIGHT INOP. REMOVED AND REPLACED LAMP AT INDICATED SLIDE LIGHT ASSY. OPS CHECKS GOOD. REF MM 33-51-06.SDR CALA2017102303753Light · inoperativeSMALL SQUARE EMERGENCY EXIT LIGHT ABOVE DOOR 2L INOP. GROUND CHECKS NORMAL.SDR CALA2017102303752Light · inoperativeR2 DOOR SLIDE EMERGENCY EXIT LIGHT INOP. RELAMPED R2 DOOR SLIDE EMERGENCY EXIT LIGHT. OPS CKS GOOD AT THIS TIME.SDR CALA2017102303750Lens · loose20F EMERGENCY SIGN FALLING DOWN REATTACHED LENS COVER, CHECKS GOOD.SDR CALA2017102303770Light · intermittent2R SLIDE LIGHT INTERMITTENT OVER DOOR PERFORMED PASSENGER DR ESCAPE SYSTEM CHECK IAW AMM 25-66-01. SYSTEM CHECKED OK. NO DEFECTS NOTED.SDR CALA2017102303768Battery · failedLEFT AND AFT EMERGENCY LIGHT BATTERYS FAIL CAPACITY CHECK. REMOVED AND REPLACED LEFT AND AFT EMERGENCY LIGHT BATTERYS REF AMM 33-51-38 PB401 OPS CHECK OK.SDR CALA2017102303767Battery · dischargedDOOR 1 LEFT EMERGENCY LIGHT CIDS MSG ON SIDS PANEL. R&R EMERGENCY BATTERY AND CONTROLLER.SDR CALA2017102303766Power Supply · faultySOME EMERGENCY LIGHTS STAY ON IN REAR OF CABIN. REMOVED AND REPLACED POWER SUPPLY AND BATTERY AT 11WL IAW AMM 33-51-15.SDR CALA2017102303764Light · inoperativeRT FWD OVERWING EMERGENCY LIGHT INOP. RELAMPED EMERGENCY LIGHT REF AMM 33-51-04-960-801. OPS CK GOOD.SDR CALA2017102303763Light · inoperativeAFT EMERGENCY EXIT SEAT LIGHT INOP AT 20C. REPLACED RED LENS AND BOTH BULBS. EMERGENCY EXIT SEAT LIGHTS OP CHECK NORMAL.SDR CALA2017102303761Light · inoperativeAFT EMERGENCY EXIT SEAT LIGHT INOP AT 15C. REPLACED AFT EMERGENCY EXIT SEAT LIGHT ASSY (RED) AT 15C. EMERGENCY EXIT SEAT LIGHTS OP CHECK NORMAL.SDR KCSA201710231072Light · inoperativeMAIN DECK DOOR L1 THRESHOLD OVERHEAD EMERGENCY LAMP IS INOP AT STA 464 ON CEILING IN THE MAIN CARGO DECK.SDR SWAA2017102317318Sign · unsecureL1 DOOR EMERGENCY EXIT SIGN LIGHT FELL OFF. R&R SIGN IAW SIP.SDR MASA2017102312714Light · inoperativeROW 18 CEILING FLOOD LIGHT INOPERATIVE. SDR DALA2017102307715Wire Harness · damagedCABIN EMERGENCY LIGHT AT SEAT 27D INOPERATIVE. REPLACED THE SEAT WIRE HARNESS AND LIGHT ASSY IAW AMM 33-53. OPS NORMAL.SDR DALA2017102307713Battery Pack · inoperativeOVERHEAD TAIL CONE EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERIES, OPS CHECKED LIGHTS AND BATTERY CHARGER IAW AMM 33-50.SDR YENA201710230856Battery Pack · no testEPSU BATTERY 12WL FAILED AN EMERGENCY LIGHT TEST. R & R THE BATTERY IAW AMM 33-51-38. SYSTEM OPS CHECKED GOOD.SDR AALA201710249010Light · inoperativeAIRCRAFT WAS NOT GROUNDED. INOPERABLE FLOOR PROXIMITY EMERGENCY ESCAPE PATH LIGHT AT ROW 14. REPLACED SEAT 14ABC EMERGENCY PATHWAY LIGHT ASSEMBLY PER AMM 33-51-19.SDR AALA201710239047Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ON THE SIDE OF THE R1 DOOR HAS A MISSING LENS COVER. REPLACED LENS COVER. OPERATIONAL CHECK GOOD.SDR DALA2017102307771Power Supply · inoperativeEMERGENCY LIGHTS AT 1A-3A ARE INOPERATIVE. FOUND THE POWER SUPPLY INOPERATIVE. REPLACED THE POWER SUPPLY AND THE SYSTEM OPS NORMAL.SDR AALA201710239026Lens · missingEMERGENCY EXIT SIGN AFT SIDE OF THE R4 DOOR, LENS MISSING. REPLACED EMERGENCY EXIT SIGN LENS.
Back to JASC 3350