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 SWAA2021031153897Lens · looseCREW REPORTED EMERGANCY EXIT LENS AT MID CABIN CAME OFF. / SECURED LENS I/A/W S.I.P.SDR CALA2021031000281Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK ABOVE L3 DOOR M33400 INOP. REMOVED AND REPLACED BATTERY PACK AS PER AMM 33-51-06-960-801. OPS CHECKS GOODSDR CALA2021031000280Battery Pack · inoperativeEMERGENCY BATTERY PACK AT L2 DOOR AFT POSITION INOP. REPLACED BATTERY PACK AS PER AMM 33-51-06-960-801. OPS CHECKS GOOD.SDR AALA202103099005Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY EXIT LAMPS INOPERATIVE. REPLACED FORWARD GALLEY EMERGENCY LAMP BATTERY PER AMM 33-51-38/0401-00.SDR AALA202103099023Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERHEAD EMERGENCY LIGHT AT ROW 26ABC BY 3L DOOR IS INOPERATIVE. RELAMPED LIGHT IAW AMM 33-51-03-960-801, OPS CHECKS GOOD.SDR AALA202103099022Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERHEAD EMERGENCY AREA LIGHT AT 25 A/C IS INOPERATIVE. RELAMPED OVERHEAD EMERGENCY AREA LIGHT AT ROW 25 A/C IAW AMM 33-51-03-960-801.SDR SIMA20210308001Light · inoperativeMAIN DOOR EXTERNAL EMERGENCY LIGHT INOP-C/A-RAR MAIN DOOR EXTERNAL EMERGENCY LIGHT IAW EMB AMM 33-50-06-000-801-A AND 33-50-06-400-801-A. OPS CHECK GOOD. NO DEFECTS NOTED. END.SDR MASA2021030700061Light · inoperativeEMER FLODD LIGHT ROW 18 INOP
PLACED ON MELSDR CALA2021030800275Battery Pack · inoperativeEMERGENCY BATTERY PACK M731 INOP. REPLACED BATTERY PACK AS PER AMM 33-51-07-902-001. OPS CHECKS GOOD.SDR ASAA2021030734410Bulb · burned outR2 DOOR EXTERIOR EXIT EMERGENCY LIGHT INOP. GROUNDED - YES. RELAMPED R2 DOOR SLIDE LIGHT AND OPS CHECK GOOD IAW ASA B737-800 AMM 33-51-04-960-801.SDR R61A2021031800251Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS 2, 3, 4 FAIL OPS CHECK. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY UNITS IAW AMM 33-50-00-710-801-A.SDR QXEA2021031200109Lens · damagedFORWARD WING BULKHEAD EMERGENCY EXIT LIGHT LENS IS DISCOLORED. REPLACED LENS IAW CMM 25-52-13.SDR SWAA2021031153633Cover · looseOVERWING EMERGENCY EXIT LIGHT COVERS FELL OFF / RESECURED PER SIPSDR AALA202103109020Lens · damagedAIRCRAFT WAS NOT GROUNDED: SEAT 33ABC EMERGENCY LIGHT LENS DAMAGED. REPLACED FLOOR PROXIMITY LIGHT, SEAT MOUNTED EMERGENCY LIGHT LENS IAW AMM 33-51-01. OPS CHECK GOOD.SDR N6WA2021030702Bulb · inoperativeCEILING LVL EMER LIGHTOUT AT ROW 7. R/R EMER LIGHT BULB ABOVE ROW 7 IAW CRJ 550 AMM 33-51-09 OPS CHECK GOODSDR N6WA2021030701Bulb · burned outEMER LIGHT SIGN IN PAX DOOR AREA HAS 1 BULB OUT. R/R BULB ON EMER LIGHTON AIRSTART WALL IAW CRJ 550 AMM 33-51-05 OPS CHECK GOODSDR QXEA2021030900106Sign · detachedLENS FOR EXIT SIGN IN ROW 2 FELL OFF. REMOVED FROM SERVICE. RE SECURED EXIT SIGN LIGHT LENS AT SEAT 2E REF Q400 AMM 33-51-06-000-804. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR DALA2021030901358Barrier · inoperative(6819169) AIRCRAFT 3114. ON CHECK FOUND EPSU-L FAULT ON F/A PANEL. REMOVED/REPLACED EPSU IAW A319 AMM 33-51-38.OPS TEST OK.SDR DALA2021030901354Power Supply · inoperativeDURING SERVICE CHECK FOUND SECTION OF FLOOR PATHWAY EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED POWER SUPPLY CHARGER. SYSTEM OPERATION IS NORMAL. (LP 7594517)SDR DALA2021030901353Connector · dirtyDURING SERVICE CHECK FOUND EMERGENCY EXIT LIGHTS AT ROW 21-31 INOPERATIVE. MAINTENANCE REPLACED M9009 BATTERY AND CHARGER AND CLEANED AND RE-SECURED CONNECTOR. SYSTEM OPERATION IS NORMAL. (LP 5137413)SDR AALA202103089011Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTING TEST FAIL. REPLACED EMERGENCY POWER SUPPLY UNIT (AALA202103079004) PER AMM 33-51-00 AND REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY (AALA202103089011) IAW AMM 33-51-00SDR AALA202103079004Power Supply · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTING TEST FAIL. REPLACED EMERGENCY POWER SUPPLY UNIT (AALA202103079004) PER AMM 33-51-00 AND REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY (AALA202103089011) PER AMM 33-51-00SDR AALA202103089013Light · dislodgedAIRCRAFT WAS NOT GROUNDED: AISLE SEAT TRIM AT SEAT 30D DISLODGED BY PASSENGER DURING EXIT WHICH RESULTED IN THE EMERGENCY PATH LIGHTING CONNECTION BEING DAMAGED. REINSTALLED SEAT TRIM AND ELECTRICAL CONNECTOR TO AISLE SEAT 30D AND ACCOMPLISHED A SATISFACTORY SDR MASA2021030700060Connector · unsecureEMER EXIT SIGN-3D/F BULKHEAD INOP. RESECURED CONNECTION TO EXIT SIGN.SDR SWAA2021031153510Battery Pack · inoperativeEMERGENCY AISLE LIGHTS AT ROW 18R AND 21R INOP / REMOVED AND REPLACED BATTERY PACK AT STA 727R PER MM 33-51-06. EMERGENCY LIGHTS OPS CK GOODPER MM 33-51-00SDR SWAA2021031053767Sign · looseEXIT SIGN ON CEILING FELL DOWN / REINSTALLED FWD SIDE OF EMER EXIT SIGN PER SIPSDR WX0A2021030873657Epsu · inoperativeMID RIGHT EPSU BATT INOP / REMOVED AND REPLACED MID RIGHT EPSU BATT IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A. OPS CK GOOD AT THIS TIME.SDR WX0A2021030873656Epsu · inoperativeFWD EPSU BATT INOP / REMOVED AND REPLACED FWD EPSU BATT IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A. OPS CK GOOD AT THIS TIME.SDR WX0A2021030873655Epsu · inoperativeAFT EPSU BATT INOP / REMOVED AND REPLACED AFT EPSU BATT IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A. OPS CK GOOD AT THIS TIME.SDR WX0A2021030873654Epsu · inoperativeMID LEFT EPSU BATT INOP / REMOVED AND REPLACED MID LEFT EPSU BATT IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A. OPS CK GOOD AT THIS TIME.SDR JJBA20210306003Sign · inoperativeAFT CEILING EMERGENCY EXIT SIGNS INOPERATIVE. R&R AFT CEILING EMERGENCY EXIT SIGN. OPS CHECK SAT.SDR R61A2021031100233Battery · failedFWD GALLEY EMERGENCY LIGHT INOP. R&R EMERGENCY LIGHT BATTERY PACK IAW AMM 33-50-00SDR YENA2021031000159Battery · failedFLT 291, BOS-TPA. EMERGENCY LIGHT TEST FAILED BATERY FIN# 13WL; R & R EMERGENCY LIGHT BATTERY FIN# 13WL PER AMM 33-51-38SDR HALA2021030800043Sign · detachedSHIP 374 EXIT SIGN AT 3R DOOR HAS FALLEN OFF. CORRECTIVE ACTION: RESECURED EXIT SIGN AT 3R. (7270711)SDR AALA202103089025Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTS INOPERATIVE AT ROWS 24-32. REPLACED BATTERY AT WELS BATTERY UNIT 27 IAW AMM 33-51-07, OPS CHECK GOOD.SDR SWAA2021030853099Bulb · inoperativeAFT EMERGENCY LIGHT ON LEFT SERVICE DOOR INOP. / RELAMPED AFT EMERGENCY BULB ON LEFT SERVICE DOOR PER AMM 31-51-22. OPS CHECK GOOD.SDR SWAA2021030853350Light · brokenEMERGENCY LIGHT LENSE AND BEZEL BROKEN AT 16 D-E-F / OK TO CONTINUE PER MEL 25-10-01 SP1B TRACKING #70711SDR DALA2021030801335Power Supply · inoperativeSHIP 3301 EMER LIGHTS BETWEEN ROW 8 TO 16AB INOP. CORRECTIVE ACTION: REMOVED AND REPLACED POWER SUPPLY 13WL. (7687856)SDR AALA202103089017Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED EMERGENCY BATTERY PACK (M1695) AT RIGHT OVERWING EMERGENCY LIGHTS.SDR AALA202103069004Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER SUPPLY UNIT 11WL IN PASSENGER CABIN DID NOT PASS TEST. REPLACED THE EMERGENCY POWER SUPPLY UNIT (11WL) PER AMM 33-51-38-400-001-A.SDR AALA202103069002Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: INOPERATIVE EMERGENCY POWER SUPPLY UNIT 10WL IN PASSENGER CABIN (1EA). REPLACED EMERGENCY POWER SUPPLY UNIT 10WL IN FORWARD PASSENGER CABIN PER AMM 33-51-38-400-001-A.SDR AALA202103069014Light · miswiredAIRCRAFT WAS NOT GROUNDED: DOOR 2R EMERGENCY THRESHOLD LIGHT REMAINS ON AT ALL TIMES. MAINTENANCE FOUND WIRES FOR LIGHT 44WL CONNECTED TO LIGHT 32WL AND RECONFIGURED THE WIRES FOR BOTH LIGHTS PER AWM 33-51-02, 33-51-03. A SATISFACTORY OPERATIONAL CHECK WAS ACCSDR AALA202103059034Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: FUNCTIONAL CHECK OF CABIN EMERGENCY LIGHTING FAILED TEST PER J/C26C20033001. TROUBLE SHOOT PER TSM 33-51-00-810-812-A. REPLACED BATTERY PACKS AT 10WL (AALA202103059013), 11WL (AALA202103059033) AND 12WL.SDR AALA202103059033Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: FUNCTIONAL CHECK OF CABIN EMERGENCY LIGHTING FAILED TEST PER J/C26C20033001. TROUBLE SHOOT PER TSM 33-51-00-810-812-A. REPLACED BATTERY PACKS AT 10WL (AALA202103059013), 11WL AND 12WL (AALA202103059034).SDR AALA202103059013Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: FUNCTIONAL CHECK OF CABIN EMERGENCY LIGHTING FAILED TEST PER J/C26C20033001. TROUBLE SHOOT PER TSM 33-51-00-810-812-A. REPLACED BATTERY PACKS AT 10WL, 11WL (AALA202103059033) AND 12WL (AALA202103059034).SDR YENA2021030500147Battery · failed inspFLT # 291, BOS-TPA. EMERCENCY LIGHT TEST FAILED BATTERY FIN#10WL ; EMERCENCY LIGHT TEST FAILED BATTERY FIN#10WLSDR AALA202103249018Light · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT DAMAGED AT SEAT 16D. REPLACED EMERGENCY LIGHT IAW AMM 33-51-06, OPS CHECK GOOD.SDR SWAA2021031555150Power Supply · faultedCB FOUND POPPED AT P-18-3 A-10 (LIGHTS-EMERCHOR-L-AFT) / R&R M1670 BATTERY POWER SUPPLY AND BATTERY PACK PER M/M 33-51-06 R&R BATTERY PACK AT M1668 PER M.M 33-51-06 R&R C/B C1357 P18-3 A10 L-AFT EMERGENCY CHER PER WDM 33-51-11-4 OPS TEST NORMAL PER M/M 33-51-0SDR SWAA2021031555329Battery Pack · faultedCB FOUND POPPED AT P-18-3 A-10 (LIGHTS-EMERCHOR-L-AFT) / R&R M1670 BATTERY POWER SUPPLY AND BATTERY PACK PER M/M 33-51-06 R&R BATTERY PACK AT M1668 PER M.M 33-51-06 R&R C/B C1357 P18-3 A10 L-AFT EMERGENCY CHER PER WDM 33-51-11-4 OPS TEST NORMAL PER M/M 33-51-0SDR YENA2021031000168Battery · failedDURING HEAVY MAINTENANCE, FAULT EPSU 10WL; (REF AEROMAN NR 2021 62778 WO 2021 73/1) R & R EPSU BATTERY 10WL IAW AMM 33-51-38 OPS CHECKS OK IAW AMM 33-51-0-710-001-A
Back to JASC 3350