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 AALA201909159003Light · inoperativeAIRCRAFT NOT GROUNDED: ROW 11 EMERGENCY LIGHT ON SEAT INOPERATIVE. REMOVED AND REPLACED ROW 11 EMERGENCY LIGHT IAW AMM 33-51-19 OPS CHECK OK.SDR MASA2019091312040Light · inoperativeOVHD EMER LIGHT ROW 9 INOP. REPLACED BULB.SDR N6WA20191201Power Supply · inoperativeEMERGENCY LIGHTS INTERIOR AND EXTERIOR ARE NOT WORKING. R&R EMERGENCY POWER SUPPLY UNIT X4. OPS CHK IS GOD IAW AMM 33-51-17.SDR ASAA2019091230679Charger · inoperativeEMERGENCY LIGHTS COMMON TO POWER SUPPLY M1676 INOP. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK AND CHARGER ASSY M1676 IAW AMM 33-51-06-960-806. OPS CHK GOOD.SDR AALA201909159008Power Supply · faultedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU FAULT NOTED DURING TEST ON JOB CARD 25-92-02 LOCATION 12WL. REMOVED AND REPLACED EMERGENCY POWER UNIT ON 12WL IAW AMM 33-51-38-00-001-A AND AMM 33-51-38-400-001A. OPS CHECKED GOOD.SDR YENA201909120528Battery · failedFLT 391, BOS-TPA. 10WL EPSU BATT FAILED; R & R 10WL EPSU BATTERY IAW AMM 33-51-38, OPS CHK GOOD.SDR YENA201909120527Battery · failedFLT 391, BOS-TPA. 10WL EPSU BATT FAILED; R & R 10WL EPSU BATTERY IAW AMM 33-51-38, OPS CHK GOOD.SDR YENA201909120526Power Unit · failedFLT 1979, DCA-FLL. WHILE PERFORMING T/C E190-33-50-01-720-801-AFT. FOUND AFT ELPU 5+6 FAILS FUNCTIONAL TEST; R & R ELPU 5 + 6 IAW AMM 33-50-01. OPS CK OK. A/C OK TO CONT SVC.SDR YENA201909120525Power Unit · failedFLT 1979, DCA-FLL. WHILE PERFORMING T/C E190-33-50-01-720-801-AFT. FOUND AFT ELPU 5+6 FAILS FUNCTIONAL TEST; R & R ELPU 5 + 6 IAW AMM 33-50-01. OPS CK OK. A/C OK TO CONT SVC.SDR SWAA2019091636999Battery Pack · failedBATTERY PACKS FAILED CAPACITY TEST AT M1669. R&R BATTERY PACKS PER DWG AND MM.SDR SWAA2019091636971Battery Pack · failedBATTERY PACKS FAILED CAPACITY TEST AT M1670. R&R BATTERY PACKS PER DWG AND MM.SDR REXA2019091201340Light · inoperative3 LIGHT BULBS ARE OUT FOR THE AIRSTAIR DOOR EMERGENCY LIGHT. RELAMPED FLOOR LEVEL EMERGENCY AIRSTAIR DOOR LIGHT IAW AMM 33-51-11. OPS CK GOOD. A/C BACK TO SVC.SDR REXA2019091201339Light · brokenEMERGENCY EXIT LIGHT OVER GALLEY SERVICE DOOR BROKEN. REMOVED & REPLACED EXIT SIGN LIGHT OVER GALLEY SERVICE DOOR IAW AMM 33-51-05. PERFORMED OPS TEST OF THE EMERGENCY LIGHT SIGN OVER THE GALLEY SERVICE DOOR IAW AMM 33-51-00. OPS TEST GOOD. A/C OK FOR SVC.SDR AALA201909139003Light · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHT INOPERATIVE ON SIDE OF SEAT 23C, AISLE LIGHT.***SUPPLEMENTAL ACTION SECTION 4 AND 5: RELAMPED SEAT 23C EMERGENCY LIGHT IAW AMM 33-51-18.***(CLOSED)SDR ASAA2019091230678Charger · inoperativeEMERGENCY LIGHTS COMMON TO POWER SUPPLY M1676 INOP. GROUNDED - YES. REMOVED AND REPLACED CHARGE ASSY AND BATTERY PACK.SDR SWAA2019091336886Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673. R&R BATTERY PER AMM.SDR SWAA2019091336885Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R&R BATTERY PER AMM.SDR SWAA2019091336884Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1672. R&R BATTERY PER AMM.SDR SWAA2019091336864Cover · brokenAFT FLT ATT PANEL EMERGENCY LIGHT SWITCH COVER BROKEN. R&R COVER IAW CMM.SDR SWAA2019091336861Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M02816. R&R BATTERY PER AMM.SDR MASA2019091212039Battery · dischargedEMER LIGHTS INOP. RECHARGED BATTERIES.SDR DALA2019091305296Battery Pack · dischargedROW 25 OVERWING EMERGENCY EXIT SIGNS INOP. REPL BATTERY PACK PER AMM 33-53. OPS CHECK GOOD. (LP5597571)SDR DALA2019091305295Unknown · malfunctionedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. EMERGENCY FLOOR LIGHTING DAMAGED OR INOP. TRACK LIGHTING GOES ON & OFF. CHECKED OPERATION OF EMERGENCY LIGHTS - UNABLE TO DUPLICATE PROBLEM - SYSTEM OP'S NORMAL REF AMM 33-53. (LP1267573)SDR DALA2019091205279Battery · dischargedFWD FLIGHT DECK / GALLEY OVERHEAD EMERGENCY LIGHT INOP. REPLACED BATTERIES FWD DROP DOWN CEILING FOR FWD FLIGHT DECK GALLEY OVERHEAD EMRG LIGHT IAW AMM 33-50. OPS CHECK GOOD. (LP6188026)SDR SWAA2019092537171Lens · crackedG-1 EXIT SIGN LENS CRACKED. R&R G-1 EXIT SIGN LENS IAW AMM.SDR AALA201909159009Battery · dischargedAIRCRAFT WAS GROUNDED: EMERG LIGHTS AT 2L AND 2R STAY ILLUMINATED. REMOVED AND REPLACED AFT CABIN EMERGENCY POWERT SUPPLY UNIT BATTERY IAW AMM 31-51-38. ALL OPS CKS GOOD.SDR DALA2019091205315Light · inoperativeMONUMENT MOUNTED EEPL AT GALLEY A1 RIGHT SIDE INOPERATIVE. REPLACED AFT GALLEY A1 EMERGENCY LIGHT. LP 6059964SDR SWAA2019091336883Lens · defectiveLT OVERWING EXIT SIDEWALL LIGHTS DIM. R&R LENS PER AMM.SDR SWAA2019091336882Light · dimRT OVERWING EXIT SIDEWALL LIGHTS DIM. R&R BULBS PER AMM.SDR SWAA2019091336881Lens · defectiveRT OVERWING EXIT SIDEWALL LIGHTS DIM. R&R LENS PER AMM.SDR SWAA2019091336867Sign · missingEMERGENCY EXIT SIGN AT AISLE EXIT AREA MISSING. REINSTALLED SIGN PER AMM.SDR SWAA2019091336863Battery Pack · failedLT EMERGENCY BATTERY PACK AT ROW 17 FAIL CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2019091336862Light · dimLT OVERWING EXIT SIDEWALL LIGHTS DIM. R&R BULBS PER AMM.SDR DALA2019091205310Charger · defective(AIRCRAFT 5804, L/P 5430100) LT BATT EMERGENCY LIGHT C/B N35 FOUND POPPED. TROUBLE SHOT TO BATT CHARGER AT 3L EMERGENCY DOOR. M11490 REPLACED BATTERY PER AMM 33-51. OPS CHECKS GOOD PER AMM 33-51.SDR DALA2019091105307Cover · missing(AIRCRAFT 682, L/P 5232077) MID CABIN AISLE "EXIT" SIGN COVER IS MISSING ON ONE SIDE. CORRECTIVE ACTION: FOUND LENS ASSY AND REINSTALLED.SDR ASAA2019091130670Charger · inoperativeR1 EMERGENCY LIGHTS INOP GROUNDED - YES. REMOVED AND REPLACED BATTERY CHARGER AND BATTERY SUPPLY IN ACCORDANCE WITH AMM 33-51-06.SDR SIMA20190911001Battery · dischargedREAR HALF OF EMERGENCT EXIT LIGHTS BATTERY DIES AFTER 2 MINUTES. C/A-REMOVED AND REPLACED #4 EMERGENCY LIGHT BATTERY AND CHARGER IAW WC# 33-700-19.SDR SIMA20190911005Light · inoperativeDURING PS-1 CHK FOUND RT OVERWING EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED RT OVERWING EMERGENCY LIGHT BULB IAW AMM 33-50-10. OPS CHK GOOD.SDR DALA2019091205292Battery Pack · discharged(AIRCRAFT 5646, L/P 6089934) ON SVC CHECK FOUND SEAT 4 AND 5 DC AND 15/16 DEF EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK M732 IAW AMM 3351.SDR AALA201909129020Switch · malfunctionedAIRCRAFT NOT GROUNDED: DOOR 4R EMERGENCY LIGHTS REMAIN ON AT ALL TIMES. EMERGENCY LIGHT SWITCH RECYCLED AND OPS TEST OK IAW AMM 33-51-00.SDR SWAA2019091236858Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2019091236857Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PACK PER AMM.SDR SWAA2019091236856Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PACK PER AMM.SDR SWAA2019091236855Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PACK PER AMM.SDR SWAA2019091236854Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PACK PER AMM.SDR SWAA2019091236853Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PACK PER AMM.SDR SWAA2019091236841Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M01668. R&R BATTERY PACK PER AMM.SDR SWAA2019091236834Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR SWAA2019091136806Battery Pack · failedAFT LT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR DALA2019091100139Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING. RE-INSTALLED COVER. LP 1265375
Back to JASC 3350