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 YENA2020020430122Battery · failedFT # 352, MCO-BOS. EPSU BATTERY (10WL) FAILED CAP CHECK; R & R EPSU (10WL) IAW AMM 33-51-38, BITE CHECK GOOD.SDR YENA2020020430121Battery · failedFT # 1161, LGA-PBI. FWD EPSU BATTERY FAILED PER TC A320-33-51-00-710-003; R & R FWD EPSU BATTERY IAW AMM 33-51-00. ALL OPS OK.SDR YENA2020020430120Battery · failedFT # 1304, SJU-JFK. EPSU FAIL OPS CHECK OF EMERGENCY LIGHT; R & R EPSU BATTERY IAW AMM 33-51-35SDR YENA2020020430119Battery · failedFT # 1304, SJU-JFK. EPSU FAIL OPS CHECK OF EMERGENCY LIGHT; R & R EPSU BATTERY IAW AMM 33-51-35SDR YENA2020020430118Battery · failedFT # 1304, SJU-JFK. OPS CHECK OF EMERGENCY LIGHT SYSTEM EPSU FAIL; R & R EPSU BATTERY IAW AMM 33-51-35.SDR YENA2020020430117Battery · failedFT # 1304, SJU-JFK. OPS CHECK OF EMERGENCY LIGHT SYSTEM EPSU FAIL; R & R EPSU BATTERY IAW AMM 33-51-35.SDR ASAA202002032036Battery Pack · dischargedEMERGENCY AISLE LIGHT ARE INOP AT SEATSROWS 26ABC AND 29ABC. GROUNDED - YES. REMOVED AND REPLACED POWER SUPPLY M1898. VERIFIED EMERGENCY AISLE LIGHTS AT ROW 26ABC AND 29ABC ARE WORKING NORMAL. REF B737-900 AMM 33-51-06/201.SDR DALA2020020310862Power Supply · inoperativeAFT OVERHEAD CABIN EXIT SIGN FOR DOORS 4L + 4R IS NOT ILLUMINATED, INSTALLED NEW EPSU [13WL] AND NEW BATTERY PACKSDR DALA2020020310860Light · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED LOCATIONS:30D, REPLACED EMERGENCY LIGHT HOUSING ASSYSDR YENA2020020390116Battery · no testFT # 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED; REMOVED & REPLACED EMERGENCY LIGHT BATTERY AT FIN# 11WL IAW AMM 33-51-38.SDR DALA2020020310851Light · damagedSHIP 6815 EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:39D. CORRECTIVE ACTION: RESECURED LIGHT ASSY. OPS NML. (1467451)SDR DALA2020020100776Charger · inoperativeCREW REST EMERGENCY LIGHT INOP AT LADDER FOUND EMERGENCY LIGHT BATTERY CHARGER INOP M1210. REPLACED PER B767-400 AMM 33-51. MEL/PLAC RMVD. OK FOR SERVICE. (6994501)SDR AALA202001319017Power Supply · no testAIRCRAFT WAS NOT GROUNDED, EMERGENCY EXIT SIGN ILLUMINATED CONTINUOUSLY WHEN NO SMOKING LIGHT SWITCH WAS ON AND DISPLAYED DISCREPANCIES. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38 AND PERFORMED SATISFACTORY EXIT SIGN LIGHT OPERATIONAL CSDR AALA202001319012Light · inoperativeAIRCRAFT WAS NOT GROUNDED EMERGENCY AREA LIGHT RIGHT ROW 15 INOPERATIVE. MAINTENANCE REPLACED EMERGENCY AREA LIGHT IAW AMM 33-51-03.SDR AALA202001319011Light · inoperativeAIRCRAFT WAS NOT GROUNDED, L1 DOOR FLOOR EMERGENCYH LIGHT INOPERATIVE. MAINTENANCE REPLACED EMERGENCY LIGHT IAW AMM 33-51-05.SDR QXEA2020013120075Light · looseFWD LIGHT STRIP IN FRONT OF FORWARD GALLEY LOOSE. REMOVED FROM SERVICE. RE-SECURED EMERGENCY LIGHT STRIP AS REQUIRED. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR QXEA2020013100073Light · looseFORWARD GALLEY FLOOR STRIP WAS LOOSE. REMOVED FROM SERVICE. SECURED THE STRIP ON FWD GALLEY FLOOR. RETURNED TO SERVICE.SDR QXEA2020013100072Light · crackedFLOOR PATH LIGHTING STRIP IS CRACKED AT SEAT ROWS 2A AND 1D. REPLACED FLOOR STRIPS 3A AND 1D IAW E175 AMM 33-50-21-00/400-801-A.SDR R61A2020013100141Light · damagedEMERGENCY FLOOR LIGHTING MCD BLEACHED OUT. R&R PHOTOLUMINESCENT INDICATOR STRIP LIGHT BENEATH WARDROBE IAW AMM33-50-21.SDR AALA202001319013Power Supply · inoperativeAIRCRAFT NOT GROUNDED: ROWS 3, 7, 15, 19, AND 24 EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY POWER SUPPLY UNIT IAW AMM 33-51-38-000-001-A, AND 33-51-38-400-001-A. PERFORMED OPS CHECK IAW AMM 33-51-00-710-001-A.SDR SWAA2020013140947Light · inoperativeLT LOWER EXTERNAL FUSELAGE EMERGENCY EXIT FLOOD LIGHT INOPERATIVE AT BS 757. R&R LIGHT LAMP IAW AMM.SDR SWAA2020013140937Battery Pack · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY CHECK AT LOCATIONS M01669I AND M01672. R&R BATTERY PACKS AT M01669 AND M01672 PER AMM.SDR ASOA2020013104001Battery Pack · dischargedIAH FLIGHT 4385, THE CREW RPORTED THAT THE FLOOR EMERGENCY LIGHTS BETWEEN SEATS 8 AND 18 WERE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NUMBER THREE EMERGENCY LIGHT BATTERY PACK, OPERATIONALLY TESTED WITH NO DEFECTS NOTED AND THE AIRCRAFT WAS APPROVED SDR SWAA2020013040881Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT PER AMM.SDR AALA202001309016Battery · no testAIRCRAFT NOT GROUNDED: THE EMERGENCY LIGHT TEST ON THE PTP PANEL 110RH FAILED TEST. THESCREEN READ ATA 31-51-38 EPSU BAT AFT LH. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT 13WL IAW AMM 33-51-38.SDR SWAA2020051829318Lens · missingL/H SIDEWALL PANEL 231ZLW MISSING EXIT LIGHT LENS COVER / REMOVED AND REPLACED L/H SIDEWALL PANEL 231ZLW EMERGENCY EXIT LIGHT ASSY. OP CHECKED GOOD IAW AMM 33-51-01-960-802. ATAG #WN8329SDR SWAA2020021941481Lens · discoloredFORWARD ENTRY CENTER PANEL EXIT LENS DISCOLORED. / R&R LENS PER AMM.SDR SWAA2020021941455Lens · discoloredFORWARD ENTRY DOOR AND FORWARD SERVICE DOOR HEADER PANEL EXIT LENSES ARE DISCOLORED. / R&R LENSES IAW AMM.SDR AALA202001309012Ballast · failedAIRCRAFT NOT GROUNDED: EMERG EXIT OVER 14F DOES NOT ILLUMINATE. MEL APPLIED.***SUPPLEMENTAL ACTION SECT 4 AND 5: REPLACED BALLAST ASSY AT 14F SIDEWALL LIGHT PER AMM 33-21-00.***(CLOSED)SDR SWAA2020021341381Lens · crackedFORWARD GALLEY AREA EMERGENCY EXIT LENS CRACKED. / R&R LENS IAW AMM.SDR SWAA2020021341379Sign · pulledL2 DOOR LOWER EMERGENCY EXIT SIGN WIRES WERE PULLED FROM THE CONNECTORS. / R&R EXIT SIGN PER AMM.SDR SWAA2020021241351Lens · discoloredAFT ENTRY CENTER EXIT LIGHT LENSES DISCOLORED. / R&R LENS PER AMM.SDR SWAA2020021214304Lens · brokenR/H UPPER G4 GALLEY TRIM, EXIT LIGHT LENS WAS BROKEN. / R&R LIGHT ASSEMBLY IAW AMM.SDR YENA2020020390115Power Supply · failedFT # 6480, SAL-MCO. AFT L/H EPSU UNIT FAULT; R & R EPSU AFT L/H GALLEY AS PER AMM 33-51-38 UNIT TESTED OK BUT FAILED FULL TEST REF LP 2785107 ITEM #2 FOR FULL OPS CK.SDR YENA2020020390114Light · failedFT # 1710, PAP-FLL. R1 DOOR SLIDE REQUIRES REPLACEMENT DUE TO EMERGENCY LIGHT FAILURE; REMOVED & REPLACED R1 DOOR SLIDE PER AMM 25-62-44-400-803-A OPS CHK OK. ACCOMPLISHED OPS TEST OF THE EMERGENCY LIGHTS IAW AMM 33-51-00-710-001.SDR YENA2020020390113Battery · failedFT # 333, BOS-SFO. GROUND POWER DROPPED AND EMERGENCY LIGHTS DID NOT ILLUMINATE; REMOVED & REPLACED 6 EMERGENCY BATTERY RE TASK CARD A320-33-51-00-710-003. OPS CHECK GOOD.SDR YENA2020020390112Battery · failedFT # 333, BOS-SFO. GROUND POWER DROPPED AND EMERGENCY LIGHTS DID NOT ILLUMINATE; REMOVED & REPLACED 6 EMERGENCY BATTERY RE TASK CARD A320-33-51-00-710-003. OPS CHECK GOOD.SDR YENA2020020390111Battery · no testFT # 333, BOS-SFO. GROUND POWER DROPPED AND EMERGENCY LIGHTS DID NOT ILLUMINATE; REMOVED & REPLACED 6 EMERGENCY BATTERY RE TASK CARD A320-33-51-00-710-003. OPS CHECK GOOD.SDR YENA2020020390110Battery · failedFT # 333, BOS-SFO. GROUND POWER DROPPED AND EMERGENCY LIGHTS DID NOT ILLUMINATE; REMOVED & REPLACED 6 EMERGENCY BATTERY RE TASK CARD A320-33-51-00-710-003. OPS CHECK GOOD.SDR YENA2020020390109Battery · no testFT # 333, BOS-SFO. GROUND POWER DROPPED AND EMERGENCY LIGHTS DID NOT ILLUMINATE; REMOVED & REPLACED 6 EMERGENCY BATTERY RE TASK CARD A320-33-51-00-710-003. OPS CHECK GOOD.SDR YENA2020020390108Battery · no testFT # 333, BOS-SFO. GROUND POWER DROPPED AND EMERGENCY LIGHTS DID NOT ILLUMINATE; REMOVED & REPLACED 6 EMERGENCY BATTERY RE TASK CARD A320-33-51-00-710-003. OPS CHECK GOOD.SDR YENA2020020390107Battery · no testFT # 950, GND-JFK. EPSU BATTERY CAPACITY CHECK ASSIGNED; R & R BATTERY OF THE EPSU AT FIN 10WL + 12WL IAW AMM 33-51-38SDR YENA2020020390106Battery · no testFT # 950, GND-JFK. EPSU BATTERY CAPACITY CHECK ASSIGNED; R & R BATTERY OF THE EPSU AT FIN 10WL + 12WL IAW AMM 33-51-38SDR YENA2020020390105Battery · no testFT # 464, SEA-JFK. EPSU BATTERY FIN 15WL REQUIRE CAPACITANCE CHECK; R & R EPSU BATTERY PER AMM 33-51-38. OPS TEST OK.SDR YENA2020020390104Battery · no testFT # 464, SEA-JFK. EPSU BATTERY 10WL REQUIRES CAPACITANCE CHECK; R & R EPSU BATTERY PER AMM 33-51-38 OPS TEST OKSDR YENA2020020390103Battery · no testFT # 464, SEA-JFK. EPSU BATTERY 14WL REQUIRES CAPACITANCE CHECK; R & R EPSU BATTERY PER AMM 33-51-38 OPS TEST OKSDR YENA2020020390102Battery · no testFT # 464, SAE-JFK. EPSU BATTERY 11WL REQUIRES CAPACITANCE CHECK; R & R EPSU BATTERY PER AMM 33-52-38 OPS TEST OK.SDR YENA2020020390101Battery · no testFT # 464, SEA-JFK. EPSU BATTERY 13WL REQUIRE CAPACITANCE CHECK; R & R EPSU BATTERY PER AMM 33-51-38 OPS TEST OK.SDR YENA2020020390100Battery · no testFT # 464, SEA-JFK. EPSU BATTERY 12WL REQUIRE CAPACITANCE CHECK; R & R EPSU BATTER PER AMM 33-51-38SDR YENA2020020390099Battery · failedFT # 662, BGI-JFK. ALL EPSU BATTERIES NEEDS REPLACEMENT PER T/C A320-33-51-00-710-003 WO 1038894; R & R ALL EPSU BATTERIES IAW AMM 33-51-38. OPS CHK NORMAL.
Back to JASC 3350