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 SWAA2019042632059Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST @ LOCATION M1671 / R & R EMER LT BATT. PACKS PER MM 33-51-06SDR SWAA2019042632058Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST @ LOCATION M1670 / R & R EMER LT BATT. PACKS PER MM 33-51-06SDR SWAA2019042632057Battery · inoperativeEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST @ LOCATION M1673. R & R EMER LT BATT. PACKS PER MM 33-51-06SDR SWAA2019042632035Sign · damagedEXIT SIGN AT FWD F/A SEAT BULKHEAD (L1 DOOR) DAMAGED. SECURED EMERGENCY LIGHT LENS PER EA#1-A33-0129 OK TO CONT.SDR REXA2019042500518Light · inoperativeEMERGENCY FLOOR TRACKS MISSING AT ROW 12
REPLACED FLOOR TRACK IAW AMM 33-51-01 P/N: ON PL1100LH07SDR SWAA2019042532010Lens · missingEMERGENCY LIGHT LENS COVER MISSING AT ROWS 17/18 RIGHT SIDE OF AIRCRAFT. REPLACED LENS PER MM.SDR DALA2019042502631Sign · brokenRIGHT DOOR EXIT SIGN IS BROKEN. MAINTENANCE REPLACED THE R1 DOOR EMERGENCY LIGHT LENS ASSY PER B717 AMM 33-50. THE AIRCRAFT IS OK FOR SERVICE. (LP #5837084)SDR VNAA2019042411102Battery · dischargedFLOOR LEVEL EMERGENCY EXIT SIGN ADJACENT TO SEAT 16F DOES NOT ILLUMINATE SWAPPED #3 AND #4 ESPU BATTERIES OPS CHECK GOOD.SDR SWAA2019050332255Lens · crackedR2 DOOR EMERGENCY LIGHT LENS COMMON TO G4 CRACKED. R&R LENS IAW AMM.SDR SWAA2019050132117Lens · missingR2 DOOR EXIT SIGN MISSING. INSTALLED EXIT LIGHT LENS IAW AMM.SDR N6WA201904302402Bulb · inoperativeLIGHTED FLOOR LEVEL EMERGENCY SIGN HAS INOP BULBS BY PAX DOOR. RELAMPED SIGN IAW CRJ 700AMM 33-51-05 OPS CHECK GOOD.SDR DALA2019042952726Lens · damaged27A EMERGENCY EXIT SIGN MISSING. ACCOMPLISH PERMANENT REPAIR PER EAR 577583-14. REPLACED EMERGENCY EXIT SIGN LENS AT PAX SEAT 27A.SDR REXA2019042640519Battery Pack · inoperativeDURING WALK AROUND FOUND FWD EMERGENCY LIGHTS OUT. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS AT PS1LF AND PS2LF IAW AMM 33-51-04. OPS CHECK IS GOOD.SDR AALA201904264017Power Supply · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS DOOR 4R AFT EMERGENCY LIGHT POWER SUPPLY ASSY M33409 FAILED TEST. REMOVED & REPLACED DOOR 4R AFT EMERGENCY POWER SUPPLY ASSY M33409. OPS CHECK IS GOOD IAW AMM 33-51-06.SDR AALA201904264014Power Supply · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS DOOR 2R FWD EMERGENCY LIGHT POWER SUPPLY ASSY M33097 FAILED TEST. REMOVED & REPLACED DOOR 2R FWD EMERGENCY LIGHT POWER SUPPLY ASSY M33097. OPS CHECK IS GOOD IAW AMM 33-51-06.SDR AALA201904264013Power Supply · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS DOOR 3L MID EMERGENCY LIGHT POWER SUPPLY ASSY M33406 FAILED TEST. REMOVED & REPLACED MID EMERGENCY POWER SUPPLY ASSY M33406. OPS CHECK IS GOOD IAW AMM 33-51-06.SDR AALA201904264012Power Supply · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS DOOR 3L AFT EMERGENCY LIGHT POWER SUPPLY ASSY M33405 FAILED TEST. REMOVED & REPLACED EMERGENCY SUPPLY M33405. OPS CHECK GOOD IAW AMM 33-51-06.SDR IPXA2019042644412Bulb · inoperativeINSPECTION TYPE:N/AEMERGENCY LIGHT HAS SEVEN INOP BULBSRELAMPED SEVEN BULBS IN EMERGENCY LIGHT PER AMM 33-51-01-2SDR SWAA2019042632056Lamp · inoperativeCABIN R/H SIDE EMERGENCY EXIT WINDOW LIGHT INOP. RELAMPED PASS. CABIN R/H SIDE EMERGENCY EXIT WINDOW LIGHT IAW AMM 33-51-11.SDR SWAA2019042632055Ballast · inoperativeL/H OVERWING EXIT SIDEWALL LIGHT INOP. REPLACED BALLAST IAW AMM 33-51-06SDR SWAA2019042632054Light · inoperativeEMERGENCY EXIT ROW WINDOW LIGHT INOP AIRCRAFT RIGHT. / RELAMPED PER AMM 33-51-01SDR SWAA2019042632041Battery · inoperativeEMERGENCY LIGHT BATTERY M1674 IS DISCHARGED. / REPLACED EMERGENCY LIGHT BATTERY M1674 PER AMMSDR SWAA2019042632040Battery · inoperativeEMERGENCY LIGHT BATTERY M1673 IS DISCHARGED. REPLACED EMERGENCY LIGHT BATTERY PER AMMSDR SWAA2019042632039Battery · inoperativeEMERGENCY LIGHT BATTERY M1672 IS DISCHARGED. REPLACED EMERGENCY LIGHT BATTERY AMMSDR JJBA201904264016Sign · unsecureEXIT SIGN AT ROW 18 UNSECURED. RE-SECURED EXIT SIGN ON ROW 18. OPS CHECK SAT.SDR AALA201904259004Light · inoperativeAIRCRAFT WAS NOT GROUNDED: DOOR L4 EXIT SIGN ABOVE DOOR INOPERATIVE. MAINTENANCE REPAIRED EXIT LIGHT PER AMM 33-51-16-400-001-A AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019042532018Battery · no testRIGHT HAND OVER WING EXIT EMERGENCY BATTERY FAILED CAPACITY CK. R&R BATTERY PER AMMSDR SWAA2019042532017Contact · dirtyL2 DOOR EVACSLIDE EMERGENCY LIGHT INOP. CLEANED BULB & CONTACT. OP CK GOOD REF AMMSDR SIMA201904254002Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND RELAMPED IAW EMB 140 AMM 33-50-09. OPS CHECK GOOD AT THIS TIMESDR MASA2019042411821Battery Pack · dischargedEMERGENCY LIGHT BATTERIES DEAD. CHARGED BATTSSDR SWAA2019052232817Light · damagedEMERGENCY EXIT LIGHT DAMAGED ON G4 GALLEY. R&R LIGHT IAW AMM.SDR SWAA2019050632309Housing · brokenR1 DOOR LOWER FORWARD EMERGENCY EXIT LIGHT HOUSING BROKEN. R&R LIGHT HOUSING IAW AMM.SDR SWAA2019050132112Light · inoperativeEMERGENCY EXIT SIDE WALL LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR 29GA2019042400001Switch · failedFLIGHT# 0080 TPA/TPA REPORT:F.A. REPORTED CABIN EMERGENCY LIGHTS WERE ON WHILE EMERGENCY LIGHT ON ARMED POSITION ON OVERHEAD PANEL QRH DID NOT RESOLVE THE PROBLEM.
CORRECTIVE ACTION: REPAIRED BROKEN WIRES AT FA PANEL SWITCH 29LN. NO FIX. T/S WIRES AT 29LN FOSDR ASOA2019042635062Inverter · inoperativeDURING MX INSPECTION THE EMERGENCY SIGN IN FRONT OF 3C WAS INOP.MX REMOVED BAD #3 INVERTER AND INSTALLED NEW INVERTER IAW EMB145 AMMII 33-50-11, OPS CHECK GOOD A/C WAS APPROVED FOR RETURN TO SERVICESDR SIMA201904263005Light · inoperativeREMOVED LH EXTERIOR EMERGENCY LIGHT ASSEMBLY AND SPACER PLATE ON FWD BELLY FAIRING TO FOM (REPAIR)-C/A-INSTALLED LH EXTERIOR EMERGENCY LIGHT ASSEMBLY AND SPACER PLATE ON FWD BELLY FAIRING IAW EMB145 AMM 33-50-10. OPC GOOD. SEE NRWC3 696-MQT-04135 FOR COMPLETIOSDR AALA201904259022Battery · no testAIRCRAFT WAS NOT GROUNDED: FOUND TWO DEAD BATTERIES DURING ETOPS PDC CHECK. MAINTENANCE REPLACED BOTH BATTERIES (SEE AALA20190424019 FOR OTHER BATTERY) FOR EMERGENCY EQUIPMENT FLASH LIGHTS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA201904523004Light · damagedCOCKPIT STEP RED EMERGENCY LIGHT IS BROKEN.-C/A-REPOSITIONED AND INSTALLED MISSING HARDWARE ON THE COCKPIT STEP COURTESY LIGHT IAW AMM33-26-06 OPS CHECK GOODSDR HNAA2019042400118Lamp · inoperativeNDIS 631 33-51 0014870 23APR19 RIC CLOSE
EMERGENCY LIGHT IN 12BC PSU INOP
27751 00 NGR
FACT 23APR19 09:56 RIC
R/R LIGHT LAMP IN PSU OVER SEATS 12BC IAW AMM 33-50-08-000-801-A/400-80SDR AALA201904249002Light · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN CEILING PANEL EMERGENCY LIGHT ASSEMBLY ON COVELIGHT DOOR R2 IN PASSENGER CABIN. REPLACED CEILING PANEL EMERGENCY LIGHT ASSEMBLY ON COVELIGHT PER AMM 33-51-11-400-001-A.SDR IPXA201904241386Battery Pack · inoperativeINSPECTION TYPE:NAREF 668020 EMERGENCY LIGHT INOP.REPLACED EMEREGENCY POWER SUPPLY BATTERY IAW MM 33-51-01-401. REVERSED DMP 33-50-4 ,PERFORMED OPS CK .CKED GOOD.SDR IPXA201904241378Light · inoperativeINSPECTION TYPE:NAINTERIOR EMERGENCY LIGHTS INOPPER FIM 33-51-815-802 FIGURE 103, R&R EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-07. OP/C GOODSDR IPXA2019042441410Battery · dischargedINSPECTION TYPE:NAEMERG BAT LOW #1 M668020. ITEM TRANSFERED TO DEFERRAL 33-50-4. ACCOMPLISHED DMP 33-50-4. PLACARD INSTALLED OK FOR SVC.REPLACED EMERGENCY POWER SUPPLY BATTERY IAW MM 33-51-01-401. REVERSED DMP 33-50-4, PERFORMED OPS CHK. CHECKED GOOD. THISDR ASOA2019042433026Bulb · inoperativeTHE CREW REPORTED OVERHEAD EMERGENCY LIGHTING INOPERATIVE AT ROW 10. MAINTENANCE REMOVED AND REPLACED LIGHT BULB AT ROW 10. OPERATIONAL CHECKS WERE GOODSDR SWAA2019042432005Cover · missingR/H OVERWING EMG EXIT LIGHT COVER MISSING. / INSTALLED NEW EMG EXIT LIGHT COVER PER SRMSDR REXA2019042430493Light · damagedANGLED SECTION OF EMERGENCY FLOOR PATH LIGHTING IN FRONT OF SEAT 4B IS BROKEN. REMOVED AND REPLACED 4B EMERGENCY FLOOR PATH IAW TS #006028B AMM 33-51-01. PN ON PL1100LH07 PN OFF PL1100LH07 SN ON N/A SN OFF N/ASDR DALA2019042402596Light · inoperativeFLOOR EMERGENCY LIGHTS INOP AT 11D, 20D, AND 22D. REMOVED AND REPLACED LIGHT ASSY PER MD88 AMM 33-51. TESTS GOOD. (LP5822313)SDR DALA2019042302593Battery Pack · inoperativeTHE EMERGENCY LIGHTS IN CEILING PANELS 8 & 9 AND ADJACENT TO THE PASSENGER DOOR ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACKS B5-118 AND B5-120 PER B717 AMM 33-51. OPERATIONAL CHECK IS GOOD. (LP #5164593)SDR QXEA2019042300184Battery Pack · inoperativeCABIN EMERGENCY POWER SUPPLY 3 APPEARS TO HAVE DEAD BATTERIES. R&R EMG. LIGHT POWER SUPPLY UNIT #3 IAW Q400 AMM 33-51-01-000/400-801. FUNC CHECK GOOD. CLEAR DEFECT.SDR SCNA201904252032Battery Pack · inoperativeEMER. LIGHTS NOT ILLUMINATION ON OVERHEAD BINS IN RH AFT SECTION ON CABIN AND AFT RH OVERWING EXIT. PLACED EMERGENCY AISLE LIGHTS AT ROWS 17,20,22 DEF ON MEL. MC NOTIFIED. REPLACED BATTERY PACK AND CHARGING ASSY. OVERWING EXIT LIGHTS OPS CHK GOOD. REMOVED AND
Back to JASC 3350