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 SWAA2016121210403Battery Pack · dischargedEMERGENCY EXIT LIGHT INOP AT M1673. R&R BATTERY PACK PER AMM.SDR SWAA2016121210402Battery Pack · dischargedEMERGENCY EXIT LIGHT M1674 BATTERY UNIT INOP. R&R BATTERY PACK PER AMM.SDR HALA2016121009770Sign · detachedDOOR 3L EXIT SIGN NOT ATTACHED. RE-INSTALLED EXIT SIGN COVER AT 3L DOOR.SDR AALA20161212009Lens · detachedEMERGENCY EXIT LIGHT FORWARD CABIN GALLEY SIDE AISLE LOWER HAS A DETACHED LENS COVER. REINSTALLED LENS COVER. OPS CHECKED GOOD.SDR AALA20161212008Lens · crackedSEAT MOUNTED EMERGENCY LIGHT AT SEAT 24D HAS A CRACKED LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-60-98. OPS CHECKED GOOD.SDR AALA20161212007Light · brokenEMERGENCY PORTABLE LIGHT ASSEMBLY HAS A BROKEN TIP ON THE BASE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20161212006Sign · crackedEMERGENCY EXIT SIGN RIGHT FORWARD OVERWING DOOR IS BRITTLE AND CRACKED. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20161212004Pin · shearedEMERGENCY EXIT SIGN OVERHEAD AISLE ROW 24 OUTBOARD ATTACH BRACKET ROLL PINS SHEARED. AIRCRAFT GROUNDED. INSTALLED NEW ROLL PINS AND SECURED EXIT SIGN IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR DALA2016121209767Lens · missingSEATS 1C, 2C, 4C, AND 10C EMERGENCY LIGHTS LENSES MISSING. INSTALLED MISSING LENSES.SDR DALA2016120909759Light · inoperativeEMERGENCY ESCAPE LIGHTS SEAT 16 D BROKEN. SECURED THE LIGHT. OPS CHECKED OK.SDR R61A201612090726Light · inoperativeMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT STRIP NEAR SEAT 14 D & F WAS GLOWING. MAINTENANCE ADJUSTED THE LIGHT IAW AMM AND OPS CHECKED GOOD.SDR SWAA2016120910352Lens · crackedLT CABIN OVERHEAD BIN EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 23 TO ROW 27. R&R LENS PER AMM.SDR SWAA2016120910304Lens · crackedRT CABIN OVERHEAD BIN EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 14 TO ROW 25. R&R LENS PER AMM.SDR MASA2016120912540Bulb · inoperativeEMERGENCY LIGHT OUT AT ROW 20. REPLACED THE BULB.SDR MASA2016120912539Light · inoperativeEMERGENCY LIGHT ROW 17 INOPERATIVE.SDR MASA2016120912538Light · inoperativeEMERGENCY LIGHT ROW 12 INOPERATIVE.SDR MASA2016120912537Light · inoperativeEMERGENCY LIGHT ROW 6 INOPERATIVE.SDR CALA2016120901064Battery Pack · faultedEPSU UNIT EMEREMERGENCY LIGHT FAULT ON PTP. REPLACED EMERGENCY LIGHT BATTERY AT 21D. OPS CHECKED NORMAL.SDR CALA2016120901063Battery Pack · faultedEPSU BATTERY FWD LIGHT FAULT ON PTP. REPLACED THE EMERGENCY LIGHT BATTERY . OPS CHECKED NORMAL.SDR CALA2016120901062Battery Pack · no testDURING EMERGENCY LIGHT TEST BATTERY FAULT LEFT MESSAGE. REPLACED BATTERY PACK IN LEFT POWER SUPPLY. OPS CHECKED GOOD.SDR CALA2016120901061Power Supply · faultyEMERGENCY LIGHT TEST SHOWS EPSU EMERGENCY LIGHT FAULT. REPLACED EMERGENCY LEFT POWER SUPPLY AND BATTERY IAW MM 33-51-38 PG.0401. EMERGENCY LIGHT TEST OPS CHECKED NORMAL. REPLACED EMERGENCY LEFT EPSU AND BATTERY IAW MM 33-51-38, PG401.SDR CALA2016120901058Lamp · inoperativeRIGHT FORWARD OVER WING EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP. OP CHECKED OK.SDR CALA2016120901057Lamp · inoperativeEXTERIOR EMERGENCY LIGHTS AT L1 AND R1 DOORS INOPERATIVE. REMOVED AND REPLACED THE LAMPS. TESTED NORMAL IAW AMM 33-51-06.SDR CALA2016120901056Light · looseEMERGENCY CEILING LIGHT AT POS 20LT AND 18RT ON SEAT INOPERATIVE. REPOSITIONED EPL ASSY ON SEAT 18R SECURED ASSY FOUND LOOSE END ON ED2542-D FOR CEILING LIGHT 20LT- SECURED END EMERGENCY LIGHTS CHECKED NORMAL REF B767 AMM 33-51-04, 33-51-10 AND WD 33-51-13.SDR CALA2016120901054Lamp · inoperativeEXTERIOR EMERGENCY LIGHT ON FUSELAGE JUST AFT OF LT WING IS INOPERATIVE. REPLACED THE LAMP AND ACCOMPLISHED SUCCESSFUL OPERATIONAL CHECK IAW AMM 3 3-50-00.SDR CALA2016120901053Lamp · inoperativeEXTERIOR EMERGENCY LIGHT AT DOOR 4L IS INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-04. O PS CHECKED GOOD.SDR CALA2016120901052Lamp · inoperativeEXTERIOR EMERGENCY LIGHT AT POSITION 4L INOPERATIVE. REPLACED THE LAMP. OPS CHECKED GOOD IAW AMM 33-51-04.SDR CALA2016120901051Light · intermittentUPPER LOBE FA CREW REST EMERGENCY LIGHTS AND DECOMP LIGHT CAME ON BREIFLY. RESET SYSTEM, NOW OPERATES AND TESTS NORMALLY.OK FOR SERVICE.SDR CALA2016120901050Light · inoperativeEMERGENCY LIGHT AT LAV 101 INOPERATIVE. REINSTALLED LIGHT ASSY. OP CHECKED OKSDR CALA2016120901049Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE SEAT ROW 41ABC AND 55HJK . REPLACED THE LAMP IAW AMM 33-51-12-422-005. OP CHECKED GOOD IAW AMM 3 3-51-00-735-10SDR AALA20161209013Battery Pack · inoperativeEMERGENCY EXIT LIGHT AT L1 DOOR IS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECKED GOOD.SDR AALA20161209008Lens · missingEMERGENCY EXIT SIGN AT R2 DOOR HAS A MISSING LENS. INSTALLED THE LENS IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR HNAA2016120900378Bulb · inoperativeFLOOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR DALA2017010600147Lens · degradedR1 DOOR EMERGENCY EXIT SIGN LETTERING DEGRADED. INSTALLED LENS IAW ER/A 553401-14.SDR 2DYA20161210007Light · inoperativeDURING DAILY CHECK INSPECTION IN SPN, MAINTENANCE PERSONNEL DISCOVERED ONE EACH EMERGENCY LIGHT OUT IN THE FLIGHT DECK. REMOVED AND REPLACED EMERGENCY LIGHT ASSY AND OPS OK IAW AMM 33-51-00. NO OTHER ISSUES.SDR DALA2016121309822Sign · crackedEXIT SIGN CRACKED AT R1 DOOR. REINSTALLED SIGN.SDR ASOA201612081251Battery Pack · inoperativeRIGHT FWD EMERGENCY LIGHT OUTSIDE SERVICE DOOR INOPERATIVE. EXTERIOR LIGHTS-FWD OVERWING EMERGENCY LIGHT ON EACH SIDE. REMOVED AND REPLACED EPSU BATTERY PACK IAW AMM 33-51-17, AND AIPC 33-51-17 ITEM 6. OPS CHECKED GOOD.SDR DALA2016121209766Battery Pack · inoperativeEMERGENCY BATTERY INOPERATIVE. REMOVED AND REPLACED THE BATTERY AND CHARGER ASSY IAW AMM 25-29-08.SDR SWAA2016120910351Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2016120910350Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2016120910345Battery Pack · failedAFT RT EMERGENCY BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2016120910343Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR SWAA2016120910342Lens · crackedL1 DOOR EMERGENCY EXIT LIGHT SIGN LENS CRACKED. R&R LENS IAW AMM.SDR SWAA2016120910341Lens · brokenR1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. R&R LENS PER AMM.SDR CALA2016120901041Charger · no testOVERWING EMERGENCY EXIT LIGHTS FOUND INOPERATIVE, DURING 2 SERVICE CHECKS BOTH SIDES OF AIRCRAFT. TROUBLESHOOTING FOUND EMERGENCY BATTERY CHARGER M1209 AT FAULT IAW FIM 33-51-00. THE BATTERY CHARGER WAS REMOVED AND REPLACED IAW 33- 51-07 AND TESTED IAW AMM 33SDR AALA201612099011Battery Pack · no testWHILE ACCOMPLISHING A 23 CHECK, THE EMERGENCY POWER SUPPLY UNIT BATTERY AT THE R4 DOOR (18WL) FAILED TO TEST. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201612099002Light · damagedSEAT MOUNTED EMERGENCY LIGHT 8D INOPERATIVE. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-18.SDR FDEA201612084363Lamp · inoperativeAT SERVICE CHECK, FOUND THE L1 DOOR EXTERNAL SLIDE EMERGENCY LIGHT NOT ILLUMINATING WHEN TESTED. REPLACED THE LAMP IAW AMM P2F 33-51-06.201. REV.3.16. OPS CHECKED GOOD.SDR AALA20161209014Lens · detachedEMERGENCY EXIT LIGHT AT SEAT 15A HAS A DETACHED LENS. REPLACED THE LENS IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20161209011Light · detachedEMERGENCY EXIT LIGHT AT LOWER RIGHT AFT GALLEY IS DETACHED. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.
Back to JASC 3350