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 REXA2021031600189Bulb · inoperativeCEILING EMERGENCY LIGHT FOUND INOP. REMOVED AND REPLACED CEILING EMERGENCY LIGHT BULB IAW CRJ 700 AMM 33-51-09. OPS CHECK GOOD.SDR UIEA2021031400543Light · inoperativeFLIGHT DECK EMERG. LIGHT INOP(<P>REMOVED/REPLACED LT. ASY. M744 F/D EMG. PER AMM 33-51-02 & OPS CHECK EMG. LT SYS OK </P><P>AMM 33-51-00</P>)SDR UIEA2021031400544Lamp · inoperativeAFT UPPER RIGHT FUESELAGE FOUND E EMERG. LIGHT INOP (OUT)(<P>RELAMPED AFT RH UPPER FUSELAGE EMG. LT. & OPS CHECK OK AMM 33-51-00</P>)SDR IPXA2021031666907Battery Pack · no testWHEN PREFLIGHT TESTING THE EMERGENCY LIGHTS EMERG LT BAT 1 LO ILLUMINATED. DEFERRED PER MEL 33 50 4 EMERGENCY LT BAT 1 LO DMP C/W M738710R/R'D EMERGENCY LIGHT BATTERY & OPS CK REF MM 33-50-00. OPS CHK GOOD. DMP REVERSED 33-50-1. M738710 CLEARED. EFF SOURCE SDR YENA2021031900180Battery · failed inspFLT 1348, SJU-DCA. EMERGENCY LIGHT BATTERY " RIGHT" FAILED CAPACITY CHECK ; R&R "RIGHT" EMERGENCY BATTERY REF AMM 33-51-38, SELF TEST OK.SDR YENA2021031900179Epsu · failed inspFLT 1348, SJU-DCA. EMERGENCY LIGHT POWER SUPPLY " AFT" TEST FUNCTION INOP ; R&R AFT EMERGENCY LIGHT POWER SUPPLY REF AMM 33-51-38, SELF TEST OK.SDR YENA2021031900178Battery · failed inspFLT 1348, SJU-DCA. EMERGENCY BATTERY "AFT" FAILED CAPACITY TEST ; R&R EMERGENCY BATTERY " AFT" REF AMM 33-51-38, SELF TEST OKSDR DALA2021031801556Lens · missingSHIP 198 RED EMERGENCY LIGHT LENS IS MISSING ACROSS FROM SEAT 42C BY THE AISLE. MAINTENANCE INSTALLED MISSING LENS COVER. SYSTEM OPERATION IS NORMAL. (LP 7389348)SDR DALA2021031801530Battery Pack · no testTHE EMERGENCY LIGHTS WOULD NOT TEST FROM F/A SWITCH. MAINTENANCE FOUND THE OVERWING BATTERY PACK LOW AND REPLACED IT. THE EMERGENCY LIGHTS NOW CHECK GOOD FROM BOTH THE F/A AND COCKPIT POSITIONS. (LP #7577565)SDR DXTA2021031839630Battery Pack · inoperativeEMERGENCY LIGHTS BATTERY: EMERGENCY LIGHTS DO NOT ILLUMINATE WHEN EMER.SWITCH IS PLACED INTO ON///SIGN-OFF//REMOVED AND REPLACED EMERGENCY BATTERY PACKS. IAW 680AS AMM 33-50-06.SDR DXTA2021031839620Battery Pack · inoperativeEMERGENCY LIGHTING: EMER LIGHT IN ARM POSITION WILL NOT GO OUT. REMOVED AND REPLACED EMERGENCY BATTERY PACK IAW EMB AMM 33-50-11.SDR SWAA2021031756127Lens · missingEXIT SIGN COVER AT RIGHT OVERWING EMERGENCY EXIT MISSING / INSTALLED RIGHT WING EMER EXIT LWR LIGHT LENSE PER AMM 33-51-01 OPS CHECK NORMAL PER AMM 33-51-00SDR SWAA2021031756245Connector · looseINOP EMERGENCY LIGHT LOCATED ON BS 365 LH SIDE AT PASSENGER CABIN / PERFORMED TROUBLESHOOTING AND FOUND LOOSE CONNECTOR D11074 IAW WDM 33-51-12. INSTALLED CORRECTLY CONNECTOR D11074 IAW SWPM 20-60-00; TEST IS OK IAW AMM 33-51-00-710-801 EMERGENCY LIGHT OPERATISDR SWAA2021031756176Light · inoperativeCAPTAIN SIDE OVERWING EXIT LIGHT INOP / RELAMPED OPS NORMAL 33-51-21SDR AALA202103179012Lamp · burned outAIRCRAFT WAS NOT GROUNDED: DOOR 4R SLIDE LIGHT BURNED OUT. RELAMPED SLIDE LIGHT AT DOOR 4R PER AMM 33-51-04.SDR QXEA2021031600115Battery Pack · inoperativeDURING OPS TEST, 4 EMERGENCY FLOOD LIGHTS IN THE AFT PAX CABIN AND 2 EXIT SIGNS (AFT CABIN) DID NOT ILLUMINATE. REMOVED AND REPLACED #3 EMERGENCY LIGHT POWER SUPPLY AND BATTERIES PER Q400 AMM 33-51-01-000-801, 33-51-01-400-801, 33-51-01-000-802, 33-51-01-400-8SDR DALA2021031901597Lamp · inoperativeSHIP 197 LOWER LOBE CREW REST VERTICAL EMERGENCY PATH LIGHT IS INOPERATIVE. MAINTENANCE RELAMPED 5 BULBS. SYSTEM OPERATION IS NORMAL. (LP 7594549)SDR DALA2021031801558Lens · unsecureSHIP 6704 EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS:606. CORRECTIVE ACTION: SECURED LOOSE COVER. (1755197)SDR SWAA2021031756392Lens · missingOVERWING EXIT ROW SIGN MISSING F/O SIDE / FOUND EXIT LENSE UNDER SEAT RE-INSTALLED PER AMM 33-51-01 LIGHT OPS CHK GOODSDR DALA2021031801548Bulb · inoperativeSHIP 197 LOWER LOBE CREW REST HORIZONTAL EXIT SIGN IS INOPERATIVE. RELAMPED 8 BULBS. SYSTEM OPERATION IS NORMAL.SDR DALA2021031801547Bulb · inoperativeSHIP 197 LOWER LOBE CREW REST VERTICAL EXIT SIGN IS INOPERATIVE. MAINTENANCE RE-LAMPED 16 BULBS. SYSTEM OPERATION IS NORMAL. (LP 7594547)SDR SWAA2021031755987Lens · missingAFT ENTRY DOOR FIRST OFFICERS SIDE EXIT LENSE MISSING / INSTALLED LENS PER M/M 33-51-01SDR SWAA2021031755237Light · looseILLUMINESENT STRIP FOR EMERGENCY EXIT LIGHTING LOOSE ROW 12 ABC SIDE ( FLOOR PROX EMER ESCAPE PATH MARKING SYS ) / DMA #0426323 RESECURED FLOR TRACK LIGHTING @ 12ABC IAW AMM 25-27-31 CLEARING #85816SDR WX0A2021031773663Epsu · no testEPSU BATTERY (12WL) FAILED OP'S CHECK VIA MCDU / REMOVED AND REPLACED EPSU BATTERY (12WL) IAW AMM 33-51-38-000-002-A/33-51-38-400-002-A; OP'S CHECK GOOD"SDR DALA2021031701512Light · detached(LOG 1755973) DURING INSPECTION FOUND EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP. REATTACHED EMERGENCY LIGHT PER B737 AMM 33-51. OPS CHECK GOOD.SDR DALA2021031701510Fuse · inoperative(LOG 7555810) DURING INSPECTION FOUND EMERGENCY EXIT EXTERIOR LIGHTS INOPERATIVE AT RIGHT WING AFT AND RIGHT SIDE JUST AFT OF WING. INSTALLED NEW FUSE. RIGHT EXTERIOR LIGHTS L548 AND L7 OK.SDR AALA202103179006Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: 10WL BATTERY FAILED ON PS CHECK TEST. REMOVED AND REPLACED 10WL BATTERY PACK PER AMM 33-51-38.SDR 2DYA20210316000Battery Pack · inoperativeDURING A ROUTINE MAINTENANCE THE MECHANIC FOUND L1,L3 AND L4 EXTERIOR EMERGENCY LIGHT INOP. MAINTENANCE REMOVED AND REPLACED M738 BATTERY PACKS. OPS CHECK IS NORMAL AND IAW AMM 33-15-66.SDR DALA2021031601477Lamp · inoperativeSHIP 3361 EEPL ROW 24 JH INOP. CORRECTIVE ACTION: RELAMPED WITH NEW ASSEMBLY. RE SECURED FLOOR CONNECTOR NEAR SIDEWALL. (7604639)SDR DXTA2021031639570Switch · trippedEMERG EXIT SIGN/LIGHT: EXIT LIGHT OVER THE PAX ENTRANCE DOOR AND BOTH EXIT LIGHTS AT THE BOTTOM OF THE DOOR WILL NOT TURN OFF IN ANY EMER SWITCH POSITION. TRIED DISCONNECTING THE BATTERIES AND RECONNECTED THE BATTERIES AND THE LIGHTS CAME BACK ON WITH THE EMERSDR MASA2021031500067Bulb · inoperativeROW 13A/C MID LEVEL EXIT SIGN BULB INOP. RELAMPED.SDR MASA2021031500066Bulb · inoperativeROW 3 CEILING EMER FLOOD LIGHT INOP. REPLACED LIGHT BULBSDR CALA2021031500319Battery · inoperativeR2 DOOR M33098 BATTERY FOUND INOP, REF TO HAECO NON-ROUTINE NO. 9432554, SPEC NO. B777-33-3-7019. REPLACED R2 BATTERY PACK AND DO THE INSTALLATION TEST, THE TEST RESULT NORMAL REF AMM 33- 51-06-960-802 REV 90.SDR DALA2021031801561Shroud · unsecureSHIP 6823 EMERGENCY LIGHT COMPONENT LOOSE SEAT 21D. CORRECTIVE ACTION: R/R SEAT 21D AISLE SHOURD. (7395012)SDR SWAA2021031755228Power Supply · inoperativePASSENGER CABIN; EMERGENCY EXIT LIGHTS CONTROLLED BY M1676 ARE OUT; SEAT ROW 7 DEF / REMOVED AND REPLACED M1676 EMERGENCY LIGHTS POWER SUPPLY IAW B 737 AMM 33-51-06-960-805 OPS TEST GOOD OF EXIT LIGHTS CONTROLLED BY M1676 SEAT ROW 7DEF POS: RH P/N OFF: D717-01SDR SWAA2021031755288Lens · missingMID CABIN AISLE EXIT SIGN MISSING A LENSE / INSTALLED NEW EMER EXIT LENS AT MID CABIN CEILING AFT SIDE REF MM 33-51-01SDR DALA2021031701525Lens · damagedSHIP 5649 EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:604. CORRECTIVE ACTION: REINSTALLED LENS ASSY. (1754800)SDR DALA2021031701524Fuse · blownSHIP 697 EMERGENCY LIGHTS AT PAX SEAT 43, 44, 45 AND L3 EXIT INOP. CORRECTIVE ACTION: T/S AND FOUND FUSES ON M736 BATTERY CHARGER AT FAULT, REPLACED SAME AND BATTERY PER B757 AMM 33-51. OPS CK NML. (6695085)SDR DALA2021031601485Sign · inoperativeSHIP 1802 CREW REST FORWARD EMERGENCY EXIT LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE EXIT SIGN ASSEMBLY. SYSTEM OPERATION IS NORMAL. (LP 7427077)SDR DXTA2021031539490Sign · inoperativeCABIN EMERG LIGHT: RED EXIT SIGN ABOVE PRECATCH (FORWARD OF MAIN CABIN DOOR) IS INOP. WHEN ACTUATING AND/OR JIGGLING THE PRECATCH LEVER, SOMETIMES THE EXIT SIGN WILL ILLUMINATE INTERMITTENTLY. REMOVED AND REPLACED CABIN EMERGENCY LIGHT FORWARD OF MED IAW CE-5SDR AALA202103159026Cover · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT COVER IS DAMAGED UNDER SEAT 32C. REPLACED LIGHT ASSEMBLY PER AMM 33-51-11.SDR I5EA2021031500008Battery Pack · dischargedRH INTERIOR AND EXTERIOR EMERGENCY EXIT LIGHTS INOP AT R1. REMOVED AND REPLACED BATTERY PACK AT M1132, STA 330R. IAW B737-400 AMM 33-51-51SDR I5EA2021031500007Battery Pack · dischargedLH INTERIOR AND EXTERIOR EMERGENCY LIGHTS INOP AT OVER WING EXIT. REMOVED AND REPLACED BATTERY PACL AT M1576, STA 727B, STR 1L, IAW B737-400 AMM33-51-51SDR SIMA20210314001Lamp · inoperativeRH EXTERIOR EMERGENCY LIGHT INOP-C/A-RAR RH EXTERIOR EMERGENCY LAMP IAW AMM 33-50-10 OPC GOODSDR SIMA20210314002Power Supply · inoperativeFOUND AFT LH PASSAGE WAY EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED #3 EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. OPERATIONAL CHECK IS GOOD.SDR SWAA2021041356420Lens · missingMISSING SIDEWALL PANEL LENS EXIT/SALIDA ON PANEL 231YHW(1E) AT PASSENGER CABIN (1EA) / INSTALLED SIDEWALL PANEL LENS EXIT/SALIDA ON PANEL 231YHW (1EA) AT PASSENGER CABIN (1EA) IAW BOEING 737-700 AMM 33-51-01-960-801 STEP 2B(4)SDR AALA202103179014Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTS INOPERATIVE AT SEAT ROWS 13-18. REPLACED WELS BATTERY UNIT WITH NEW IAW AMM 33-51-07, OPS CHECK GOOD.SDR AALA202103179013Battery · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT SIGN INOPERATIVE AT L1 DOOR. REPLACED WELS BATTERY UNIT WITH NEW IAW AMM 33-51-07, OPS CHECK GOOD.SDR DALA2021031701518Light · inoperativeSHIP 676 ESCAPE SLIDE GIRT BAR ENGAGEMENT LIGHTS - R1 DOOR SLIDE LIGHT INOP. CORRECTIVE ACTION: FOUND DEBRIS ON 1R GIRT BAR INDICATION SWITCH. CLEANED DEBRIS OPS CHK GOOD. (1754079)SDR SWAA2021031755684Lens · missingEMERGENCY EXIT LIGHT COVER FELL OFF L/H SIDE O/WING EXIT / INSTALLED LIGHT LENS PER AMM 33-51-01
Back to JASC 3350