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 SWAA2017041213078Battery Pack · inoperativeLEFT FWD EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW MM.SDR AALA20170410008Battery Pack · dischargedEMERGENCY LIGHTS INOP AT MID GALLEY OVERHEAD. R&R BATTERY PACK B5-107. LIGHTS OP CK OK. THE AIRCRAFT WAS NOT GROUNDED.SDR HALA2017041000095Power Supply · inoperativeFOUND 2 EMERGENCY LIGHTS INOP. RIGHT SIDE WING SLIDE ILLUMINATION LIGHTS. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY (M733) PER AMM 33-51-07. OPS CHECK GOOD, OK FOR SERVICE.SDR AALA201704119004Light · brokenAIRCRAFT WAS GROUNDED. EMERGENCY LIGHT AT LAV L38 IS BROKEN. LIGHT ASSEMBLY IN LAVATORY L38 WAS REPLACED.SDR AALA201704119003Sign · unsecureAIRCRAFT WAS NOT GROUNDED. EXIT SIGN FROM DOOR 3RH NEEDS TO BE REATTACHED. REATTACHED EXIT SIGN.SDR AALA201704119002Sign · unsecureAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN 3L FELL OFF. REATTACHED 3L EMERGENCY EXIT LIGHT COVER.SDR SWAA2017041113057Light · looseMID CABIN CEILING EMERGENCY EXIT LIGHT ASSY LOOSE. SECURED LIGHT ASSY PER MM.SDR CALA2017041000952Switch · faultyWHEN TURNING OFF EMERG LIGHTS, LIGHTS ALL COME ON WHEN SWITCHED TO OFF. T/S AND FOUND EMERGENCY LIGHT SWITCH ON OVHD PANEL AT FAULT. REMOVED AND REPLACED WINDOW HEAT, EMERGENCY LIGHTS, PAX OXY, FLT DECK DOOR, SERVICE INTERPHONE AND BATTERY CONTROL PANEL REF AMSDR CALA2017041000951Director · malfunctionedEMERGENCY EXIT LIGHTS COME ON. RESET CIDS 2 DIRECTOR EMERGENCY LIGHTS. OPS CHECK GOOD REF MM 33-51-00.SDR CALA2017041000940Battery Pack · dischargedL2 FWD DM33096 EMERG BATTERY PACK FOUND INOP. L2 FWD DM33096 BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2017041000962Light · inoperativeRIGHT AFT OVERWING EMERGENCY SLIDE LIGHT INOP. RELAMPED IAW AMM 31-51-04. OPS CHECK OK.SDR CALA2017041000961Battery Pack · dischargedAFT DOOR EMERGENCY LIGHTS AND VARIOUS EMER LIGHTS ON LEFT OF AIRCRAFT ARE INOP. REMOVED AND REPLACED AFT EMERGENCY BATTERY PACK PER AMM 33-51-06. OPS CHECK GOOD.SDR CALA2017041000959Cover · missingEMER EXIT SIGN IS MISSING AT DOOR 2L. REPLACED EMER EXIT COVER, OPS CHECK GOOD.SDR CALA2017041000953Lens · brokenEMERGENCY LIGHT LENS BROKEN AT SEATS 23D AND 31F. REPLACED LENS OK, REF AMM33-51-00.SDR KO0R201704100012Light · inoperativeEMERGENCY LIGHTS DO NOT ILLUMINATE WITH SWITCH SET TO ON.SDR YENA201704100251Power Supply · failedDURING ROUTINE MAINTENANCE, EMERGENCY LIGHTS AT ROWS 15, 19, & 23 INOPERATIVE. R & R THE POWER SUPPLY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR DALA2017041002851Power Supply · no testDURING CHECK, FOUND SEVERAL OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED THE POWER SUPPLY AND BATTERY IAW AMM 33-51. OPS CHECKED GOOD.SDR SWAA2017042513370Light · brokenFORWARD GALLEY EMERGENCY EXIT LIGHT BROKEN AT GALLEY 1. R & R LIGHT IAW AMM.SDR AALA201704129020Battery Pack · dischargedEMERGENCY EXIT LIGHT ABOVE OVERWING HATCH VERY DIM. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-53-00. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704129019Battery Pack · dischargedEMERGENCY EXIT LIGHT ABOVE OVERWING HATCH INOP. SEAT ROW 20D INOP. REMOVED AND REPLACED BATTERY PACK IAW 33-53-00. OP CKS OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704119023Sign · unsecureR1 DOOR FA REPLACED EMERGENCY SIGN FELL OFF FWD GALLEY ON TAKE OFF, REPORTED JUST BEFORE LANDING. REMOVED AND REPLACED FWD GALLEY EMERGENCY EXIT SIGN ASSY IAW AMM 33-51-01 OPS CK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704119022Lens · missingEPM LENS COVER MISSING BY R AFT LAV. REINSTALLED LENS COVER ON EPM AT R AFT LAV PER AMM 33-51-03. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704119021Lens · missingEMERGENCY LENS AT ROWS 7 AND 9 MISSING. INSTALLED EMERGENCY LENS AT ROWS 7 AND 9 IAW AMM 33-51-02 NOW GOOD FOR SVC. THE AIRCRAFT IS NOT GROUNDED.SDR AALA201704119020Cover · damagedEMERGENCY EXIT LIGHT COVER AFT GALLEY DAMAGED. REPLACED AFT GALLEY EMERGENCY EXIT LIGHT COVER. TEST GOOD PER AMM 33-51-00. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704109051Lens · brokenR4 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REPLACED THE LENS IAW AMM 33-15-13. ACCOMPLISHED SATISFACTORY OPS CHECK.SDR AALA201704109050Lens · brokenL4 DOOR EMERGENCY EXIT LIGHT LENS COVER BROKEN. REPLACED THE LENS IAW AMM 33-51-15. ACCOMPLISHED SATISFACTORY OPS CHECK.SDR SWAA2017041113061Battery Pack · dischargedRT OVERWING EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER MM.SDR AALA201704109036Lens · missingEMERGENCY EXIT SIGN COVER ON RIGHT SIDE OF THE R4 DOOR IS MISSING. REPLACED EMERGENCY EXIT SIGN.SDR AALA201704109030Sign · detachedR1 DOOR EXIT SIGN DETACHED. REPLACED EXIT SIGN.SDR SWAA2017041013050Light · brokenR2 DOOR EMERGENCY LIGHT ASSEMBLY BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2017041013031Cover · missingEMERGENCY LIGHT MISSING PROTECTIVE COVERING BETWEEN ROWS 2 TO 12. INSTALLED STRIP IAW AMM.SDR SWAA2017041013029Sign · brokenMID CABIN EXIT SIGN BROKEN. REPAIRED SIGN IAW SIP.SDR IPXA2017041015995Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK CHARGE IS LOW. REPLACED THE BATTERY PACK IAW AMM 33-51-01-400-802.SDR DALA2017041002872Battery Pack · inoperativeEMERGENCY LIGHTS IN CEILING FIRST CLASS SECTION INOPERATIVE. REPLACED THE BATTERY PACKS IAW AMM 33-53. OPS CHECKED GOOD.SDR HNAA2017041000113Bulb · inoperativeROW 2 EMERGENCY LIGHT INOPERATIVE. R & R THE BULB.SDR SWAA2017050113475Light · crackedEMERGENCY LIGHT CRACKED. R & R THE EMERGENCY LIGHT IAW AMM.SDR SWAA2017041813158Cover · missingRIGHT OVERWING EMERGENCY EXIT SMALL SIGN COVER MISSING. REINSTALLED THE COVER IAW AMM.SDR ASOA201704083082Light · inoperativeTHE CREW REPORTED FORWARD FLOOR EMERGENCY LIGHT INOPERATIVE.SDR R61A201704080272Light · missingEMERGENCY LIGHT STRIP MISSING AT 19A. REPLACED THE STRIP IAW MM 33-50-21.SDR DALA2017041202963Lens · missingEMERGENCY EXIT LENS MISSING. I NSTALLED THE LENS.SDR SWAA2017041113075Light · inoperativeL2 DOOR EXTERNAL EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA2017041113073Lens · looseMID CABIN OVERHEAD EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA2017041113062Light · inoperativeLT OVERWING EXIT LIGHT INOP. RELAMPED PER MM.SDR AALA201704109064Light · unsecureLIGHT COVER ON LOWER RIGHT FORWARD CABIN IN FRONT OF SEATS 3EF WILL NOT ATTACH TO WALL EMERGENCY EXIT ISLE LIGHT. REPLACED LIGHT ASSY AS PER AMM 33-51-14 TEST LIGHT TESTED OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704109063Light · brokenEMERG EXIT LENS MISSING AT DOOR AFT ENTRY. REMOVED & REPLACED BROKEN EMERGENCY LIGHT ASSEMBLY AT AFT LEFT DOOR ENTRY. OPS GOOD IAW MM 33-51-00. THE AIRCRAFT WAS GROUNDED.SDR AALA201704109062Cover · damagedEXIT LIGHT AT DOOR 2R DAMAGED. REPLACED EMERG EXIT LIGHT COVER AT DOOR 2R IAW GPM. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704109061Lens · missing4L EXIT LIGHT COVER MISSING. INSTALLED NEW LENS OPS CHECKS OK PER AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR CALA2017041000937Battery Pack · dischargedCABIN G5 GALLEY LOWER CLG EMER LT FOUND DIM CABIN M33405 BATTERY PACK. REPLACED AND LAMP TESTED NORMAL AS PER AMM 33-51-00.SDR CALA2017041000936Battery Pack · dischargedZONE D LT AISLE EMER LT FOUND DIM M33407. BATTERY PACK REPLACED AND ZONE D LT AISLE EMER LT TESTED NORMAL AS PER AMM 33-51-00.SDR CALA2017041000935Battery Pack · dischargedZONE A LT AISLE EMER LT FOUND DIM. ZONE A LT AISLE EMER BATTERY PACK M33424 REPLACED AND TEST NORMAL AS PER AMM 33-51-00
Back to JASC 3350