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 SWAA2016091607895Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST. R & R BATTERY IAW AMM.SDR SWAA2016091607894Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST. R & R BATTERY IAW AMM.SDR SWAA2016091607893Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST. R & R BATTERY IAW AMM.SDR SWAA2016091607892Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST. R & R BATTERY IAW AMM.SDR SWAA2016091607890Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST. R & R BATTERY IAW AMM.SDR SWAA2016091607889Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST. R & R BATTERY IAW AMM.SDR SWAA2016091607877Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST. R & R THE BATTERY IAW AMM.SDR SWAA2016091607874Battery Pack · inoperativeAISLE EMERGENCY LIGHT INOPERATIVE BETWEEN BS 710 & 727E. R & R BATTERY PACK IAW MM.SDR SWAA2016091607851Sign · looseEXIT ROW SIGN LOOSE. SECURED THE SIGN IAW AMM.SDR DALA2016091506681Power Supply · inoperativeFWD EMERGENCY EXIT OVERWING LIGHT INOPERATIVE. REMOVED & REPLACED THE POWER SUPPLY UNIT IAW AMM 33-53. OPS CHECKED OK.SDR HNAA2016091600282Lens · jammedF/A EMERGENCY LIGHT SWITCH DIFFICULT TO ACTIVATE, DEACTIVATE. R & R F/A EMERGENCY LIGHT LENS COVER IAW 33-51-00.SDR SIMA20160915001Fuse · blownMEL 33-29, EMERGENCY LIGHT ON PASSENGER DOOR INOPERATIVE. R & R FUSE FOR EMERGENCY LIGHT ON PASSENGER DOOR AT POWER SUPPLY. OPS CHECK GOOD MEL HAS BEEN RESTORED, REF CMM 25-60-03.SDR CALA2016091500655Light · malfunctionedEMERGENCY LIGHTS AT SEATS 28 THRU 34 ABC AND OVERHEAD EMERGENCY LIGHTS STAY ON ALL THE TIME. COCKPIT SWITCH POS. AND / OR POWER CONFIG. OF ACFT HAVE NO EFFECT. ALL OTHER EMERGENCY LIGHTS INOP ALL THE TIME, IN ALL MODES. BATTERY PACK & POWER SUPPLY TEST IAW ASDR CALA2016091500654Switch · inoperativeEMERGENCY LIGHT INOPERATIVE, CEILING, ISLE ABOVE 45ABC. CYCLED CABIN EMERGENCY LIGHT SWITCH. OPS CHECKED GOOD.SDR CALA2016091500653Lamp · inoperativeEMERGENCY LIGHT INOP, LEFT BODY FAIRING AFT LAMP ASSY FWD LAMP. REPLACED LAMP.SDR MASA2016091512390Flashlight · inoperativeCAPTAIN`S EMERGENCY FLASH LIGHT INOPERATIVE. PLACED ON MEL.SDR MASA2016091512389Light · inoperativePASSENGER DOOR EMERGENCY FLOOD LIGHT HALF INOPERATIVE.SDR MASA2016091512388Light · inoperativeEMERGENCY EXIT SIGN ROW 18, 1 BULB INOPERATIVE. PLACED ON MEL.SDR MASA2016091512387Light · inoperativeROW 17A EMERG EXIT SIGN 1 BULB INOPERATIVE. PLACED ON MEL.SDR AALA20160926002Lens · looseL1 DOOR SLIDE EXTERNAL LIGHT LENS FOUND LOOSE. LIGHT LENS REINSTALLED IAW AMM 33-51-04.SDR AALA20160914001Light · brokenAISLE MOUNTED EMERGENCY LIGHT AT SEAT ROW 11C BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW MM 33-51-19. THE AIRCRAFT WAS GROUNDED.SDR DALA2016091506680Power Supply · inoperativeDURING SERVICE CHECK, FOUND EMERGENCY LIGHTS OUT FROM ROWS 24EF THRU 30 E AND F RT SIDE. REMOVED & REPLACED THE POWER SUPPLY, OPS CHECKED GOOD.SDR CALA2016091500651Cover · looseEMERGENCY EXIT LIGHT COMING OUT OF WALL BY LAVATORY 101. INSTALLED THE COVER, OPS GOODSDR CALA2016091500652Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE, RIGHT BODY FAIRING, THIRD LAMP ASSY FROM TOP-AFT LAMP INOPERATIVE. REPLACED LAMP.SDR RAIA201609130002Bulb · inoperativeEMERGENCY EXIT LIGHT IN CEILING, AT ROW 23 IS INOPERATIVE. R & R THE BULB. OPS CHECKED GOOD.SDR AALA201609159016Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT ROW 6 RIGHT. REPLACED EMERGENCY LIGHT LENS AT SEAT ROW 6 RIGHT PER AMM 33-50-00.SDR AALA201609159015Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT ROW 23 LEFT. REPLACED THE LENS IAW AMM 33-50-00.SDR AALA201609159012Lens · missingSEAT MOUNTED LIGHT LENS COVER MISSING AT 20L. INSTALLED LENS COVER AT 20L.SDR HALA2016091400352Battery · dischargedEMERGENCY LIGHT IN COCKPIT DOES NOT ILLUMINATE WHEN ON POSITION. R & R BATTERY AT B5-123 IAW WDM 33-51-12. OPS CHECK GOOD. OK FOR SERVICE.SDR SIMA20160914003Sign · inoperativeRT OVERWING INTERIOR EXIT SIGN WILL NOT ILLUMINATE. R & R RT OVERWING INTERIOR EXIT SIGN IAW AMM 33-50-14. OPS CK GOOD.SDR MASA2016091412386Battery Pack · inoperativeEMERGENCY LIGHTS WON`T STAY ON. MX CHARGED BATTERIES.SDR SWAA2016092608107Light · brokenG-1 GALLEY EMERGENCY EXIT LIGHT ASSY BROKEN. R & R LIGHT ASSY IAW SRM.SDR QXEA2016091300584Lamp · inoperativeAFT RIGHT EMERGENCY EGRESS LIGHT IS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-11-00-801 AND 33-51-11-400-801. CHECKED GOOD.SDR QXEA2016091300581Lamp · inoperativeFORWARD EMERGENCY LIGHT SWITCH BY MAIN CABIN DOOR INOPERATIVE. REPLACED THE LAMPS IN THE SWITCH. CHECKED GOOD. RETURNED TO SERVICE.SDR VNAA2016091300013Light · inoperativeFORWARD AND AFT OVERHEAD EMERGENCY LIGHTS INOPERABLE. MAINTENANCE INSPECTED, RELAMPED FORWARD AND AFT OVERHEAD EMERGENCY LIGHTS AND PERFORMED CHECKS IAW THE AMM. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR AALA20160915002Light · brokenSEAT EMERGENCY LIGHT INOPERATIVE AT ROW 40B. REPLACED THE EMERGENCY LIGHT , OPS CHECKED GOOD IAW AMM 33-51-10.SDR AALA20160914002Battery Pack · faultyON PS 2 CHECK, FOUND R4 EMERGENCY LIGHT ON DOOR ALL 3 EXIT SIGNS INOPERATIVE. TROUBLESHOOTING FOUND FAULTY BATTERY & CHARGER. REPLACED THE BATTERY & CHARGER IAW MM 33-51-07. ACCOMPLISHED OPSS CHECK OF EMERGENCY LIGHT, CHECKED NORMAL.SDR AALA20160913004Light · damagedLEFT LOWER EXIT LIGHT ASSEMBLY FOR LEFT FORWARD ENTRY DOOR FOUND DAMAGED. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-00. OPS CHECK GOOD.SDR DALA2016091406693Battery Pack · faultedEPSU SYSTEM TEST, FAULTED BATTERY. REPLACED BATTERY 15WL.SDR SWAA2016091607853Cover · missingCENTER ISLE CEILING EMERGENCY EXIT SIGN LENS COVER MISSING. INSTALLED COVER IAW MM.SDR SWAA2016091507837Fuse · inoperativeRIGHT FORWARD EMERGENCY DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R FUSE IAW AMM.SDR SWAA2016091507825Cover · unsecureRIGHT OVERWING EXIT SIGN LENS COVER FELL OFF. INSTALLED COVER IAW AMM.SDR RAIA201609130001Light · misinstalledRIGHT OVERWING EMERGENCY EXIT LIGHT ASSEMBLY IS UPSIDE DOWN. REMOVED, REPOSTIONED AND INSTALLED THE RIGHT OVERWING EMERGENCY EXIT LIGHT. OPS CHECKED GOOD.SDR AALA201609149008Battery Pack · inoperativeEMERGENCY POWER SUPPLY UNIT 13WL FAILS OPERATIONAL TEST IAW TASK CARD 33C22033002. REPLACED THE BATTERY PACK AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201609149007Battery Pack · inoperativeEMERGENCY POWER SUPPLY UNIT 15WL FAILS OPERATIONAL TEST PER TASK CARD 33C22033002. REPLACED BATTERY PACK AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201609149011Cover · missingAIRCRAFT WAS NOT GROUNDED: 2-R DOOR MISSING EXIT LIGHT COVER. INSTALLED 2-R DOOR EXIT LIGHT COVER.SDR AALA201609149009Lens · missingAIRCRAFT WAS NOT GROUNDED: EXIT ROW 22C SEAT MISSING RED LENS COVER. REINSTALLED RED SEAT LENS COVER.SDR SWAA2016091407817Lens · crackedLEFT CABIN EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 5 TO ROW 8. R & R LENS IAW AMM.SDR SWAA2016091407796Light · faultyEMERGENCY EXIT LIGHT FAULTY. R & R LIGHT IAW AMM.SDR SWAA2016091407783Lens · crackedRIGHT CABIN EMERGENCY LIGHT LENS CRACKED AT ROW 6. R & R LENS IAW AMM.
Back to JASC 3350