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 DALA2019071004160Light · inoperativeLLCR EMERGENCY LIGHTS ALL BURNT. REPLACED ALL EMERGENCY LIGHTS BULBS IN LLCR. SYSTEM OPERATION IS NORMAL.SDR AALA201907119004Light · inoperativeAIRCRAFT WAS GROUNDED: FORWARD, RIGHTHAND SIDE, OVERWING, EMERGENCY EXIT LIGHT WAS INOPERABLE DURING TEST. MAINTENANCE RELAMPED OVERWING EMERGENCY LIGHT PER AMM 33-51-06.SDR SWAA2019071134748Light · inoperativeL2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R&R LAMP PER AMM.SDR SWAA2019071134730Cover · looseFWD ENTRY DOOR EMERGENCY EXIT SIGN DISLODGED. SECURED COVER PER AMM.SDR SWAA2019071134720Lens · unsecureOVERWING EMERGENCY EXIT SIGN NOT SECURE. SECURED LENS IAW AMM.SDR SWAA2019071134697Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R&R LAMP PER AMM.SDR SWAA2019071034708Battery Pack · failedOVERWING EMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR AALA20190709002Light · inoperativeAIRCRAFT WAS GROUNDED: FOUND 6 LIGHTS ON THE LEFT SIDE OF AIRCRAFT TO BE INOPERABLE. MAINTENANCE REPLACED SLIDE ESCAPE LIGHT ASSEMBLY PER AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR UIEA2019070904718Battery Pack · dischargedLT UPPER DECK GULL WING DOOR EMERGENCY EXIT SIGN INOP (<P>REMOVED AND REPLACED LT GULL WING DOOR EMERGENCY EXIT SIGN BATTERY PACK AND OPERATIONAL CHECK GOOD</P>)SDR UIEA2019070904715Light · inoperativeR-5 DOOR SLIDE LIGHT INOP. (<P>REMOVED AND REPLACED R-5 DOOR SLIDE LIGHT ASSY. OPS CHECKED PER AMM TASK 33-51-06-004-001 AND 33-51-06-404-007.</P>)SDR UIEA2019070804714Light · inoperativeRT EXTERNAL OVERWING EMERGENCY LIGHTS HAVE 1 EA LAMPS INOP. (<P>RELAMPED RT EXTERNAL OVERWING EMERGENCY LIGHTS PER AMM 33-51-03-962-001. OPS CHECKED GOOD PER AMM 33-51-03-962-001.</P>)SDR UIEA2019070804713Light · inoperativeLT EXTERNAL OVERWING EMERGENCY LIGHTS HAVE 1 EA LAMPS INOP. (<P>RELAMPED LT EXTERNAL OVERWING EMERGENCY LIGHTS PER AMM 33-51-03-962-001. OPS CHECK PASSED PER AMM 33-51-03-962-001.</P>)SDR DALA2019071004144Light · unsecureEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE LOCATIONS:19B. SECURED LIGHTING STRIP. OK FOR SVC. REF AMM 33-51. (LP1162517)SDR FDEA201907091510Battery Pack · dischargedON PREFLIGHT FOUND LT EMERGENCY LIGHTS INOP. REMOVED AND REPLACED LT BATTERY PACK PER AMM 33-51-07-2. OP'S CHECK GOOD.SDR DALA2019070904111Battery Pack · dischargedFWD OVERWING EMER EXIT SIGNS OUT ON WALK AROUND. R/R EMER LIGHT BATTERY PACK B5-103 REF AMM 33-53. ALL CKS NORMAL. (LP5846431)SDR DALA2019070904178Light · damaged(AIRCRAFT 672, L/P 1160316) EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:27D / INTERIOR. SECURED LENS.SDR YENA201907080397Battery · dischargedFLT 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED EPSU BATTERIES AT FIN# 11WL AND 13WL; REMOVED & REPLACED EMERGENCY LIGHT BATTERIES AT FIN 11WL AND 13WL PER AMM 33-51-38.SDR YENA201907080396Battery · dischargedFLT 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED EPSU BATTERIES AT FIN# 11WL AND 13WL; REMOVED & REPLACED EMERGENCY LIGHT BATTERIES AT FIN 11WL AND 13WL PER AMM 33-51-38.SDR AALA201907099002Epsu · faultyAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS OVER EXIT EMERGENCY LIGHTS REMAINED ON AFTER ALL DOORS CLOSED AND ARMED. REMOVED AND REPLACED EPSU IAW AMM 33-51-38. EMERGENCY LIGHTS OPS TEST NORMAL.SDR SWAA2019070934689Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R&R LAMP PER AMM.SDR FDEA201907081509Battery · dischargedDURING PRE-DEPARTURE CHECK, FOUND NUMEROUS EMERGENCY EXIT SIGNS AND R1 EXTERIOR LIGHT INOP. ATTEMPTED TO CHARGE EMERGENCY LIGHT BATTERIES USING SHIP'S POWER FOR 1 HOUR. NO HELP. REMOVED AND REPLACED #2 EMERGENCY LIGHT BATTERY ASSY IN REF TO AMM 33-51-07-2. SDR SIMA20190708003Inverter · inoperativeCOCKPIT STEP AND GALLEY AISLE CEILING PANEL EMERGENCY EXIT IDENTIFIER SIGNS INOP. C/A-REMOVED AND REPLACED #1 EMERGENCY LIGHT DC/AC INVERTER IAW AMM 33-50-11. OPC GOOD.SDR DALA2019070804071Light · inoperativeLT OVERWING EMERG EXIT DOOR LIGHT INOP. RELAMPED SAME PER AMM 33-53 OPS CK GOOD. (LP6256107)SDR SWAA2019081335785Battery · no testEMERGENCY EXIT LIGHTS AT M1673 FAILED BATTERY PACK CAPACITY CHECK. / R&R BATTERY PER AMM.SDR SWAA2019081335784Battery · no testEMERGENCY EXIT LIGHTS AT M1672 FAILED BATTERY PACK CAPACITY CHECK. / R&R BATTERY PER AMM.SDR SWAA2019081335783Battery · no testEMERGENCY EXIT LIGHTS AT M1669 FAILED BATTERY CAPACITY CHECK. R&R BATTERY PER AMM.SDR DALA2019071704282Light · inoperativeSHIP 689 DOOR L3 SLIDE LIGHT BURNT OUT. CORRECTIVE ACTION: REMOVED AND REPLACED L3 SLIDE PER AMM 29-60. (8919621)SDR YENA2019070700394Light · unsecureFLT 568, FLL-ATL. 1 A,B,C FLOOR PROXIMITY LIGHT HANGING ( OUT OF BOX ); RE-SECURED FLOOR PROXIMITY LT AT ROW 1 ABC REF AMM 33-50-00.SDR SWAA2019070934604Lens · unsecureGALLEY EXIT LENS OUT OF POSITION. SECURED LENS PER AMM.SDR R61A201907070697I/O Module · faultyEMERGENCY LIGHT ON INDICATION AT CRUISE. ATTEMPTED QRH PROCEDURE AND MESSAGE DID NOT CLEAR. LIGHTS STAYED ON AND CONTINUED TO FLICKER INTERMITTENTLY. R&R DISCRETE I/O MODULE IN SPDA 1 SLOT 19 IAW AMM 24-61-05. EMERGENCY LIGHTS OPS CHECK GOOD.SDR ASAA2019070729944Sign · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN ON #4 GALLEY ADJACENT TO R-2 DOOR IS BROKEN. GROUNDED - YES. REMOVED, REPLACED, AND TESTED EXIT LOCATOR SIGN ASSY PER AMM 33-51-01-960-802 - OPS NORMAL.SDR DALA2019070804095Battery Pack · dischargedL-1 + R-1 UPPER EMERGENCY EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR SIMA20190707002Light · inoperativeLT FWD EXTERANL EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED LT FWD EXTERNAL EMERGENCY LIGHT LAMP IAW AMM TASK 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD.SDR DALA2019070704069Fuse · blownSEAT MOUNTED EMERGENCY LIGHTS FROM DOOR 1L TO SEAT 12DE INOP. FOUND FUSE F1 ON B5-211 TO BE BAD. REPLACED SAME, CHECKS GOOD. REF. AMM 33-53. (LP5774473)SDR DALA2019070704068Charger · inoperativeEMERGENCY LIGHTS AFT OF L2 DOOR INOP.FOUND AFT BATTERY CHARGER INOP. REPLACED BATTERY CHARGER PER AMM 33-53 CKS GOOD. (LP4619564)SDR SWAA2019071134741Battery Pack · dischargedAFT ENTRY DOOR EMERGENCY LIGHTS INOPERATIVE. R&R BATTERY PACK M1673 PER AMM.SDR SWAA2019071134728Ballast · inoperativeLT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R&R BALLAST PER AMM.SDR SWAA2019070934612Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019070934611Light · inoperativeRT OVERWING EXIT EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR DALA2019070804102Fuse · blownSHIP 3823 EMERGENCY LIGHT FROM ROW 28 TO ROW 32 INOP. CORRECTIVE ACTION: R/R FUSE ON EMERG LIGHT PWR SUPPLY PER AMM 33-51-06. OPS CHECK NLM. (6288194).SDR AALA201907089006Guard · faultyAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SWITCH WIRE WOULD NOT OPEN. MAINTENANCE REPLACED EMERGENCY LIGHT GUARD OVER TOGGLE PER STANDARD PRACTICES AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA20190706004Charger · inoperative#4 EMERGENCY BATTERY/CHARGER INOP. C/A-REMOVED AND REPLACED BATTERY HOLDER AND BATTERY CHARGER ASSEMBLY IAW AMM 33-50-04, OPERATIONALLY CHECKED GOOD.SDR DALA2019070804080Battery Pack · dischargedEMERGENCY EXIT SIGNS INOPERATIVE. EXIT LIGHTS FLASHING. T/S AS PER FIM 33-50; ALLOW SUFFICIENT TIME FOR BATTERY PACKS TO RE-CHARGE OPS CHECK NORMAL OK FOR SERVICE. (LP1157653)SDR DALA2019070604067Battery · dischargedFWD OVERWING EXIT ROW ESCAPE EXIT SIGNS INOP BOTH SIDES (ROW 24). REPLACED BATTERIES ABOVE SEAT 24E REF AMM 33-53. OPS CHECK GOOD. (LP4750837)SDR SIMA2019080705004Light · damagedFOUND 7 EMERGENCY FLOOR LIGHTS DAMAGED.-C/A-COMPLETE:REPLACED 7 EMERGENCY FLOOR LIGHTS AND INSERTED THEM ONTO THE FLOOR PROFILE READY TO INSTALL SEE BOW 324814 FOR INSTALLATION OF CARPET FLOOR PROFILES AND E727950 FOR OPS CHECK.SDR SIMA2019080705005Light · damaged4 EACH EMERGENCY LIGHT STRIPS FLOOR ANGLES ARE CRACKED.-C/A-COMPLETE:REPLACED 4 EACH EMERGENCY LIGHT STRIP FLOOR ANGLES AND INSERTED EMERGENCY LIGHT STRIPS IN ANGLE PROFILES READY TO INSTALL ON AIRCRAFT SEE BOW324814 FOR INSTALLATION OF EMERGENCY LIGHT STRIPSSDR SIMA2019080705006Control Panel · inoperativeEMERGENCY LIGHTS ARE INNOP WHEN USING FLIGHT ATTENDANT PANEL "NORM/ON" PUSH BUTTON.-C/A-COMPLETE:REMOVED AND REPLACED FLIGHT ATTENDANT PANEL IAW AMM 25-27-09. OPS CHECK GOOD, EMERGENCY LIGHTS ILLUMINATE.SDR SIMA2019080705003Light · cracked#1 FLOOR EMERGENCY LIGHT PROXIMITY STRIP IS CRACKED-C/A-COMPLETE:REPLACED #1 EMERGENCY FLOOR STRIP AND INSERTED EMERGENCY LIGHT ONTO STRIP READY TO INSTALL SEE BOW324814 FOR INSTALLATION AND OPERATIONAL TEST OF FLOOR STRIPS.SDR DALA2019070804132Sign · missingSHIP 698 DOOR 2L EXIT SIGN MISSING. CORRECTIVE ACTION: REPLACED MISSING EXIT SIGN PER MM 33-21. (5946946)SDR DALA2019070804127Housing · crackedSHIP 5805 EMERGENCY LIGHT HOUSING BROKEN @ ROW 17DEF. CORRECTIVE ACTION: INSTALLED NEW HOUSING. CKS GOOD. (5513537)
Back to JASC 3350