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 DALA2019072304408Sign · detachedSHIP 5815 EMERG EXIT SIGN OVERHEAD MID CABIN DETACHED. CORRECTIVE ACTION: REATTACHED LENS IAW AMM 33-51. OPS NRML. (6266422)SDR DALA2019072304400Fuse · blownSHIP 5656 LT FWD AND AFT OVERWING EMERGENCY EXIT LIGHTS INOP. CORRECTIVE ACTION: REPLACED FUSE ON EMERGENCY LIGHT POWER SUPPLY. (6015067)SDR AALA201907229011Light · malfunctionedAIRCRAFT NOT GROUNDED: CABIN EMERGENCY LIGHTS REMAIN ON. RETURNED TO GATE. OVERHEAD EXIT LIGHTS REMAINED ON, NOT THE FLOOR PATH LIGHTS. MAINTENANCE RESET CIDS SYSTEM. OPS CHECK GOOD IAW AMM 23-73-00.SDR AALA201907239011Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU 12WL FAILED BITE TEST. REMOVED AND REPLACED EPSU (12WL) IAW AMM 33-51-38. OPS CHECK NORMAL.SDR SWAA2019072435262Fuse · blownR2 DOOR HEADER EMERGENCY EXIT LIGHT INOP AT M1673. R&R FUSES IAW SWPM AND WDM.SDR SWAA2019072335226Lens · damagedLT OVERWING EMERGENCY EXIT LIGHT DAMAGED. R&R LENS IAW AMM.SDR SWAA2019072235195Light · inoperativeRT WING OVERWING EMERGENCY EXIT SLIDE LIGHT INOP. R&R LAMP PER AMM.SDR AALA201907229014Light · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATH LIGHTING DAMAGED AT R1 DOOR. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-00.SDR AALA201907229013Light · missingAIRCRAFT WAS NOT GROUNDED: COVER FOR EMERGENCY PATH LIGHTING MISSING AT 1L CLOSET. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-00.SDR AALA201907229010Receptacle · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT RECEPTACLE DAMAGED AT SEAT 32C. MAINTENANCE REPLACED LIGHT RECEPTACLE PER AMM 33-51-19.SDR AALA201907229006Switch · faultyAIRCRAFT WAS NOT GROUNDED: ON PREFLIGHT FOUND EXTERIOR EMERGENCY LIGHT ILLUMINATED BOTH SWITCHES WERE OFF. MAINTENANCE RESET LIGHT SWITCH PER 33-50-00.SDR HNAA2019072200197Light · inoperativeRT WING ROOT AFT EMERGENCY LIGHT INOP. FIX: R&RD BULB IAW AMM 33-50-10.SDR REXA2019072101121Light · inoperativeEMERGENCY CEILING FLOOD LIGHT INOP ON ROW 4. R&R LIGHT BULB IAW AMM 33-51-09. OPS CHECK GOOD AT THIS TIME. P/N ON/OFF: 1317 S/N ON/OFF: NSNSDR 29GA2019072200001Light · inoperativeFLIGHT# 0112 EYW/FLL REPORT: EMERGENCY LIGHT LAMP WILL NOT ILLUMINATE. CORRECTIVE ACTION: REPLACED EMERGENCY LIGHT PUSH BUTTON INDICATION BULBS FOR " ARM" AND "ON" WITH NEW IAW AMM 33-50-00-01. OPERATIONAL CHECKS GOOD. A/C OK FOR SERVICE.SDR MASA2019072111959Light · inoperativeROW 13A LOWER EMER LIGHT INOP. RELAMPED.SDR ASAA2019072030183Battery Pack · dischargedEMERGENCY LIGHTS INOP THROUGHOUT CABIN. GROUNDED - YES. REMOVED AND REPLACED LT FWD EMERGENCY POWER SUPPLY ASSY BATTERY PACK M1675 IAW AMM 33-51-06 OP CHECK GOOD ALL EMERGENCY LIGHTS OPERATIONAL.SDR SIMA20190720001Light · inoperativeSUPPLEMENTAL DURING PS-1 FOUND EMERGENCY LIGHT FLOOR STRIP AT SEAT 9A PARTIALLY OUT. C/A-DEFERRED EMERGENCY LIGHT STRIP AT SEAT 9A PER MEL 33-30. REMOVED AND REPLACED EMERGENCY LIGHT STRIP IAW AMM 33- 50-12 OPS CHECK GOOD MEL ITEM RESTORED.SDR DALA2019072304407Lens · damagedSHIP 684 EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:G4B. CORRECTIVE ACTION: REINSTALLED DIFFUSER LENS COVER IAW AMM 33-51. (1181775)SDR YENA201907200414Epsu · failedFLT 430, SMF-BOS. AFT EXIT LIGHT INOP; R & R AFT EPSU IAW AMM 33-51-00 OPS CHECK AND TEST GOOD. A/C OK FOR CONT. SERVICED.SDR SWAA2019072335251Light · inoperativeRT EMERGENCY AISLE LIGHT INOP AT ROW 22. R&R LAMP IAW AMM.SDR SWAA2019072335225Lens · missingAFT LT EMERGENCY EXIT LIGHT L1190 LENS COVER MISSING. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2019072235158Battery Pack · dischargedFORWARD LT UPPER ENTRY EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER AMM.SDR SWAA2019072235150Cover · missingRT OVERWING EMERGENCY EXIT SIGN COVER MISSING AT SIDEWALL. R&R COVER IAW AMM.SDR SIMA20190720002Battery · dischargedDURING THE PS-2 CHECK FOUND EMERGENCY LIGHTS RELATED TO EMERGENCY BATTERY #2 INOP. C/A-REMOVED AND REPLACED EMERGENCY BATTERY #2 IAW AMM 33-50-04. OPS CHECK GOOD.SDR SIMA20190720003Light · inoperativeRT FORWARD LOWER FAIRING EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED RT FORWARD LOWER FAIRING EMERGENCY LIGHT IAW AMM 33-50-10. OPS CHECK GOOD.SDR SIMA20190720004Light · inoperativeGALLEY EXIT LIGHT OVER SERVICE DOOR INOP. C/A-REMOVED AND REPLACED GALLEY EXIT LIGHT. IAW AMM 33-50-14. OPS CK IAW AMM 33-50-00. OPS CK GOOD.SDR N6WA2019072002Cover · missingGALLEY EMERGENCY EXIT LIGHT COVER MISSING. VERIFIED MISSING COVER IS FLOOD LIGHT COVER, DEFERRED GALLEY FLOOD LIGHT COVER ON OPEN CONTROL NUMBER 1906273 PER NEF 25-100-12 CAT 1 AUTHORIZED BY MXC.SDR N6WA2019072001Light · inoperativeEMERG LIGHT (AFT) BULB IN CEILING INOP. AS TELCOM WIUTH MXC. DEFERED AFT CEILING EMERGENCY FLOOD LIGHT ON OCN 70058845 PER MEL 33-51-01B-2A. CAT CSDR ASOA201907195087Light · inoperativeDURING MX THE EMERGENCY LIGHT FLOOR PROXIMITY STRIP ROW 22A TO 24A WAS DISCOVERED INOP. MX PLACED ON MEL. ON 7/24/19 MX REMOVED AND REPLACED THE LIGHT STRIP WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2019072235157Battery Pack · failedFORWARD EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R&R FORWARD BATTERY PACK M1675 PER MM.SDR DALA2019072204347Light · detachedEMERGENCY SEAT MOUNTED LIGHTING AT 27F ARE INOPERATIVE. REATTACHED SEAT EMERGENCY PATH LIGHT ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR SIMA20190719001Light · inoperativeLT FUSELAGE EMERGENCY LIGHT INOP JUST AFT OF MAIN DOOR. C/A-REMOVED AND REPLACED LT FUSELAGE EMERGENCY LIGHT IAW AMM 33-51-15. OPT CHECK GOOD.SDR IPXA2019071944615Battery · dischargedINSPECTION TYPE:N/A ON PDC, EMERGENCY LIGHTS TEST, FAIL. EMER. LT BAT 1 LO MSG. R&R EMER. LIGHT BATT PER AMM 33-51-01 P401 TEST PASS. (P/N ON/OFF: 60-4411-5, S/N ON/OFF: 0818/0352) IPC 33-51-10-01 ITEM 008.SDR QXEA2019071900267Module · looseCABIN EMERG. LIGHTS REMAIN ILLUMINATED WITH FLIGHT DECK EMER. LIGHTS SWITCH IN THE ARM POSITION. REMOVED FROM SERVICE. FOND THE EMER LIGHT SW BODY MODULE ON THE WING BULKHEAD ASSY LOOSE. TIGHTENED BODY MODULE IAW AMM TASK 33-541-05-400-801. C/W OPS CK OF EMER SDR VNAA2019071811102Light · inoperativeL/H FWD EMERGENCY LIGHT INOP REMOVED AND REPLACED LH FWD EMERGENCY LIGHT OPS CHECK GOOD.SDR VNAA2019071811101Battery · dischargedEMERGENCY LIGHTS WON'T STAY ON. R&R ALL 4 EMERGENCY POWER SUPPLY BATTERIES IAW CRJ 200 AMM 33-51-04-000/400-801. OPS CHECK GOOD AT THIS TIME. S/N 169577, 121949, 103966, 126070SDR SWAA2019072535305Light · inoperativeLT EMERGENCY AISLE LIGHTS INOP AT SEAT ROWS 13. R&R LIGHT IAW AMM.SDR SWAA2019072535283Power Supply · inoperativeEXTERNAL EMERGENCY LIGHTS INOP AT RT FORWARD AND AFT ENTRY DOORS. R&R POWER SUPPLY IAW AMM.SDR SWAA2019072535282Light · inoperativeLT EMERGENCY AISLE LIGHTS INOP AT SEAT ROWS 1. RELAMPED LIGHT IAW AMM.SDR DALA2019072204394Light · missingROW 27 MISSING FLOOR PROXIMITY EMERGENCY ESCAPE PATH LIGHT ASSY, REPLACED EPL ASSEMBLY.SDR CALA2019072401226Charger · malfunctionedREPLACE THE EMERGENCY LIGHT POWER SUPPLY CHARGER ON M33409 REF NON-ROUTINE NR 9483398, SPEC NR B777- 33-3-7019. REPLACED POWER SUPPLY CHARGER ON M33409 & POWER SUPPLY BATTERY PACK CAPACITY CHK FOUND ''NORMAL'' AS PER AMM 33-51-06-960-803 & AMM 33-51-06-200-801SDR CALA2019072401225Battery Pack · malfunctionedREPLACE THE EMERGENCY LIGHT POWER SUPPLY BATTERY PACK ON M33409 REF NON-ROUTINE NR 9483397 -, SPEC NR B777-33-3-7019. REPLACED THE BATTERY PACK ON POWER SUPPLY M33409 & POWER SUPPLY BATTERY PACK CAPACITY CHK FOUND ''NORMAL'' AS PER AMM 33-51-06-960 -802 REV.86SDR AALA201907199001Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: BURNED EMERGENCY LIGHT ON SEAT 9D IN PASSENGER CABIN. MAINTENANCE REPLACED LIGHT PER AMM 33-51-19-400-001-A.STEP 4.A THROUGH 4.B(3) AND 4.C THROUGH 5 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019072335220Light · inoperativeLT OVERWING EXTERNAL EMERGENCY LIGHT INOP AT EXIT DOOR. RELAMPED LIGHT PER AMM.SDR SWAA2019072335218Light · looseLT EMERGENCY ELECTRIC LIGHT STRIP LOOSE BETWEEN ROW 7 TO ROW 8. CLEANED AND REATTACHED PHOTO STRIP AMM.SDR YENA201907180412Light · inoperativeDURING HEAVY MAINTENANCE, L1 DOOR LOWER EMERGENCY LIGHT EXIT INOP; REMOVED AND REPLACED EMERGENCY LIGHT IDENTIFIER OF L1 DOOR IAW AMM 33-51-10-400-01 OPS CHK GOOD.SDR RAIA201907190002Light · inoperativeRT FWD WING EMERGENCY FLOOD LIGHT (LIGHT # 4) IS INOP. R&R RT FWD WING EMERGENCY FLOOD LIGHT BULB. OPS CHECK GOOD.SDR SWAA2019071935133Housing · brokenEMERGENCY EXIT ROW OVERHEAD BULKHEAD EXIT SIGN BROKEN. R&R HOUSING ASSEMBLY IAW AMM.SDR SWAA2019071935132Light · inoperativeR1 DOOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019071935131Light · inoperativeAFT GALLEY EMERGENCY FLOOR PATH LIGHTS INOP. R&R LIGHTS IAW AMM.
Back to JASC 3350