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 SWAA2019051532714Light · inoperativeRT AFT EMERGENCY EXIT DOOR LIGHT FAILED TO ILLUMINATE. RELAMPED LIGHT PER AMM.SDR SWAA2019051532711Sign · brokenR2 DOOR LOWER EMERGENCY EXIT SIGN BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR ASAA2019051429334Lens · detachedEMERGENCY EXIT COVER MID CABIN CAME OFF. COVER LOCATED IN FLIGHT DECK. GROUNDED - YES. RE-INSTALLED MID CABIN EMERGENCY EXIT SIGN REF AMM 33-51-01.SDR AALA201905159008Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AFT RIGHT LAVATORY INOPERATIVE. MAINTENANCE REPLACED AUXILIARY/MIRROR LIGHT ASSEMBLY PER AMM 33-24-12.SDR IPXA2019051442124Light · inoperativeINSPECTION TYPE:SDR EMERGENCY LIGHT HAS THREE INOP BULBS. INSTALLED THREE BULBS IN EMERGENCY LIGHT PER AMM 33-51-01.SDR MASA2019051311855Light · inoperativeROW 22 EMER FLOOD LIGHT INOP. RELAMPED.SDR DALA2019051403011Light · inoperativeEMERGENCY LIGHT OVER DOOR AT 24A INOP. RELAMPED SAME OPS NML REF AMM 33-52. (LP4751576)SDR VNAA2019051311101Light · inoperativeRH OVERWING EMERGENCY EXIT DOOR LOWER EMERGENCY LIGHT INOP. R&R R/H OVERWING EXIT DOOR LOWER EMERGENCY LIGHT IAW CRJ 200 AMM 33-51-10-000/400-801 & ESPM 20-17-31. OPS CHECK GOOD.SDR FDEA201905131040Warning System · false activationMDIS 589 33-50 2920 13MAY19 AKL OPEN U EMERG LT BAT 1 LO MESSAGE DISPLAYED DURING EMERGENCY LIGHTS TEST. FACT 14MAY19 21:03 ANC T/S PER FIM 33-51-02-00, ALL TEST FUNCTION NORMAL. COULD NOT DUPLICATE. OK FOR SVC.SDR SWAA2019061333660Bulb · inoperativeCABIN SIDEWALL PANEL #231YHW EMERGENCY EXIT LIGHT BULBS INOPERATIVE. R & R LIGHT IAW AMM.SDR YENA201905130275Battery Pack · dischargedDURING HEAVY MAINTENANCE, EMERGENCY LIGHTS AT L/H OVER-WING FAIL TO ILLUMINATE WITH SWITCH IN ARMED AND CIRCUIT BREAKERS H5 & H6 ON THE 49VU OPENED; R & R EPSU & BATTERY PACK IAW AMM 33-51-38 SYSTEM OPS CHECK GOOD IAW AMM 33-51-00-710-804-A.SDR YENA201905130274Epsu · failedDURING HEAVY MAINTENANCE, EMERGENCY LIGHTS AT LT OVER-WING FAIL TO ILLUMINATE WITH SWITCH IN ARMED AND CIRCUIT BREAKERS H5 & H6 ON THE 49VU OPENED; R & R EPSU & BATTERY PACK IAW AMM 33-51-38 SYSTEM OPS CHECK GOOD IAW AMM 33-51-00-710-804-A.SDR CALA2019051700770Battery · discharged(SUPPORT TASK) L-58 NO DOT; THE EMER LIGHT TEST FAILS WITH THE MESSAGE ''EPSU UNIT FWD L'' ATA 33-51-38. REMOVED AND FWD EPSU(10WL) AND FWD EPSU BATTERY IAW AMM 33- 51-38-000-002-A, 33-51-38-000-001-A, 33-51-38-400-001-A AND 33-5 1-38-400-002-A. OPS CHK GOOD ISDR UIEA2019051604217Battery Pack · dischargedL1 ENTRY EMER EXIT LIGHT INOP PER AMC INSPECTION(<P>CHARGED EMERGENCY BATTERY PACK PER AMM 33-51-07-612-056. OPS CHECKED GOOD.</P>)SDR UIEA2019051604218Light · inoperativeCOCKPIT EMERGENCY EXIT LIGHT INOP PER AMC INSPECTION(<P>REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT ASSY IAW AMM 33-51-01</P>)SDR DALA2019051503037Battery Pack · discharged(AIRCRAFT 663, L/P 5618725) WHITE SEAT EMERGENCY LIGHTS RT SIDE @ ROWS 6-8 INOP. T/S INOP EMERGENCY LIGHTS TO A BAD BATTERY SUPPLY. REMOVED AND REPLACED BATTERY PACK. OPS CHECK GOOD. PER AMM 33-51.SDR SWAA2019051532705Sign · damagedMID CABIN EXIT SIGN DAMAGED. SECURED SIGN PER SIP.SDR AALA20190513004Portable Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: COCKPIT PORTABLE EMERGENCY LIGHT INOPERABLE. REPLACED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-00.SDR AALA20190513002Power Supply · failedAIRCRAFT WAS NOT GROUNDED: CIDS EMERGENCY LIGHT FAILED EMERGENCY POWER SUPPLY UNIT 11WL. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA20190513003Inverter · inoperativeMAIN DOOR EXIT SIGN INOP. C/A-REMOVED AND REPLACED NR 1 INVERTER IAW AMM 33-50-11 OPS CHECK GOOD.SDR SIMA20190513002Sign · inoperativeDURING PS-1 CHECK, FOUND EXIT SIGN NEAR THE MAIN DOOR TO BE INOP. C/A-REMOVED AND REPLACED EXIT SIGN IAW AMM 33-50-14. OPS CHECK GOOD.SDR 29GA2019051400001Light · inoperativeFLIGHT 9004 FLL/MCO REPORT:EMERGENCY LIGHTING STRIP NEXT TO SEAT 2A IS INOP. CORRECTIVE ACTION: R/R SEAT 2A FLOOR EMERGENGY LIGHT ASSY. IAW AMM 33-50-20-04 OPS CHECK GOOD.SDR DALA2019051302989Battery Pack · dischargedTHE AFT ACCESSORY COMPARTMENT AND TAIL CONE EMERGENCY LIGHTS WERE FOUND INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY PACK AT POSITION B5-116 PER AMM 33-51-03. LIGHTS NOW OPERATE NORMALLY. (LP #5692881)SDR VNAA2019051211102Light · inoperativeRH FWD & MID EMERGENCY LIGHTS INOP. R&R RH FWD & MID EMERGENCY LIGHTS IAW CRJ700 AMM 33-51-15-000/400-801-A02. OPS CHECK GOOD.SDR FDEA201905121038Battery · dischargedPDIS 617 33-50 8018 12MAY19 MEM OPEN U LOGPAGES:3111468 DURING CA CABIN PREFLIGHT, EMER LIGHTS TEST FAILED W/ "EMER LT BAT 1 LOW" FAULT. MEL 12MAY19 20:06 MEM U RELEASED FOR SERVICE PER MEL : 33-50-04 CATEGORY : C EXPIRATION : 22MAY19 "MEL 33-50-04:SDR FDEA201905121037Battery · dischargedDURING CA CABIN PREFLIGHT, EMER LIGHTS TEST FAILED W/ "EMER LT BAT 1 LOW" FAULT. R&R'ED EMERGENCY POWER SUPPLY BAT PER MM 33-51-01-4 AND PERFORMED TEST PER MM 33-51-01-5, TEST PASSED MEL CLOSED.SDR FDEA201905121039Power Supply · inoperativeMDIS 643 33-50 1574 12MAY19 MEM OPEN U LOGPAGES:3109226 "EMER LT BATT 1 LO" MEL 12MAY19 21:18 MEM U RELEASED FOR SERVICE PER MEL : 33-50-04 CATEGORY : C EXPIRATION : 22MAY19 "MEL 33-50-04: EMER LIGHTS - INOP." C/7185238 REMOVED AND REPLACED EMSDR U2RA201905120003Light · inoperativeCEILING EMERGENCY LIGHT AT SEAT 31C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 31C PER AIRCRAFT MAINTENANCE MANUAL 33-51-05.SDR U2RA201905120002Power Supply · inoperativeOVERHEAD BIN EMERGENCY LIGHTS AT SEAT ROWS 19D, 21C, AND 24D ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY POWER SUPPLY PER AIRCRAFT MAINTENANCE MANUAL 33-51-07.SDR U2RA201905120001Light · inoperativeEXTERIOR EMERGENCY LIGHT AT LEFT NUMBER 4 DOOR INOPERATIVE. RELAMPED EXTERIOR EMERGENCY LIGHT AT LEFT NUMBER 4 DOOR PER AIRCRAFT MAINTENANCE MANUAL 33-51-06.SDR AALA20190512005Battery · failedAIRCRAFT IN BASE MAINTENANCE: EPL BATTERY FAILED FUNCTIONAL CHECK. MAINTENANCE REPLACED EPL BATTERY AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019051432621Lens · unsecureEXIT SIGN OVER EMERGENCY EXIT ROWS FELL OFF. R&R LENS PER AMM.SDR SWAA2019051432603Light · inoperativeRT EMERGENCY LIGHT INOP AT ROW 11. RELAMPED LIGHT PER AMM.SDR AALA201905139017Light · faultyAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WOULD NOT TURN OFF. MAINTENANCE ACCOMPLISHED RESET OF EMERGENCY LIGHTS SYSTEM CHECKS PER AMM 33-51-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201905139012Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT EMERGENCY EXIT LENS INOPERABLE IN AFT AIRCRAFT. MAINTENANCE REPLACED EXIT SIGN LUMINATOR ASSEMBLY L-1190 PER AMM 33-51-01.SDR DALA2019051303000Battery Pack · discharged(LOG 5704272) DURING INSPECTION FOUND EMERGENCY LTS AND EXIT SIGN INOP BETWEEN ROWS 19 AND 24. RPLD BATTERY PACK M1670 PER AMM 33-51. ALL EMERGENCY LTS CK GOOD.SDR SIMA20190512001Sign · unsecureILLUMINATED EMERGENCY EXIT SIGN FELL ( OVER ROW 12 ). C/A-REMOVED AND REPLACED EXIT LOCATING SIGN IAW AMM 33-50-15. OPS CHECK GOOD.SDR SIMA20190512002Light · inoperativeFLOOR EMERGENCY LIGHT STRIP AT ROWS 6A/7A INOP. C/A-REMOVED AND REPLACED EMERGENCY LIGHT STRIP IAW AMM 33-50-12 OPS TEST GOOD.SDR REXA2019051200697Light · inoperativeEMERGENCY FLOOR LIGHT STRIP NOT LIGHTING. REMOVED AND REPLACED 8CD EMERGENCY FLOOR TRACK LIGHT STRIP IAW AMM 33-51-01. OPS CHECK GOOD.SDR SIMA2019061251006Light · damagedAFT LH AND RH EMERGENCY FLOOR LIGHTING EXTRUSIONS IN LAV AREA DAMAGED-C/A-COMPLETE:AFT LH AND RH EMERGENCY FLOOR LIGHTING EXTRUSIONS ARE INSTALLED IN LAV AREA IAW AMM 33-50-12SDR R61A2019060110570Sign · inoperativeWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, R2 DOOR EMERGENCY EXIT IDENTIFIER AT R2 DOOR FOUND NOT COMPLETELY ILLUMINATED. EXIT IDENTIFIER REPLACED IAW AMM 33-50-15. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETIONSDR SIMA20190511002Flashlight · inoperativeSUPPLEMENTAL AFT FA FLASHLIGHT INOP. C/A-FLIGHT CREW PLACARDED AFT FA FLASHLIGHT MEL 2514 AUTH #050031 MOC #680993. REMOVED AND REPLACED AFT FA FLASHLIGHT AND CRADLE IAW AMM 25-61-02. OPC GOOD. MEL ITEM RESTORED.SDR FDEA201905111027Light · inoperativeR1 DOOR ESCAPE SLIDE LIGHT INOP. RELAMPED WITH MPN 767 BULB PER AMM 33-51-06-2-1. OPS CK GOOD PER SAME.SDR AALA20190511006Battery · dischargedAIRCRAFT IN BASE VISIT: MAINTENANCE FOUND SEAT ROW 20HJ AND 21HJ EMERGENCY LIGHT (2X) INOP. REMOVED AND REPLACED BATTERY FOR SEAT ROW 20HJ / 21HJ AT M1209 STA871 RIGHT IAW AMM 33-51-07. OPS CHECKED NORMAL.SDR DALA2019051403010Light · broken(AIRCRAFT 5653, L/P 5199688) DURING SERVICE CHECK FOUND FLT DECK EMERGENCY LIGHT INOP. RELAMP NO HELP. FOUND LIGHT ASSY M10549 BROKEN. REPLACED LIGHT ASSEMBLY PER WDM 33-51-12. OPS CHECK GOOD OK FOR SVC.SDR ASAA2019051129302Lens · detachedFLT ATT REPORTS: ROW 17A FLOOR LEVEL EXIT SIGN FELL OFF. GROUNDED - YES. RE-INSTALLED EXIT COVER ROW 17ABC REF AMM 33-51-01, OPS CHECK GOOD. OK FOR CONTINUED SERVICE.SDR AALA201905129010Sign · missingAIRCRAFT WAS GROUNDED: MID LAVATORY EMERGENCY EXIT PATH LIGHT ASSEMBLY MISSING. MAINTENANCE REPLACED EMERGENCY EXIT MARKER SIGN PER 33-51-13-000-001A.SDR SIMA20190511003Light · inoperativeDURING PS-1 CHECK FOUND EXTERNAL OVERWING EMERGENCY LIGHT NOT WORKING ON LEFT HAND SIDE. C/A-REMOVED AND REPLACED EMERGENCY LIGHT LAMP IAW AMM 33-50-10. OPS CHECK GOOD.SDR REXA2019051100696Charger · inoperativeFIRST ROW FLOOR LIGHT EMER STRIP WILL NOT LIGHT. REPLACED PS1LF BATTERY CHARGER ASSY IAW AMM 33-51-05. REPLACED FIRST ROW FLOOR TRACK LIGHTING STRIP IAW AMM 33-51-01. PN BA5-0933-901. SN OFF C01087. SN ON C00494. PN 36491-1. EMERGENCY LIGHTING SYSTEM OPS CHECKSDR SWAA2019051332561Lens · unsecureOVERHEAD EMERGENCY EXIT LENS COVER CAME OFF. REINSTALLED EGRESS LIGHT LENS IAW AMM.
Back to JASC 3350