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 CALA2017040700917Light · inoperativeEMERGENCY EXIT DOOR FWD LEFT LIGHT INOP. RELAMPED FWD LEFT FLOURO TUBE IN OVERWING EXIT DOOR ASSY. CHECKS NORMAL.SDR CALA2017040700914Warning System · false activationEMERG LIGHT EICAS MESSAGE ON RECALL. EMERG LIGHTS OPERATIONAL TEST GOOD PER AMM 33-51-00. EICAS NOT ILLUMINATED ON RECALL.SDR CALA2017040700913Unknown · malfunctionedAFTER LANDING ON ROLLOUT EMERG EXITS CYCLED ON OFF 3 TIMES FOR NO REASON. C/OUT EMERG LIGHTS OPERATIONAL TEST IAW AMM 33-51-00-710-801 SATIS. TOMC CONSULTED- NIL HISTORY OF DEFECT NOTED. SATIS TO CONTINUE.SDR CALA2017040700912Fuse · faultyLEFT, OVERWING EMERGENCY LIGHTS INOP AT BODY FLARING PANEL. FOUND FUSE IN POWER SUPPLY M7919 OPEN, REPLACED FUSE REF SSM 33-51-01.SDR CALA2017040700907Battery · dischargedEMERGENCY EXIT DOOR LIGHT BATTERIES FAILED CAPACITANCE TEST AT FWD AND AFT POSITIONS REF JC JE18-2428-1-6192. CHANGE EMERGENCY EXIT DOOR LIGHT BATTERIES AT LOCATION FWD AND AFT REF AMM 33-51-38. TEST PASSED.SDR CALA2017040700905Switch · brokenFT ATTENDANTS PANEL EMERGENCY LIGHT SWITCH IS BROKEN . REMOVED AND REPLACED THE PANEL IAW AMM 23-73-13-000- 001-A, AND AMM 23-73-13-400-001-A, OP TESTED GOOD IAW AMM 23 -73-00-740-005-A.SDR CALA2017040700903Battery Pack · no testEMERGENCY LIGHTS FAILED TO TEST. REPLACED THE AFT LEFT POWER SUPPLY BATTERY PACK. OP CHECKED NORMAL.SDR QXEA2017040700223Lens · brokenEMERGENCY EXIT LIGHT AT THE LOWER CORNER OF THE RIGHT EMERGENCY EXIT IS CRACKED AND HAS A BROKEN BASE PLATE. REPLACED DAMAGED ASSEMBLY IAW CMM 25-23-29. PERFORMED OPERATIONAL CHECK IAW AMM 33-51-00-710-801. CHECKS GOOD. RETURNED TO SERVICE.SDR YENA201704070246Battery Pack · no testDURING ROUTINE MAINTENANCE, EMERGENCY LIGHTS FAILED TO TEST. R & R THE EPSU BATTERY AT 10WL,11WL,AND 13WL. CHECKED GOOD IAW AMM 33-51-38.SDR YENA201704070245Battery Pack · no testDURING ROUTINE MAINTENANCE, EMERGENCY LIGHTS FAILED TO TEST. R & R THE EPSU BATTERY AT 10WL,11WL,AND 13WL. CHECKED GOOD IAW AMM 33-51-38.SDR YENA201704070244Battery Pack · no testDURING ROUTINE MAINTENANCE, EMERGENCY LIGHTS FAILED TO TEST. R & R EPSU BATTERY AT 10WL,11WL,AND 13WL CHECKED GOOD IAW AMM 33-51-38.SDR REXA2017040600526Light · inoperativeLT EMERGENCY LIGHT BEHIND OVERWING EXIT IS OUT. REPLACED BULB IN LT AFT OVERWING EXIT LIGHT IAW AMM TASK 33-51-21-400-801 OPS CK GOOD.SDR REXA2017040600482Fuse · inoperativeLEFT CENTER OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE NR 3 FUSE IN THE NR 3 BATTERY CHARGER IAW CMM 33-21-70. OPS TESTED GOOD IAW AMM 33-51-00-710-801.SDR AALA201704079003Battery Pack · no testON CIDS, AFT LEFT EMERGENCY POWER SUPPLY BATTERY 13WL FAILED SYSTEM TEST. REPLACED THE BATTERY PACK IAW AMM 33-51-38.SDR SWAA2017041013056Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01673. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017041013055Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01669. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017041013054Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01672. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017041013053Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01675. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017041013052Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01668. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017041013044Lens · missingR1 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED LENS IAW SIP.SDR SWAA2017041013040Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01670. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017041013039Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01674. R & R THE BATTERY PACK IAW AMM.SDR HNAA2017041000115Battery Pack · inoperativeRIGHT AFT EMERGENCY LIGHT INOPERATIVE ON FUSELAGE. R & R THE BATTERY PACK PS4 AT CEILING ROW 8.SDR AALA201704079007Lens · brokenEMERGENCY EXIT SIGN BROKEN AT THE R4 DOOR. REPLACED THE DAMAGED LENS.SDR DALA2017040702843Light · damagedSEAT 1A FWD EMERGENCY LIGHT DAMAGED, REINSTALLED 1A EMERG. LIGHT & TESTEDSDR DALA2017040702844Lens · missingEMERGENCY SEAT MOUNTED PATH LIGHTING (RED) MISSING, REPLACED LENS.SDR AALA201704079029Light · brokenMID CABIN LAV 4F-RC FLOOR PROX LIGHT 1 EACH FOUND BROKEN. MAINTENANCE REMOVED AND REPLACED WITH NEW PROX LIGHT IN MID CABIN LAV 4F-RC 1 EACH IAW 33-51-05-960-802, OPS CHECKED GOOD. AIRCRAFT IN BASE MAINTENANCE.SDR AALA201704079028Light · brokenMID CABIN LAV 3F-LC FLOOR PROX LIGHT 1 EACH FOUND BROKEN. MAINTENANCE REMOVED AND REPLACED WITH NEW PROX LIGHT IN MID CABIN LAV 3F-LC FLOOR 1 EACH IAW 33-51-05-960-802, OPS CHECKED GOOD. AIRCRAFT IN BASE MAINTENANCE.SDR CALA2017040700877Light · damagedEMERGENCY LIGHTS FAILED TEST. REPLACED THE LIGHT ASSY AND TESTED NORMAL IAW AMM 33-51-06-902-082, REV 196, & AMM 33-51-06-902-100, REV 196.SDR CALA2017040700866Light · inoperativeFOUND CABIN EMERGENCY LIGHT INOPERATIVE. REPLACED THE LIGHT AND OPS TESTED NORMAL IAW AMM 33-51-12-332-001, REV 87.SDR CALA2017040700865Lamp · inoperativeEMERGENCY LIGHT FOUND INOPERATIVE AT 6J. REPLACED THE LAMP AND OPS TESTED NORMAL IAW AMM 33-51-12-332-001, REV 87.SDR CALA2017040700864Fuse · inoperativeEMERGENCY LIGHTS L329 & L738 FOUND INOPERATIVE. REPLACED THE FUSE AND TESTED NORMAL IAW AMM 33-51-00-715-001, REV 196.SDR CALA2017040700863Light · inoperativeFOUND 20JK, 33JK, AND 37JK SEAT EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LIGHTS AND TESTED NORMAL IAW CMM 25-24-68, REV 2.SDR CALA2017040700861Battery Pack · dischargedEMERGENCY LIGHTS INOPERATIVE, RT SIDE FIRST AND BUSINESS CLASS. REPLACED THE BATTERY PACK AND FOUND NORMAL IAW AMM 33-51-07-422-007-002, REV 196 , AMM 25-25-06-701-801, REV 196, WDM 33-51-12-001, REV 132 & CMM 25-28-72, REV 5.SDR 7C7A2017040600304Battery Pack · dischargedFWD LEFT OUTSIDE EGRESS AND LEFT LOWER EXIT EMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED THE BATTERY PACK . OPS CHECKED NORMAL IAW MM 33-51-00.SDR SIMA20170406003Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-10 , OPS CHECKED GOOD.SDR SIMA20170406002Light · crackedROWS 5 DC AND 6 DC EMERGENCY LIGHT CRACKED. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-01.SDR AALA201704079001Lens · detachedEMERGENCY EXIT SIGN FELL OFF THE L3 DOOR. ATTACHED THE EMERGENCY SIGN COVER.SDR DALA2017040702819Lens · looseEMERGENCY EXIT LENS LOOSE. SECURED EMERGENY LENS AT SEAT 44D.SDR DALA2017040702816Light · damagedSEAT 36D MOUNTED EMERGENCY LIGHTING DAMAGED. REPLACED EMERGENCY LIGHT ASSY. OPS CHECKED GOOD.SDR SWAA2017040713026Lens · looseCEILING EXIT ROW SIGN LENS LOOSE. R & R THE SIGN IAW MM.SDR JJBA20170406006Light · malfunctionedFWD EMERGENCY LIGHT AT ROW 18 INOPERATIVE. IAW MX CONTROL, CYCLED EMERGENCY LIGHTS, OPS CHECKED GOOD. NO MX ACTION REQUIREDSDR YENA201704060248Battery Pack · failedDURING PRE DEPARTURE CHECKLIST, FOUND EMERGENCY LIGHTS INOPERATIVE AT OVERWING EXIT ROW SEATS. REMOVED & REPLACED ESPU & BATTERY AT 13WL.SDR YENA201704060247Power Supply · failedPRE DEPARTURE CHECKLIST FOUND EMERGENCY LIGHTS INOPERATIVE AT THE OVERWING EXIT ROWS, & SEATS. REMOVED & REPLACED THE ESPU & BATTERY AT 13WL & 12WL.SDR MASA2017040612723Light · inoperativeROW 17 CEILING LEVEL EMER FLOOD LT INOP. PLACED ON MEL.SDR DALA2017040602773Lamp · inoperativeONE RED EMERGENCY LIGHT ON SEAT 24D INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-53. CHECKED GOOD.SDR SWAA2017041813165Lamp · inoperativeL2 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR AALA20170410007Battery Pack · dischargedDOOR R4 EMER LT POWER PACK M33409 FOUND LOW CAPACITY. DOOR R4 EMER LT POWER PACK M33409 REPLACED. INSTALLATION TEST CARRIED OUT AND RESULT NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170410006Battery Pack · dischargedDOOR R3 EMER LT POWER PACK M33401 FOUND LOW CAPACITY. DOOR R3 EMER LT POWER PACK M33401 REPLACED. INSTALLATION TEST CARRIED OUT AND RESULT NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170410005Battery Pack · dischargedDOOR L3 EMER LT POWER PACK M33406 FOUND LOW CAPACITY. DOOR L3 EMER LT POWER PACK M33406 REPLACED. INSTALLATION TEST CARRIED OUT AND RESULT NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.
Back to JASC 3350