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 SWAA2019100237460Wire · brokenFORWARD LT EXTERIOR EMERGENCY LIGHT INOPERATIVE. FOUND A BROKEN WIRE, AFT OF THE FORWARD ENTRY DOOR, RETAINING LANYARD. REPAIRED LIGHT PER AMM. R&R LENS RETAINER WIRE PER AMM.SDR DALA201910035676Battery Pack · no testFOUND EPSU BATTERY FAULT AT THE LEFT OVERWING DOOR, FOUND DURING AN EMERGENCY LIGHT TEST, R & R THE EPSU BATTERY.SDR HALA2019100290154Cover · looseEXIT SIGN COVER AT DOOR 3R LOOSE. RE-INSTALLED EXIT SIGN COVER AT DOOR 3R. LP 6774360SDR AALA201910029022Power Supply · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY IN-SEAT LIGHTS FROM SEAT 1H AND 5H RIGHT AISLE INOPERATIVE. MAINTENANCE FOUND CONNECTOR P2, SEAT 2H OFF PER WDM 33-51-58, AND PLUGLOCK BROKEN UNDER SEAT 24. MAINTENANCE REPLACED POWER SUPPLY PER AMM 33-51-06 AND REPLACED COSDR AALA201910029002Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 21D EMERGENCY LIGHT BROKEN. MAINTENANCE REPLACED EMERGENCY LIGHT PER AMM 33-51-11E.SDR SWAA2019100217434Cover · missingR/H OVERWING EXIT SIGN COVER MISSING. SECURED COVER PER SIP.SDR SWAA2019093037389Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOP. / RELAMPED LIGHT IAW AMM.SDR JJBA20190929011Light · unsecureAISLE OVERHEAD EMERGENCY LIGHT HANGING. SECURED AISLE EMERGENCY LIGHT PANEL. OPS CHECK SAT. NO DEFECTS NOTED.SDR MASA2019092912068Light · inoperativeEMER FLOOD LIGHTMROW 9 INOP
REPLACED BULBSDR MASA2019092912067Light · inoperativeSVC DOOR LWR/AFT FLOOD LIGHT INOP
PLACED ON MELSDR MASA2019092912066Light · inoperativeSVC DOOR EMERG EXIT LIGHTS INOP. RELAMPEDSDR MASA2019092912065Light · inoperativeRIGHT AFT EXT EMER LIGHT INOP. PLACED ON MELSDR ASOA2019100498102Light · inoperativeDURING MX INSPECTION THE EMERGENCY EXIT LIGHT AT FWD STEP BELOW COCKPIT WILL NOT ILLUMINATE. MX REMOVED AND INSPECTED WIRES TO LIGHT ASSEMBLY AND FOUND VOLTAGE AT SPLICE AND REINSTALLED EXIT LIGHT ASSEMBLY WITH OPS CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SESDR YENA2019100280557Charger · failedFT # 6460, RT OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY CHARGER FOR R/H OVERWING EMERG. LIGHTS. CHECKS GOOD AT THIS TIME. REPLACED BATTERY OF R/H OVERWING EMERG. LIGHT. NO HELP SEE NEXT ITEM-2717051-2SDR YENA2019100280555Battery · failedFT # 524, LAX-JFK. EPSU OVER R2 DOOR BATTERY FAULT ON FAP; R & R EPSU AT POSITION 14WL IAW AMM 33-51-38. OPS CHECK GOOD. MSG NO LONGER PRESENT. A/C OK FOR SVC.SDR SWAA2019100237503Battery Pack · inoperativeR/H EMERGENCY LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019100237502Battery Pack · inoperativeL/H EMERGENCY LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019100237484Power Supply · inoperativeR/H EMERGENCY LIGHTS INOP AT BS. 610. R&R POWER SUPPLY IAW AMM.SDR SIMA2019100198011Lamp · inoperativeROW 17 AISLE EMERGENCY LIGHT INOPERATIVE. R & R ROW 17 AISLE EMERGENCY LIGHT LAMP IAW AMM 33-50-08. OPS CHECKED GOOD. NO FURTHER DEFECTS NOTED.SDR SIMA2019100198010Power Supply · inoperativeSERVICE DOOR EXIT IDENTIFIER EMERGENCY LIGHT INOP. T/S IAW W/D 33-50-50 AND FOUND NO VOLTAGE COMING THROUGH. REMOVED AND REPLACED ELPU IAW AMM-33-50-01. OPC GOOD AT THIS TIME.SDR AALA2019100199022Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 12WL BATTERY FAILED EMERGENCY POWER SUPPLY UNIT SYSTEM TEST IN REFERENCE WITH JOB CARD 26L00005005. MAINTENANCE REPLACED BATTERY PER AMM 33-51-38.SDR HALA2019093000393Cover · looseEXIT SIGN COVER AT DOOR 3R LOOSE. // REINSTALLED EXIT SIGN COVER AT 3R.SDR SIMA20190928003Inverter · inoperativeDURING PS-2 CHECK FOUND TOP SERVICE DOOR EMERGENCY EXIT LIGHT INOP-C/A-REMOVED AND REPLACED EMERGENCY LIGHT DC/AC INVERTER #2 IAW EMB 145 AMM 33-50-11SDR SIMA20190928002Light · inoperativeDURING PS-1 CHECK FOUND LH OVERWING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED LH OVERWING EMERGENCY LIGHT BULB IAW AMM 33-50-07.OPS CHECK GOOD.SDR SWAA2019093037418Lens · crackedL/H EMERGENCY LIGHT LENS CRACKED AT POSITION 4. / R&R LENS IAW AMM.SDR DALA2019093005608Shroud · damagedSEAT MOUNTED EMERGENCY PATH LIGHT SHROUD DAMAGED AT SEAT 14G AND 26B. REPLACED SHROUDS. SYSTEM OPERATION IS NORMAL. (LP 1291536)SDR SWAA2019100237508Sign · inoperativeFORWARD GALLEY AREA R/H EXIT SIGN INOP. R&R SIGN IAW AMM.SDR SWAA2019100237507Battery Pack · inoperativeFORWARD GALLEY AREA R/H EMERGENCY LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019100237506Charger · inoperativeFORWARD GALLEY AREA R/H EMERGENCY LIGHTS INOP. R&R BATTERY CHARGER IAW AMM.SDR SWAA2019100237505Charger · inoperativeFORWARD GALLEY AREA L/H EMERGENCY LIGHTS INOP. R&R BATTERY CHARGER IAW AMM.SDR SWAA2019100237504Battery Pack · inoperativeFORWARD GALLEY AREA L/H EMERGENCY LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019100237483Sign · inoperativeFORWARD GALLEY AREA L/H EXIT SIGN INOP. R&R SIGN IAW AMM.SDR ASOA2019100294054Light · inoperativeFLIGHT 4087, THE CREW REPORTED THAT THE EMERGENCY STRIP INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED EMERGENCY LIGHT STRIP, OPERATIONALLY TESTED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA2019100199023Power Supply · no testAIRCRAFT WAS NOT GROUNDED: DURING EMERGENCY LIGHT TEST ON "CIDS 1" RECEIVED FAULT MESSAGE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY PER AMM 33-51-38.SDR SIMA20190927002Battery Pack · dischargedFLOOR EMERGENCY STRIP LIGHTING INOP. ROWS 1-4-C/A-REMOVED AND REPLACED #2 BATTERY PACK IAW AMM 33-50-04. OPS CHK GOODSDR SIMA20190927001Battery Pack · dischargedEMERG LT TURNED ON IN FLIGHT. ONLY ILLUMINATED THE FIRST ROW IN THE CABIN , THE COCKPIT JS, AND FA JS.-C/A-REMOVED AND REPLACED #1 (FWD) BATTERY PACK AND POWER SUPPLY AS PER AMM 33-50-04. OPS CHECK OK AS PER AMM 33-50-00. BATTERY CHARGER ASSY P/N 11-0049 S/N 2SDR AALA201909309004Epsu · faultyAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT SYS TEST AT PTP PANEL FAULTS 14WL EPSU. MAINTENANCE REPLACED EPSU & BAT 14WL IAW AMM 33-51-38. OPS CHECK OK.SDR SWAA2019093037426Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01669. / R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019093037425Battery Pack · dischargedR/H EMERGENCY EXIT LIGHTS INOP AT ROW 8. / R&R BATTERY PACK IAW AMM.SDR SWAA2019093037424Power Supply · inoperativeR/H EMERGENCY EXIT LIGHTS INOP AT ROW 8. / R&R POWER SUPPLY IAW AMM.SDR SWAA2019093037423Battery Pack · dischargedL/H EMERGENCY EXIT LIGHTS INOP BETWEEN ROW 7 TO ROW 12. / R&R BATTERY PACK IAW AMM.SDR SWAA2019093037422Power Supply · inoperativeL/H EMERGENCY EXIT LIGHTS INOP BETWEEN ROW 7 TO ROW 12. / R&R POWER SUPPLY IAW AMM.SDR SWAA2019093037421Battery Pack · dischargedR1 DOOR OUTSIDE EMERGENCY EXIT LIGHTS INOP. / R&R BATTERY PACK IAW AMM.SDR SWAA2019093037420Light · inoperativeR1 DOOR OUTSIDE EMERGENCY EXIT LIGHTS INOP. / R&R LAMP IAW AMM.SDR SWAA2019093037391Lens · unsecureMID CABIN EMERGENCY "EXIT" SIGN FELL OUT. / SECURED LENS PER AMM.SDR SWAA2019093037379Power Supply · inoperativeR1 DOOR OUTSIDE EMERGENCY EXIT LIGHTS INOP. / R&R POWER SUPPLY IAW AMM.SDR SWAA2019093037321Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01675. / R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019093037287Lens · missingFORWARD ENTRY LOWER EMERGENCY LIGHT LENS COVER MISSING DIRECTIONAL ARROW. / R&R COVER PER AMM.SDR SWAA2019093037286Battery Pack · dischargedL/H FORWARD OVERWING DOOR EXTERIOR EMERGENCY ESCAPE LIGHT (L1210) INOP. / R&R M2335 BATTERY PACK PER AMM.SDR SWAA2019093037285Battery Pack · dischargedR1 DOOR EXTERIOR EMERGENCY LIGHT (L1063) INOP. / R&R M2816 BATTERY PACK PER AMM.
Back to JASC 3350