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 AALA201902069009Switch · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS SWITCH INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT SWITCH 4WL. OPERATIONS CHECK GOOD PER ESPM 20-42-21 AND AMM CH 33-51-00.SDR AALA201902069005Light · damagedAIRCRAFT NOT GROUNDED: SEAT 26 ABC EMERGENCY LIGHT IS DAMAGE. REMOVED AND REPLACED SEAT MOUNTED EMERGENCY LIGHT AT SEAT 26ABC; OPS CHECK IS GOOD IAW AMM 33-51-19.SDR AALA201902069002Light · inoperativeAIRCRAFT WAS NOT GROUNDED: COCKPIT EMERGENCY LIGHT WOULD NOT TEST WHEN SWITCH WAS IN THE ARM POSITION. MAINTENANCE REPLACED COCKPIT EMERGENCY LIGHT EXIT SIGN ASSEMBLY PER MM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20190205001Light · inoperativeAIRCRAFT WAS NOT GROUNDED: COCKPIT EMERGENCY LIGHT WOULD NOT TEST WHEN SWITCH WAS IN THE ARM POSITION. MAINTENANCE REPLACED COCKPIT EMERGENCY LIGHT EXIT SIGN ASSEMBLY PER MM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019020629295Sign · looseAFT GALLEY EXIT SIGN LOOSE. REPAIRED SIGN PER SIP.SDR HNAA2019020600036Inverter · faultyEMERGENCY LIGHTS INOP AT 1A AND 2A AT FLOOR. TROUBLESHOT AND FOUND GALLEY CEILING INVERTER PS 8501 TO BE AT FAULT. (SHORT SIGNED). R&R EMERGENCY LIGHTS INVERTER ASSY AS REQ. OPS CK GOOD.SDR SIMA20190205002Light · inoperativeRT FWD WING EMERGENCY LIGHT INOP. REMOVED AND REPLACED RT FWD WING EMERGENCY LIGHT BULB. OPC GOOD IAW AMM 33-50-10.SDR SIMA20190205001Light · inoperativeFLOOR EMERGENCY PROX LIGHT STRIP BETWEEN SEATS 7 THROUGH 9 INOP. REMOVED AND REPLACED FLOOR EMERGENCY PROX LIGHTS STRIP BETWEEN SEATS 7 THROUGH 9 IAW AMM 33-50-12. OPS CHECK GOOD.SDR SIMA20190205003Light · inoperativeFWD CEILING EMERGENCY LIGHT INOP. R&R EMERGENCY LIGHT IAW AMM 33-50-08. OPC GOOD.SDR DALA2019020600812Battery Pack · malfunctionedSHIP 3819 DURING SERVICE CHECK FOUND SEAT MOUNTED EMERGENCY LIGHTS FROM ROW 22-27. CORRECTIVE ACTION :R&R BATTERY PACK @ 25D IAW B737 AMM 33-51-06, OPS CHECK GOOD, OK FOR SERVICE (5266389).SDR WX0A2019021673380Power Supply · no testEPSU 12WL FAILED AN EMERGENCY LIGHT CHECK. R & R THE EPSU.SDR UIEA2019020503125Lamp · inoperativeL1 DOOR SILL EMERGENCY LIGHTS L1853 AND L1854 INOP(<P>RELAMPED L1853 AND L1854 PER B747-400 AMM TASK 33-51-05-962-031. OPS CHECKED GOOD PER B747-400 SUB-TASK 33-51-05-712-029.</P>)SDR DALA2019020500759Power Supply · inoperativeGALLEY AND FIRST CLASS EMERGENCY LIGHTS INOP. R/R POWER SUPPLY/ BATT CHARGER FUSES PER MD 88 AMM 23-51. OPS GOOD. (LP5571308)SDR SIMA20190204004Structure · damagedALL RT FLOOR SIDEWALL EXTRUSIONS ARE DAMAGED. C/A-COMPLETE:REMOVED AND REPLACED ALL RT FLOOR SIDEWALL EXTRUSIONS IAW AMM 33-50-12. SEE BOW313523 FOR INSTALLATION.SDR SIMA20190204003Structure · tornEXTRUSIONS FOR EMERGENCY LIGHT STRIPS #1, #4, #5, #6, #7 AND #8 ARE TORN. C/A-COMPLETE:REMOVED AND REPLACED EXTRUSIONS FOR EMERGENCY PROXIMITY LIGHTS #1,#4,#5,#6,#7 AND #8 IAW AMM 33-50-12. SEE BOW313523 FOR OPS CHECK.SDR IPXA2019020538707Power Supply · lowEMERGENCY LIGHT BAT "1" LOW. R&R EMERGENCY POWER. SUPPLY REF AMM 33-51-01. OPS CK GOOD.SDR SIMA20190204001Holder · defectiveFOUND LT & RT OVERWING EMERGENCY LIGHTS OUT DURING PS-1 CHECK IN THE EXTERIOR. REMOVED AND REPLACED BATTERY POWER SUPPLY HOLDER IAW AMM 33-50-04. OPC GOOD. NO FURTHER DEFECTS NOTED.SDR QXEA2019020500060Light · looseFLOOR LIGHTING IN FRONT OF ROW 2 LOOSE. REMOVED FROM SERVICE. EMER STRIP IN FRONT OF ROW 2DE NOT PROPERLY INSTALLED. REINSTALLED/RESECURED EMER STRIP LIGHTING IN FRONT OF 2ED. NO FURTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR SWAA2019020529271Battery Pack · dischargedAFT LOWER LT EXTERIOR EMERGENCY LIGHT INOP AT BS 727. R&R BATTERY PACK PER AMM.SDR SWAA2019020529270Fuse · blownRT EMERGENCY EXIT ROW SIDEWALL LIGHT INOP. R&R FUSE IAW AMM.SDR SWAA2019020529269Power Supply · inoperativeAFT LOWER LT EXTERIOR EMERGENCY LIGHT INOP AT BS 727. R&R POWER SUPPLY PER AMM.SDR SWAA2019020529267Lens · unsecureCENTER CABIN EXIT SIGN LENS POPPED OFF. REINSTALLED SIGN IAW MM.SDR 29GA2019020500001Annunciator · malfunctionedFLIGHT# 0137 EYW/MCO REPORT: EMERGENCY CABIN LIGHT ARM ANNUNCIATOR @ FLT ATTENDANTS STATION DOES NOT ILLUMINATED W/ COCKPIT EMERGENCY LT SWITCH IN ARMED POSITION. CORRECTIVE ACTION: OPERATIONAL CHECKS GOOD AT THIS TIME. PERFORMED OPERATION CHECK I.A.W. SAAB 3SDR DALA2019020540750Light · detached(AIRCRAFT 7102, L/P 0930919) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:49F / ACARS TEXT: FRC 33520149F / INTERIOR. FOUND IT WAS DETACHED FROM ITS POSITION. REPOSITIONED FLOOR PROX LIGHT AT 49F. CHECKED OP AND OK.SDR IPXA2019020438667Battery Pack · no testON CHECK FOUND UPPER DECK L/H EMERGENCY DOOR LIGHT TEST INOP.R/R EMERGENCY BATTERY PACK ASSY, LIGHT TEST OK PER AMM 33-51-04/201.SDR SWAA2019031230588Light · inoperativeFORWARD LAV, EMERGENCY EXIT LIGHT BULBS BURNED OUT. R&R LIGHT IAW AMM.SDR SWAA2019031230587Light · inoperativeLT OVERWING EXIT, LOWER EMERGENCY EXIT LIGHT BULBS BURNED OUT. R&R BULB IAW AMM.SDR SWAA2019031230586Light · inoperativeG4 GALLEY EXIT LIGHT BULBS BURNED OUT. R&R LIGHT IAW AMM.SDR SWAA2019031230480Light · inoperativeRT OVERWING LOWER EMERGENCY EXIT LIGHT BULBS BURNED OUT. R&R BULB IAW AMM.SDR REXA2019020300115Battery Pack · dischargedEMERGENCY EXIT SIGNS (LOWER) NOT ILLUMINATED AT ROW 12. BOTH SIDES NOT ILLUMINATED. REMOVED BATTERY PACKS NR 3 AND NR 5, AND INSTALLED SERVICEABLE IAW AMM 33-51-17. EMERGENCY LIGHT OPS CHECK GOOD, AIRCRAFT OK FOR SERVICE. NR 3 PS37 P/N ON/OFF AD-2013-1A S/N OFSDR AALA20190204002Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: DURING WC 2735 BATTERY PACK M33099 WAS NOT WORK PROPERLY. MAINTENANCE REPLACED BATTERY PACK NEXT TO DOOR 2L PER AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20190204001Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK, FOUND SEVERAL EMERGENCY LIGHTS NOT ILLUMINATING IN BUSINESS CLASS BETWEEN DOOR 1 TO DOOR 2. MAINTENANCE TROUBLESHOT AND FOUND EMERGENCY POWER SUPPLY ON DOOR 1R FORWARD BATTERY INOPERABLE. MAINTENANCE ALSO REPLACED POSDR DALA2019020400778Light · inoperativeEMERGENCY LIGHTS AT 15B ARE INOPERATIVE. REPLACED LIGHT ASSEMBLY.SDR FDEA201902030253Bulb · inoperativeEMERGENCY SLIDE LIGHT L1 NO LIGHT FACT 03FEB19 11:23 CPH EMERGENCY SLIDE LIGHT L1 BULP REPLACED AMM 33-51-06-2-1 REV 123.4 SDR UIEA2019020503120Battery Pack · no testFOUND POWER SUPPLY EMERGENCY LIGHT M5170,M5168 CAPACITIY FUNCTION NOT GOOD.(<P>1.IAW AMM 33-51-04-902-001-001 REV.94 REPLACED EMERGENCY LIGHTS SUPPLY BATTERIES M5170,M5168 AND CONDTION CHECK NORMAL 2.I.A.W. AMM 33-51-04-902-001-001 REV.94 STEP 3.E PERFORMED POSDR SWAA2019020429145Light · inoperativeL1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR DALA2019020400703Bulb · inoperative23D SEAT EMERGENCY LIGHT OUT. R/R BULB AT SEAT 23D PER STANDARD PRACTICE. (LP4807909)SDR DALA2019020400705Charger · inoperativeEMERGENCY LIGHTS IN CEILING BETWEEN ROWS 31 AND 33 NOT ILLUMINATING. RELAMPED NO HELP REPLACED EMRG BATTERY PACK NO HELP. R/R BATTERY CHARGER @ STA 1120 OPS CHKS GOOD PER MD88 AMM 33-53 - A/C OK FOR SVC. (LP4702558)SDR 29GA2019020400001Light · unsecureFLT 0117 FPO/FLL REPORT: FA EMERGENCY LIGHT ARMED LIGHT NOT ILLUMINATING WITH COCKPIT EMERGENCY LIGHT SWITCH IN THE ARMED POSITION. SECURED BULBS OPS CHECK OK IAW 33-50-60 AMM.SDR MASA2019020311702Light · inoperativeCEILING EMER FLOOD LIGHTS INOP. PLACED ON MEL.SDR AALA201902049028Contact · brokenON INSPECTION OF THE EMERGENCY LIGHTS, FOUND THE EXIT SIGN AT THE L2 DOOR HAD FAILED TO ILLUMINATE. FOUND A BROKEN CONTACT AT CONNECTOR D10084. TERMINATED A NEW CONTACT IAW SWPM 20-30-12. OPS TESTED GOOD.SDR SWAA2019020529259Light · looseCENTER CABIN OVERWING EMERGENCY EXIT LIGHT ASSEMBLY LOOSE. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2019020429144Light · inoperativeRT FORWARD CABIN EMERGENCY LIGHT INOP AT ROW 6. REPAIRED LIGHT IAW WDM AND MM.SDR SWAA2019020429139Lens · unsecureRT AFT DOOR EXIT SIGN AFT AIRCRAFT FELL OFF. R&R LENS PER MM.SDR AALA201902049023Light · inoperativeLEFT SIDE EMERGENCY EXIT LIGHT WAS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-15/400. OPS CHECKED NORMAL.SDR VNAA2019100121101Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK #4 INOP LIGHTS NOT ILLUMINATING. REMOVED AND REPLACED #4 EMERGENCY POWER SUPPLY BATTERY IAW CRJ 700 AMM 33-51-17-000/400-801SDR SWAA2019020529260Battery Pack · dischargedLT OVERHEAD BIN EMERGENCY EXIT LIGHT INOP BETWEEN ROW 9 TO ROW 12. R&R BATTERY PACK PER SIP.SDR SWAA2019020529217Light · inoperativeL2 DOOR EMERGENCY EXIT LIGHT BULBS INOP. R&R LIGHT PER AMM.SDR SWAA2019020529215Light · inoperativeAFT LAV WALL EMERGENCY EXIT LIGHT INOP. R&R LIGHT PER AMM.SDR SWAA2019020529180Charger · inoperativeLT OVERHEAD BIN EMERGENCY EXIT LIGHT INOP BETWEEN ROW 9 TO ROW 12. R&R CHARGER ASSEMBLY PER SIP.
Back to JASC 3350