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 SIMA20170320003Bulb · inoperativeLT EXTERIOR OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW 33-51-15. OPS CHECKED ALL EXTERIOR EMERGENCY LIGHTS, OPS CHECKED GOOD.SDR YENA201703200199Power Supply · no testDURING HEAVY MAINTENANCE, THE EPSU 12WL AND 13WL FAILED CAPACITY CHECK. REPLACED THE EPSU IAW AMM 33-51-38-000-002-A.SDR MASA3017032012680Sign · inoperativeTHREE EMERGENCY EXIT SIGNS INOPERATIVE.SDR MASA2017032012679Bulb · inoperativeROW 13 EMERGENCY EXIT SIGN HAD ONE BULB INOPERATIVE.SDR MASA2017032012678Bulb · inoperativeLT FWD OVERWING EXIT SIGN ONE BULB INOPERATIVE.SDR JJBA20170320012Bulb · inoperativeGALLEY EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BULB. OPS CHECKED GOOD.SDR DALA2017032002193Battery · dischargedFWD EMERGENCY LIGHT FOUND INOP DURING SERVICE CHECK. REPLACED EMERGENCY LIGHT BATTERY IAW AMM 33-51. OPS CHECK GOOD AT THIS TIME. A/C OK FOR SVC.SDR DALA2017032002192Battery Pack · dischargedDURING SERVICE CHECK, FOUND FWD CEILING EMERGENCY LIGHTS COME ON MOMENTARILY DURING TEST. REPLACED EMERGENCY LIGHT BATTERY PACK AT BIN 4R / SEAT ROW 11R PER AMM 33-51-03. EMERGENCY LIGHT TEST NORMAL.SDR SWAA2017032812737Charger · inoperativeEMERGENCY LIGHT INOPERATIVE AT LOCATION M1673. R&R BATTERY CHARGER IAW AMM.SDR AALA201703229023Light · missingL3 DOOR MISSING EXIT LIGHT. REINSTALLED AFT EXIT LIGHT ASSY AT L3 DOOR IAW AMM 33-51-01. OPS CHECKED OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703229022Lens · missingEMERGENCY LIGHT LENS MISSING AT STATION 1305, AFT VAULT DOOR. REPLACED EMERGENCY LIGHT LENS, IAW AMM REF 33-53-00. OPERATION NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR SWAA2017032212720Light · inoperativeR1 DOOR EMERGENCY EXIT AISLE LIGHT INOP BETWEEN ROW 11 TO ROW 13. REPAIRED LIGHT IAW AMM.SDR ASOA201703195027Relay · faultyEMERGENCY LIGHTS CYCLING ON AND OFF WITH GROUND POWER AND APU POWER. CONTRACT MX REMOVED AND REPLACED RELAY K135 WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2017032202324Bezel · damagedDURING INSPECTION FOUND 1L DOOR EMERGENCY LIGHT BEZEL DAMAGED. MAINTENANCE R&R LIGHT BEZEL PER AMM 33-26.SDR ASOA201703193052Relay · inoperativeTHE CREW REPORTED EMERGENCY LIGHTS ARE CYCLING ON AND OFF WITH GROUND POWER AND APU POWER. MAINTENANCE REPLACED THE RELAY KJ35 IAW ESPM 20-39-00. OPS CHECKED GOOD.SDR AALA20170320003Control Unit · faultyAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS ILLUMINATED IN THE BUSINESS CLASS AFT SEATS DURING APU START. REMOVED AND REPLACED WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT AT WCU01 AND WELS BATTERY AT WCU23 (AALA201703219018) IAW AMM 33-5-07. OPERATSDR AALA20170320001Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT STATION 1305 AFT VAULT DOOR HAS A MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA201703219018Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS ILLUMINATED IN THE BUSINESS CLASS AFT SEATS DURING APU START. REMOVED AND REPLACED WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT AT WCU01 (AALA20170320003) AND WELS BATTERY AT WCU23 IAW AMM 33-5-07. OPERATSDR SWAA2017032112707Battery · dischargedRT FORWARD LOWER DOOR EMERGENCY LIGHT INOP AT BS 313. R&R BATTERY PER MM.SDR SWAA2017032112691Battery · dischargedLT FORWARD LOWER DOOR EMERGENCY LIGHT INOP AT BS 313. R&R BATTERY PER MM.SDR SWAA2017032112681Light · inoperativeRT OVERWING EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR REXA2017031900386Bulb · inoperativeMAIN CABIN DOOR EMERGENCY LIGHT BULBS ARE BURNED OUT. R & R THE BULBS IAW AMM 33-51-09. OPS CHECKED GOOD.SDR AALA201703219008Lens · missingEMERGENCY EXIT SIGN LENS ON LOWER PORTION OF L4 DOOR IS MISSING. REPLACED EMERENGENCY EXIT LIGHT LENS, AT DOOR 4L.SDR AALA201703219005Lens · brokenL4 DOOR EMERGENCY EXIT LENS BROKEN. INSTALLED NEW LENS.SDR SWAA2017032112638Lamp · inoperativeRIGHT OVERWING EXTERNAL EMERGENCY EXIT SLIDE LIGHT FORWARD OF AFT CARGO DOOR INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR RAIA201703210001Lens · crackedSERVICE DOOR EMERGENCY LIGHT LENS CRACKED. R & R THE LENS, OPS CHECKED GOOD.SDR SWAA2017032012566Lens · unsecureR1 DOOR LOWER EMERGENCY EXIT SIGN COVER LENS FELL OFF. SECURED LENS IAW EA.SDR SIMA20170319001Battery Pack · failedEMERGENCY LIGHTS AT LT FWD WING TO FUSELAGE AND ISLE LIGHT ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AND POWER SUPPLY, OPS CHECKED GOOD IAW AMM 33-50-04.SDR HNAA2017032000092Bulb · inoperativeRIGHT FWD EMERGENCY EGRESS LIGHT INOPERATIVE. R & R THE BULB.SDR JJBA20170319011Inverter · inoperativeROW 18CD EMERGENCY LIGHTS INOPERATIVE. R & R THE NR 3 INVERTER. OPS CHECKED GOOD.SDR DALA2017032102391Hook And Loop · failedEMERGENCY EXIT SIGN COVER LOOSE. REPLACED THE HOOK AND LOOP. CHECKED OK.SDR AALA201703229020Lens · brokenEMERGENCY PATH WAY WALL MOUNTED LIGHT HAS LENS BROKEN LOCATED AT LAV 4F-LC. REPLACED BROKEN LENS ON EMERGENCY LIGHT LOCATED AT LAV 4F-LC PER AMM 33-51-05. OPS CHECKED OK. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703229018Pin · missingEXIT SIGN OVER AISLE AT 24H BROKEN. INSTALLED NEW PIN AT EMER EXIT SIGN MOUNT BRACKET. EMER LIGHT OPS CHKD OK PER AMM 33-51-01 & AARD 33-51-01-1. THE AIRCRAFT WAS NOT GROUNDED.SDR DALA2017031902321Light · missingFLOOR EMERGENCY LIGHT AT SEAT 42JH FOUND MISSING. REPLACED THE EMERGENCY LIGHT.SDR AALA20170318001Charger · inoperativeAIRCRAFT WAS GROUNDED. DURING OPERATIONAL CHECK OF S10035, FOUND EMERGENCY ESCAPE PATH LIGHTS FROM SEAT 9 TO 15, EMERGENCY EXIT INDICATOR L752 AT L2 DOOR, AND EMERGENCY EXIT INDICATOR L751 AT R2 DOOR INOPERATIVE. REMOVED AND REPLACED BATTERY PACK (AALA201703SDR AALA201703209047Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT OVER L1 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-09. OPERATIONAL CHECK GOOD.SDR AALA201703209043Lens · missingEMERGENCY EXIT SIGN AT R4 DOOR HAS A MISSING LENS COVER. REINSTALLED THE LENS COVER. OPERATIONAL CHECKED GOOD.SDR AALA201703209041Battery Pack · inoperativeDURING OPERATIONAL CHECK OF S10035, FOUND EMERGENCY LIGHTS FROM SEAT 9 - 15, EMERGENCY EXIT INDICATOR L752 AT L2 DOOR, AND EMERGENCY EXIT INDICATOR L751 AT R2 DOOR INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND CHARGER ASSEMBLY IAW AMM 33-51-07. OPERSDR AALA201703209040Light · inoperativeR1 DOOR SLIDE LIGHT DOES NOT ILLUMINATE. REMOVED SLIDE BUSTLE AND FOUND LACING HANGING DOWN. SECURED THE SLIDE LIGHT. OPERATIONAL CHECKED GOOD.SDR SWAA2017032112690Cover · missingFORWARD ENTRY LOWER EMERGENCY EXIT SIGN MISSING LENS. R&R COVER IAW EA.SDR SWAA2017032112682Lens · looseRT OVERWING EMERGENCY EXIT ROW LIGHT COVER LENS LOOSE. R&R LENS PER MM.SDR SWAA2017032112672Lens · missingRIGHT LOWER OVERWING EMERGENCY EXIT SIGN LENS COVER MISSING. R & R THE LENS IAW AMM.SDR AALA20170319002Battery · no testEMARGENCY EXIT LIGHT BATTERY 14WL FAILED TEST. REPLACED EMERGENCY EXIT LIGHT BATTERY IAW AMM 33-51-38.SDR AALA201703219001Battery · no testOPERATIONAL TEST OF EMERGENCY LIGHTS FAIL PERIODIC SERVICE CHECK. REPLACED EPSU 10WL AND BATTERY PER AMM 33-51-38. PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00. AIRCRAFT WAS GROUNDED.SDR AALA201703209050Lens · brokenBROKEN SEAT MOUNTED EMERGENCY LIGHT LENS AT SEAT 16C. REPLACED SEAT MOUNTED LIGHT IAW AMM 33-51-18.SDR AALA201703209026Power Supply · no testEMERGENCY POWER SUPPLY UNIT 12WL FAILS SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 12WL IAW AMM 33-51-38 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201703209012Lens · brokenBROKEN SEAT MOUNTED EMERGENCY LIGHT LENS AT SEAT 4C. REPLACED SEAT MOUNTED LIGHT IAW AMM 33-51-18.SDR AALA201703209011Lens · missingEMERGENCY LIGHT AT SEAT 3C IS MISSING IT'S LENS COVER. REPLACED EMERGENCY LIGHT MOUNTING IAW AMM 33-51-19.SDR AALA201703209008Power Supply · no testOPERATIONAL TEST OF EMERGENCY LIGHTS FAIL PERIODIC SERVICE CHECK. REPLACED EPSU 10WL AND BATTERY IAW AMM 33-51-38. PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00. AIRCRAFT WAS GROUNDED.SDR R61A201703180224Sign · brokenEXIT IDENTIFIER SIGN BY L1 DOOR BROKEN. R&R EXIT IDENTIFIER SIGN BY L1 DOOR, OPS CHECK GOOD REF AMM 33-50-15.
Back to JASC 3350