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 IPXA2017111523608Light · malfunctionedEMERGENCY LIGHT BY THE ENTRANCE FOUND INOPERATIVE IN AUTO AND MANUAL. PERFORMED AN OPS CHECK OF INTERIOR EMERGENCY LIGHTING IAW AMM 33-50-00, NO DEFECTS NOTED, OPS CHECKED GOOD.SDR DALA2017111508135Battery Pack · inoperativeFOUND THE OVERWING EMERGENCY LIGHTS INOPERATIVE, ALSO LIGHTS IN MID-CABIN INOPERATIVE. REPLACED THE BATTERY AND CHARGER ASSEMBLY IN AFT CARGO BAY. EMERGENCY LIGHTS CHECKED GOOD. REPLACED THE BATTERY PACK AT BS 1045 AND CABIN LIGHTS NOW CHECKED GOOD IAW AMM SDR DALA2017112708329Lens · missingEMERGENCY LIGHTS AT THE LT OVERWING EXIT ROW MISSING BLUE LENSES. INSTALLED IAW AMM 35-51. OPS NORMAL.SDR DALA2017112208277Sign · inoperativeL2 OVERHEAD EXIT SIGN BROKEN. REMOVED AND REPLACED THE SIGN.SDR CALA2017111704085Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M33094 FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2017111704084Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M33407 FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2017111704083Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M33404 FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2017111704080Lamp · burned outEMERGENCY LIGHT NOT ILLUMINATED AT THE L3 DOOR. REPLACED THE LAMP & TESTED NORMAL IAW AMM 33-51-03-960-001, AND 33-51-03-710-001, REV 81.SDR CALA2017111704079Light · crackedR1 DOOR AFT EXIT EMERGENCY LIGHT CRACKED. REPLACED LIGHT ASSY AND OPS TESTED NORMAL IAW AMM 33-51-01-960-802, REV 81.SDR CALA2017111704078Battery Pack · no testBATTERY FAILED A CAPACITY TEST. REPLACED THE BATTERY PACK M33401 & TESTED, FOUND NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2017111704077Battery Pack · no testEMERGENCY BATTERY PACK M33098 FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK. PERFORMED AN INSTALLATION TEST. FOUND NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2017111704076Battery Pack · no testEMERGENCY BATTERY PACK M33097 FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK. PERFORMED AN INSTALLATION TEST. FOUND NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2017111704074Battery Pack · no testEMERGENCY BATTERY PACK M33405 FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK. PERFORMED AN INSTALLATION TEST. FOUND NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2017111704073Battery Pack · no testEMERGENCY BATTERY PACK M334 09 FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK. PERFORMED AN INSTALLATION TEST. FOUND NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2017111704072Battery Pack · no testEMERGNECY BATTERY PACK FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK. PERFORMED AN INSTALLATION TEST. FOUND NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR CALA2017111704071Battery Pack · no testEMERGENCY BATTERY PACK M33408 FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK. PERFORMED INSTALLATION TEST, FOUND NORMAL IAW AMM 33-51-06-960-801, REV 81.SDR CALA2017111704070Charger · inoperativeEMERGENCY LIGHT NOT ILLUMINATED AT 36HJK AND 33HJK CEILING AREA. REPLACED THE CHARGER ASSY & PERFORMED A INSTALLATION TEST. FOUND TO BE NORMAL IAW AMM 33-51-06-960-803, REV 81.SDR AALA201711159016Lens · brokenEMERGENCY EXIT LIGHT AT THE L1 DOOR HAS A BROKEN LENS. REPLACED THE LENS IAW AMM.SDR AALA201711159015Light · obstructedEMERGENCY LIGHT IN CEILING PANEL AT ROW 18 HITS A WIRE BUNDLE WHEN INSTALLING.SDR REXA2017111401178Light · inoperativeLT OVERWING FWD EMERGENCY LIGHT & RT OVERWING AFT EMERGENCY LIGHT DO NOT ILLUMINATE. REPLACED LT FWD EMER LIGHT ASSY & RT AFT EMER LIGHT ASSY PER AMM 33-51-15-400-801.SDR SWAA2017111617850Light · inoperativeRT OVERWING EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017111617849Fuse · blownRT AFT ENTRY EMERGENCY LIGHT INOP. R&R FUSE PER AMM.SDR SIMA20171114001Light · inoperativeFWD FLOOR EMERGENCY LIGHT STRIP INOPERATIVE. R & R THE EMERGENCY LIGHT IAW 33-50-12, OPS CHECKED GOOD.SDR DALA2017111508169Light · detachedDURING INSPECTION, FOUND THE EMERGENCY LIGHT UNDER SEAT 27D WAS DETACHED. MAINTENANCE ATTACHED THE EMERGENCY LIGHT AND OPS CHECKED GOOD.SDR AALA201711159032Light · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS AT SEAT 1D LOOSE. SECURED LIGHT SEGMENT.SDR SWAA2017111517834Cover · detachedMID CABIN EMERGENCY EXIT SIGN LIGHT LENS FELL OFF. INSTALLED THE LENS IAW SIP.SDR DALA2017111508148Battery Pack · inoperativeEMERGENCY CEILING LIGHTS INOPERATIVE ROW 24. REPLACED THE BATTERY PACK. OPS CHECKED GOOD.SDR SWAA2017111517808Bulb · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BULB IAW AMM.SDR DALA2017111508137Bulb · burned outDURING A SERVICE CHECK, ALL BULBS BURNED OUT IN THE EMERGGENCY EXIT SIGN. REPLACED THE BULBS IAW AMM 25-29. OPS CHECKED GOOD.SDR YENA201711140929Power Supply · no testDURING HEAVY MAINTENANCE, EMERGENCY LIGHTS FAILED AN OPS CHECK. R & R ESPU 13WL. OPS CHECKED GOOD IAW AMM 33-51-38. OPENSDR YENA201711140926Bulb · inoperativeRT OVERWING EMERGENCY INTERIOR LIGHT INOPERATIVE. R & R BULBS. OPS CHECKED GOOD IAW AMM 33-51-16.SDR IPXA2017111323542Relay · inoperativeT/S EXIT SIGN FUNCTION USING EXIT SWITCH. C/W T/S PER AWM 33-51-12 AND DETERMINED RELAY 69WL AT FAULT. REQUIRES REPLACEMENT. R&R RELAY 69WL PER ESPM 20-46-50-0101-02 OPS TEST GOOD IAW MM 33-50-00-5.SDR CALA2017111704082Lamp · burned outR3 DOOR AFT EXIT SIGN HAD THREE LAMPS INOPERATIVE. REPLACED THE LAMPS AND OPS TESTED NORMAL IAW AMM 33-51-00-710-801, REV 81.SDR CALA2017111704081Light · brokenA & B ZONE PARTITION EMERGENCY LIGHT FOUND BROKEN. THE EMERGENCY LIGHT WAS REPLACED. OPS TESTED NORMAL IAW AMM 33-51-00-710-801, REV 81.SDR CALA2017111704064Guard · incorrectEMERGENCY LIGHT SWITCH COVER IN CLOSED POSITION TURNS EMERGENCY LIGHTS MANUALLY OFF. GUARD SWITCH WAS ON WRONG SIDE OF THE EMERGANCY LIGHT SWITCH.GUARD SWITCH NOW CORRECTLY FITTED TO CORRECT SIDE.SDR AALA201711159011Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE L1 DOOR NEAR THE FLOOR HAS A BROKEN LENS COVER. INSTALLED NEW LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA201711149035Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT LENS COVER FOUND MISSING BY CABIN CREW AFTER PUSHBACK. INSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA201711149033Lens · detachedAIRCRAFT WAS NOT GROUNDED. AFT L4 DOOR RIGHT EMERGENCY EXIT LIGHT LENS IS BEING HELD UP BY CLEAR TAPE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR AALA201711149032Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R4 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED EXIT SIGN PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017111617856Light · inoperativeEMERGENCY FLOOR MOUNTED EXIT STRIP AT ROW 24 INOP. R&R STRIP IAW AMM.SDR SWAA2017111617855Light · inoperativeLT OVERWING EXIT SIDEWALL LIGHT INOP. R&R LIGHT ASSEMBLY PER AMM.SDR DALA2017111508170Charger · inoperativeDURING INSPECTION, FOUND THE BATTERY CHARGER EIN M01671 INOPERATIVE FOR THE EMERGENCY LIGHTS. MAINTENANCE R & R THE CHARGER AND BATTERY IAW AMM 33-51. OPS CHECKED GOOD.SDR DALA2017111408147Power Supply · inoperativeGALLEY EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY FUSE IAW AMM 33-51-07. PERFORMED SATISFACTORY OPS CHECK IAW AMM 33-51-00.SDR DALA2017111408143Power Supply · inoperativeROW 40, 44, 45 CEILING EMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT IAW WDM 33-51-15. ALL THREE LIGHTS DO NOT RECEIVE POWER. WIRES FROM LIGHT 44 & 45 FOUND TO BE SPLICED TOGETHER. INSTALLED POWER SUPPLY M11649 & BATTERY, OPS CHECKED GOOD.SDR AALA201711149012Light · brokenSEAT ROWS 8 ABC & 30 ABC EMERGENCY LIGHTS FOUND BROKEN. REPLACED THE EMERGENCY LIGHTS IAW AMM.SDR AALA201711149009Lens · missingEMERGENCY LENS MISSING AT SEAT 9E. REPLACED THE LENS IAW AMM.SDR AALA201711149005Ballast · burned outBURNING PLASTIC ODOR AT REAR OF CABIN ON TAKEOFF. FOUND A BAD BALLAST ASSEMBLY. REMOVED AND REPLACED THE OVERHEAD LIGHT ASSEMBLY.SDR HALA2017111308096Sign · detachedR3 DOOR EXIT SIGN DETACHED. SECURED THE SIGN.SDR DALA2017111408093Battery Pack · dischargedEMERGENCY EXIT SIGN L2-791 IS INOPERATIVE. TROUBLE SHOT PER WDM 33-51-12 AND FOUND BATTERY PACK AT B5-259 FOR THE EMERGENCY LIGHTS BAD. REPLACED THE SAME PER AMM 33-51. OPERATIONAL CHECK IS GOOD.SDR DALA2017111308087Battery Pack · dischargedOVERHEAD EMERGENCY LIGHT INOPERATIVE, SEAT 35-37. REMOVED AND REPLACED BATTERY PACK. OPERATION CHECKS GOOD.
Back to JASC 3350