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 AALA2019081209901Light · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY PATH LIGHTING HAD INOPERABLE LIGHT OUT SEAT 20DEF REF SIC 2904. MAINTENANCE REPLACED LIGHT PER AMM 33-51-11.SDR IPXA2019080984449Battery Pack · dischargedON PRE-FLIGHT LVL EMER LT BAT 1 LOW. R & R EMERGENCY LIGHTING BATTERY POWER SUPPLY PER AMM 33-51-01. OPS CHECKED GOOD.SDR CALA2019081091339Charger · inoperativeL3 DOOR EMERGENCY LIGHT POWER SUPPLY M33406 BATTERY HAD CAPACITY LOW. POWER SUPPLY CHARGER AND BATTERY REPLACED. TESTED NORMAL IAW AMM 33-51-06.SDR CALA2019081091338Battery · dischargedL3 DOOR EMERGENCY LIGHT POWER SUPPLY M33400 BATTERY PACK HAD CAPACITY LOW. POWER SUPPLY CHARGER, AND BATTERY REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2019081091337Battery · dischargedL2 DOOR EMERGENCY LIGHT POWER SUPPLY M33096 BATTERY PACK LOW CAPACITY. POWER SUPPLY BATTERY REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2019081091336Charger · inoperativeL3 DOOR EMERGENCY LIGHT POWER SUPPLY M33405 BATTERY PACK CAPACITY LOW. POWER SUPPLY, CHARGER, AND BATTERY REPLACED AND TESTED NORMAL IAW AMM33-51-06.SDR CALA2019081091335Charger · inoperativeR3 DOOR EMERGENCY LIGHT POWER SUPPLY M33401 BATTERY PACK CAPACITY LOW. POWER SUPPLY, CHARGER, AND BATTERY REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2019081091334Battery · dischargedR2 DOOR EMERGENCY LIGHT POWER SUPPLY M33097 BATTERY PACK CAPACITY LOW . POWER SUPPLY, CHARGER, AND BATTERY PACK REPLACED AND TESTED IAW AMM 33-51-06.SDR ASOA2019080984042Bulb · inoperativeIAH _ FLIGHT 4192 THE CREW REPORTED THE CA SIDE EMERGENCY LIGHT TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED LIGHT BULB, OPERATIONALLY TESTED WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SIMA201908098003Light · inoperativeR/H UPPER EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EXTERIOR EMERGENCY LIGHT IAW AMM 33-50-10. OPS CHECKED.SDR DALA2019080904674Battery Pack · inoperativeLT AND RT LWR AFT EMER LIGHTS INOP. REMOVED AND REPLACED EMER LIGHT BATTERY PACK AT STA. 850R. OPS CHECK GOOD. (LP5743702)SDR DALA2019080904672Power Supply · inoperativeDURING CHECK OF CONDITION OF THE LIGHTED EXIT SIGN LOCATED ABOVE VENTRAL DOOR THE LIGHT DID NOT WORK.. REF CARD 1130-2002 STEP 28. EMERGENCY LIGHTS POWER SUPPLY WAS REMOVED AND A SERVISEABLE EMERGENCY LIGHTS POWER SUPPLY WAS INSTALLED IAW AMM 33-51-03-400-802,SDR SIMA20190808001Inverter · inoperativeRH EXIT ROW AFT EMERGENCY MARKER DID NOT ILLUMINATE.-C/A-REMOVED AND REPLACED #5 EMERGENCY LIGHT AC/DC INVERTER IAW EMB AMM 33-50-11 WITH WM 33-50-50. OPC OF EMERGENCY LIGHTING SYSTEM GOOD IAW EMB AMM 33-50-00-700-801-A. NO OTHER DEFECTS NOTED.SDR MASA2019080811991Light · inoperativeROW 21 CEILING LIGHT EMER LIGHT INOP. STILL IN WORKSDR SIMA20190807004Light · inoperativeEMERGENCY LIGHT STRIPS #4 #5 ARE INOP-C/A-COMPLETE:REMOVED AND REPLACED SPLICE FOR EMERGENCY LIGHT STRIP #5 IAW EMB145 SWPM 20-21-00, REMOVED AND REPLACED EMERGENCY LIGHT STRIP ASSY #4 IAW 145 AMM 33-50-12 OPS CHECK GOOD. EASI #4745,102,5241SDR SWAA2019091136767Retaining Clip · brokenMAIN CABIN SIDEWALL PANEL 232YHW EXIT LENS CLIPS BROKEN. R&R INDICATOR ASSEMBLY IAW AMM.SDR AALA201908089003Cover · damagedAIRCRAFT WAS NOT GROUNDED: AFT LEFT EXIT SIGN LIGHT COVER DAMAGED. MAINTENANCE REPLACED SIGN IDENTIFIER PER AMM 25-60-00.SDR SWAA2019081335869Fuse · inoperativeL/H INTERIOR EMERGENCY LIGHTS AT OVERWING EXITS INOP. / R&R #1 FUSE IN M1668 BATTERY PER AMM.SDR SWAA2019081335868Fuse · inoperativeR/H INTERIOR EMERGENCY LIGHTS AT OVERWING EXITS INOP. / R&R #2 FUSE IN M1669 BATTERY PER AMM.SDR SWAA2019081335867Fuse · inoperativeR/H INTERIOR EMERGENCY LIGHTS AT OVERWING EXITS INOP. R&R NR 1 FUSE IN M1669 BATTERY PER AMM.SDR SWAA2019081335843Lens · damagedPASSENGER CABIN R/H EMERGENCY EXIT LIGHT LENS COVER DISCOLORED. R&R COVER IAW SIP.SDR SWAA2019081335841Lens · detachedL1 DOOR LOWER EXIT SIGN COVER FELL OFF. / REINSTALLED LENS IAW SIP.SDR SWAA2019081335778Fuse · inoperativeL/H INTERIOR EMERGENCY LIGHTS AT OVERWING EXITS INOP. R & R NR 2 FUSE IN M1668 BATTERY PER AMM.SDR SWAA2019081335770Cover · damagedPASSENGER CABIN L/H EMERGENCY EXIT LIGHT LENS COVER DISCOLORED. R & R COVER IAW SIP.SDR SWAA2019081335749Sign · detachedCENTER OVERHEAD OVERWING EXIT SIGN DETACHED. R&R EXIT SIGN PER AMM.SDR DALA2019081214702Light · inoperativeONE WHITE EMERGENCY LIGHT AT SEAT 2CD INOP. REPLACED 2CD EMERGENCY PATH LIGHT PER A320 AMM 33-51.SDR R61A2019080970821Power Supply · faulty4TH EMERGENCY LIGHT FROM FRONT TO BACK IS INOP. R&R EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR DALA2019080804669Light · damagedEMERGENCY FLOOR LIGHTING DAMAGED LOCATIONS:12C, REINSTALLED LIGHTING AT SEAT 12CSDR SIMA201908087001Battery Pack · inoperativeEMERGENCY LIGHTS OVER R/H WING AND AT R/H EMERGENCY EXIT LIGHT AFT GALLEY ARE INOP-C/A-RAR # 2 BATTERY POWER SUPPLY IAW AMM 33-50-04. OPC GOOD FOR EMERGENCY LIGHT OVER R/H WING AND R/H EMERGENCY EXIT LIGHT AFT GALLEY.SDR AALA201908089010Bulb · brokenAIRCRAFT WAS NOT GROUNDED: BULB IN THE EPL WAS BROKEN. MAINTENANCE REPLACED LIGHT PROXIMITY HOLDER PER AMM 33-51-05.SDR AALA201908089007Lens · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT LENS BROKEN AT 24ABC. MAINTENANCE REPLACED EMERGENCY LIGHT LENS PER AMM 33-51-19.SDR AALA201908089002Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 2E EMERGENCY LIGHT AFT INOPERABLE, MISSING LENS AND BULBS. MAINTENANCE REPLACED LIGHT PER AMM 33-51-05.SDR QMLA2019080879065Battery · hotON CLIMB OUT ON AN IFR FLIGHT PLAN, THE ENTIRE CREW NOTICED WHAT APPEARED TO BE A BURNING SMELL THROUGHOUT THE AIRCRAFT. WE CANCELLED THE IFR FLIGHT PLAN AND ABORTED THE FLIGHT, TURNED TO RTB AND SECURED ALL UNNECESSARY CONSUMERS. UPON RETURN TO BASE, THE MESDR MASA2019080871990Lamp · inoperativeFWD FA OVHD EMERGENCY LIGHT INOP. RELAMPEDSDR SWAA2019080835741Housing · looseL2 DOOR EMERGENCY EXIT LENS CAME OFF. R&R BASE ASSEMBLY IAW AMM.SDR SWAA2019080835740Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PACK PER AMM.SDR SWAA2019080835739Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PACK PER AMM.SDR SWAA2019080835738Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PACK PER AMM.SDR SWAA2019080835736Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PACK PER AMM.SDR SWAA2019080835735Lens · detachedL2 DOOR EMERGENCY EXIT LENS CAME OFF. R&R LENS IAW AMM.SDR SWAA2019080835722Charger · inoperativeL/H SIDE OVERWING EMERGENCY EXIT LIGHTS INOP. R&R BATTERY PACK CHARGER ASSEMBLY IAW AMM.SDR DALA2019080804646Housing · damagedAN EMERGENCY FLOOR LIGHTING WAS DAMAGED AT SEAT 22D. REPLACED EMERGENCY LIGHT HOUSING. OK FOR SERVICE.SDR AALA201908079004Battery · no testAIRCRAFT WAS NOT GROUNDED: R2 DOOR EXIT LIGHT SIGN LIGHT INOPERABLE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT (SEE AALA201908079003) AND BATTERY PER AMM 33-51-38 AND AMM 33-51-38-00-002-A.SDR AALA201908079003Power Supply · no testAIRCRAFT WAS NOT GROUNDED: R2 DOOR EXIT LIGHT SIGN LIGHT INOPERABLE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT AND BATTERY (SEE AALA201908079004) PER AMM 33-51-38 AND AMM 33-51-38-00-002-A.SDR DALA2019080704631Light · inoperativeEMERGENCY ESCAPE PATH LIGHT INOP AT SEAT 28D. REPLACED THE LIGHT ASSY PER AMM 33-50.SDR VNAA2019080611102Light · inoperativeRH OVER WING EMERGENCY EXIT AFT LIGHT INOP. R/R RH OVER WING EMERG EXIT AFT LIGHT IAW AMM 33-51-21-000/400-801. OPS CK GOOD.SDR VNAA2019080611101Inverter · failedLH OVERWING EMERGENCY EXIT LIGHT WILL NOT TEST. R/R #2 EMERGENCY LIGHT INVERTER, IAW CRJ200 AMM 33-51-07-000/400-801. OPS CHECK GOODSDR YENA201908126440Battery Pack · failedFT # 225, JFK-TPA. EMERGENCY LIGHT BATTERY 13WL FAILS TEST; R & R BATTERY 13WL IAW AMM 33-51-38. OPS CKS OK.SDR QXEA2019080800309Battery · inoperativeCABIN OVERHEAD EMERGENCY LIGHTS AT ROW 11 AND 15 DID NOT ILLUMINATE. REPLACED BATTERY POWER SUPPLY IAW E175 AMM 33-50-01-000-A & 33-50-01-400-801A.SDR FDEA2019080861815Power Supply · no testDURING CHECK, FOUND THE RT EMERGENCY EXIT LOCATOR SIGN LIGHT ONLY ILLUMINATIED FOR 10 SECONDS WHEN THE EMERGENCY SWITCH ON OR PERFORMED THE EMERGENCY LIGHT TEST. REMOVED AND REPLACED THE EMERGENCY LIGHT POWER SUPPLY M730 IAW AMM 33-51-07-2. IAW AMM 33-
Back to JASC 3350