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 AALA201701029007Cover · missingTHE L2 DOOR EMERGENCY LIGHT COVER WAS FOUND MISSING. INSTALLED A NEW COVER.SDR AALA201701029005Lens · missing9D LENS FOR EMERGENCY EXIT MISSING. INSTALLED A NEW LENS.SDR SIMA20170101001Charger · failedLEFT AND RIGHT EXTERNAL OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT SYSTEM CHARGER NR 4 AND BATTERY NR 4 IAW W/C 33-700-19. OPS CHECKED GOOD.SDR DALA2017010200027Battery Pack · dischargedDURING PREFLIGHT, FOUND EMERGENCY LIGHTS ON AND BATTERIES DEAD LIGHTS WILL COME ON FOR 5 SECONDS THEN DIE. REPLACED THE BATTERY PACKS IAW WORK CARD 3350-7353. EMERGENCY LIGHTS CHECKED GOOD IAW AMM 33-53-00.SDR DALA2017010200014Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE NOTED THAT THE LOWER EMERGENCY LIGHTS FOR THE OVERWING EXITS WERE INOPERATIVE. REPLACED THE BATTERIES AND THE OPS CHECKED GOOD.SDR DALA2017010200004Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE NOTED THAT THE OVERHEAD EMERGENCY LIGHTS FOR BOTH THE AFT OVERWING EXITS WERE INOPERATIVE. MAINTENANCE REPLACED THE APPLICABLE BATTERY PACK AND THE OPERATION OF THE LIGHTS CHECKED GOOD. (LP #9446654)SDR CALA2017010100005Battery Pack · dischargedEMERGENCY LIGHTS INOP ABOVE RIGHT SIDE EXIT ROWS. R&R EMERGENCY LIGHTS BATTERY PACK. OPS CHECK GOOD.SDR CALA2017010100003Sign · disconnectedPER 2SVC, EEL EXIT SIGN AT DOOR 1R INOP FOUND LITE ASSY L629 DISCONNECTED REF WD33-51-21. RECONNECTED AND RELAMPED, CKS OK ACP SAFETY AND SECURITY INSP. OPS CHECK GOOD.SDR CALA2017010100001Power Supply · inoperativeNR 2 SVCK OPS TEST EMERG LTS FOUND FLT DECK DOME, L-1 DOOR SIDE LINING, EXT ESCAPE SLIDE AND OVERHEAD FWD ENTRY INOP. ACCESS PWR SUPPLY M1675, REMOVED CHK FUSE 4EA GOOD. CHK PWR C/P PIN 2/22 GOOD. REPLACED PWR SUPPLY AND BATT PACK ASSY. OPS CHK GOOD. REF WDM 3SDR AALA20161231010Housing · damagedAIRCRAFT IN BASE MAINTENANCE. L2 DOOR FORWARD MAIN AISLE EMERGENCY EXIT SIGN HOUSING IS DAMAGED. REMOVED AND REPLACED HOUSING IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR DALA2017010400140Fuse · inoperativeFOUND ROWS 1CD, 2CD, AND 3CD EMERGENCY LIGHTS INOPERATIVE. R & R THE FUSE IAW WDM 33-55. OPS NORMAL.SDR SWAA2017010511006Battery Pack · dischargedL1 DOOR EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017010511004Battery Pack · dischargedL2 DOOR EMERGENCY EXIT SIGN INOP AT LOCATION M01672. R&R BATTERY PACK PER MM.SDR SWAA2017010510999Battery Pack · dischargedAFT CENTER CEILING EMERGENCY EXIT SIGN INOP AT LOCATION M01672. R&R BATTERY PACK PER MM.SDR SWAA2017010510991Battery Pack · dischargedR1 DOOR EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR AALA20170104020Light · failedAIRCRAFT NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHT AT SEAT 7J FAILED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR AALA20170104019Sign · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT R2 DOOR NEAR TRASH BIN IS DETACHED. SECURED EXIT SIGN IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170104018Lens · detachedAIRCRAFT NOT GROUNDED. OVERWING EMERGENCY EXIT SIGN LENS COVER IS DETACHED. REATTACHED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170104017Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT R1 DOOR HAS A DETACHED LENS COVER. SECURED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170104015Light · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT R2 DOOR IS DETACHED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170104009Sign · looseAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN IN CEILING ABOVE SEAT 25H IS LOOSE. SECURED EXIT SIGN. OPERATIONAL CHECK GOOD.SDR AALA20170104007Sign · detachedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN IS DETACHED FROM ANCHORAGE AT ROW 21 OUTBOARD RIGHT SIDE OF AIRCRAFT. RESECURED EXIT SIGN IAW EA 266384. OPERATIONAL CHECK GOOD.SDR SWAA2017010410949Cover · detachedRIGHT OVERWING EXIT SIGN COVER DETACHED. SECURED THE SIGN IAW AMM.SDR SWAA2017010410896Battery Pack · inoperativeRIGHT EMERGENCY EXIT AISLE LIGHT INOPERATIVE AT ROW 6. R & R THE BATTERY PACK IAW AMM.SDR SCNA20161231382Light · inoperativeLEFT SEAT ROW 7 AND 9 OVERHEAD BIN BULL NOSE'S TWO EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHTS. OPS CHECKED GOOD.SDR DALA2017010300051Battery Pack · inoperativeEMERGENCY LIGHTS AT SEATS 22B THRU 27B INOPERATIVE. REPLACED THE EMERGENCY LIGHT BATTERY AND CHARGER IAW AMM 33-51.SDR YENA201612311123Epsu · failedEPSU 11WL "EMERGENCY LEFT" WAS INTERMITTANT; R & R 11WL EPSU IAW AMM 33-51-38 R & R 11WL BATTERY IAW AMM 33-51-38. RELAMPED 63WL IAW AMM 33-51-15. PERFORMED OPS CHECK. OPS CHECK PASSED.SDR YENA201612311124Battery · failedEMERGENCY LIGHT EPSU 11WL WAS INTERMITTANT. R & R THE EPSU IAW AMM 33-51-38 IAW AMM 33-51-15. OPS CHECK PASSED.SDR YENA201612311122Battery · failedWHILE PERFORMING TASK CARD A320-33-51-00-710-003, FOUND EPSU BATTERY CAPACITY FOR EMERGENCY LIGHTS, NEEDS REPLACEMENT. R & R THE ESPU IAW AMM 33-51-38. OPS CHECK PASSED.SDR YENA201612311121Battery · no testWHILE PERFORMING TASK CARD A320-33-51-00-710-003, FOUND EPSU BATTERY CAPACITY FOR THE EMERGENCY LIGHTS NEEDS REPLACEMENT. R & R THE ESPU IAW AMM 33-51-38. OPS CHECK PASSED.SDR ASAA2016123119214Lens · detachedEXIT LIGHT COVER CAME OFF AT MID CABIN OVERHEAD. GROUNDED - YES. REINSTALLED CEILING EXIT SIGN COVER , NO DAMAGE NOTED.SDR AALA201701019002Sign · looseEMERGENCY EXIT SIGN BY SEAT 9D STICKING OUT. REINSTALLED EXIT SIGN BY SEAT 9D AND ACCOMPLISHED SATISFACTORY CHECK.SDR AALA201701019001Switch · no testEMERGENCY EXIT LIGHTS STAY ILLUMINATED WITH OVERHEAD SWITCH SELECTED OFF. REPLACED EMERGENCY EXIT LIGHT ARMING SWITCH IAW ESPM 20-45-21.SDR DALA2017010100020Battery Pack · inoperativeMULTIPLE CEILING EMERGENCY LIGHTS INOPERATIVE. REMOVED & REPLACED THE BATTERIES. OPS CHECKED GOOD.SDR CALA2016123101204Battery Pack · faultyCB AT B10/EMER CHARGER FOUND POPPED. MECH RESET AND IT POPPED AGAIN. FOUND EMERGENCY BATT PACK M1669 FAULTING. REPLACED POWER SUPPLY AND BATT PACK PER AMMM33-51-06, OPS CHECKS NORMAL.SDR CALA2016123101203Light · inoperativeEMERGENCY SLIDE/OVERWING LIGHT DOES NOT COME ON RIGHT NEEDS T/S. FOUND ISLE LIGHT {EMERGENCY) ON BOTTOM OF OVERHEAD BIN AT 22DEF INOP. PLACED ON MEL, DDP C/W. APPROVED RELAMPED EMERGENCY OVERWING LIGHT. OPS CK GOOD.SDR MASA2016123112785Light · inoperativeEMERGENCY FLOOD LIGHT ROW 18 INOPERATIVE.SDR AALA20161231006Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. EMERGENCY POWER SUPPLY M33406 INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR VNAA2016123000049Screw · strippedEMERGENCY EXIT LIGHT SIGN IS HANGING DOWN. REMOVED AND REPLACED STRIPPED SCREW.SDR IPXA2017010412390Lamp · inoperativeEMERGENCY EXIT UN ARMED ANNUC LT HAS 1 LAMP INOPERATIVE. REPLACED THE LAMP IAW MM 33-16-02-962-001. OPS CHECKED NORMAL..SDR SWAA2017010410941Battery Pack · smokeSMOKE CAME FROM CEILING IN FORWARD GALLEY. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017010410935Light · inoperativeRIGHT EMERGENCY EXIT HATCH LIGHT LOWER POSITION LAMP INOPERATIVE. R & R THE LIGHT IAW AMM.SDR SWAA2017010410934Lens · looseL1 DOOR EMERGENCY EXIT LOWER EXIT LIGHT LENS LOOSE. R & R THE LENS IAW AMM.SDR SWAA2017010410905Sign · damagedL2 DOOR EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROW. R & R THE SIGN IAW MM.SDR SWAA2017010410904Power Supply · inoperativeL1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE POWER SUPPLY IAW AMM.SDR SWAA2017010410898Lens · brokenLEFT OVERHEAD BIN EMERGENCY LIGHT LENS BROKEN AT ROW 27. R & R THE LENS IAW AMM.SDR SWAA2017010410897Light · inoperativeLEFT OVERHEAD BIN EMERGENCY LIGHT INOPERATIVE AT ROW 8. R & R THE LIGHT IAW AMM.SDR ASAA2016123019213Battery Pack · failedBATTERY PACKS M1671, M1672, M1673, M1675, AND M1694 FAILED CAPACITY TEST REF T/C 78233001. GROUNDED - YES. REPLACED BATTERY PACKS AT M1671, M1672, M1675, AND M1694. REPLACED BATTERY AND CHARGER ASSEMBLY AT M1673. OPERATIONAL TEST OK, REF AMM 33-51-06/201.SDR AALA20170103020Lens · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AFT OF RIGHT AFT LAVATORY HAS A BROKEN LENS COVER. REPLACED LENS COVER IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA20170103019Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN ON FIRST GALLEY WALL HAS A DETACHED LENS COVER. SECURED LENS COVER. OPERATIONAL CHECK GOOD.
Back to JASC 3350