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 SWAA2019050132204Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2019050132136Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R&R BATTERY PACK PER AMM.SDR SWAA2019050132123Lens · brokenRT AFT OVERWING EXTERIOR EMERGENCY LIGHT LENS BROKEN. R&R LENS PER AMM.SDR SWAA2019050132086Battery · dischargedRT CABIN EMERGENCY EXIT LIGHT INOP AT ROW 6. R&R BATTERY IAW AMM.SDR SWAA2019050132084Battery Pack · dischargedLT CABIN EMERGENCY EXIT LIGHT BATTERY PACK AT ROW 7 INOP. R&R BATTERY PACK PER AMM.SDR SWAA2019050132083Lens · looseLT CABIN EMERGENCY EXIT LIGHT LENS WOULD NOT LATCH AT ROW 6. SECURED LENS IAW AMM.SDR DALA201904302761Light · missingSEAT ROW 22 EMERGENCY LIGHT MISSING. CORRECTIVE ACTION: INSTALLED LIGHT ASSY OPS CHECK GOOD. (5442245)SDR ASAA201904296166Cover · missingPLASTIC EXIT LIGHT COVER NEAR R2 DOOR MISSING. GROUNDED - YES. INSTALLED NEW EXIT LENS COVER NEXT TO COMPARTMENT 4-17 AFT GALLEY.SDR ASAA201904296165Light · brokenEMERG LIGHT ASSY L1188 BROKEN. GROUNDED - YES. REMOVE AND REPLACED EMERG EXIT LIGHT ASSY L1188 PER B737-800 AMM 53-51-01. EMERG LIGHT OPS CKS NORMAL PER AMM 33-51-00-710-801 AND 33-51-00-720-801.SDR SWAA2019042932072Charger · inoperativeEMERGENCY EXIT LIGHT CHARGER AT M1674 HAD A BAD EMERGENCY BATTERY CHARGER. R&R POWER SUPPLY PER AMM.SDR SWAA2019042932061Sign · looseMID CABIN EMERGENCY EXIT SIGN LOOSE. R&R SIGN PER MM.SDR AALA201904299031Battery · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE FOUND THE EPSU 15WL BATTERY INOP. REPLACED THE EPSU 15WL BATTERY IAW AMM 33-51-38. OPS TEST GOOD.SDR AALA201904297002Battery · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE FOUND THE EPSU 13WL BATTERY INOP. REPLACED THE EPSU 13WL BATTERY IAW AMM 33-51-38. OPS TEST GOOD.SDR IPXA2019042964485Bulb · inoperativeEMERGENCY LIGHT HAS THREE INOP BULBS.RELAMPED THREE BULBS IN EMERGENCY LIGHT PER AMM 33 51 01 2SDR R61A201904270427Power Supply · inoperativeDURING HEAVY CHECK, CABIN CEILING EMERGENCY LIGHT NOT WORKING (3RD PANEL BACK FROM FRONT OF A/C). REMOVED AND REPLACED NO. 3 EMERGENCY LIGHTING POWER UNIT. REF AMM: 33-50-01. SEE EAMS W/O H6756 SN 535 FOR WORK DETAILSSDR SIMA20190426001Sign · inoperativeAFT PAX DOOR EMERGENCY LOWER EXIT SIGN INOP. (FOUND ON CLOSE UP)-C/A-REMOVED AND REPLACED THE AFT PAX DOOR EMERGENCY LOWER EXIT SIGN IAW ERJ 175 AMM 33-50-15, SYS CKS GOOD.SDR JJBA20190426015Light · inoperativeMAIN DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. R & R MAIN DOOR EXTERNAL EMERGENCY LIGHT. OPS CHECK SAT.SDR SWAA2019050632308Light · inoperativeEMERGENCY EXIT LIGHTING BATTERY PACK INOP (M1674). R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2019050232207Battery · dischargedABOVE FORWARD ENTRY WAY EMERGENCY LIGHT BATTERY M1675 DISCHARGED. R&R BATTERY M1675 PER AMM.SDR SWAA2019050232206Light · inoperativeRT EMERGENCY AISLE LIGHT INOP AT SEAT 13. RELAMPED LIGHT PER AMM.SDR SWAA2019050232190Light · burnedLT OVERWING GROUND PROXIMITY EXIT LIGHTS HAD 2 BURNED BULBS. R&R BULBS PER AMM.SDR SWAA2019050132167Battery Pack · dischargedEMERGENCY EXIT AISLE LIGHTS INOP BETWEEN BS. 500C TO BS. 560. R&R BATTERY PACK PER AMM.SDR YENA2019042950239Battery Pack · failedFT # 1391, BOS-TPA. EMERGENCY LIGHT TEST FAILED FIN 10WL BATTERY; REMOVED & REPLACED EMERGENCY LIGHT BATTERY FIN 10WL PER AMM 33-51-38SDR YENA2019042950238Battery Pack · failedFT # 1692, LIR-JFK. SEAT MOUNTED EMR LIGHT AT SEAT 3C AND 7C FOUND INOP; R & R OF SEAT MOUNTED EMER LIGHT AT SEAT 3C AND 7C IAW AMM 33-51-18. NO HELP. R & R OF EPSU & EMER LIGHT BATTERY AT 11WL IAW AMM 33-51-38. ALL OPS NML OK FOR SVC.SDR YENA2019042950237Epsu · failedFT # 1692, LIR-JFK. SEAT MOUNTED EMR LIGHT AT SEAT 3C AND 7C FOUND INOP; R & R OF SEAT MOUNTED EMER LIGHT AT SEAT 3C AND 7C IAW AMM 33-51-18. NO HELP. R & R OF EPSU & EMER LIGHT BATTERY AT 11WL IAW AMM 33-51-38. ALL OPS NML OK FOR SVC.SDR DALA2019042962729Battery Pack · inoperativeEMERGENCY LIGHTS INOP ON ROWS 27 THRU 32. R & R EMER BATTERY PACK AND CHARGER ASSY IAW B757 AMM 33-51.SDR DALA2019042962718Housing · damagedSEAT 40D EMERGENCY PATH LIGHT HOUSING ASSY DAMAGED. LIGHT OPS OK. CORRECTIVE ACTION: INSTALLED NEW HOUSING ASSY AS REQUIRED. LIGHT OPS CK NORMAL.SDR SWAA2019042932071Battery Pack · inoperativeMULTIPLE EMERGENCY LIGHTS ATTACHED TO M1674 EMERGENCY EXIT BATTERY PACK DO NOT ILLUMINATE. / R&R POWER SUPPLY-BATTERY PACK PER AMM.SDR DALA2019042962700Lens · missingR1 DOOR FWD FLOOR LEVEL EXIT IDENTIFIER LENS MISSING, INSTALLED LENSSDR DALA2019042952699Light · not reportedEMERGENCY LIGHT AT SEAT 35C, INSTALLED NEW EMERGENCY LIGHT ASSY AT SEAT 35CSDR DALA2019042702676Lens · unsecureEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS: 2C / ACARS TEXT: FRC3352021C *2C *3C. RE-SECURED SEAT MOUNTED EMERGENCY LIGHT LENS'.SDR DALA2019042702675Lens · unsecureEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS: 1C / ACARS TEXT: FRC3352021C *2C *3C. SEE LP 1046743 FOR CORRECTIVE ACTION. RE-SECURED SEAT MOUNTED EMERGENCY LIGHT LENS'. OK FOR SVC.SDR DALA2019042702674Light · unsecureEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS: 3C / ACARS TEXT: FRC3352021C *2C *3C. REF LP 1046743 FOR CORRECTIVE ACTION. RE-SECURED SEAT MOUNTED EMERGENCY LIGHT LENS'. OK FOR SVC.SDR REXA2019042650520Bulb · inoperativeDURING WALK AROUND FOUND RH EXTERIOR EMERGENCY LIGHT INOP. R+R EMERGENCY LIGHT BULB IAW AMM 33-51-21 OPS CHECK GOOD. P/N ON/OFF 1317, S/N NSN.SDR AALA201904269020Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WERE INOPERATIVE AT B5-28. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY PACK ASSEMBLY PER AMM 33-53-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904269017Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WERE INOPERATIVE AT B5-27. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY PACK ASSEMBLY PER AMM 33-53-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904269015Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WERE INOPERATIVE AT B5-107. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY PACK ASSEMBLY PER AMM 33-53-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904269012Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WERE INOPERATIVE AT B5-106. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY PACK ASSEMBLY PER AMM 33-53-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904269009Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WERE INOPERATIVE AT AB5-4. MAINTENANCE REPLACED BATTERY PER AMM 33-60-98 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904269008Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WERE INOPERATIVE AT AB5-3. MAINTENANCE REPLACED BATTERY PER AMM 33-60-98 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904269007Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WERE INOPERATIVE AT AB5-2. MAINTENANCE REPLACED BATTERY PER AMM 33-60-98 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904269006Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WERE INOPERATIVE AT AB5-1. MAINTENANCE REPLACED BATTERY PER AMM 33-60-98 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904269005Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WERE INOPERATIVE AT B5-105. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY PACK ASSEMBLY PER AMM 33-53-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904269004Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WERE INOPERATIVE AT B5-103. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY PACK ASSEMBLY PER AMM 33-53-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904269003Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WERE INOPERATIVE AT B5-102. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY PACK ASSEMBLY PER AMM 33-53-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904269002Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS WERE INOPERATIVE AT B5-125. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY PACK ASSEMBLY PER AMM 33-53-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904269026Battery · inoperativeAIRCRAFT IN BASE VIST: MAINTENANCE FOUND R1 ESPU BATTERY FAULT. REMOVED AND REPLACED BATTERY FOR ESPU AT R1. OPS TEST GOOD.SDR R61A2019042650424Power Supply · inoperativeFWD CEILING EMERGENCY LIGHTS FLICKERING ON AND OFF. R&R ELPU 2 WITH REF TO AMM 33-50-03. OPERATIONAL CHECK GOOD.SDR N6WA20190426501Bulb · inoperativeLAST EMERGENCY OVERHEAD LIGHT INOP R&R ROW 18 EMERGENCY CEILING FLOODLIGHT BULB IAW CRJ 700 AMM 33-51-09. OPS CHECK GOOD. OK FOR SVCSDR SIMA201904265002Sign · inoperativeEMERGENCY EXIT SIGN ON CEILING PANEL AT EMERGENCY ROW IS NOT ILLUMINATED ON AFT SIDE-C/A-REMOVED AND REPLACED CEILING PANEL EXIT LOCATING AFT SIGN AT EMERGENCY ROW IAW EMB 145 AMM 33-50-15.
Back to JASC 3350