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 AALA201712079029Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE RIGHT AFT LAVATORY HAS A MISSING LENS COVER. REMOVED AND REPLACED EXIT SIGN PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201712079039Cover · detachedAIRCRAFT WAS NOT GROUNDED. SMALL WHITE EXIT SIGN COVER CAME OFF NEAR 2R DOOR. REPLACED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECKED NORMAL.SDR AALA201712089021Lens · missingAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LENS MISSING AT R2 DOOR. REPLACED LENS COVER AT R2 PER MM 33-51-16.SDR AALA201712089015Battery · dischargedAIRCRAFT WAS GROUNDED. FOUND EMERGENCY LIGHTS AT RIGHT AND LEFT LAVATORY FLOOD EXIT, INOPERABLE. REPLACED POWER SUPPLY AND BATTERY M1210 PER AMM 33-51-07 (SEE ALSO AALA20171206006 FOR POWER SUPPLY - CHARGER).SDR AALA20171206008Power Supply · faultyAIRCRAFT WAS GROUNDED. ESCAPE PATH LIGHT RIGHT HAND ROW 20 AND 21, INOPERABLE. FOUND POWER SUPPLY AT M1209 FAULTY. REPLACED POWER SUPPLY (CHARGER) PER AMM 33-51-07.SDR AALA20171206006Charger · inoperativeAIRCRAFT WAS GROUNDED. FOUND EMERGENCY LIGHTS AT RIGHT AND LEFT LAVATORY FLOOD EXIT, OPERABLE. REPLACED POWER SUPPLY (CHARGER) AND BATTERY M1210 PER AMM 33-51-07 (SEE ALSO AALA201712089015 FOR BATTERY).SDR DALA2017120808483Cover · brokenEMERGENCY EXIT SIGN ROW 26 BROKEN. INSTALLED NEW LIGHT COVER.SDR AALA201712079016Light · brokenAIRCRAFT NOT GROUNDED. SEAT 11C EMERGENCY LIGHT HOUSING BROKEN. REPLACED EMERGENCY LIGHT HOUSING ON SEAT 11C PER CMM 25-22-52.SDR YENA201712060987Battery · failedFT # 2080, FLL-DCA. ALL 6 EMERGENCY LIGHT POWER UNITS FAILED TO STAY ON MORE THAN 15 MINUTES PER FUNCTIONAL TEST STEP 8 OF TASK CARD E190-33-50-01-720-801-M. R & R EMERGENCY-LIGHT POWER UNIT 1 & 2 IAW AMM 33-50-01. OPS CHECK NORMAL. R & R EMERGENCY-LIGHT POWERSDR YENA201712060986Battery · failedFT # 2080, FLL-DCA. ALL 6 EMERGENCY LIGHT POWER UNITS FAILED TO STAY ON MORE THAN 15 MINUTES PER FUNCTIONAL TEST STEP 8 OF TASK CARD E190-33-50-01-720-801-M. R & R EMERGENCY-LIGHT POWER UNIT 1 & 2 IAW AMM 33-50-01. OPS CHECK NORMAL. R & R EMERGENCY-LIGHT POWERSDR YENA201712060985Battery · failedFT # 2080, FLL-DCA. ALL 6 EMERGENCY LIGHT POWER UNITS FAILED TO STAY ON MORE THAN 15 MINUTES PER FUNCTIONAL TEST STEP 8 OF TASK CARD E190-33-50-01-720-801-M. R & R EMERGENCY-LIGHT POWER UNIT 1 & 2 IAW AMM 33-50-01. OPS CHECK NORMAL. R & R EMERGENCY-LIGHT POWERSDR YENA201712060984Battery · failedFT # 2080, FLL-DCA. ALL 6 EMERGENCY LIGHT POWER UNITS FAILED TO STAY ON MORE THAN 15 MINUTES PER FUNCTIONAL TEST STEP 8 OF TASK CARD E190-33-50-01-720-801-M. R & R EMERGENCY-LIGHT POWER UNIT 1 & 2 IAW AMM 33-50-01. OPS CHECK NORMAL. R & R EMERGENCY-LIGHT POWERSDR AALA201712079020Light · inoperativeAIRCRAFT WAS NOT GROUNDED. SEAT 24H EMERGENCY LIGHT WAS FOUND INOPERATIVE. THE SEAT 24H EMERGENCY LIGHT WAS REPLACED IAW MM 33-60-98.SDR MASA2017120612819Light · inoperativeROW 14 LT FLOOR LEVEL EMER LIGHT INOP.SDR YENA201712060982Battery · failedFT 225, JFK-TPA. EMERGENCY LIGHT FAILS TEST. R&R EMERGENCY LIGHT BATTERY AT EPSU 10WL BITE AND OPS CKS GOOD IAW AMM 33-51-38.SDR JJBA20171207006Bulb · inoperativeCABIN EMERGENCY PASSAGEWAY EXIT C/D SIDE INOP R&R BULB OPS CHECK SAT.SDR JJBA20171206005Bulb · inoperativeEMERGENCY LIGHT OVER AT 18A INOP. RR LIGHT BULB, OPS CHECK SAT.SDR JJBA20171206004Bulb · inoperativeEMERGENCY LIGHT OVER SEAT 18A INOP. R&R EMERGENCY LIGHT BULB. OPS CHECK SAT.SDR MASA2017120612818Lamp · inoperativeAFT EMERG FLOOD LIGHT INOP. RELAMPEDSDR JJBA20171206003Light · inoperativeENTRY DOOR EMERGENCY LIGHT INOP. R&R LIGHT BULB. OPS CHECK SAT.SDR AALA201712079014Sign · unsecureAIRCRAFT WAS NOT GROUNDED: R1 DOOR, LOWER EMERGENCY EXIT SIGN NOT SECURED. MAINTENACE REPLACED LOWER EMERGENCY LIGHT ASSEMBLY PER 33-51-16 AND PERFORMED SUCCESSFUL OPERATIONAL CHECK.SDR AALA20171214012Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHT ON R4 DOOR IS INOPERATIVE., INSTALLED SERVICEABLE LAMP AND OPS CHECKED GOOD IAW AMM.SDR AALA20171214011Lamp · inoperativeAIRCRAFT IN BASE MAINTENACE. EMERGENCY LIGHT AT THE LT OVERHEAD CEILING PANEL AT SEAT 5A WAS INOPERATIVE., INSTALLED A SERVICEABLE LAMP IAW AMM 33-51-00, OPS CHECKED GOOD.SDR AALA20171214010Light · inoperativeAFT EMERGENCY AISLE LIGHT IN SEAT 5J IS INOPERATIVE., INSTALLED A NEW AISLE LIGHT ASSEMBLY AND TESTED GOOD IAW AMM 33-51-00.SDR AALA20171214009Lamp · inoperativeEMERGENCY LIGHT ON THE LT SIDE OF AIRCRAFT BETWEEN WING T/E AND BULK CARGO DOOR ARE INOPERATIVE, INSTALLED SERVICEABLE LAMPS AND OPS CHECKED GOOD IAW AMM 33-51-00.SDR SWAA2017121118298Battery · no testFORWARD L/H BATTERY FAILED TIME TEST. / R&R BATTERY PER AMM.SDR DALA2017120708491Fuse · open(AIRCRAFT 697, L/P 3158337) EMER LIGHT IN BULL NOSE INOP AT ROW 23RT. REPLACED OPEN FUSE AT BATTERY PACK. OPERATIONAL TEST OK PER B757 AMM 33-51.SDR AALA20171206009Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT BROKEN AT THE FORWARD GALLEY CLOSET ACROSS FROM L1 DOOR FORWARD LIGHT CAPSULE. REPLACED EMERGENCY PROXIMITY LIGHT ASSEMBLY PER MM 33-51-05.SDR AALA20171206007Charger · inoperativeAIRCRAFT WAS GROUNDED. ESCAPE PATH LIGHT RIGHT HAND ROW 25 THRU 35, INOPERABLE. FOUND FAULTY POWER SUPPLY AT M1209. REPLACED POWER SUPPLY (CHARGER) PER AMM 33-51-07.SDR DALA2017120608482Battery Pack · dischargedL2 DOOR EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY PACK B5-241 PER MM. OPERATION CHECKS GOOD.SDR AALA201712079015Lens · missingAIRCRAFT NOT GROUNDED. 2L EXIT LIGHT COVER MISSING. REPLACED LIGHT COVER.SDR AALA201712089016Cover · unsecureAIRCRAFT WAS NOT GROUNDED: 4L EXIT COVER HAD FALLEN OFF. RESECURED 4L EXIT COVER PER MM 33-50-00.SDR REXA2017120501228Lens · damagedDURING PAINT NOTICED EMERGENCY LIGHT LENS BEHIND RH SERVICE DOOR DAMAG
ED
R AND R EMERGENCY LIGHT LENS IAW AMM 33-51-15 SEE IAC WC#4245 FOR DETA
ILSSDR AALA201712079004Light · unsecureAIRCRAFT WAS NOT GROUNDED: R4 EMERGENCY EXIT SIGN FELL OFF. MAINTENANCE REPLACED EMERGENCY EXIT LIGHT (EXIT IDENTIFIER) PER AMM 33-51-01 AND PERFORMED SUCCESSFUL OPERATIONS CHECK.SDR AALA201712079006Lens · looseAIRCRAFT WAS NOT GROUNDED. EXIT LIGHT LOCATED AT 3L DOOR IS OFF FRAME. RESECURED EXIT LENS.SDR DALA2017120608475Charger · inoperativeEMERGENCY LIGHTS ARE INOPERATIVE JUST AFT OF THE LEFT TRAILING EDGE FLAP. REPLACED CHARGER SYSTEM OPERATION IS NORMAL.SDR ASAA2017120522808Lens · detachedFLIGHT ATTENDANTS REPORT EXIT ROW LIGHT COVER AT SEAT 17A FELL OFF. GROUNDED - YES. REINSTALLED EXIT ROW LIGHT COVER AT SEAT 17A. OP'S CHECK GOOD. REF AMM 33-51-01.SDR UIEA2017120502358Light · detachedL1 DOOR EMERGENCY EXIT LIGHT ASSEMBLY DETACHED FROM SIDE WALL (<P>RE-SECURED LIGHT ASSY AT C1 DOOR EMERGENCY EXIT OK FOR SERVICE </P>)SDR ASOA201712054064Battery Pack · weakIAH- DURING MAINTENANCE INSPECTION THE EMERGENCY LIGHT BATTERY PACKS AT LOCATIONS 3 & 4 WERE FOUND TO BE NOT HOLDING A CHANRGE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BATTERY PACKS, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR SDR ASOA201712054063Battery Pack · weakIAH- DURING MAINTENANCE INSPECTION THE EMERGENCY LIGHT BATTERY PACKS AT LOCATIONS 3 & 4 WERE FOUND TO BE NOT HOLDING A CHANRGE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BATTERY PACKS, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR SDR SWAA2017120718288Light · inoperativeRT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR AALA201712069024Cover · missingAIRCRAFT WAS NOT GROUNDED, MISSING EXIT SIGN COVER AT LAVATORY 2R. REINSTALLED EXIT SIGN COVER PER AMM 33-00-00.SDR AALA201712069018Battery · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY LIGHTS, WITH SWITCH ON, ARE INOPERATIVE FROM ROW 16 TO AFT GALLEY. REPLACED BATTERY AT LEFT HAND AFT LAVATORY PER MM 33-51-07 AND 33-51-00. (SEE ALSO AALA20171206002)SDR AALA20171206002Battery · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY LIGHTS, WITH SWITCH ON, ARE INOPERATIVE FROM ROW 16 TO AFT GALLEY. REPLACED BATTERY AT 17D PER MM 33-51-07 AND 33-51-00. (SEE ALSO AALA201712069018).SDR AALA20171206001Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. BUSINESS CLASS EMERGENCY LIGHTS INOPERATIVE WITH SWITCH ON. REMOVED AND REPLACED BATTERY ABOVE 1B PER MM 33-51-07 AND 33-51-00.SDR DALA2017120608459Battery Pack · dischargedR4 DOOR EMERGENCY EXIT SIGN LIGHT IS OUT. R&R BATTERY PACK M1210 PER AMM 33-51 R4 DOOR EMERGENCY LIGHT OPS CK GOOD A/C OK FOR SVC.SDR ASAA2017120522792Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN AT R-2 DOOR HAS DAMAGED LENS. GROUNDED - YES. REMOVED AND REPLACED LENS AND TESTED LIGHT ASSY PER AMM 33-51-01-960-801 - OPS NORMAL.SDR ASAA2017120522780Lens · detachedEMERGENCY LIGHT EXIT LOCATOR SIGN ON #4 GALLEY ADJACENT TO R-2 DOOR IS MISSING LENS. GROUNDED - YES. REPLACED LENS AND TESTED LIGHT ASSY PER B737-800 AMM 33-51-01-960-801 - OPS NORMAL.SDR ASAA2017120522779Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN ON #4 GALLEY ADJACENT TO L-2 DOOR HAS BROKEN LENS. GROUNDED - YES. REMOVED AND REPLACED LENS AND TESTED LIGHT ASSY PER B737-800 AMM 33-51-01-960-801 - OPS NORMAL.SDR FDEA201712053334Light · inoperativeLT DOOR CEILING EMERGENCY LIGHT OUT. AMM: 33-51-03-2, RELAMPED EMERGENCY LIGHT ABOVE L1 DOOR. OPERATIONAL CHECKS GOOD. OK FOR SERVICE.
Back to JASC 3350