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 MASA2019032511779Battery Pack · dischargedFWD 5 CEILING EMERG LIGHTS INOP. REPLACED NR 3 BATTERY PACK.SDR DALA2019032601912Light · inoperativeEMERGENCY LIGHT AT 22ED INOP. REPLACED LIGHT AND HARNESS ASSY OPS NML REF AMM 33-53. (LP5058053)SDR DALA2019040502289Light · inoperativeEMERGENCY LIGHT ROW 31 INOP, REPLACED EMERGENCY LIGHT ASSYSDR SWAA2019040231256Housing · brokenAFT ENTRY LOWERED CEILING EMERGENCY EXIT LIGHT HOUSING BROKEN. R&R LIGHT HOUSING IAW AMM.SDR DALA2019040272096Lamp · inoperative(AIRCRAFT 7007, L/P 5723650) EXTERIOR EMERGENCY LIGHTS L1 AND R4 DOOR INOP. REMOVED AND REPLACED R4 LAMP- OPS CK OK. REMOVED AND REPLACED L1 LAMP. FOUND FUSES BAD. REPLACED FUSES PER B777 AMM 33-51-06. OPS CHECK GOOD.SDR YENA201903250159Lens · missingFLT 1136, LGB-SFO. ON-FLIGHT CREW REPORTS EMER LIGHT LENS COVER MISSING AT 13C AISLE; REPLACED MISSING EMERG. LIGHT COVER AS REQUIRED. OPS CKS GOOD.SDR DALA2019032602029Light · damagedSHIP 5646 EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:18D / SEAT MOUNTED EMERG LT PUSHED INTO HOUSING. CORRECTIVE ACTION: REINSTALLED EMERGENCY LIGHT, OP'S NORMAL. (1001546)SDR DALA2019032602026Battery Pack · dischargedSHIP 5803 EMERGENCY EXIT SIGNS INOP AT DOORS 2L & R. CORRECTIVE ACTION: R&R BATTERY PACK. (5780547)SDR YENA201903250158Battery · failedFLT 1562, BGI-JFK. EPSU 12WL FAULTED; R & R EPSU AND BATTERY AT 10WL AS PER AMM 33-51-38.SDR YENA201903250157Epsu · failedFLT 1562, BGI-JFK. EPSU 12WL FAULTED; R & R EPSU AND BATTERY AT 10WL AS PER AMM 33-51-38.SDR YENA201903250156Battery · failedFLT 1562, BGI-JFK. EPSU 12WL FAULTED; R & R EPSU &BATTERY AT 10WL AS PER AMM 33-51-38.SDR YENA201903250155Epsu · failedFLT 1562, BGI-JFK. EPSU 12WL FAULTED; R & R EPSU 12WL AND BATTERY AS PER AMM 33-51-38.SDR AALA201903276003Battery Pack · weakL4 DOOR EXIT SIGN WAS DIM. MAINTENANCE REPLACED THE BATTERY PACK M10801 IAW AMM 33-51-07, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201903276002Battery Pack · weakTHE R4 DOOR EXIT SIGN WAS DIM. MAINTENANCE REPLACED BATTERY PACK M10801 IAW AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201903276001Battery Pack · weakSEAT MOUNTED EMERGENCY LIGHTS WERE DIM FROM 27D TO 36D. MAINTENANCE REPLACED THE BATTERY PACK M10801 IAW AMM 33-51-07, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR MASA2019032511778Light · inoperativeEMER FLOOD LIGHT IN FRONT OF LAV INOP. RELAMPED.SDR SIMA20190325003Battery · dischargedRT AND LT OVERWING EMERGENCY LIGHTS DO NOT ILLUMINATE. C/A-REMOVED AND REPLACED NR 4 EMERGENCY BATTERY AND POWER SUPPLY IAW AMM 33-50-04. OPS TEST GOOD. NO OTHER DEFECTS NOTED AT THIS TIME. BATTERY CHARGER ASSY P/N 11-0049 S/N 10546.SDR SWAA2019032631075Sign · unsecureRT 'EXIT SIGN FELL OFF' NEAR SEAT 12. SECURED SIGN PER AMM.SDR SWAA2019032631074Light · inoperativeRT WING BEHIND EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019032631067Light · inoperativeLT OVERWING EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019032631058Light · inoperativeRT OVERWING EXIT LIGHT INOP. SECURED LIGHT PER SRM.SDR SWAA2019032631057Sign · missingRT EMERGENCY EXIT "EXIT/SALIDA" ILLUMINATING PLACARD MISSING AT ROW 14. REATTACHED SIGN IAW EA.SDR CALA2019032500474Battery Pack · dischargedREF NON-ROITINE REF NON-ROUTINE NO.:9475253 - SPEC NO.B777-33-3-7019 - EMERGENCY LT BATT PACK CAPACTITY CHK FOUND D4 LT BATT PACK DM33407 BATT PACK OUT OF LIMIT P/N:ADD717-0 1-100. EMERGENCY LT BATT PACK REPLACED AND EMERGENCY LT TEST CARRIED OUT THE RESULT FOSDR DALA2019032501895Light · inoperativeCOCKPIT EMERGENCY FLOODLIGHT INOP. RELAMPED PER AMM 33-51 NO HELP. R&R EMERGENCY BATTERY PACK B5-123 PER AMM 33-51 OPS CHECK NORMAL OK FOR SERVICE. (LP5528324)SDR REXA2019032540291Lamp · inoperativeAFT CENTER OVERHEAD EMERGENCY LIGHT INOP. RELAMPED CENTER OVERHEAD EMERGENCY FLOOD LIGHT IAW CRJ700 AMM 33-51-09. OPS CHECK GOOD.SDR DALA2019040202092Light · unsecureEMERGENCY SEAT MOUNTED LIGHTING INOPERATIVE. RE-SECURED LIGHT ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR DALA2019032602025Power Supply · inoperativeSHIP 671 DOOR 1R EMERGENCY EXIT IDENTIFIER LIGHT INOP. CORRECTIVE ACTION: REPLACED EMERGENCY LIGHT BATTERY POWER SUPPLY M730 PER AMM 33-51. OPS CK GOOD. (3009641)SDR YENA201903240154Lens · crackedOUTER LENS OF EXTERIOR EMER. LIGHT BEHIND LEFT WING ROOT IS CRACKED. ( EXTERNAL EMERGENCY LIGHT LENSES--DAY OPS ONLY ); CHECKED THE INTEGRITY OF THE LIGHT ASSEMBLY. LENS FOUND OK. REMOVED AND REPLACED OUTER EXTERNAL LENS IAW AMM 33-50-25. OP'S CHK OK. PERFORMESDR HNAA2019032800078Sign · malfunctionedNDIS 628 33-51 0016010 24MAR19 SBY CLOSE EMERGENCY EXIT SIGN ABOVE SERVICE DOOR DOES NOT ILLUMINATE DURING OPS CHECK.
FACT 24MAR19 10:35 SBY CYCLED EMERGENCY LIGHTS EMERGENCY EXIT SIGN ABOVE SERVICE DOOR NOW ILLUMINATES. OPS CHECK GOOD.SDR AALA201903279010Power Supply · inoperativeMAINTENANCE FOUND THE EMERGENCY LIGHT ON THE CEILING ISLE ABOVE SEAT 9C-10C INOPERATIVE. THE AIRCRAFT WAS GROUNDED. REMOVED AND REPLACED THE EPSU IAW AMM 33-51-38. OPS CHECKED NORMAL.SDR AALA201903279007Power Supply · inoperativeMAINTENANCE FOUND THE EMERGENCY CEILING LIGHT ABOVE SEAT 1C-2C INOPERATIVE. REMOVED AND REPLACED THE EPSU IAW AMM 33-51-38. OPS CHECKED NORMAL.SDR AALA201903275001Power Supply · no testEMERGENCY LIGHTS IN THE BUSINESS CLASS, SEAT ROWS 13-25 FAILED A 10 MINUTE FUNCTIONAL TEST. REMOVED AND REPLACED THE POWER SUPPLY M33404 IAW AMM 31-51-06.SDR ASAA2019032428775Circuit Breaker · trippedCIRCUIT BREAKER POPPED, "CABIN EMER LIGHTS", PANEL BEHIND F/O SEAT. GROUNDED - YES. RESET CABIN EMERGENCY LIGHT BREAKER P6-11, A9. REF AMM 20-60-01 AND WDM 33-51-11, EMERG LTS OPS NORMAL. REF AMM 33-51-00.SDR AALA201903269007Battery · dischargedEPSU 10WL TESTED AND HAD A LOW BATTERY. REMOVED AND REPLACED THE BATTERY IAW AMM 33-51-38. OPS CHECKED NORMAL.SDR AALA2019032659015Power Supply · inoperativeMAITENANCE FOUND THE FWD CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED THE EMERGENCY LIGHT POWER SUPPLY 10WL IAW AMM 33-51-38.SDR SWAA2019032631082Light · looseFORWARD EXIT SIGN LIGHT ASSEMBLY LOOSE AT LOWERED CEILING DROP DOWN PANEL BETWEEN G-1 AND FORWARD LAV. R&R LIGHT ASSEMBLY PER AMM.SDR SIMA20190324001Battery · dischargedBOTH AFT OVERWING EMERGENCY LIGHTS INOP. C/A-REPLACED THE NR 4 EMERGENCY BATTERY IAW AMM 33-50-04. BATTERY CHARGER ASSY P/N 11-0049 S/N 24703.SDR AALA201903259025Battery · no testEMERGENCY LIGHT AT ROW 17 CEILING WAS INOPERATIVE. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE NR 6 BATTERY PACK IAW AMM 33-50-01, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201903254002Power Supply · no testEMERGENCY EXIT LIGHTS AT THE R1 DOOR FAILED A 10 MINUTE TEST. REPLACED THE POWER SUPPLY M33094 IAW AMM 31-51-06.SDR QXEA2019032500139Light · inoperativeFORWARD FA EMER SWITCH LIGHT BURNED OUT. REMOVED FROM SERVICE. RELAMPED FWD FA EMERGENCY LIGHTS SWITCH. CHECKS GOOD. RETURNED TO SERVICE.SDR SWAA2019032530972Cover · missingROW 12 EMERGENCY EXIT ROW LIGHT COVER MISSING. R&R COVER PER AMM.SDR 29GA2019032500001Light · corrodedFLIGHT 0122 EYW/FLL REPORT: EMER LT CTL CIRCUIT BRAKERS L-8 POPPED OUT. RESET ONCE STILL POPPED OUT. CORRECTIVE ACTION: CLEANED & REMOVED CORROSION ON RT EXTERNAL EMERGENCY LIGHT ASSY IAW CMM 33-52-05 & PERFORMED OPS CHECK IAW AMM 33-50-00-05.SDR MASA2019032411773Battery · dischargedALL L/R LOWER WING EMER LIGHTS ARE INOP. CHARGED BATTERIES.SDR MASA2019032411775Light · inoperativeCABIN ENTRY EXIT SIGN OUT. RELAMPED.SDR MASA2019032411774Light · inoperativeCABIN EGRESS LIGHT OUT AT ROW 13AC. RELAMPED.SDR VNAA201910021101Battery Pack · inoperativeEMERGENCY LTS INOP. R&R EPSU BATTERY PACKS 1-4 IAW CRJ 900 33-51-17-000/400-801. OPS CHECK GOOD. NO SERIAL NUMBERS PROVIDEDSDR SIMA20190323003Light · damagedFOUND FLOOR EMERGENCY LIGHT STRIPS SIDEWALL ASSEMBLIES CRACKED, CHIPPED AND BROKEN BROKEN. C/A-COMPLETE:RAR FLOOR EMERGENCY LIGHT STRIPS IAW AMM 33-50-12.SDR SIMA20190323004Light · defectiveLT FLOOR PROXIMITY EMERGENCY LIGHT (IN THE FLOOR) AT FRM54. CONNECTOR WILL NOT CONNECT WITH THE PROX LIGHT CONNECTOR. C/A-COMPLETE: REPLACED LT FLOOR PROX EMERGENCY LIGHT @ FR54 IAW SWPM 20-21-00.SDR YENA201903230152Power Unit · failedFLT 1736, MSP-BOS. FWD RT EMERGENCY LIGHT POWER UNIT FAILED FUNCTIONAL CHECK; R & R FWD RT EMERGENCY LIGHT POWER UNIT REF AMM CH 33-50-01 OPS CHECK OK.SDR YENA201903230151Power Unit · failedFLT 1736, MSP-BOS. MID LT EMERGENCY POWER UNIT FOR LIGHT FAILED FUNCTIONAL CHECK; R & R MID LT EMERGENCY LIGHT POWER UNIT. REF AMM CH 33-50-01.
Back to JASC 3350