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 SWAA2020061591864Battery Pack · inoperativeEMERGENCY EXIT LIGHTS ON ROW 9ABC AND 11ABC INOP. / REMOVED AND REPLACED BATTERY PACK PER AMM 33-51-06SDR SIMA202006121001Bulb · inoperativeL/H OVERWING EXTERIOR EMERGENCY LIGHT INOP.-C/A-REMOVED AND REPLACED L/H OVERWING EXTERIOR EMERGENCY LIGHT BULB IAW AMM 33-50-10. OPS CHECK GOOD.SDR SWAA2020061291134Battery Pack · dischargedAFT ENTRY DOOR INTERIOR/EXTERIOR EMERGENCY LIGHTS INOP. R/R BATTERY PACK AT POSITION M1673 PER AMM 33-51-06 PN OFF/ON D717-01-100SWA SN OFF 46464 SN ON 208967.SDR SWAA2020061291369Battery Pack · dischargedEMERGENCY ASILE LIGHTS AT STATION 560-620 LBL AND BOTH OVER WING EXIT LIGHTS OUT AT STATION 747 ARE OUT. REMOVED AND REPLACED BATTERY PACK AT STATION 727C & B WL 212 LBL 68 SYSTEM OPS CHECKS GOOD POS M1670 P/N OFF/ON D-717-01-100SWA S/N OFF 81550 S/N ON 2112SDR SWAA2020061291168Battery Pack · dischargedEMERGENCY LIGHTS IN BINS ABOVE LEFT EMERGENCY OVERWING EXIT INOP. REMOVED/REPLACED EMERGENCY LIGHT BATTERY PACK FOR LIGHTS ABOVE LEFT OVERWING EXIT IAW AMM 33-51-06. OPS TEST OK.SDR SWAA2020061291506Battery Pack · dischargedFWD LT EMERGENCY LIGHTS. R&R FWF LT BATTERY PACK OPS CK GOOD PER MM 33-51-06.SDR SWAA2020061291294Battery · dischargedEMERG LIGHTS AT ROW 10 DEF + 14 DEF INOP. REMOVED + REPLACED BATTERY + BATTERY CHARGER AT STA 500 C ON RT SIDE. OPS CHECK GOOD IAW AMM 33-51-06.SDR AALA202006129004Battery · faultedAIRCRAFT NOT GROUNDED - EPSU (EMERGENCY POWER SUPPLY UNIT) 11WL BATTERY FAULT, WHILE PERFORMING EPSU TEST. REMOVED AND REPLACED EPSU 11WL BATTERY PER AMM 33-51-38, OPERATIONAL CHECK GOOD.SDR AALA202006129003Power Supply · faultyAIRCRAFT NOT GROUNDED - EPSU (EMERGENCY POWER SUPPLY UNIT) 12WL FAULT, WHILE PERFORMING EPSU TEST. REMOVED AND REPLACED EPSU 12WL PER AMM 33-51-38, OPERATIONAL CHECK GOOD.SDR AALA202006129002Battery Pack · dischargedAIRCRAFT WAS GROUNDED: RIGHT HAND OVERWING EMERGENCY EXIT LIGHT INOPERATIVE AT SEAT ROW 15. REPLACED BATTERY PACK IN EMERGENCY POWER SUPPLY UNIT M1695 AND ACCOMPLISHED A SATISFACTORY OPERTIONAL CHECK PER AMM 33-51-00.SDR AALA202006129001Battery Pack · dischargedAIRCRAFT WAS GROUNDED: LEFT HAND OVERWING EMERGENCY EXIT LIGHT INOPERATIVE AT SEAT ROW 15. REPLACED BATTERY PACK IN EMERGENCY POWER SUPPLY UNIT M1694 AND ACCOMPLISHED A SATISFACTORY OPERTIONAL CHECK PER AMM 33-51-00.SDR SWAA2020062991254Light · damagedRIGHT PASSENGER CABIN SIDEWALL PANEL 232YHW EXIT LIGHT ASSEMBLY WAS DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-01-960-802; STEP 3, D5, D6, 10. OPS CHECKED IAW MM 33-51-00-720-801, AND MM 33-51-00-710-801, TESTED GOOD.SDR ASAA2020061232796Light · inoperativeEMERGENCY EXIT LIGHT AT ROW 10ABC BELOW OVERHEAD BIN IS INOP. GROUNDED - YES. RELAMPED EXIT LIGHT AT ROW 10 ABC, OPS NORMAL.SDR DALA2020061202467Light · damagedDURING INSPECTION FOUND EMERGENCY SEAT MOUNTED LIGHTING DAMAGED/INOPERATIVE. SECURED SEAT LIGHTING. OPS NORMAL.SDR SWAA2020061290950Battery · dischargedEMERGENCY LIGHTS INOP ROWS 14ABC TO 24ABC. R&RED EMERGENCY LT BATTERY (M1673) PER AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2020061291274Light · looseEMERGENCY EXIT LIGHTING FLOOR STRIP AT ROW 8 LOOSE. SECURED FLOOR PROXIMITY LIGHT STRIP PER AMM 33-51-15.SDR WX0A2020061273513Light · inoperativeLT OVER WING EMERGENCY EXIT LIGHT INOP. REPLACED OVER WING EMERGENCY EXIT LIGHT.SDR SIMA202006110001Power Unit · inoperativeFWD SERVICE DOOR LOWER EMERGENCY LIGHT INOP. REMOVED AND REPLACED NR 1 EMERGENCY LIGHT POWER UNIT FOR THE FWD SERVICE DOOR LOWER EMERGENCY LIGHT IAW AMM 33-50-01. OPS CHK GOOD.SDR R61A2020061100526Power Supply · inoperativeDURING EMERGENCY LIGHT TEST, THE EXIT SIGN AT THE BOTTOM RIGHT CORNER OF THE L2 DOOR CUT-OUT DID NOT ILLUMINATE. R&R EXIT LIGHT AND EMERGENCY LIGHT POWER UNIT NR 3 IAW AMM 33-50-15.SDR AALA202006119003Battery · failedAIRCRAFT IN BASE MAINTENANCE - EPSU 14WL TEST FAILED. REPLACED EPSU 14WL BATTERY PER AMM 33-51-38, OPERATIONAL CHECK GOOD.SDR AALA202006119002Battery · failedAIRCRAFT IN BASE MAINTENANCE - EPSU 10WL TEST FAILED. REPLACED EPSU 10WL BATTERY PER AMM 33-51-38, OPERATIONAL CHECK GOOD.SDR MASA2020061010101Sign · inoperativeSVC DR EXIT SIGN INOPERATIVE. REPLACED LIGHTED SIGN ASSYSDR SWAA2020061091070Strip · damaged1FED EMERGENCY FLOOR TRACK STRIP DAMAGED. REMOVED & REPLACED 1FED EMERGENCY FLOOR TRACK STRIP; PER DWG 33500007.SDR SWAA2020061091069Strip · damaged1ABC EMERGENCY FLOOR TRACK STRIP DAMAGED. REMOVED AND REPLACED 1ABC EMERGENCY FLOOR TRACK STRIP PER ENG DWG 33500007.SDR SWAA2020061091054Light · inoperativeEMERGENCY LIGHT AFT OF LEFT WING INOP. RELAMPED EMERGENCY LIGHT AFT OF LEFT WING IAW MM 33-51-04. OPS CHECK GOOD.SDR SWAA2020061091011Light · brokenR1 & L1 EMERGENCY EXIT LIGHT ASSY NEED REPLACING DUE TO BROKEN BASES. REMOVED & REPLACED EXIT LIGHT ASSYS REF AMM 33-51-01.SDR DALA2020061002460Power Supply · no testEPSU (14WL) FAILS EPSU SYSTEM TEST, REPLACED EMERGENCY POWER SUPPLY UNIT 14WLSDR SWAA2020061290735Power Supply · inoperativeSUPPLEMENTAL INFORMATION: THE CAPTS FLT DECK EMERGENCY LIGHT LOCATED IN THE DOME LIGHT IS INOP. RELAMPED EMERGENCY LIGHT NO HELP ( COCKPIT/FLT DECK/INST LT SYS ) / DMA 0298102REMOVED AND REPLACED POWER SUPPL M1675 PER AMM 33-51-06. OPS NORMAL CLEARING # 77189SDR SWAA2020061590949Connector · disconnectedR/H CABIN EMERGENCY EXIT DOOR AFT SIDE LIGHT INOP. RESECURED R/H CABIN EMERGENCY EXIT DOOR AFT SIDE LIGHT ASSY CONNECTOR D12394 PER B737 AMM 33-51-01-960-801SDR SWAA2020061290817Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATIONS M1670; M1672; M1673 AND M1675 IN THE CABIN. REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES AT LOCATIONS M1670; M1672; M1673 AND M1675 IN THE CABIN PER AMM 33-51-06.SDR SWAA2020061290984Battery Pack · dischargedEMERGENCY EXIT LIGHTS COMMON TO BATTERY PACK M 1674 INOP. REPLACED EMERGENCY EXIT LIGHTS BATTERY PACK M1674 AND PERFORMED GOOD OPS CHECK PER AMM 33-51-06-960-805.SDR SWAA2020061291268Battery Pack · failedAFT LT EMERGENCY BATTERY PACK FAILED CAPACITY TEST. REMOVED AND REPLACED AFT LT EMERGENCY LIGHTS BATTERY PACK PER M/M 33-51-06.SDR VNAA2020061211101Lens · missingÏ¿½FORWARD FACING CEILING EMERGENCY EXIT SIGN MISSING RED LENS CAP. INSTALLED RED LENS CAP ON FWD SIDE OF CEILING EMERGENCY EXIT SIGN IAW CRJ 700 AMM 33-51-07-400-801.SDR VNAA2020061211102Lens · missingAFT FACING CEILING EMERGENCY EXIT SIGN MISSING RED LENS CAP. INSTALLED RED LENS CAP ON AFT SIDE OF CEILING EMERGENCY EXIT SIGN IAW AMM 33-51-07-400-801.SDR SIMA202006109002Light · inoperativeLAST ROW FLOOR EMERGENCY LIGHT STRIP INOP. REMOVED AND REPLACED LAST ROW FLOOR EMERGENCY LIGHT STRIP IAW AMM 33-50-12 STEP 4 J2, STEP 5 I-J. ETN-EM-33-058.SDR DALA2020061002459Power Supply · faultedEPSU SYSTEM TEST FAULTS BATTTERY EPSU (13WL) AFT L, REPLACED THE BATTERY ON EPSU 13WLSDR AALA202006099003Power Supply · faultedAIRCRAFT NOT GROUNDED. LEFT EMERGENCY OVERWING EXIT EMERGENCY POWER SUPPLY UNIT FAULT DURING TESTING. REPLACED EMERGENCY POWER SUPPLY UNIT (11WL) ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR SWAA2020061290982Battery Pack · dischargedEMERGENCY EXIT LIGHTS COMMON TO BATTERY PACK M1675 INOP. REMOVED; REPLACED AND PERFORMED GOOD OPS TEST OF M1675 BATTERY PACK PER AMM 33-51-06-960-805.SDR SWAA2020061290620Power Supply · failedEMERGENCY LIGHTS FAILED OPERATIONAL TEST AT POSITIONS: FWD GALLEY WALL LOWER RT POSITION AND OUTSIDE RT FWD OF AFT CARGO DOOR. SECURED CONNECTOR AT EMERGENCY EXIT SIGN AT FWD GALLEY WALL LOWER RT AND REMOVED AND REPLACED BATTERY POWER SUPPLY AND BATTERY PACK SDR SWAA2020061290619Power Supply · failedEMERGENCY LIGHTS FAILED OPERATIONAL TEST AT POSITIONS: OVERHEAD BINS POSITIONS (NR 9 & 11) LT AND FWD LAV WALL LOWER LT POSITION. REMOVED AND REPLACED BATTERY POWER SUPPLY AND BATTERY PACK AT POSITION M1670 AND SECURED CONNECTOR AT EXIT SIGN FWD LAV WALL LOWESDR DALA2020061202465Power Supply · inoperativeDURING SVC CHK FOUND EMERGENCY LIGHTS AT ROWS 38-42 OUT AS WELL AS CEILING LIGHTS. R/R M735 POWER SUPPLY AS PER AMM 33-51. OPS CHK GOOD.SDR SWAA2020061190983Light · inoperativeLT OVER WING EXTERIOR EMERGENCY EXIT LIGHT INOP. REPLACED LT OVERWING EXTERIOR EMERGENCY EXIT LIGHT LAMP AND PERFORMED GOOD OPS CHECK PER AMM 33-51-04-960-801.SDR SWAA2020061091107Battery · dischargedCABIN AFT LEFT EMERGENCY LIGHTS INOP. REMOVED & REPLACED M1673 EMER LIGHT BATTERY. OPS CHECK GOOD PER AMM 33-51-06 P/N OFF/ON D717-01-100SWA S/N OFF 46639 S/N ON 55152.SDR SWAA2020061090954Battery Pack · dischargedBULLNOSE LIGHTS AT ROW 3 DEF & 6 DEF INOP. R&R EMERGENCY LIGHT BATTERY PACK PER AMM 33-51-06 OPS CHECK GOOD.SDR SWAA2020061090971Battery Pack · dischargedBATTERY PACKS INOPS FOR EMERGENCY LIGHTS AT STA 603 LEFT & 223 RIGHT. R&R BATTERY PACKS FOR EMERGENCY LIGHTS AT STA 60327 & 223 RT REF AMM 33-51-06.SDR SWAA2020061090643Battery Pack · dischargedLT PAX CABIN EMERGENCY EXIT LIGHTS (OVER WING INSIDE & OUSIDE) INOP. REPLACED LT OVER WING EMERGENCY EXIT LIGHTS BATTERY PACK REF AMM 33-511-06.SDR SIMA202006098002Charger · inoperativeNR 2 EMERGENCY LIGHT BATTERY INOP. REMOVED AND REPLACED NR 2 EMERGENCY LIGHT BATTERY AND CHARGER IAW AMM 33-50-04. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 85828.SDR R61A2020061000523Battery Pack · dischargedEMERGENCY LIGHT BATTERY FAULT ON EICAS. CHARGED EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR SIMA202006098001Light · inoperativeMAIN DOOR CEILING EMERGENCY LIGHT INOP. REMOVED AND REPLACED MAIN DOOR CEILING EMERGENCY LIGHT LAMP IAW AMM TASK 33-50-06-000-801-A AND 33-50-06-400-801-A. OPC GOOD.SDR SWAA2020061190472Light · inoperativeAFT ENTRY DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED IAW AMM 33-51-04.
Back to JASC 3350