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 DALA2021072304176Sign · inoperativeSHIP 1708 EMERGENCY LIGHTS AT CHAIR LOCATION ARE INOPERATIVE. CORRECTIVE ACTION: REPLACED EXIT SIGN. SYSTEM OPERATION IS NORMAL. (LP 7453849)SDR AALA202107236646Light · missingAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK FOUND EMERGENCY EXIT PROXIMITY LIGHT MISSING AFT OF GALLEY 5 LEFT SIDE. INSTALLED NEW EMERGENCY EXIT FLOOR PROXIMITY LIGHT PER AMM 33-51-05.SDR AALA202107231004Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATH LIGHTING AT 8ABC INOPERATIVE. RECONNECTED EMERGENCY LIGHT CONNECTOR UNDER SEAT 8C.SDR IPXA2021072171930Battery Pack · inoperativeINSPECTION TYPE:N/AEMERGENCY LIGHT EXIT MARK INOP.EMERGENCY LIGHT BATTERY PACK SUSPECTED BATTERY REPLACED PER AMM 33-51-07-022-001 REV 133.07. OPS CHK SATIS OFF P/N 2013-1A, S/N 48165. ON P/N AD-20131A, S/N 75695SDR DALA2021072204146Light · inoperativeSHIP 3308 PAX SEAT 16HJ EMERGENCY PATH LIGHT INOP. CORRECTIVE ACTION: REMOVED & REPLACED EMERGENCY LIGHT ASSY AT 16HJ. (7908626)SDR AALA202107227889Light · brokenAIRCRAFT WAS NOT GROUNDED: AFT GALLEY EMERGENCY EXIT LIGHT COVER BROKEN. REPLACED EMERGENCY EXIT LIGHT OPERATIONS CHECK GOOD PER AMM 35-51-11.SDR AALA202107223583Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT GUIDE LIGHT AT 9C FELL OFF. SECURED EMERGENXY FLOOR LIGHT ON SEAT 9C REF AMM 33-51-11.SDR DALA2021072204141Lens · missingTHE THE FLIGHT ATTENDANT FOUND THAT THE OVERWING FWD SIDE EMERGENCY EXIT SIGN COVER DIFFUSER LENS IS MISSING. DFRD BY WEISS 00389354 HSV 21JUL21 RII: N ENTR 00389354 P MCC FCP DEFERRAL, FLIGHT CREW PLACARD REQUIRES VALIDATION FLIGHT CREW PLACARD INSTALLED. FOUSDR SIMA20210721002Light · inoperative#1 FLOOR PROXIMITY EMERGENCY LIGHT STRIP INOP-C/A-RAR #1 FLOOR PROXIMITY EMERGENCY LIGHT STRIP IAW EMB-140 AMM 33-50-12. OPC GOOD.SDR SIMA20210721004Lamp · inoperativeDURING PS-1 CHECK, FOUND #3 AISLE EMERGENCY LIGHT INOP.-C/A-RAR LAMP ON # 3 AISLE EMERGENCY LIGHT REF AMM 33-50-08. OPC GOOD.SDR HALA2021072100101Light · inoperativeSHIP 384 3R EMERGENCY LIGHTS INOP. RESET AND TESTED EPSU. LIGHT OPS NORMAL.SDR SWAA2021081196748Battery Pack · inoperativeDONT WORK CORRECTLY LOWER SIDEWALL BATTERY PACK ON EMERGENCY EXIT DOOR AT PASSENGER CABIN (1 EA) ; 2021-311822 / [01] REPLACED LOWER SIDEWALL BATTERY PACK ON EMERGENCY EXIT DOOR AT PASSENGER CABIN (1 EA) IAW B737-700 AMM 33-51-06-960-805.; [02] REPLACED LOWER SDR SWAA2021072696741Sign · looseEMERGENCY EXIT LIGHT COVER @ FORWARD BULKHEAD LOOSE. ; / [01] RESECURED FWD GALLEY EMERGENCY EXIT SIGN OVERHEAD AS REQUIRED PER M/M 33-51-01SDR SWAA2021072696742Sign · detachedFORWARD SERVICE DOOR EXIT SIGN DETATCHED ; / [01] RESECURE EMER. EXIT SIGN PER SIPSDR YENA2021072300477Sign · brokenFLT # 2893, JFK-MIA. AT SEAT 11F SIDEWALL EMERGENCY EXIT SIGN BROKEN ; R/R SEAT 11F SIDEWALL EMERGENCY EXIT LEAN IAW AMM 33-51-13. OPS CHK OK. A/C OF FOR SVCSDR AALA202107225764Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: L1 DOOR EXIT SIGN INOPERATIVE. REMOVED AND REPLACED INOPERATIVE L1 HEADER PANEL EXIT LIGHT WITH NEW EXIT LIGHT PER A321AMM 33-51-00.SDR DALA2021072104137Epsu · no testSHIP 3328 EPSU FIN 12WL FAILS SELF/MCDU BITE TEST. CORRECTIVE ACTION: REMOVED AND REPLACED EPSU. (1882274)SDR DALA2021072104135Epsu · no testSHIP 3328 EPSU FIN 17WL FAILS SELF/MCDU BITE TEST. CORRECTIVE ACTION: REMOVED AND REPLACED EPSU 17WL. (1882162)SDR DALA2021072104134Epsu · no testSHIP 3328 EPSU FIN 18WL FAILS SELF/MCDU BITE TEST. CORRECTIVE ACTION: REMOVED AND REPLACED EPSU 18WL. (1882161)SDR AALA202107212499Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: CROSS AISLE EMERGENCY LIGHT ADJACENT TO LAVATORY 1A-L INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AND CHARGER M33093 IAW MM 33-51-06.SDR AALA202107216029Cover · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT LENS COVER AT SEAT 15 D IS MISSING. REPLACED 15D EMERGENCY LIGHT LENS COVER IAW CMM 25-02-67 AND AMM 33-51-00.SDR WX0A2021072173782Lamp · inoperativeDURING INSPECTION OF TC 335100-10-1-001, DISCOVERED MULTIPLE LIGHTS FAILED TO ILLUMINATE ON MID FWD EMERGENCY EXIT SIGN 51WL. / RELAMPED MID FWD EMERGENCY EXIT SIGN 51WL, OPS CK GOOD IAW AMM 33-51-17."SDR WX0A2021072173781Lamp · inoperativeDURING INSPECTION OF TC 335100-10-1-001, DISCOVERED MULTIPLE LIGHTS FAILED TO ILLUMINATE ON L2 DOOR EMERGENCY EXIT SIGN 45WL. / RELAMPED L2 DOOR EMERGENCY EXIT SIGN 45WL, OPS CK GOOD IAW AMM 33-51-16."SDR WX0A2021072173780Lamp · inoperativeDURING INSPECTION OF TC 335100-10-1-001, DISCOVERED MULTIPLE LIGHTS FAILED TO ILLUMINATE ON RH WALL MOUNTED OVERWING EMERGENCY EXIT SIGN 42WL. / RELAMPED RH WALL MOUNTED OVERWING EMERGENCY EXIT SIGN 42WL, OPS CK GOOD IAW AMM 33-51-16."SDR WX0A2021072173779Lamp · inoperativeDURING INSPECTION OF TC 335100-10-1-001, DISCOVERED MULTIPLE LIGHTS FAILED TO ILLUMINATE ON MID AFT EMERGENCY EXIT SIGN 53WL. / RELAMPED MID AFT EMERGENCY EXIT SIGN 53WL, OPS CK GOOD IAW AMM 33-51-17."SDR WX0A2021072173778Lamp · inoperativeDURING INSPECTION OF TC 335100-10-1-001, DISCOVERED MULTIPLE LIGHTS FAILED TO ILLUMINATE ON CENTER AFT EMERGENCY EXIT SIGN 52WL. / RELAMPED CENTER AFT EMERGENCY EXIT SIGN 52WL, OPS CK GOOD IAW AMM 33-51-17."SDR WX0A2021072173777Lamp · inoperativeDURING INSPECTION OF TC 335100-10-1-001, DISCOVERED MULTIPLE LIGHTS FAILED TO ILLUMINATE ON L1 DOOR EMERGENCY EXIT SIGN 41WL. / RELAMPED L1 DOOR EMERGENCY EXIT SIGN 41WL, OPS CK GOOD IAW AMM 33-51-16."SDR WX0A2021072173776Lamp · inoperativeDURING INSPECTION OF TC 335100-10-1-001, DISCOVERED MULTIPLE LIGHTS FAILED TO ILLUMINATE ON R2 DOOR EMERGENCY EXIT SIGN 44WL. / RELAMPED R2 DOOR EMERGENCY EXIT SIGN 44WL, OPS CK GOOD IAW AMM 33-51-16."SDR WX0A2021072173775Lamp · inoperativeDURING INSPECTION OF TC 335100-10-1-001, DISCOVERED MULTIPLE LIGHTS FAILED TO ILLUMINATE ON LH WALL MOUNTED OVERWING EMERGENCY EXIT SIGN 43WL. / RELAMPED LH WALL MOUNTED OVERWING EMERGENCY EXIT SIGN 43WL, OPS CK GOOD IAW AMM 33-51-16."SDR WX0A2021072173774Lamp · inoperativeDURING INSPECTION OF TC 335100-10-1-001, DISCOVERED MULTIPLE LIGHTS FAILED TO ILLUMINATE ON R1 DOOR EMERGENCY EXIT SIGN 40WL. / RELAMPED R1 DOOR EMERGENCY EXIT SIGN 40WL, OPS CK GOOD IAW AMM 33-51-16."SDR WX0A2021072173773Lamp · inoperativeDURING INSPECTION OF TC 335100-10-1-001, DISCOVERED MULTIPLE LIGHTS FAILED TO ILLUMINATE ON CENTER FWD EMERGENCY EXIT SIGN 50WL. / RELAMPED CENTER FWD EMERGENCY EXIT SIGN 50WL, OPS CK GOOD IAW AMM 33-51-17."SDR AALA202107212765Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER SUPPLY UNIT 15WL BATTERY INOPERATIVE. REPLACED BATTERY PER AMM 33-51-00-710-001-A.SDR SIMA20210720001Lamp · inoperativeRH OVER WING EMERGENCY LIGHT INOP-C/A-RAR RH OVER WING EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPS CHECK GOOD. END.SDR CALA2021072101148Battery Pack · inoperativeEMERGENCY BATTERY PACK NEEDS TO BE REPLACED. ROW 30 LK. REPLACED BATTERY PACK ROW 30 LK. REF 767/400 AMM 33-51-07SDR CALA2021072101147Battery Pack · inoperativeEMERGENCY BATTERY PACK NEED TO BE REPLACED POSITION ROW 41 BA REPLACED EMERGENCY BATTERY PACK POSITION 41BA REF. B767-400 AMM 33-51-07SDR MASA2021072000162Switch · unsecureUNABLE TO TURN OFF EMERGENCY LIGHTS - MX RESECURED PILOTS OVHD PANEL EMER EXIT SW. OPS CK NORMAL. STS MXSDR I5EA2021072000002Battery Pack · no testEMERGENCY LIGHT INOP AT ROW 20 L/H.. REMOVED AND REPLACED BATTERY PACK ON M1135 POWER SUPPLY AT STA. 629R IAW B-737-300 AMM 33-51-51. OPS CHECK GOOD.SDR SIMA20210719003Nut Plate · missingRIGHT OVERWING EMERGENCY LIGHT HAS A MISSING LENS ATTACH NUTPLATE-C/A-COMPLETE:RAR'D EMERGENCY LIGHT IAW AMM 33-50-10, OPS CHECK GOODSDR AALA202107266103Cover · brokenAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY TRIM LIGHT COVER BROKEN ON ROW 30 C,B,A. **SUPPLEMENTAL REPORT FOR AALA202107216103: REMOVED AND REPLACED AT SEAT ROW 30CBA EMERGENCY TRIM LIGHT COVER PER AMM 25-21-00.** (CLOSED)SDR SWAA2021072396077Cover · missingOVERHEAD EMERGENCY EXIT SIGN COVER IS MISSING. THE SIGN AT THE OVERWING EXIT. / RE-SECURED O/H EMERGENCY SIGN COVER PER AMM 20-00-00.SDR SWAA2021072396133Fuse · failedLEFT EMERGENCY EXIT WINDOW LIGHT INOP ; / [01] R&RD FUSE PER AMM 33-21-00SDR SWAA2021072396016Lamp · inoperativeEXTERIOR AFT ONLY DOOR EMERGENCY EXIT LIGHT INOP (SLIDE LIGHT) / RELAMPED PER AMM 33-51-04SDR AALA202107233545Light · missingAIRCRAFT WAS NOT GROUNDED: ROW 15ABC WHITE SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY MISSING. **SUPPLEMENTAL REPORT FOR AALA202107213545: INSTALLED ESCAPE PATH LIGHTING SHROUD ASSEMBLY AND LIGHT PER ESO NUMBER 34240** (CLOSED)SDR AALA202107216103Cover · brokenAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY TRIM LIGHT COVER BROKEN ON ROW 30 C,B,A. (OPEN)SDR AALA202107213545Light · missingAIRCRAFT WAS NOT GROUNDED: ROW 15ABC WHITE SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY MISSING. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR IPXA2021072071872Battery Pack · inoperativeEMERGENCY LIGHTS INOP.REMOVED AND REPLACED EMERGEMCY BATTERY PACK IAW AMM 33-51-07.SDR AALA202107201509Control Unit · no testAIRCRAFT WAS NOT GROUNDED: DURING EMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK, WELLS CONTROL UNIT LH1 NOT COMMUNICATING WITH WELS BATTERY UNITS. REPLACED WELS CONTROL UNIT LH1 PER AMM 33-51-07.SDR SIMA20210719002Light · inoperativeDURING PS-2 CHECK FOUND RH CENTER FAIRING EXTERIOR EMERGENCY LIGHT INOP-C/A-RAR RH CENTER FAIRING EXTERIOR EMERGENCY LIGHT IAW EMB 145 AMM 33-50-10. OPS CHECK GOOD.SDR AALA202107191720Light · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT CABIN WALL-MOUNTED BOTTOM EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED FORWARD RIGHT CABIN WALL-MOUNTED BOTTOM EMERGENCY EXIT LIGHT PER AMM 33-51-13.SDR SWAA2021082395933Battery Pack · inoperativeINOP LOWERED CEILING PANEL BATTERY PACK LT SIDE AT FWD GALLEY AREA (1 EA) ; 2021-325912 / [01] REPLACED LOWERED CEILING PANEL BATTERY PACK LT SIDE AT FWD GALLEY AREA (1 EA) I.A.W. B737-700 AMM 33-51-06-960-805 TEST OK; [02] REPLACED LOWERED CEILING PANEL BATTE
Back to JASC 3350