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 MASA2020012000029Bulb · inoperative13A EMERGENCT SIGN HAS 3 BULBS INOP- RELAMPED, OPS GOOD.SDR DALA2020012000388Epsu · inoperative13WL LIGHT MODULE FAIL(EPSU), REPLACED EPSU(13WL) & BATTERY PACKSDR SWAA2020030442131Power Supply · inoperativeLH CABIN EMERGENCY LIGHTS LOCATED AT BS 560 AND 628 / IS INOP. / R&R THE EMERGENCY LIGHT POWER SUPPLY AT BS 727C+13. / OPS CHECK GOOD PER AMM 33-51-06.SDR SWAA2020012740731Sign · inoperativeLIGHT BELOW EMERGENCY EXIT SIGN AT STARBOARD OVERWING EXIT OUT. CORRECTED IAW AMM 33-51-01.SDR YENA2020012390042Battery · no testEPSU BATTERY FAILED A CAPACITY CHECK. R & R BATTERY EMERG LIGHT AT (15WL) AND (14WL) IAW AMM 33-51-38. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR YENA2020012390041Battery · no testEPSU BATTERY FAILED A CAPACITY CHECK. R & R BATTERY EMERG LIGHT AT (15WL) AND (14WL) IAW AMM 33-51-38. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR YENA2020012390039Battery · failedEPSU BATTERY FAILED A CAPACITY CHECK, R & R EMERG LIGHT BATTERY AT (11WL) AND (12WL) IAW AMM 33-51-38. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR YENA2020012319038Battery · failedEPSU BATTERY FAILED CHECK. R & R EMERG LIGHT BATTERY AT (10WL) AND (13WL) IAW AMM 33-51-38. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR YENA202001239037Battery · failedEPSU BATTERY REQ. REMOVAL FOR BATTERY CHECK; R&R EMERG LIGHT BATTERY AT (10WL) AND (13WL) IAW AMM 33-51-38. OPS CHK GOOD. ACFT OK FOR SERVICE.SDR DALA2020012310537Sign · detachedEXIT SIGN OVER 2L NEEDS REATTACHED. RE INSTALLED SAME.SDR AALA2020012319006Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY EMERGENCY POWER SUPPLY 13WL FAULT. MAINTENANCE REPLACED BATTERY 13WL PER AMM 33-51-38.SDR DALA202001220499Light · detached17D SEAT MOUNTED FLOOR PROXIMITY LIGHT BROKEN OFF, INSTALLED NEW LIGHT ASSYSDR SWAA2020012240672Battery Pack · inoperativeEXTERIOR AFT OVERWING HATCH LIGHT AT R/H AFT HATCH INOPERATIVE. R & R THE BATTERY PACK M1671 IAW AMM.SDR SWAA2020012240671Battery Pack · inoperativeRIGHT EMERGENCY EXIT GROUND ILLUMINATION LIGHT INOP. R & R THE BATTERY PACK M1671 IAW AMM.SDR SWAA2020012240551Battery Pack · inoperativeEMERGENCY EXIT LIGHTS AT AFT OF R/H AFT OVERWING EXIT INOP. R&R BATTERY PACK M1671 PER AMM.SDR AALA2020012109006Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EXIT IDENTIFIER SIGNES INOPERABLE AT R2 AND L2 DOORS. REPLACED EMERGENCY LIGHT POWER UNIT PER E190 AMM 33-50-01.SDR QXEA2020012100034Light · inoperativeFIRST 2 STRIPS (PHOTOLUMINESCENT) ON GROUND WONT LIGHT UP ( PHOTOLUMINESCENT ESCAPE ROUTE MARKING SYSTEM ). REMOVED FROM SERVICE. INSPECTED AND FOUND FIRST TWO PHOTOLUMINESCENT GROUND STRIPS IAW E175 AMM33-50-21-960-801-A. CLEARS DMI, PLACARDS REMOVED, MTX CONSDR DALA202001210455Battery Pack · inoperativeEMERGENCY LIGHTS POWER ROWS 6-20 ARE INOPERATIVE. REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR SIMA202001219007Lamp · inoperativeFOUND L/H WING EMERGENCY LIGHT INOP-C/A-RELAMPED L/H WING EMERGENCY LIGHT IAW EMB145 AMM 33-50-10. OPS CHECK GOODSDR DALA2020012000393Power Supply · inoperativeDURING SERVICE CHECK FOUND EMERGENCY LIGHTS INOP @ ROW 31 AFT INTO AFT ACCESSORY COMPARTMENT. R/R POWER SUPPLY AND BATTERY PACK B5-212 MULTIPLE TIMES PER MD88 AMM 33-53. LIGHTS WORKED INITIALLY BUT AFTER 5 MINUTES STOPPED WORKING AGAIN (354789) FOUND L2-873 SHSDR CALA2020012000208Charger · inoperativeSEAT 21DEF & 23DEF BULLNOSE EMERGENCY LIGHT IN-OP. RELAMPED NO HELP. T/S FOUND FAUTLY BATTERY CHARGER (M1671). REMOVED AND REPLACED M1671 BATTERY CHARGER PER AMM 33-51-06. OPS TEST NORMAL. OKAY FOR SERVICE.SDR SWAA2020012040541Battery · dischargedRT EMERGENCY EXIT LIGHTS INOP NEAR OVERWING EXIT. R&R BATTERY PER AMM.SDR SWAA2020012040584Light · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT INOP. RELAMPED LIGHT PER AMM.SDR N6WA202001201901Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT STAY ON. CHARGED AIRCRAFT BATTERY PACKS FOR SIX HOURS PER MX-043 INSERTED BEFORE AMM 33-15-17. PERFORMED OPERATIONAL TEST OF THE EMERGENCY LIGHTS IAW CRJ 700 33-51-00. OPS CHECK GOOD. OK FOR SERVICE.SDR SIMA2020012019002Light · wrong partEMERGENCY EXIT FLOOR LIGHTING STRIPS INCORRECT-C/A-REMOVED AND REPLACED EMERGENCY EXIT FLOOR LIGHTING STRIP,IAW EMB 140 AMM 33-50-12, OPS CHECK GOODSDR SIMA2020012019001Battery Pack · inoperativeDURING OPC OF EMERGENCY LIGHTING SYSTEM FOUND BOTH OVERWING EMERGENCY LIGHT INOP-C/A-RAR BATTERY PACK #4 IAW EMB145 AMM 33-50-04-04 OPS CHECK GOOD.SDR DALA2020010383Battery Pack · inoperativeCOCKPIT AND FWD GALLEY CEILING EMERGENCY LIGHT INOP. REPLACED BATTERIES IN FWD BATTERY PACK AT B5-23. OPS CHKS GOOD, A/C OK FOR SVC, REF MD88 AMM 33-53. (LP6466872)SDR AALA2020012299005Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT INOPERABLE AT SEAT 3E. MAINTENANCE REPLACED SEAT EMERGENCY LIGHT IAW AMM 33-51-10.SDR AALA2020012291004Light · inoperativeAIRCRAFT WAS NOT GROUNDED, EMERGENCY LIGHT INOPERABLE AT SEAT 1E. MAINTENANCE REPLACED SEAT EMERGENCY LIGHT PER AMM 33-51-10.SDR REXA2020012380048Bulb · inoperativeEMERGENCY FLOOR LEVEL FLOOD LIGHTS HAVE 1 BULB INOP AT PAX DOOR AND 3 BULBS INOP AT GALLEY SERVICE DOOR
REMOVED AND REPLACED EMERGENCY LIGHT BULBS 4 EA PER CRJ-900 AMM 33-51-11. OPS CHECK GOODSDR VNAA2020012218101Lens · crackedDURNING OVERNIGHT MAINTENANCE THE EMERGENCY EXIT SIGN LENSE ABOVE THE SERVICE DOOR WAS FOUND CRACKED. MAINTENANCE REMOVED AND REPLACED THE THE LENSE WITH NO FURTHER DEFECTS FOUND.SDR DALA202001220512Fuse · failedFOUND THE PAX SEAT EMERGENCY LIGHTS AT SEATS 46 - 49 WERE INOPERATIVE. FOUND THE POWER SUPPLY FUSES ON M737 FAILED. R & R THE FUSES AND OPS CHECKED GOOD IAW AMM 33-51.SDR YENA202001228035Battery · failedFT # 1818, POS-JFK. EMER LIGHT BAT AT POSITION12WL, 14WL & 15WL FAILED CAPACITY CHECK; R & R EMR LIGHT BATT AT 12WL, 14WL & 15WL IAW AMM 33-51-38 AND TC A320-33-51-00-710-003.SDR YENA202001228034Battery · failedEMER LIGHT BAT AT POSITION12WL, 14WL & 15WL FAILED CAPACITY CHECK; R & R EMR LIGHT BATT AT 12WL, 14WL & 15WL IAW AMM 33-51-38 AND TC A320-33-51-00-710-003.SDR YENA202001228033Battery · failedEMERGENCY LIGHT BATTERY PACKS AT POSITION 10WL, 11WL & 13WL FAILED A CAPACITY CHECK. R & R THE BATTERY PACKS IAW AMM 33-51-38 AND TC A320-33-51-00-710-003.SDR YENA202001228032Battery · failedEMERGENCY LIGHT BATTERIES AT POSITION 10WL, 11WL & 13WL FAILED A CAPACITY CHECK. R & R THE BATTERY PACKS IAW AMM 33-51-38 AND TC A320-33-51-00-710-003.SDR DALA2020012290498Lamp · inoperativeRIGHT AFT OVERWING EXIT DOOR PULL HANDLE LIGHT INOP, RELAMPED RIGHT AFT OVERWING EXIT DOOR PULL HANDLE LIGHT ASSEMBLYSDR DALA2020012290497Lamp · inoperativeLEFT FWD OVERWING EXIT DOOR PULL HANDLE LIGHT INOP, RELAMPED LEFT FWD OVERWING EXIT DOOR PULL HANDLE LIGHT ASSEMBLYSDR YENA202001221831Battery · failedAS PER T/C: A320-33-51-00710-003 FOUND EPSU AND BATTERY EMERGENCY LIGHT TO BE AT FAULT AT LOCATION 13WL; R & R EPSU AND BATTERY EMERGENCY LIGHT IAW AMM 33-51-38.SDR YENA202001221830Epsu · failedAS PER T/C: A320-33-51-00710-003 FOUND EPSU AND BATTERY EMERGENCY LIGHT TO BE AT FAULT AT LOCATION 13WL; R & R EPSU AND BATTERY EMERGENCY LIGHT IAW AMM 33-51-38.SDR SWAA2020012040643Battery Pack · defectiveEMERGENCY BATTERY PACK M1672 WOULD NOT CHARGE. R&R LIGHT BATTERY PACK IAW AMM.SDR SWAA2020012040642Battery Pack · defectiveEMERGENCY BATTERY PACK M1673 WOULD NOT CHARGE. R&R LIGHT BATTERY PACK IAW AMM.SDR SWAA2020012040641Battery Pack · defectiveEMERGENCY BATTERY PACK M1675 WOULD NOT CHARGE. R&R LIGHT BATTERY PACK IAW AMM.SDR SWAA2020012040640Battery Pack · defectiveEMERGENCY BATTERY PACK M1670 WOULD NOT CHARGE. R&R LIGHT BATTERY PACK IAW AMM.SDR SWAA2020012040639Battery Pack · defectiveEMERGENCY BATTERY PACK M2335 WOULD NOT CHARGE. R&R LIGHT BATTERY PACK IAW AMM.SDR SWAA2020012040589Battery Pack · dischargedEMERGENCY BATTERY PACK M1674 WOULD NOT CHARGE. R&R LIGHT BATTERY PACK IAW AMM.SDR 29GA2020012000001Light · unsecureFLIGHT# 0053 MCO/FLL REPORT: ESCAPE PATH LIGHTING IS COMING OFF BETWEEN ROWS 5 TO 7. CORRECTIVE ACTION: SECURED ESCAPE PATH LIGHTING BETWEEN ROWS 5 TO 7, OPERATIONAL TEST GOOD IAW SAAB 340 AMM 33-50-20-04.SDR SWAA2020012040552Lens · detachedMID CABIN OVERHEAD EMERGENCY EXIT SIGNS OUTER LENS DETACHED. INSTALLED LENS IAW SIP.SDR DALA2020011980382Lamp · inoperativeDURING SVC, FOUND LT OVERHEAD EMERGENCY LIGHT AT ROW 25 INOP. RELAMPED LT OVERHEAD EMERGENCY LIGHT AT ROW 25 PER MD88 AMM 33-53 . OPS CKS GOOD. (LP6410610)SDR ASAA2020012171914Lens · detachedEXIT LENS MISSING AT AFT DIVIDER BY GALLEY (LEFT SIDE). GROUNDED - YES. INSTALLED EXIT LENS MISSING. REF B737-800 AMM 33-51-01. GRD CHECK OK.
Back to JASC 3350