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 SWAA2019040931474Lamp · inoperativeL1 EMERGENCY SLIDE LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR AALA2019040879010Light · inoperativeAIRCRAFT WAS NOT GROUNDED: ROW 8C EMERGENCY SEAT MOUNTED LIGHT INOPERATIVE. MAINTENANCE REPLACED LIGHT SEAT MOUNTED ASSEMBLY PER AMM 33-51-18 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019040831509Light · dimRIGHT MID CABIN EMERGENCY EXIT SIDEWALL LIGHT DIM. R&R LIGHT IAW AMM.SDR SWAA2019040831435Light · buckledEMERGENCY LIGHT STRIP BUCKLED AT ROW 9. / SECURED STRIP PER SIP.SDR DALA2019040802315Lens · detachedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:607. RE-ATTACHED LENS ON EMER EXIT SIGN. (1019273)SDR IPXA2019040864843Bulb · inoperativeEXTERIOR EMERGENCY LIGHT INOP. REPLACED THE BULB IAW AMM 33-51-16-962-001 OPS CKS OKSDR ASOA2019040864012Battery Pack · dischargedIAH - FLIGHT 4306, THE CREW REPORTED EMERGENCY LIGHTS NOT WORKING. MAINTENANCE REMOVED AND REPLACED THE #3 EMERGENCY LIGHT BATTERY PACK, OPERATIONALLY TESTED WITH NO DEFECTS NOT AND THE AIRCRAFT WAS APPROVED FOR RETURN SERVICE.SDR DALA2019040762278Power Supply · inoperativeEMERGENCY ESCAPE PATH LIGHTING INOP SEATS 13 TO 17, REPLACED EPSU W/ BATTERYSDR REXA2019041250460Light · missingEMER LIGHT STRIP MISSING 9 A/B. REPLACED EMER LIGHT IAW AMM 33-51-01.SDR HALA2019040900184Light · inoperativeR1 DOOR EMERGENCY WALL LIGHT (90WL2) INOP. // REPLACED EMERGENCY LIGHT AS REQUIRED. OPS CHECKS GOOD. OK FOR SVCSDR SWAA2019040931510Lens · detachedCENTER CABIN EMERGENCY EXIT LIGHT LENS COVER CAME OFF. / REINSTALLED COVER IAW AMM.SDR SWAA2019040931475Sign · detachedOVERWING EXIT SIGN KNOCKED FROM CEILING. / R&R SIGN PER MM.SDR SWAA2019040931444Lens · brokenEXT LIGHT LENS NEAR L1 DOOR BROKEN. / R&R EXIT LIGHT LENS PER AMM.SDR SWAA2019040931441Lamp · inoperativeR/H SIDEWALL LIGHT AT EMERGENCY EXIT INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019040931440Switch · missingEMERGENCY EXIT LIGHT "NOT ARMED" SWITCH LIGHT MISSING. / R&R SWITCH PER SWPM.SDR I5EA2019040901Lamp · burned outROW 12 L/H SIDE EMERGANCY LIGHT INOP. REMOVED LAMP ROW 12 L/H SIDE AEREA LIGHT PER AMM 33-51-03. OPS TEST WAS GOOD.SDR REXA201904085418Light · inoperativeINTERIOR EMERGENCY EXIT LIGHT AT 8 A NOT ILLUMINATING. REPLACED EMERGENCY LIGHT AT SEAT 8 A OPS CHECK GOOD IAW AMM 33-51-10, OPS CHECKED GOODSDR SWAA2019040831462Lamp · inoperativeEMERGENCY AISLE LIGHT INOP AT ROW 23. RELAMPED LIGHT IAW AMM.SDR SWAA2019040831461Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PER MM.SDR SWAA2019040831438Sign · brokenR2 DOOR EMERGENCY EXIT SIGN BROKEN. R&R SIGN PER MM.SDR DALA2019040852308Power Supply · inoperativeEMERGENCY LIGHTS ROW 27 THRU 32 D E F INOP. R/R EMERG LIGHT POWER SUPPLY PER AMM 33-51. OPS CHECK GOOD.SDR YENA2019040850181Battery Pack · no testFT # 391, EMERGENCY LIGHT TEST FAILS BATTERIES 11WL AND 12WL; R & R 11WL AND 12WL BATTERIES IAW AMM 33-51-38. OPS CHECK OK.SDR YENA2019040850180Battery Pack · no testFT # 391, EMERGENCY LIGHT TEST FAILS BATTERIES 11WL AND 12WL; R & R 11WL AND 12WL BATTERIES IAW AMM 33-51-38. OPS CHECK OK.SDR DALA2019040502209Battery Pack · inoperativeBOTH AFT OVERWING EMERGENCY EXIT LIGHT VERTICAL STRIPS ARE INOPERATIVE. MAINTENANCE REPLACED THE OVERWING EMERGENCY EVACUATION BATTERY PACK IAW B717 AMM 33-51. EMERGENCY LIGHTS OP NORMAL. (LP #5836814)SDR VNAA2019040411102Sign · inoperativeL/H EMERGENCY EXIT FLOOR LEVEL EMERGENCY LIGHT WILL NOT ILLUMINATE. REMOVED AND REPLACED LIGHTED FLOOR-LEVEL EXIT SIGN OPS CHECK GOOD AT THIS TIMESDR R61A201904280438Power Supply · inoperativeEMERGENCY LIGHTING SYSTEM POWER SUPPLY DEFECTIVE AT AFT PAX DOOR REMOVED AND REPLACED POWER SUPPLY PER AMM 33-50-15SDR SWAA2019040931460Battery Pack · dischargedL/H AFT BATTERY PACK (M01673) FOUND TO HAVE HAD LOW OUT PUT. / R&R BATTERY PACK PER AMM.SDR SWAA2019040931459Lamp · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019040931458Lamp · inoperativeL2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR YENA2019040840178Power Supply · failedFT # 391, 3 ROWS OF LOW LEVEL LIGHTING INOP; REMOVED AND REPLACED AFT EPSU (13WL) IAE AMM 33-51-38. OPS CKD GOODSDR YENA2019040840177Battery Pack · no testFT # 391, EMERGENCY LIGHT TEST FAILED EPSU BATTERY 11WL; REMOVED AND REPLACED EPSU BATTERY AT FIN 11WL IAW AMM 33-51-38.SDR SWAA2019040531390Lamp · inoperativeR/H OVERWING EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2019040531386Lens · looseL/H EMERGENCY EXIT DOOR LOWER EXIT SIGN LOOSE. SECURED LIGHT LENS PER MM.SDR HALA2019040500179Light · inoperativeR1 DOOR EMERGENCY WALL LIGHT (90WL2) INOP. REPLACED EMERGENCY LIGHT AS REQUIRED. OPS CHECKS GOOD. OK FOR SVC.SDR MASA2019040541795Lamp · inoperativePAX DOOR EMERGENCY EXIT 4 LIGHTS INOPERATIVE. RELAMPEDSDR DALA2019040502210Power Supply · inoperativeEMERGENCY EXIT SIGN IS INOPERATIVE AT 20A. MAINTENANCE REPLACED THE POWER SUPPLY AND BATTERY PER AMM 33-51. OPERATIONAL CHECK WAS GOOD. LOCATION PASS SEATS: 20A (LP #1016254)SDR DALA2019040402156Battery Pack · inoperativeFOUND FLIGHT DECK AND CABIN EMERGENCY LIGHTS B523/P5 INOP. RELAMPED NO HELP. CHECKED AND FOUND ONE BATTERY WITH ZERO VOLTS. REPLACED BATTERY SET, CKS NML REF MD88 AMM 33-53. (LP5767472)SDR DALA2019040402154Battery Pack · inoperativeIT WAS FOUND ON SERVICE CHECK THAT THE FORWARD LEFT & RIGHT OVER WING EXIT DOOR EMERGENCY EXIT SIGN IS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK FOR THE FORWARD LEFT & RIGHT OVERWING EXIT DOOR EMERGENCY EXIT SIGN. OPERATION RETURNED TO NORMAL PER B717SDR VNAA2019100243101Light · inoperativeFWD LH EXTERIOR EMERGENCY LIGHT INOP. R AND R FWD LH EXTERIOR EMERGENCY LIGHT IAW CRJ 900 AMM 33-51-15-000/400-801-A05 OPS CHECK GOOD / "SDR SWAA2019052032862Light · inoperativeRT STOW BIN EMERGENCY LIGHT INOP AT ROW 7. R&R LIGHT PER AMM.SDR SWAA2019041231646Lamp · inoperativeL1 DOOR SLIDE LIGHT INOP. R&R LAMP PER AMM.SDR SWAA2019040931457Charger · inoperativeR2 DOOR SLIDE EMERGENCY LIGHT INOP. / R&R BATTERY CHARGER BASE PER AMM.SDR DALA2019040842314Sign · inoperativeEMERGENCY EXIT SIGNS INOPERATIVE / LOCATIONS: 26. CORRECTIVE ACTION: FOUND SIGN INSTALLED UPSIDE DOWN. INSTALLED SIGN CORRECTLY. (1015135)SDR AALA201904054001Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: RIGHT EMERGENCY GROUND ILLUMINATION LIGHT FAILED TEST. REPLACED BATTERY PACK PER STANDARD PRACTICES AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019040531418Power Supply · inoperativeR/H BULLNOSE EMERGENCY LIGHTS INOP BETWEEN AT SEAT ROW 8. / R&R POWER SUPPLY PER AMM.SDR SWAA2019040531417Battery · inoperativeL/H BULLNOSE EMERGENCY LIGHTS INOP BETWEEN SEAT ROW 6 TO ROW 10. / R&R BATTERY PER AMM.SDR SWAA2019040531416Battery · inoperativeR/H BULLNOSE EMERGENCY LIGHTS INOP BETWEEN AT SEAT ROW 8. / R&R BATTERY PER AMM.SDR SWAA2019040531412Power Supply · inoperativeL/H BULLNOSE EMERGENCY LIGHTS INOP BETWEEN SEAT ROW 6 TO ROW 10. / R&R LIGHT POWER SUPPLY PER AMM.SDR SWAA2019040531402Battery · no testR/H MIDDLE FORWARD OF R/H EMERGENCY EXIT DOOR, EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. / R&R BATTERY PER AMM.SDR SWAA2019040531401Battery · no testL/H AFT EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. / R&R BATTERY PER AMM.
Back to JASC 3350