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 REXA2019041900659Housing · defectiveFWD LT EXTERIOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED FWD LT EMER LIGHT HOUSING IAW AMM 33-51-21 OPS CHK GOOD OK FOR SVC.SDR AALA2019042219009Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS IN CABIN DID NOT COME ON WHEN SWITCH WAS MOVED TO ON POSITION. MAINTENANCE REPLACED LIGHT BATTERY PER AMM 33-53-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904249015Battery · no testAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT TEST, ON THE MCDU, SHOWED FAULT MESSAGE "BAT/EPSU (10WL) FORWARD LEFT". MAINTENANCE REPLACED POWER SUPPLY UNIT (SEE AALA201904249014) AND BATTERY PER STANDARD PRACTICES AT 10WL POSITION AND PERFORMED SATISFACTORY OPERATIOSDR AALA201904249014Power Supply · no testAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT TEST, ON THE MCDU, SHOWED FAULT MESSAGE "BAT/EPSU (10WL) FORWARD LEFT". MAINTENANCE REPLACED POWER SUPPLY UNIT AND BATTERY (SEE AALA201904249015) PER STANDARD PRACTICES AT 10WL POSITION AND PERFORMED SATISFACTORY OPERATIOSDR YENA2019042390211Bulb · inoperativeFT # 857, HPN-PBI. L1 DOOR EXIT SIGN BULBS BURNT OUT, ALSO RH /W EXIT SIGN, ALSO AFT CTR AISLE EXIT SIGN; RELAMPED L1 DOOR EXIT SIGN & REPLACED R/H O/W EXIT SIGN 42WL & AFT CTR AISLE 52WL PER AMM 33-51-16. TEST OF EMERGENCY LIGHTS OK.42WSDR DALA2019042202566Battery Pack · inoperativeEMERGENCY SEAT LIGHTS INOPERATIVE AT ROWS 27 - 32. INSTALLED A SERVICEABLE BATTERY PACK IAW AMM 33-51.SDR AALA2019042219006Battery Pack · no testAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EMERGENCY LIGHT BATTERY PACK M1694 FAILED 15 MINUTE CAPACITY TEST. MAINTENANCE REPLACED BATTERY PACK M1694 IAW AMM 33-51-06. OPS TEST. IS NORMAL.SDR AALA2019042219004Battery Pack · no testAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS THE EMERGENCY LIGHT BATTERY PACK M1671 FAILED CAP TEST IAW WORK CARD 2908. ACCOMPLISHED DEEP CYCLE PROCEDURE IAW AMM 33-51-06, TASK 600-802. OPS CHECKED NORMAL.SDR N6WA201904221901Light · inoperativeOVERHEAD EMERGENCY FLOODLIGHT INOP AT ROW 11. R AND R FLOOD LIGHT IN OVERHEAD PANEL IN CABIN OPS TEST GOOD WITH REFERENCE TO CRJ-700-AMM-33-51-09SDR SWAA2019042231878Sign · detachedOVERWING EMERGENCY EXIT SIGN FELL OFF. INSTALLED SIGN I.A.W. S.I.P.SDR SWAA2019042231873Cover · missingAFT SERVICE DOOR FO SIDE LOWER EXIT LIGHT COVER MISSING REPLACED COVER AS REQUIRED REF SIP & AMM 33-51-01SDR MASA2019041911810Light · inoperativeEMER LIGHTS INOP AT SERVICE DOOR. PLACED ON MEL.SDR CALA2019041900619Battery Pack · dischargedLH DOOR 3 SLIDE LIGHT FOUND INOP. REPLACED L3 DOOR SLIDE LT LAMP AND CHARGED L3 DR EMERG PWR PACK M33405 AND O/P TEST CARRIED OUT NORMAL R EF AMM 33-51-04-960-801 REV.85,AMM33-51-06-960-802 REV.85.SDR CALA2019041900618Battery Pack · dischargedEMERG PWR PACK M33400 O/P FOUND CAPACITY LOW. REPLACED EMERG PWR PACK M33400 AND O/P TEST CARRIED OUT NORMAL REF AMM 33-51-06-960-802 REV.85.SDR IPXA2019041941214Guard · brokenEMERGENCY LIGHT GUARD HAD A BLACK PIECE BREAK OFF. R&R THE SWITCH GUARD IAW SWPM 20-83-11, OPS CHECKED GOOD.SDR SWAA2019052232921Lens · damagedRT BIN EMERGENCY LIGHT LENSES DAMAGED AT ROW #8. R&R LENS IAW AMM & SIP.SDR SWAA2019052232920Lens · damagedLT BIN EMERGENCY LIGHT LENSES DAMAGED AT ROW #4. R&R LENS IAW AMM & SIP.SDR SWAA2019052232919Lens · damagedLT BIN EMERGENCY LIGHT LENSES DAMAGED AT ROW #1. R&R LENS IAW AMM & SIP.SDR SWAA2019052232864Lens · damagedRT BIN EMERGENCY LIGHT LENSES DAMAGED AT ROW #11. R&R LENS IAW AMM & SIP.SDR SWAA2019052232863Lens · damagedLT BIN EMERGENCY LIGHT LENSES DAMAGED AT ROW #6. R&R LENS IAW AMM & SIP.SDR DALA2019041802908Lens · cracked(AIRCRAFT 7107; L/P 1035671) MIDLIFE MOD- PROXIMITY EMER LT LENS ASSY FOUND CRACKED AT EXTERIOR OF OFCR AND OFAR. OFCR AND OFAR PROXIMITY LIGHT REPLACED AND OPS CHECK SA PER AMM 33-51-05 AND FOUND SATISFACTORY.SDR SWAA2019042331940Battery · no testAFT RIGHT EMERG LIGHT BATT PACK FAIL CAPACITY TEST. REMOVED AND REPLACED AFT RIGHT EMERG LIGHT BATT PACK LOCATION MO1672 PER AMM 33-51-11SDR DALA2019042292565Light · inoperativeEMERGENCY EXIT IDENTIFIERS WERE INOPERATIVE AT THE LEFT DOORS. REMOVED & REPLACED EXIT IDENTIFIER LIGHTS IAW WDM'S 33-51-12, 13, 14, 15. OPS CHECKED GOOD.SDR SWAA2019042231880Sign · brokenMID CABIN EMERGENCY EXIT SIGN (OVERHEAD) BROKEN. RESECURED EMERGENCY EXIT SIGN PER. S.I.P.SDR SWAA2019042231877Light · detachedMID CABIN EMERG EXIT LT FELL. REPLACE LENS PER SIPSDR SWAA2019042231876Sign · missingNOTIFIED BY F/A THAT OVERHEAD EXIT SIGN AT OVERWING IS MISSING THE FORWARD FACING EXIT SIGNAGE FOUND AND REINSTALLED EXIT LIGHT LENS IAW AMM 33-51-01 (AP 3315101)SDR SWAA2019042231860Lamp · inoperativeEXTERIOR EMERGENCY LIGHT @ R2 DOOR INOP (AFT SERVICE DOOR) RELAMPED EXTERIOR EMERGENCY LIGHT @ R2 DOOR. REF. B-737 AM 33-51-04. (AFT SERVICE DOOR)SDR SWAA2019042231856Battery Pack · no testEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M01672. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY PACKSSDR SWAA2019042231855Battery Pack · no testEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M01672. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY PACKSSDR SWAA2019042231853Light · inoperativeL/H OVERWING EXIT SIDEWALL LIGHT INOP R&R L/H OVERWING EXIT LIGHT BALLAST ASSEMBLY PER AMM 33-51-06SDR SWAA2019042231843Battery Pack · no testEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M01675. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY PACKSSDR AALA201904220004Battery Pack · no testAIRCRAFT NOT GROUNDED: BATTERY PACK FAILED OP"S CHECK AT LOCATION M1673, REMOVED AND REPLACED BATTERY PACK.SDR AALA201904220001Battery Pack · weakAIRCRAFT NOT GROUNDED: M1694 BATTERY PACK FAILED CAPACITY TEST PER WORK CARD 2908. REPLACED BATTERY PACK M1694 REF. AMM 33-51-06. OPS. TEST IS NORMAL REF. AMM 33-51-00.SDR CALA2019041900616Light · inoperativeCABIN EMERGENCY LIGHTING ON STOW BIN AT SEAT 23D IS INOP. RELAMPED PER AMM 33-51-03-960-803. NO JOY. LIGHT NOT ON WITH SWITCH IN THE ON POSITION. REPLACED LIGHT ASSY REF AMM 33-51-03-960-802, OPS CHECKED GOOD.SDR CALA2019041900611Power Supply · no testFWD AND AFT CABIN EMERGENCY LIGHTS DO NOT COME ON WITH SWITCH AR MED AND 49VU CIRCUIT BREAKERS H05 AND H06 OPENED PER HAECO LCQ N R LP NO 9294465 GENERATED BY V039704 TROUBLESHOT EMERGENCY LIGHTS IAW A320 TSM 33-33-51-00-810-812-A REMOVED AND REPLACED 10WH ANDSDR N6WA20190419801Light · inoperativeEMERGENCY CEILING LIGHT AT ROW 15 INOPERATIVE.SDR MASA2019041811809Bulb · inoperativeROW 14 A/C FLOOR LVL EMER FLOOD LTS INOP
REPLACED BULBSSDR R61A201904180385Light · fadedPHOTOLUMINESCENT STRIPS 2EA AT WARDROBE PASSENGER SEAT 1C FADED. R&R 2EA SECTION PHOTOLUMINESCENT STRIP IAW AMM 33-50-21.SDR FDEA201904257832Battery Pack · inoperativeEMERG LT BAT 1 LO DURING PREFLIGHT TEST R&RD EMERGENCY POWER SUPPLY/BATT IAW MM 33-51-01-4,CHKD OK.PLACARD AND STICKER REMOVED.SDR SWAA2019042331983Battery · inoperativeEMERGENCY ISLE LIGHTS INOP BETWEEN SEAT ROWS 3 FED AND 6 FED. / REMOVED, REPLACED AND PERFORMED INSTALLATION TEST FOR EMERGENCY BATTERY PACK IAW AMMSDR SWAA2019042331982Battery · inoperativeRH FWD EXTERIOR EMERGENCY LIGHT INOP. / REMOVED & REPLACED EMERGENCY BATTERY PACK PER MM.SDR SWAA2019042331881Lamp · inoperativeL2 DOOR SLIDE EMERGENCY LIGHT INOPERATIVE. RELAMPED PER AMM 33-51-04SDR ASOA2019042375060Control Module · faultyPILOT REPORTED THE EMERGENCY LIGHTS CAME ON WHEN F/A TURNS SIDEWALL LIGHTS FROM BRIGHT TO DIM. MX REMOVED AND REPLACED FLIGHT ATTENDANT LIGHT CONTROL PANEL WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA2019042375058Light · inoperativeDURING MX INSPECTION THE CEILING EMERGENCY LIGHT ABOVE SEAT 18A WAS FOUND INOP. MX REPLACED LIGHT ASSEMBLY WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR YENA201904227210Power Supply · failedFLT 679, SEAT MOUNTED EMERG LIGHTS ON ROW 1 LH & ROW 5 LH- INOP; CHECKED WIRING-ALL GOOD. R & R EPSU (10WL) PER AMM 33-51-38. OPS CHECK GOOD. BITE TEST NORMAL. OK FOR SERVICE.SDR DALA2019042282573Power Supply · malfunctionedFIRST 3 ROWS AND ALL DOOR EMERGENCY LIGHTS ILLUMINATED INTERMITTENTLY THROUGHOUT FLIGHT, UNCOMMANDED LAST 4 HOURS OF FLIGHT. OPS NORMAL. T/S PER WDM 33-51. REMOVED AND REPLACED THE POWER SUPPLY MODULE M730 IAW AMM 33-51-OPS, TESTED NORMAL.SDR SWAA2019042231858Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY AT LOCATION M1674 PER AMM 33-51-06SDR SWAA2019042231857Lamp · inoperativeEMERGENCY LIGHT OUT AT 6ABC RELAMPED PER AMM33-51-03SDR SWAA2019042231846Lens · missingRIGHT OVERWING EMERG EXIT LIGHT LENS MISSING INSTALLED OVERWING EXIT EMERGENCY LIGHT LENS IAW AMM 33-51-01. OPS CHECK GOOD OK FOR SERVICESDR SWAA2019042231840Power Supply · inoperativeAIRCRAFT CENTER OVERHEAD EMERGENCY EXIT SIGN INOP. R+R AIRCRAFT CENTER OVERHEAD EMERGENCY EXIT SIGN POWER SUPPLY IAW AMM 33-51-06. OPS CHECKS GOOD.
Back to JASC 3350