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 AALA201909239036Power Supply · inoperativeAIRCRAFT NOT GROUNDED: EPSU 12 WL INOPERATIVE. REMOVED AND REPLACED EPSU 12WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR DALA2019092305440Battery Pack · dischargedTHE OVERWING EMERGENCY ESCAPE LIGHTS WILL TURN ON WHEN THE SWITCH IS TURNED OFF. MAINTENANCE REPLACED THE OVERWING EMERGENCY ESCAPE LIGHTING BATTERY PACK IAW AMM 33-51. LIGHTS NOW OPERATE NORMALLY. (LP #6025180)SDR SIMA20190922001Panel · inoperativeFOUND GALLEY WALL EMERGENCY EXIT PANEL INOP DURING PS1 CHECK. C/A-RAR GALLEY WALL EMERGENCY PANEL EXIT LIGHT IAW AMM 33-50-14. OPS CHECK GOOD.SDR DALA2019092905609Socket · unsecureEMERGENCY LIGHTS AT SEAT 30B ARE INOPERATIVE. SECURED LIGHT SOCKET. SYSTEM OPERATION IS NORMAL.SDR SWAA2019092537176Battery Pack · failedEMERGENCY LIGHT BATTERY PACK M1675 FAILED TO CHARGE AT BS 322, LBL 7. R&R BATTERY PACK IAW AMM.SDR DALA2019092305500Power Supply · inoperativeSHIP 6700 DURING SVC CHECK FOUND EMERGENCY PATH LIGHTS BETWEEN ROW 27-32 WOULD NOT TEST. CORRECTIVE ACTION: REMOVED & REPLACED POWER SUPPLY M10568 & BATTERY PACK IAW AMM 33-51. OPS TEST OK. (6246013)SDR AALA201909249017Power Supply · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33401 AT DOOR 4R FAILED TEST. MAINTENANCE REPLACED POWER SUPPLY PER AMM 33-51-06.SDR AALA201909249016Power Supply · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33408 AT DOOR 5R FAILED TEST. MAINTENANCE REPLACED POWER SUPPLY PER AMM 33-51-06.SDR AALA201909249015Power Supply · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33407 AT DOOR 5L FAILED TEST. MAINTENANCE REPLACED POWER SUPPLY PER AMM 33-51-06.SDR AALA201909249014Power Supply · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33424 AT DOOR 1L FAILED TEST. MAINTENANCE REPLACED POWER SUPPLY PER AMM 33-51-06.SDR AALA201909249013Power Supply · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33652 AT DOOR 2R FAILED TEST. MAINTENANCE REPLACED POWER SUPPLY PER AMM 33-51-06.SDR AALA201909249012Power Supply · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33652 AT DOOR 2R FAILED TEST. MAINTENANCE REPLACED POWER SUPPLY PER AMM 33-51-06.SDR DALA2019092305493Light · inoperativeCREW REST EMERGENCY LIGHTS ARE INOPERATIVE. REPLACED ALL BULBS. SYSTEM OPERATION IS NORMAL.SDR ASAA2019092130774Lens · unsecureEMERGENCY "EXIT" PLASTIC COVER FELL FROM ROW 16. GROUNDED - YES. REPLACED EMERGENCY "EXIT" COVER ONTO BRACKET, TIGHTENED RETENTION SCREW TILL COVER REMAINED IN PLACE.SDR SWAA2019092337152Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILS TO STAY CHARGE. R&R BATTERY PACK PER AMM.SDR SWAA2019092337112Battery Pack · dischargedLEFT EMERGENCY EXIT LIGHTS INOP AT BULLNOSE 9 AND 11. R&R BATTERY PACK PER AMM.SDR QXEA2019092300366Battery Pack · dischargedEMERGENCY LIGHT EXIT SIGN AT MAIN CABIN DOOR DOES NOT ILLUMINATE. REMOVED FROM SERVICE. REMOVED AND REPLACED BATTERY PACK POWER SUPPLY RT & LT #1 IAW AMM 33-51-01-000-801 & 33-51-01-400-801. OPS CK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR AALA201909239037Power Supply · inoperativeAIRCRAFT NOT GROUNDED: EPSU 11 WL INOPERATIVE. REMOVED AND REPLACED EPSU 11WL IAW AMM 33-51-38. OPS CHECK GOOD. OK FOR SERVICE.SDR DALA2019092305439Battery · dischargedUPON ARRIVAL AT THE GATE IN ATL, THE AFT EMERGENCY EXIT LIGHT WAS FLASHING. MAINTENANCE REPLACED THE BATTERY AND POWER SUPPLY. OPERATIONAL CHECK WAS GOOD PER AMM 33-51. (LP #5966954)SDR XMXR20191211024Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR XMXR20191211023Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR XMXR20191211005Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR SWAA2019092637203Battery Pack · dischargedRT EMERGENCY AISLE LIGHTS INOP BETWEEN SEAT ROWS 3 TO ROW 6. R&R BATTERY PACK PER AMM.SDR SWAA2019092637202Battery Pack · dischargedR1 DOOR EMERGENCY SLIDE LIGHT INOP AT M1674. R&R BATTERY PACK PER AMM.SDR SWAA2019092637201Battery Pack · dischargedR1 DOOR EMERGENCY EXIT LIGHT ON GALLEY INOP AT M1674. R&R BATTERY PACK PER AMM.SDR HNAA2019092500284Battery · dischargedEMERGENCY LIGHT OUT FROM ROW 8 TO 12. FIX: REPLACED EMERGENCY BATTERY #3 IAW FIM TASK 33-50-00-810-804-A AND IAW AMM 33-50-50, AMM 33-50-04. OPS CHK IAW W/C 33-70-17. OK FOR SERVICE.SDR R61A201909200989I/O Module · malfunctionedEMERGENCY LIGHTS REMAIN ON WITH SWITCH IN OFF POSITION. PERFORMED FIM 33-50-00. RESET MAU 2 GEN I/O MODULE, FAULT CLEARS.SDR DALA2019092305488Battery Pack · discharged(AIRCRAFT 683, L/P 5093572) ON SERVICE CHECK, FOUND MULTIPLE INTERIOR EMERGENCY LIGHTS INOP. R/R'D EMERGENCY LIGHT PACK BATTERY PER AMM 33-51. LOCATION M9102. TEST OK.SDR SWAA2019092337148Battery Pack · dischargedEMERGENCYS FAILED. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS PER AMM.SDR SWAA2019092337122Light · inoperativeEMERGENCY EXIT LIGHT HAS BURNED OUT LIGHT BULBS. RELAMPED PER AMM.SDR SWAA2019092337119Light · inoperativeEXIT SIGN INOP LIGHT BULBS. RELAMPED PER AMM.SDR SWAA2019092337118Light · inoperativeEXIT SIGN INOP. RELAMPED PER AMM.SDR SWAA2019092337117Light · inoperativeEMERGENCY EXTERIOR LIGHT INOP. RELAMPED GOOD OPS CHECK PER AMM.SDR SWAA2019092337084Battery Pack · dischargedEMERGENCY LIGHTS ARE OUT AT LEFT AFT INTERIOR & EXTERIOR. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACK FOR LEFT AFT INTERIOR AND EXTERIOR IAW AMM.SDR AALA201909239042Cover · brokenAIRCRAFT WAS NOT GROUNDED: 3L AND 4L SEAT MOUNTED EMERGENCY LIGHT COVERS BROKEN. MAINTENANCE REPLACED LIGHTS AT 3L (SEE AALA201909239001) AND 4L PER AMM 33-51-09.SDR AALA201909239001Cover · brokenAIRCRAFT WAS NOT GROUNDED: 3L AND 4L SEAT MOUNTED EMERGENCY LIGHT COVERS BROKEN. MAINTENANCE REPLACED LIGHTS AT 3L AND 4L (SEE AALA201909239042) PER AMM 33-51-09.SDR DALA2019092105476Light · brokenEMERGENCY FLOOR LIGHTING 14D BROKE OFF SEAT, RESECURED LIGHT ASSY AT 14D.SDR DALA2019092305441Lens · missingTHE EMERGENCY EXIT COVER DIFFUSER LENS IS MISSING. MAINTENANCE REPLACED THE AFT EMERGENCY LIGHT COVER. (LP #1279759)SDR JJBA20190920010Light · inoperativeSERVICE DOOR UPPER EMERGENCY LIGHT INOPERATIVE. R&R SERVICE DOOR EXIT MARKING SIGN ASSEMBLY. OPS CHECK SAT.SDR JJBA20190920009Light · inoperativeMAIN DOOR HINGE EMERGENCY LIGHT INOPERATIVE. R&R EMERGENCY LIGHT ASSEMBLY. OPS CHECK SAT.SDR SIMA20190920002Light · inoperativeRT OVERWING EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED RT OVERWING EMERGENCY LIGHT LAMP IAW AMM 33-50-07. OPS CHECKS GOOD NO FURTHER DEFECTS NOTED.SDR DALA2019092005430Battery Pack · dischargedEMERGENCY LIGHTS AT L4 AND R4 ARE INOPERATIVE. REPLACE BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR DALA2019092005428Light · inoperativeEMER SEAT LIGHT AT 14E INOP. RELAMPED SEAT 14E EMER SEAT LIGHT. OPS CK'D GOOD. (LP6122470)SDR SWAA2019092537104Sign · brokenFORWARD LAV EXIT SIGN BROKEN. REPLACED SIGN PER AMM.SDR ASAA2019091930757Lens · detachedR1 EMERGENCY DOOR LIGHT COVER HAS FALLEN OFF. GROUNDED - YES. REPLACED L1186 R1 LIGHT ASSY REF AMM 33-51-01. OPS NML.SDR SWAA2019092337114Battery Pack · dischargedLEFT FWD EMERGENCY LIGHTS FAILED. R&R BATTERY PACK PER AMM.SDR SWAA2019092337110Ballast · inoperativeRIGHT EMERGENCY EXIT LIGHT SIDEWALL LIGHT INOP. R&R LIGHT BALLAST AND BULB PER AMM. NO HELP.SDR SWAA2019092337103Battery Pack · dischargedRIGHT FWD EMERGENCY BATTERY PACK DOES NOT LAST THE REQUIRED TEST TIME. R&R RIGHT FWD EMERGENCY BATTERY PACK AND CHARGER PER AMM 33-51-06.SDR SWAA2019092337102Battery Pack · dischargedLEFT FWD EMERGENCY BATTERY PACK DOES NOT LAST THE REQUIRED TEST TIME. R&R LEFT FWD EMERGENCY BATTERY PACK AND CHARGER PER AMM.SDR SWAA2019092337097Light · damagedEMERGENCY LIGHT DAMAGED. R&R LIGHT IAW AMM.
Back to JASC 3350