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 CALA2018100102025Light · inoperativeR1 DOOR EXTERNAL FUSELAGE EMERGENCY LIGHT INOP. REF. N/R:99823833 RELAMPED R1 DOOR EXTERNAL FUSELAGE EMERGENCY LIGHT AS PER REF AMM 33-51-06. PERFORMED OPERATIONAL CHECK AND FOUND NORMAL. REF. N/R:99823833SDR HALA2018101000276Sign · detachedDOOR 3R EXIT SIGN FELL OFF. RE-ATTACHED EXIT SIGN. LP 4970613SDR DALA2018100505904Light · missing(AIRCRAFT 5807, L/P 4561284) SEAT 35 DEF EMERGENCY LIGHT ASSY MISSING. INSTALLED NEW EMER LIGHT ASSY AT SEAT 35 D. OPS CK GOOD.SDR DALA2018100505903Battery · discharged(AIRCRAFT 676, L/P 4112793) RT OVER AND BETWEEN OVER WING EXIT SIGN INOP. REMOVED AND REPLACED BATTERY POWER PACK OP'S CHECK GOOD. IN REF TO AMM 33-51-07.SDR YENA201809300480Battery · dischargedFLT 269, BOS-FLL. DURING BLOCKING IN GATE F4 FFL GROUND POWER DID NOT CONNECT PROPERLY (TWICE). AIRCRAFT DID NOT HAVE APU RUNNING. EMERGENCY CABIN LIGHTING DID NOT ILLUMINATE DURING THESE NON-POWERED EVENTS. FOUND FWD, MID AFT EMERGENCY LIGHT BATTERIES DEAD. RSDR YENA201809300479Battery · dischargedFLT 269, BOS-FLL. DURING BLOCKING IN GATE F4 FFL GROUND POWER DID NOT CONNECT PROPERLY (TWICE). AIRCRAFT DID NOT HAVE APU RUNNING. EMERGENCY CABIN LIGHTING DID NOT ILLUMINATE DURING THESE NON-POWERED EVENTS. FOUND FWD, MID AFT EMERGENCY LIGHT BATTERIES DEAD. RSDR YENA201809300478Battery · dischargedFLT 269, BOS-FLL. DURING BLOCKING IN GATE F4 FFL GROUND POWER DID NOT CONNECT PROPERLY (TWICE). AIRCRAFT DID NOT HAVE APU RUNNING. EMERGENCY CABIN LIGHTING DID NOT ILLUMINATE DURING THESE NON-POWERED EVENTS. FOUND FWD, MID AFT EMERGENCY LIGHT BATTERIES DEAD. RSDR DALA2018100205846Battery Pack · dischargedTHE FORWARD EMERGENCY EXIT SIGN IS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK B5-235 REF AMM 33-51. OPERATIONAL CHECK WAS GOOD. (LP #3914354)SDR AALA2018100230005Control Unit · inoperativeL4 DOOR EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR HALA2018100200467Sign · detachedEXIT SIGN FELL OFF AT 3R DOOR. EXIT SIGN REATTACHED NOW OK FOR FLIGHT.SDR AALA2018100230006Light · shortedL2 DOOR EMERGENCY EXTERIOR SLIDE LIGHT WAS INOPERATIVE. FOUND THE LIGHT ASSEMBLY SHORTED OUT INTERNALLY AND THE FUSE BLOWN IN THE BATTERY MOUNT. REPLACED THE LIGHT ASSEMBLY AND FUSE, OPS CHECKED GOOD.SDR DALA2018100105810Battery · dischargedAFT CAT WALK TAIL CEILING LIGHTS INOP. REMOVED AND REPLACED BATTERIES IN AFT RIGHT LAV OPS CHECK IAW AMM 33-50 P/N OFF/ON AD4002P. (LP5352836)SDR SWAA2018100125671Sign · missingRT EMERGENCY EXIT LIGHT COVER MISSING AT ROW 14. INSTALLED SIGN IAW AMM.SDR SWAA2018100125651Battery Pack · inoperativeBATTERY PACK INOP AT LOCATION M1672. R&R BATTERY PACK PER AMM.SDR SWAA2018100125627Light · inoperativeRT EMERGENCY LIGHT BULB INOP AT ROW 13. RELAMPED BULB IAW AMM.SDR ASAA2018093026315Light · detachedESCAPE PATH LIGHTING STRIPS AT ROW 13 DETACHED. GROUNDED - YES. RETAPED FLOOR PROXIMITY LIGHT - PHOTOLUMINESCENT STRIP AT ROW 13 FED PER AMM 33-51-15.SDR ASAA2018093026314Light · inoperativeEMERGENCY LIGHT EXTERIOR SLIDE LIGHT AT R-1 DOOR INOP. GROUNDED - YES. RELAMPED AND TESTED PER AMM 33-51-04-960-801 - OPS NORMAL.SDR AALA201810019053Housing · brokenEMERGENCY LIGHT HOUSING AT SEAT 12C WAS BROKEN. MAINTENCE REPLACED THE LIGHT HOUSING IAW AMM 33-51-19, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR SIMA2018100130004Light · inoperativeFOUND MAIN-DOOR EMERGENCY LIGHT TO BE INOP DURING PS-1 CHECK-C/A-REMOVED AND REPLACED MAIN-DOOR EMERGENCY LIGHT LAMP IAW AMM TASK 33-50-06. OPS CHECK GOODSDR SIMA2018100130002Sign · inoperativeDURING PS-1 CHECK, FOUND INTERIOR RT OVERWING EMERGENCY EXIT LIGHTED SIGN INOP-C/A-REMOVED AND REPLACED INTERIOR RT OVERWING EMERGENCY EXIT LIGHTED SIGN IAW AMM 33-50-14. SEE NRWC 678-ORD-02684 FOR OPERATIONAL CHECKSDR SWAA2018101025850Light · inoperativeLT STOW BINS EMERGENCY LIGHT INOP BETWEEN ROW 3 TO ROW 4. R&R LIGHT IAW AMM.SDR IPXA2018100194528Sign · unknownEXIT LIGHT ABOVE THE CREW ENTRY DOOR WAS INOPERATIVE. PERFORMED AN OPS CHECK OF THE EMERGENCY EXIT LIGHTS, OPS CHECKED NORMAL IAW MM 33-51-13-0401.SDR YENA201809290442Epsu · failedFLT 2633, BDL-TPA. EMERGENCY LIGHT POWER SUPPLY UNIT FAULT. R&R EPSU IAW AMM 33-51-00. EMERGENCY LIGHT TEST OK.SDR YENA201809290441Battery · failedFLT 2633, BDL-TPA. EMERGENCY LIGHT TEST FAILED. R&R LT EMERGENCY LIGHT BATTERY IAW AMM 33-51-00. SYSTEM CK'S GOOD.SDR ASAA2018092926336Battery · dischargedMULTIPLE EMERGENCY LIGHTS INOP THROUGHOUT CABIN. GROUNDED - YES. REMOVED AND REPLACED BATTERY AT SEAT/ROW 7, 16, 23 LT SIDE. AND REPLACED 2 CHARGERS AT SEAT/ROW 7, 16 ABC. ALSO CORRECTED PROVISIONED WIRES AT STATION 642 EXIT LIGHT L1359 FOUND CONNECTED, CAP & SDR DALA2018100305877Light · unsecureEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:15D. RESECURED LIGHT CHECKS GOOD.SDR DALA2018100305855Battery Pack · dischargedDURING EMERGENCY LIGHT CHECK ON SERVICE CHECK GOT MESSAGE "EPSU (10WL) FWD L", REPLACED FWD EPSU BATTERY PACKSDR DALA2018100205827Battery Pack · discharged(AIRCRAFT 694, L/P 5356814) ON SVC CHK FOUND EMERGENCY LIGHTS DIM ABOVE DOOR 2L. REMOVED AND REPLACED BATTERY PACK PER AMM 33-51.SDR AALA20180929007Battery Pack · no testEMERGENCY LIGHTS WERE OUT AT THE A ZONE SEATS. MAINTENANCE REPLACED THE BATTERY PACK, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018200299006Battery Pack · no testEMERGENCY LIGHTS INOPERATIVE BETWEEN SEATS 13D TO 21D. MAINTENANCE REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018100299005Battery Pack · no testEMERGENCY LIGHTS INOPERATIVE BETWEEN SEATS 13D TO 21D. MAINTENANCE REPLACED THE BATTERY PACK AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA2018100299004Battery Pack · no testDURING THE PERFORMANCE OF TC 2735, THE BATTERY PACK M33404 FOR THE R3 DOOR WAS INOPERATIVE. MAINTENANCE THE REPLACED BATTERY PACK ASSEMBLY IAW AMM 33-51-06, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018100125675Lens · looseCENTER OVERWING EXIT SIGN LENS LOOSE. ADJUSTED IAW AMM.SDR SWAA2018100125653Cover · unsecureRT OVERWING EMERGENCY EXIT LIGHT COVER CAME OFF. SECURED COVER IAW SIP.SDR SWAA2018100125648Light · inoperativeRT LOWER EXTERIOR EMERGENCY LIGHT INOP. R&R LAMP IAW AMM.SDR SWAA2018100125628Light · inoperativeRT EMERGENCY LIGHT INOP AT ROW 18. R&R LIGHT IAW AMM.SDR AALA201810019051Lens · brokenEMERGENCY AISLE LIGHT AT 18C HAD A BROKEN LENS. MAINTENANCE REPLACED THE LIGHT AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-18.SDR SIMA2018100129001Light · inoperativeSERVICED DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT LAMP IAW AMM TASK 33-50-10-000-801-A AND 33-50-10-000-801-A. OPS CHECK GOOD.SDR CALA2018100102014Battery · discharged(A3NB-33-3-6016) L-83 NO DOT, 3 ESPU BATTERIES ARE DEAD AT LOCAT IONS FWD LEFT, AFT LEFT, AND EMERG RIGHT OVERWING. NONROUTINE 9017915 REMOVED AND REPLACED 3ESPU BATTERIES AND FOWARD LEFT, AFT LEFT AND EMERGENCY RIGHT OVERWING IAW AMM 33-51-38-000-002-A AND 33SDR REXA2018100200926Battery Pack · dischargedEMERGENCY EXIT SIGNS IN ROW 12 SEAT A AND D APPROX AT KNEE LEAVEL ARE INOP R/R PS37 EPSU BATTERY PACK IAW JOB CARD 33-900-701 OPC GOOD OK FOR SERVICE.SDR YENA201809280412Battery · failedFLT 1038, AUS-BOS. DURING EMERGENCY LIGHTS BATTERY CAPACITY TEST. EPSU UNIT LEFT FAILED. REMOVED AND REPLACED EPSU (11WL) LEFT BATTERY. OPS CHECK GOOD. REF AMM 33-51-38.SDR YENA201809280411Battery · failedFLT 2044, PBI-EWR. PSU EMERG LIGHT TEST FAIL. R&R FWD LT EMERG LIGHT BATTERY (10WL) IRW AMM 33-51-38. OPS CHECK SAT.SDR SWAA2018100125677Battery Pack · failedEMERGENCY LIGHTS BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PACK PER MM.SDR SWAA2018100125669Cover · missingMID CABIN CEILING EXIT SIGN MISSING COVER PLATE. INSTALLED COVER PER AMM.SDR SWAA2018100125668Battery Pack · failedEMERGENCY LIGHTS BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PACK PER MM.SDR SWAA2018100125647Light · inoperativeLT LOWER OVERWING EXIT INDICATOR LIGHT INOP. R&R LAMPS IAW AMM.SDR SWAA2018100125646Light · inoperativeLT AISLE LIGHT INOP AT SEAT ROW 20. R&R HOUSING LIGHT ASSEMBLY IAW AMM.SDR SWAA2018100125643Light · brokenRT OVERWING EMERGENCY EXIT LIGHT ASSEMBLY BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2018100125626Light · inoperativeLT EMERGENCY EXIT SIDE WALL LIGHT INOP. REPAIRED LIGHT PER MM.SDR AALA201810019050Wire · misinstalledPERFORMED AN OPERATIONAL TEST OF THE EMERGENCY LIGHT IAW PS21 AND FOUND THREE OVERHEAD LIGHTS AT 203WL, 204WL AND 205WL INOPERATIVE. MAINTENANCE FOUND LIGHT ASSEMBLY WIRED WRONG AND WIRED LIGHT ASSEMBLY IAW AWM 33-51-02.
Back to JASC 3350