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 DALA2018051603413Fuse · blownDURING SERVICE CHECK FOUND EMERGENCY LIGHTS AT RT FWD OVERWING EXIT INOP. REMOVED AND REPLACED FUSE AT BATTERY PACK M10568. OPS CHECK GOOD. A/C OK FOR SERVICE.SDR DALA2018051603416Fuse · blownDURING SERVICE CHECK FOUND EMERGENCY LIGHT AT SEAT 30DEF CEILING INOP. REMOVED AND REPLACED FUSE AT BATTERY PACK M10568. OPS CHECK GOOD.SDR CALA2018051701301Battery Pack · inoperativeZONE B, LEFT CEILING EMERGENCY LIGHT FOUND DIM. THE POWER SUPPLY BATTERY PACK M33400 AND 33406 WERE REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018051701300Battery Pack · dischargedR1 DOOR AREA EMERGENCY LIGHT FOUND DIM. THE POWER SUPPLY M33094 AND BATTERY PACK WERE REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018051701299Power Supply · faultedL1 DOOR AREA EMERGENCY LIGHT FOUND DIM. THE POWER SUPPLY M33093 AND BATTERY PACK WERE REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018051701298Battery Pack · dischargedZONE A, CEILING EMERGENCY LIGHT FOUND DIM. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018051701297Battery Pack · dischargedZONE B, RT EMERGENCY LIGHT FOUND TO BE DIM AT THE R2 DOOR AND THE R3 DOOR, THE POWER SUPPLY BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR SWAA2018051721994Sign · looseOVERHEAD OVERWING AISLE EMERGENCY EXIT SIGN LIGHT LOOSE FROM CEILING. REINSTALLED SIGN PER AMM.SDR SWAA2018051721992Sign · looseEXIT SIGN LOOSE AT ROW 16. SECURED SIGN IAW AMM.SDR AALA2018051769023Light · damagedL1 DOOR EMERGENCY EXIT LIGHT DAMAGED. REPLACED EMERGENCY EXIT AREA LIGHT IN AISLE IAW 33-50-00. OPS CHECKED GOOD.SDR AALA2018051769024Power Supply · inoperativeFORWARD OVERHEAD EMERGENCY LIGHTS ARE INOPERATIVE. REPLACED THE POWER SUPPLY AT FORWARD LAVATORY IAW AMM 33-53-00. OPS CHECKED NORMAL.SDR AALA201805175006Light · no testEMERGENCY EXIT AISLE LIGHT AT SEAT ROW 37HJ, DID NOT ILLUMINATE DURING A TEST IAW W/C 0357. REMOVED AND REPLACED THE SEAT LIGHT IAW AMM 33-51-10. OPS CHECKED NORMAL.SDR MASA201805163221Bulb · inoperativeEMERGENCY CEILING LIGHT INOPERATIVE AT ROW 11. REPLACED THE BULB.SDR DALA2018051653385Power Supply · inoperativeAISLE EMERGENCY LIGHTS INOPERATIVE FROM SEATS 30AB TO THE AFT LEFT LAVATORY. REPLACED THE POWER SUPPLY 17WL.SDR SIMA201805165003Bulb · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-07. OPS CHECKED GOOD IAW AMM 33-50-00.SDR N6WA20180516501Light · detachedLEFT EMERGENCY EXIT LIGHT ON THE GALLEY PARTITION IS DETACHED. SECURED THE EMERGENCY EXIT LIGHT IAW AMM 33-51-05. OPS CHECKED GOOD.SDR SWAA2018051621988Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1674. R & R THE BATTERY IAW AMM.SDR SWAA2018051621980Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1672. R & R THE BATTERY IAW AMM.SDR SWAA2018051621978Light · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM.SDR SWAA2018051621976Cover · detachedLEFT AFT GALLEY EMERGENCY SIGN COVER DETACHED. SECURED THE COVER IAW AMM.SDR SWAA2018051621970Lens · missingRIGHT OVERWING EXIT FLOOR LEVEL EXIT SIGN PLASTIC COVER MISSING. R & R SIGN IAW AMM.SDR SWAA2018051621969Lens · missingRIGHT OVERWING EXIT FLOOR LEVEL EXIT SIGN PLASTIC COVER MISSING.SDR DALA2018051603373Power Supply · inoperativeTHE TAIL SECTION WALKWAY, LOWER EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE FOUND THAT THE B5-200 POWER SUPPLY AND BATTERY PACK ARE BAD. REPLACED THE B5-200 POWER SUPPLY AND BATTERY PACK REF AMM 33-51. LIGHT OPERATION NOW CHECKS GOOD.SDR DALA2018051603375Power Supply · inoperativeON SERVICE CK FOUND FIRST CLASS EMERGENCY ESCAPE LIGHT ON SEATS INOP. REMOVED AND REPLACED POWER SUPPLY IN FIRST CLASS AREA. OPS CKS GOOD PER AMM 33-50.SDR REXA2018051500384Lamp · inoperativeLEFT NR 3 EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-15. OPS CHECKED GOOD.SDR CALA2018051501291Battery Pack · dischargedMAIN DECK L1 DOOR EMERGENCY LIGHT BATTERY PACK M33424 HAD LOW CAPACITY. REPLACED THE BATTERY PACK. OPS TESTED GOOD IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018051501290Battery Pack · no testMAIN DECK R3 DOOR HAD ONE EMERGENCY LIGHT BATTERY PACK M33404 WITH LOW CAPACITY. REPLACED BATTERY PACK. OPS TESTED GOOD IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018051501289Battery Pack · no testM/D R2 DOOR HAD ONE EMERGENCY LIGHT BATTERY PACK M33097 TO HAVE LOW CAPACITY. REPLACED BATTERY PACK. OP TESTED GOOD IAW AMM 33-51-06-960-802, REV 82.SDR DALA2018061103934Battery Pack · inoperativeFIRST CLASS UPPER EMERGENCY LIGHTS INOPERATIVE. INSTALLED A REPLACEMENT BATTERY PACK IAW AMM 33-53. OPS CHECKED GOOD.SDR REXA2018052540412Light · inoperativeAFT RT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED & REPLACED THE EMERGENCY LIGHT AND LENS IAW AMM 33-51-15.SDR HNAA20180521001Light · inoperativeFLOOR EMERGENCY LIGHT INOPERATIVE BY THE EMERGENCY EXIT DOOR. R & R EMERGENCY LIGHT IAW AMM 33-50-12. OPS CHECKED GOOD.SDR R61A2018051840598Battery Pack · faultedEMERGENCY BATTERY FAULTED. R & R THE EMERGENCY LIGHT BATTER PACK IAW AMM 33-50-01.SDR SWAA2018051722003Light · inoperativeAFT OF L2 DOOR LT EXTERIOR EMERGENCY EXIT LIGHT INOP. R&R LAMP PER AMM.SDR AALA201805179011Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS NEAR SEATS 28 THROUGH 30, AND AFT GALLEY REMAIN ILLUMINATED AFTER POWER IS REMOVED FROM AIRCRAFT. OPERATIONS TEST OF EMERGENCY LIGHTS SHOWS ROWS 8, 13, 20 AND 28 OVERHEAD AISLE LIGHTS INOPERATIVE. REPLACED BATTERY PASDR AALA201805179010Battery Pack · inoperativeEMERGENCY LIGHTS NEAR SEATS 28 THROUGH 30, AND AFT GALLEY REMAIN ILLUMINATED AFTER POWER IS REMOVED FROM AIRCRAFT. OPERATIONS TEST OF EMERGENCY LIGHTS SHOWS ROWS 8, 13, 20 AND 28 OVERHEAD AISLE LIGHTS INOPERATIVE. REPLACED BATTERY PACKS IAW AMM 33-55-00.SDR AALA201805179009Battery Pack · inoperativeEMERGENCY LIGHTS NEAR SEATS 28 THROUGH 30, AND AFT GALLEY REMAIN ILLUMINATED AFTER POWER IS REMOVED FROM AIRCRAFT. OPERATIONS TEST OF EMERGENCY LIGHTS SHOWS ROWS 8, 13, 20 AND 28 OVERHEAD AISLE LIGHTS INOPERATIVE. REPLACED BATTERY PACKS IAW AMM 33-55-00.SDR AALA201805179003Battery Pack · inoperativeEMERGENCY LIGHTS NEAR SEATS 28 THROUGH 30, AND AFT GALLEY REMAIN ILLUMINATED AFTER POWER IS REMOVED FROM AIRCRAFT. OPS TESTED THE EMERGENCY LIGHTS SHOWS ROWS 8, 13, 20 AND 28 OVERHEAD AISLE LIGHTS INOPERATIVE. REPLACED THE BATTERY PACKS IAW AMM 33-55-00.SDR AALA2018051769008Lens · detachedEMERGENCY EXIT SIGN LENS FELL OFF THE PANEL BY THE L1 JUMPSEAT. REPLACED THE LENS. OPS CHECKED GOOD.SDR DALA2018051503330Light · inoperativeFWD EMERGENCY LIGHTS ON FIRST CLASS OVERHEAD NOT TURNING ON. REPLACED BATTERIES PER 33-53, NO HELP. RELAMPED ALL OVERHEAD EMERGENCY LIGHTS REF AMM 33-53. OPS CHECKS GOOD.SDR ASOA2018051645127Light · inoperativeDURING MX INSPECTION THE OVERHEAD EMERGENCY LIGHT AT ROW 4 IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT IAW AMM 33-51-09, CHECKED GOOD. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201805169021Light · brokenSEAT EMERGENCY LIGHTS AT 3, 10, 12, 16 LEFT BROKEN. MAINTENANCE REPLACED SEAT EMERGENCY LIGHTS IAW AMM 33-51-19 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201805169019Light · brokenSEAT EMERGENCY LIGHTS AT 3, 10, 12, 16 LEFT BROKEN. MAINTENANCE REPLACED SEAT EMERGENCY LIGHTS IAW AMM 33-51-19 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201805169018Light · brokenSEAT EMERGENCY LIGHTS AT 3, 10, 12, AND 16 LEFT BROKEN. MAINTENANCE REPLACED SEAT EMERGENCY LIGHTS IAW AMM 33-51-19, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018051659031Light · brokenSEAT EMERGENCY LIGHTS AT 3, 10, 12, AND 16 LEFT BROKEN. MAINTENANCE REPLACED SEAT EMERGENCY LIGHTS IAW AMM 33-51-19 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201805165001Power Supply · no testFOWARD OVERHEAD EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-53-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018051621987Lamp · inoperativeLEFT BULLNOSE EMERGENCY LIGHT INOPERATIVE AT ROW 20. REPLACED THE LAMPS IAW AMM.SDR AALA201805165003Bulb · burned outRIGHT AFT EMERGENCY EXIT SIGN, LOWER EXIT LIGHT, FORWARD LIGHT BULB IS INOPERATIVE. REPLACED THE BULBS IAW AMM 33-51-01.SDR AALA2018051659025Power Supply · no testEMERGENCY LIGHT POWER SUPPLY TEST FAILED. REPLACED THE POWER SUPPLY, AND BATTERY IAW AMM 33-51-38.SDR AALA201805159022Battery · faultedAIRCRAFT WAS NOT GROUNDED. PERFORMED CIDS 1 TEST, FAULTED WITH "EPSU (13WL) AFT L" MESSAGE. REPLACED BATTERY OF EPSU PER AMM 33-51-38.SDR AALA201805159019Housing · damagedAIRCRAFT WAS NOT GROUNDED. SEAT 17C EMERGENCY LIGHT HOUSING DAMAGED. REPLACED SEAT 17C EMERGENCY LIGHT HOUSING PER CMM 25-22-52.
Back to JASC 3350