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 AALA2018082219004Power Supply · inoperativeL3 DOOR FORWARD EXIT SIGN WOULD NOT ILLUMINATE. REPLACED THE POWER SUPPLY M33400 AND OPS CHECKED OK IAW AMM 33-51-06-960.SDR DALA2018082105182Lens · damagedEMERGENCY LIGHT LENS DAMAGED. INSTALLED THE LENS.SDR SWAA2018082124313Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018082024312Light · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018082024292Sign · unsecureAFT EXIT SIGN FELL OFF. SECURED SIGN PER SIP.SDR AALA2018082109050Light · brokenSEAT MOUNTED EMERGENCY LIGHT WAS BROKEN AT ROW 8L. MAINTENANCE REPLACED THE LIGHT IAW AMM 33-51-19, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018082105167Light · detachedEMERGENCY LIGHT AT ROW 38B WAS INOPERATIVE. FOUND EMERGENCY LIGHT DETACHED. INSTALLED.SDR DALA201808215165Light · inoperativeEMERGENCY LIGHT AT 30B WAS INOPERATIVE. FOUND THE EMERGENCY LIGHT BLANKET DETACHED AND REINSTALLED.SDR AALA2018082109037Battery · inoperativeFORWARD LT FLIGHT ATTENDANT FLASHLIGHT WAS INOPERATIVE. REPLACED THE FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR AALA2018082109016Battery · inoperativeEMERGENCY LIGHTS AT FIRST CLASS AND MAIN CABIN INOPERATIVE. THE AIRCRAFT WAS GROUNDED. REPLACED EMERGENCY LIGHT BATTERIES M10798, M10799, M10800, M10801 IAW AMM 33-51-07, TESTED NORMAL.SDR AALA2018082109014Battery · inoperativeEMERGENCY LIGHTS AT FIRST CLASS AND MAIN CABIN INOPERATIVE. THE AIRCRAFT WAS GROUNDED. REPLACED EMERGENCY LIGHT BATTERIES M10798, M10799, M10800, M10801 IAW AMM 33-51-07, TESTED NORMAL.SDR AALA2018082190011Battery · inoperativeEMERGENCY LIGHTS AT FIRST CLASS AND MAIN CABIN INOPERATIVE. THE AIRCRAFT WAS GROUNDED. REPLACED EMERGENCY LIGHT BATTERIES M10798, M10799, M10800, M10801 IAW AMM 33-51-07, ALL TESTED NORMAL.SDR ASAA201808205849Light · detachedFA ADVISES EXIT PLACARD NEAR R2 DOOR FELL OFF. ACFT GROUNDED. INSTALLED A NEW EXIT LIGHT ASSY. OPS NORMAL.SDR ASAA2018081825841Nut · missingFA REPORTS EXIT ROW SIGN FELL DOWN AND IS MISSING ITS NUTS. ACFT GROUNDED. INSTALLED EXIT ROW SIGN AT MID CABIN - REF BOEING CMM 25-00-66.SDR AALA2018082019009Battery Pack · no testEMERGENCY CEILING LIGHT ABOVE THE L2 DOOR FAILED A TIME LOAD. MAINTENANCE REPLACED THE M33096 BATTERY PACK IAW AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180819008Battery Pack · no testL2 DOOR EMERGENCY LIGHT FAILED A TIME LOAD TEST. MAINTENANCE REPLACED M33099 BATTERY PACK IAW AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018082005144Lens · missingTHE R1 DOOR EXIT SIGN LENS WAS MISSING. MAINTENANCE INSTALLED A NEW EXIT SIGN LENS IAW AMM 33-51.SDR 2DYA2018082018001Charger · inoperativeEMERGENCY LIGHT FAILED DURING AN OPS CHECK. REMOVED AND REPLACED THE BATTERY CHARGER M737 AT BS 988, WL 20, LBL 32 IAW AMM 33-42-03. OPS CHECKED NORMAL.SDR DALA2018082005140Battery Pack · inoperativeOVERWING AFT EMERGENCY EXIT SIGNS WERE INOPERATIVE. R & R THE BATTERIES IAW AMM 33-50. OPS CHECKED NORMAL.SDR DALA2018082005139Battery Pack · inoperativeCOCKPIT AND FWD GALLEY EMERGENCY LIGHTS INOPERATIVE. R & R THE FWD BATTERY PACKS IAW AMM 33-53. OPS CHECKED GOOD. OK FOR SERVICE.SDR DALA2018083075349Light · detachedSEAT 29D EMERGENCY LIGHT WAS DETACHED. R & R THE HOUSING. OPS CHECKED NORMAL IAW AMM 33-51.SDR UIEA2018082801822Power Supply · inoperativeFOUND EMERGENCY LIGHT INOP CL1854, LI8537. IAW AMM 33-51-04-002-009-001 & 33-51-04-402-012-001 REV 93, REPLACED THE EMERGENCY POWER SUPPLY AND CONDITION CHK NML. IAW AMM 33-51-04-402-012-001 REV 93 PEFORMED POWER SUPPLY TEST, RESULT SATISFACTORY.SDR SIMA2018082017001Light · inoperativeGREEN LIGHT FLOOR EMERGENCY PROXIMITY STRIP FAILS TO ILLUMINATE NEXT TO SEAT 2A AND 3A.-C/A-EMERGENCY FLOOR PROX STRIP AT 2A AND 3A DEFERRED PER MEL 33-30.SDR AALA201808219022Battery Pack · no testEMERGENCY LIGHT M1671 FAILED A FUNCTIONAL CHECK. REPLACED THE BATTERY PACK AND CHARGER IAW AMM 33-51-06.SDR AALA201808219021Battery Pack · no testEMERGENCY LIGHT M1672 FUNCTIONAL CHECK FAILED. REPLACED THE BATTERY PACK, AND CHARGER IAW AMM 33-51-06.SDR AALA201808219020Battery Pack · no testDURING EMERGENCY LIGHT M1694 FUNCTIONAL CHECK, FAILED. THE AIRCRAFT WAS GROUNDED. REPLACED THE BATTERY PACK AND CHARGER IAW AMM 33-51-06.SDR AALA201808217006Battery Pack · inoperativeEMERGENCY LIGHT M1695, FUNCTIONAL CHECK FAILED. THE AIRCRAFT WAS GROUNDED. REPLACED THE BATTERY PACK AND CHARGER IAW AMM 33-51-06.SDR REXA2018082170709Bulb · inoperativeFA REPORTED BULBS OUT ON THE EMERGENCY LIGHT. R & R THE BULBS IAW AMM 33-51-11. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR SWAA2018082024463Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM.SDR SWAA2018082024462Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2018082024461Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR SWAA2018082024456Battery Pack · dischargedR1 DOOR EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018082024455Battery Pack · dischargedLT EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018082024335Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2018082024310Battery Pack · dischargedR2 DOOR EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018082024307Light · looseAFT GALLEY ENTRY DOOR EXIT SIGN ON WALL LOOSE. R&R LIGHT ASSEMBLY IAW AMM.SDR AALA2018082109049Lens · brokenR1 DOOR EMERGENCY LIGHT LENS WAS BROKEN. MAINTENANCE REPLACED EMERGENCY LIGHT LENS IAW AMM 33-51-16, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018082005156Light · unknownEMERGENCY EXIT LIGHT AT ROW 30 LEFT FLICKERS. PERFORMED AN OPS CHECK OF THE EMERGENCY LIGHTS IAW AMM 33-51-00. COULD NOT DUPLICATE THE FAULT. NO HISTORY OR EMER. LIGHTS FLICKERING . ALL CL'S GOOD AT THIS TIME, ACFT OK FOR SERVICE.SDR AALA201808209047Light · damagedSEAT 22L EMERGENCY LIGHT WAS DAMAGED. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19. OPERATIONS OK.SDR AALA201808209029Light · damagedSEAT 8L EMERGENCY LIGHT DAMAGED. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19. OPS OK.SDR AALA201808209027Light · brokenEMERGENCY LIGHT AT SEAT 6L WAS FOUND BROKEN. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19.SDR CALA2018082001830Lamp · inoperativeSEATS 20, 21, AND 28 EMERGENCY LIGHTS WERE INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-11-201. OPS CHECKED OK.SDR CALA2018082001827Lamp · inoperativeLEFT FORWARD OVERWING EMERGENCY LIGHT AFT LAMP WAS INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-51-15-000-001-A, AND 33-51-15-400-001-A. OPS TESTED GOOD.SDR CALA2018082001826Power Supply · inoperativeSEAT MOUNTED EMERGENCY LIGHTS AT SEATS 22ABC THROUGH 28ABC WERE INOPERATIVE. REPLACED THE M1670 POWER SUPPLY ASSY IAW AMM 33-51-06. CHECKED NORMAL.SDR CALA2018082001825Fuse · blownEMERGENCY LIGHT BATTERY CHARGER M1694 HAD FOUR BLOWN FUSES. REPLACED THE FUSES IAW AMM 33-51-06. OPS CHECKED OK. ACP IDT INSP OF REPLACED FUSES IAW GM M 09-10-05, AND AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2018082001822Charger · inoperativeEMERGENCY LIGHTS WERE INOPERATIVE AT ROWS 7 - 14, FOUND THE CHARGER AND BATTERY M1676 BAD, REMOVED AND REPLACED THE CHARGER AND BATTERY IAW AMM 33-51-06-960-805, AND THE LIGHTS CHECKED GOOD. ACCOMPLISHED IDT INSPECTION OF THE EMERGENCY LIGHTS, OPS CHECKED GOSDR CALA2018082001817Charger · inoperativeEMERGENCY LIGHT BATTERY PACK AND CHARGER M1671 WERE INOPERATIVE. REPLACED THE BATTERY CHARGER IAW AMM 33-51-06. OPS CHECKED OK.SDR HNAA2018082000205Light · inoperativeFWD SEAT EMERGENCY LIGHT UNDER COCKPIT DOOR WAS INOPERATIVE. R & R THE EMERGENCY LIGHT.SDR 2DYA2018082017001Battery Pack · inoperativeDURING A SERVICE CHECK, FOUND SEVERAL EMERGENCY LIGHTS INOPERATIVE IN THE MAIN CABIN. REMOVED AND REPLACED THE BATTERY PACKS M732, M1210, M739,M734 AND TESTED GOOD IAW AMM 33-51-07.SDR MASA2018081973493Light · inoperativeEMERGENCY LIGHT STRIP 1A WAS INOPERATIVE.
Back to JASC 3350