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 DALA2018100405889Light · inoperativeFOUND LT OVERWING EXIT UPPER EMERGENCY LIGHT INOP. RELAMPED OVERWING EXIT EMERGENCY LIGHT IAW AMM 33-50. OPS CK NML. (LP3740096)SDR SWAA2018100925828Battery Pack · failedLT AFT DOOR EMERGENCY LIGHT FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR QXEA20181005359Battery Pack · inoperativeALL FWD EMERGENCY LIGHTS FAIL TO ILLUMINATE. REPLACED POWER SUPPLY.SDR ABXA201810053103Power Supply · inoperativeNR 3 EMERGENCY LIGHT INOP IN SUPERNUMERARY COMPARTMENT CEILING AND BOTH SPARE EMERGENCY LIGHTING BATTERY POWER SUPPLIES ARE INOP. WHILE THE AIRPLANE WAS GROUNDED, THE EMERGENCY LIGHTING BATTERY POWER SUPPLIES AT POSITIONS M734, M736, AND M737 WERE REPLACED. THSDR SIMA20181003002Inverter · inoperativeON PS-1 CHECK FOUND CABIN GALLEY CEILING EMERGENCY EXIT LOCATOR SIGN INOP. FOUND NR 1 DC/AC INVERTER TO BE CAUSING LIGHT TO BE INOP. REMOVED AND REPLACED NR 1 DC/AC INVERTER IAW AMM 33-50-11-04. OPS CHECK GOOD.SDR AALA201810049033Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. 2R, 14WL BATTERY EMERGENCY LIGHT FAILED. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201810049032Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT 20C EMERGENCY FLOORPATH LIGHT LENS COVER MISSING. MAINTENANCE REPLACED LIGHT LENS COVER PER 33-50-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201810049027Battery · failedAIRCRAFT WAS NOT GROUNDED. WHILE ACCOMPLISHING EPSU BATTERY CAP CHECK BATTERY AT 4L FAILED. REPLACED EPSU BATTERY AT 4L PER AMM 33-51-38. OPERATIONS CHECK GOOD.SDR SWAA2018100425769Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PACK PER MM.SDR SWAA2018100425768Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PACK PER MM.SDR SWAA2018100425756Light · inoperativeLT OVERHEAD BIN EMERGENCY LIGHT INOP AT SEAT 14. R&R BULB IAW AMM.SDR SWAA2018100425752Lens · looseRT EMERGENCY LIGHT LENS LOOSE AT ROW 14. SECURED LENS PER AMM.SDR SWAA2018100425751Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PACK PER MM.SDR SWAA2018100425749Fuse · blownRT OVERWING WINDOW OVER EMERGENCY EXIT SIDEWALL LIGHT INOP. R&R FUSE PER MM.SDR QXEA2018100400358Light · looseTRACK LIGHTING STRIP IS LOOSE BY THE LAVATORY. REMOVED FROM SERVICE. RESECURED FLOOR TRACK LIGHTING STRIP BY LAVATORY. NO OTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR DALA2018100405890Sign · missingR1 DOOR EXIT SIGN MISSING. INSTALLED R1 DOOR EXIT SIGN IAW AMM 33-51. OPS NORM. OK FOR SVC. (LP# 4743781)SDR DALA2018100305873Light · inoperativeEMERGENCY LIGHT AT SEAT 31JH AND 34JH INOP. REPLACED EMERGENCY LIGHTS.SDR DALA2018100305847Power Supply · defectiveTHE EMERGENCY EXIT SIGN ABOVE THE DOOR TO THE AFT ACCESSORY COMPARTMENT IS INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY BASE AND THE LIGHT RETURNED TO NORMAL OPERATION. (LP #5111438)SDR DALA2018100905938Lens · damaged(AIRCRAFT 7103, L/P 0767163) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:903 / INTERIOR. INSTALLED NEW LENS AT EMERGENCY FLOOR LIGHTING LOC 903. OK FOR SVC PER MM 33-51.SDR DALA2018100905937Lens · damaged(AIRCRAFT 7103, L/P 0767164) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:405 / INTERIOR. INSTALLED NEW LENS AT EMERGENCY FLOOR LIGHTING LOC 405. OK FOR SVC PER MM 33-51.SDR FDEA2018100522770Battery · dischargedDURING S-CHECK FOUND ON LT SIDE EMERGENCY EXIT LIGHTS AND OUTSIDE BEAM LAMP NOT ILLUMINATED DURING EMERGENCY LIGHT TEST AMM: TF-3350-T0338038 REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY IN ACC WITH AMM 33-51-07-2. TEST FOUND OKSDR DALA2018100505906Light · damaged(AIRCRAFT 694, L/P 0767423) EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:25D / EMERGENCY SEAT MOUNTED LIGHT DAMAGED / INTERIOR. REATTACHED LIGHT CHKS OK.SDR AALA201810049013Battery · failedAIRCRAFT WAS NOT GROUNDED. WHILE ACCOMPLISHING J/C 33C20033002 EPSU BATTERY 15WL & 18WL FAILED TEST. REPLACED EPSU BATTERIES 18WL PER AMM 33-51-38-000-802/400-802 OPERATIONS CHECK GOOD.SDR AALA201810049011Battery · failedAIRCRAFT WAS NOT GROUNDED. WHILE ACCOMPLISHING J/C 33C20033002 EPSU BATTERY 15WL & 18WL FAILED TEST. REPLACED EPSU BATTERIES 15WL PER AMM 33-51-38-000-802/400-802 OPERATIONS CHECK GOOD.SDR SWAA2018100425766Strip · delaminatedRT FLOOR EGRESS STRIPS BY AFT WHEELCHAIR CLOSET DELAMINATED. R&R EGRESS STRIPS PER DWG.SDR SWAA2018100425754Strip · delaminatedLT FLOOR EGRESS STRIPS BY AFT WHEELCHAIR CLOSET DELAMINATED. R&R EGRESS STRIPS PER DWG.SDR AALA201810049018Lens · missingSEAT 24C EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201810039022Cover · missingAIRCRAFT WAS NOT GROUNDED. EXIT LIGHT COVER AT 3L MISSING. MAINTENANCE FOUND AND RESECURED LENS COVER AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA20181002003Power Supply · inoperativeEMERGENCY LIGHT ON CEILING PANEL 253CLC INOP. FOUND EMERGENCY LIGHT ON CEILING PANEL 253CLC INOP. WHILE TROUBLESHOOTING FOUND THAT EMERGENCY LIGHT POWER UNIT SUPPLY NR 4 WAS NOT WORKING. R&R EMERGENCY LIGHT POWER UNIT SUPPLY NR 4 IAW AMM 33-50-01. EMERGENCY LISDR SWAA2018100325729Light · inoperativeRT EMERGENCY LIGHT INOP AT ROW 9. R&R BULB IAW AMM.SDR SWAA2018100325718Sign · unsecureEXIT SIGN FELL OFF AT ROW 14. REINSTALLED SIGN PER SIP.SDR SWAA2018100325717Battery Pack · dischargedR1 DOOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018100325714Cover · missingR2 DOOR EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED COVER PER EA.SDR DALA2018100305852Battery Pack · dischargedAFT OVER WING EMERG EXIT OVHEAD SIGNS INOP. R/R BATTERY PACK B5-105 PER AMM 33-53. OPS CHK GOOD. (LP5351362)SDR AALA201810039008Lens · missingL1 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-51-13.SDR DALA2018100205841Fuse · blownDURING INSPECTION FOUND AFT EXTERIOR LIGHT FOR RT WING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED BAD FUSE IN M1671 PER AMM 33-51 OPS CKS GOOD.SDR SWAA2018110226413Lens · out of positionLT OVERWING EMERGENCY UPPER LIGHT LENS OUT OF POSITION. R&R LENS PER IPC AND SOPM.SDR SWAA2018102926280Lens · looseLT EMERGENCY BIN LIGHT LENS LOOSE AT ROW 4. SECURED LENS PER AMM.SDR HALA2018101000274Light · not seatedAFT GALLEY EXIT PATH LIGHTING COMING OFF. RESEAT AFT GALLEY STRIP. LP 5371459SDR YENA2018081005485Battery Pack · no testDURING HEAVY MAINTENANCE, REF HAECOSO# 440516 NR# 32183 EMERGENCY EXIT LIGHT EPSU 13WL FAILS TEST; REF HAECO SO# 440516 NR# 32183 REMOVED AND REPLACED EPSU 13WL BATTERY PACK IAW A320 AMM 33-51-38-020-051-A AND 33-51-38-420-050-A OPS TEST OF THE EPSU CHECKS GOSDR AALA201810049026Lens · missingAIRCRAFT WAS GROUNDED. SEAT 1C EMERGENCY LIGHT LENS MISSING. INSTALLED 1C EMERGENCY LIGHT LENS.SDR AALA201810029011Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHTS WERE DIM AT SEATS 9 TO 16 AND 2R DOOR. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018100325742Splice · brokenFORWARD LAV EMERGENCY EXIT LIGHT SPLICE BROKEN. R&R SPLICES PER WDM AND AMM.SDR REXA2018100300928Sign · inoperativeEMER EXIT SIGN NO LIT ON BACK SIDE ABOVE SEAT 5C DEFERRED EXIT SIGN AT 5C IAW MEL 33-51-1E PLACARDS INSTALLED MMO2 UPDATED MOC NOTIFIED 98765 RESECURED CONNECTOR P5440 AT ROW 5 O/H PANEL.SYSTEM CHECKS GOOD PER AMM 33-50-01. MMO2 CLEARED+STICKER REMOVED. MOC 95SDR ASAA2018100126331Light · inoperativeEMERGENCY LIGHT PROXIMITY LIGHT ON FORWARD EXTERIOR OF LAVATORY G IS INOP. GROUNDED - YES. REFERENCE WDM SUPPLEMENT 33-51-22-P3 - RELAMPED AND TESTED L6 PROXIMITY LIGHT PER AMM 33-51-14-960-801 - OPS NORMAL.SDR SIMA201810021002Light · inoperativeLT AFT OVERWING EMERGENCY EXIT LIGHT INOP. -C/A-REMOVED AND REPLACED LT AFT OVERWING EMERGENCY EXIT LIGHT IAW 33-50-07, OP CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 76040SDR SWAA2018100225702Battery Pack · dischargedLT EMERGENCY AISLE BULLNOSE LIGHTS INOP BETWEEN ROW 9 TO ROW 11. R&R BATTERY PACK IAW MM.SDR MASA2018100111420Battery · dischargedSEVERAL CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERIES.SDR DALA2018100100275Interface Unit · malfunctionedSEVERAL EXIT SIGNS WILL NOT TURN OFF. FOUND NONSMOKING SIGN SWITCH IN ON POSITION. RESET LGCIU 1 AND 2. LP 5014610SDR CALA2018100102026Light · inoperativeRT FWD OVERWING EXTERNAL FUSELAGE EMERGENCY LIGHT INOP. REF. N/R:99823834 RELAMPED RT FWD OVERWING EXTERNAL FUSELAGE EMERGENCY LIGHT AS PER REF AMM 33-51-06, PERFORMED OPS CHECK AND FOUND NORMAL. REF. N/R:99823834
Back to JASC 3350