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 AALA201709269013Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE R4 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA20170925004Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE R1 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED EXIT LIGHT PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR ASAA2017092522036Power Supply · failedFOUND AFT EMERGENCY OUTSIDE LIGHT INOP. GROUNDED - YES. REF WDM 33-51-14, NO 6VDC AT L732 AFT LT ESCAPE SLIDE EMERGENCY LIGHT. REPLACED M1673 EMERGENCY EXIT LIGHT BATTERY PACK, OPS NORMAL, REF AMM 33-51-06-960-805. EMERGENCY LIGHTS OPERATIONAL TEST GOOD, REF ASDR SWAA2017092716684Light · inoperativeRT AFT WING FAIRING EMERGENCY LIGHT LAMP INOP. R&R LAMP PER AMM.SDR IPXA2017092522037Power Supply · no testDURING A PDC EMERGENCY LIGHTS TEST, THE LIGHTS FAILED. R & R THE EMERGENCY LIGHT BATTERY POWER SUPPLY IAW AMM 33-51-01. OPS TEST PASSED.SDR DALA2017092507117Battery Pack · failedFOUND THE STAIR CATWALK EMERGENCY LIGHT BATTERY FAILED. R & R THE BATTERY.SDR AALA201709279012Lens · missingEXIT LIGHT LENS MISSING AT THE L4 DOOR. REPLACED LIGHT LENS IAW AMM.SDR AALA201709279011Lens · missingTHE CREW FOUND THE L4 DOOR EMERGENCY EXIT LIGHT LENS MISSING DURING PREFLIGHT. THE LENS WAS REPLACED IAW AMM.SDR JJBA20170925033Bulb · inoperativeAFT CEILING EMERGENCY LIGHT INOPERATIVE. R & R THE BULB, OPS CHECKED GOOD.SDR DALA2017092607103Light · damagedSEAT ROW 14R EMERGENCY LIGHT DAMAGED. REPLACED THE EMERGENCY LIGHT ASSY. OPS NORMAL.SDR SWAA2017092616607Lens · brokenR1 DOOR LOWER "EXIT" SIGN BROKEN. R&R LENS IAW AMM.SDR DALA2017092607090Power Supply · inoperativeOVERWING EMERGENCY EVACUATION LIGHTS WERE INOPERATIVE. REPLACED THE OVERWING EMERGENCY EVACUATION LIGHT POWER SUPPLY AND BATTERY IAW AMM 33-51. OPS CHECKED NORMAL.SDR DALA2017092507089Battery Pack · inoperativeFOUND THE AFT EMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT IAW FIM 33-50-00 810-801. FOUND EMERGENCY FLOOR LIGHTS POWER SUPPLY BATTERY B5-119 INOPERATIVE. REPLACED THE BATTERY PER B717 AMM 33-51-03. OPS CHECKED OK. AIRCRAFT IS OK FOR SERVICE.SDR DALA2017092507088Sign · looseCREW REPORTED THE CEILING EXIT SIGN AT ROW 1 WAS LOOSE. SECURED THE SIGN.SDR MASA2017092512663Battery Pack · dischargedFWD EMERGENCY LIGHTS INOP. MX REPLACED NR 1 BATTERY PACK.SDR MASA2017092512660Light · inoperativeROW 18 AND 21 EMER FLOODLIGHT INOP. RE-LAMPED.SDR YENA201709250788Battery · dischargedFT 2291, BOS-TPA. EMER LIGHT FAILS TEST. R&R EMERGENCY LIGHT BATTERIES AT 12WL,11WL, AND 13WL BITE AND OPS CKS GOOD IAW AMM 33-51-38.SDR YENA201709250787Battery Pack · failedFT # 2291, EMER LIGHT FAILS TEST; R & R EMERGENCY LIGHT BATTERIES AT 12WL,11WL, AND 13WL BITE AND OPS CKS GOOD IAW AMM 33-51-38.SDR YENA201709250786Battery Pack · no testEMERGENCY LIGHT FAILED TO TEST. R & R EMERGENCY LIGHT BATTERIES. BITE AND OPS CHECKED GOOD IAW AMM 33-51-38.SDR CALA2017092503334Warning Message · false activationEPSU BATTERY FWD LT MESSAGE DISPLAYED WHILE PERFORMING EMERGENCY LIGHT OPS CHECK IAW AMM 33-51-00-710-001-A. ACCOMPLISHED EMERGENCY LIGHTS TEST. NO FAULTS NOTEDSDR CALA2017092503333Light · malfunctionedRT SIDE OVERWING EXIT DOOR LIGHT ILLUMINATED RESET EMERGENCY LIGHT SYSTEM SWITCH, RT OVERWING EXIT DOOR LIGHT OPS CHECKED NORMAL.SDR CALA2017092503332Charger · inoperativeEMERGENCY LIGHT POWER SUPPLY BATTERY FAILED A BITE TEST. REPLACED THE POWER SUPPLY BATTERY CHARGER IAW AMM 33-51-3 8-401.SDR CALA2017092503331Lens · missingEMERGENCY LIGHT LENS ON FORWARD CLOSET WALL IS MISSING. REPLACED THE LENS.SDR CALA2017092503330Light · malfunctionedOVERWING EMERGENCY LIGHTS ON IN THE ARMED POSITION. RESET, AND TESTED OKSDR CALA2017092503328Battery Pack · inoperativeAFT 7 ROWS OF THE EMERGENCY LIGHTS ARE INOPERATIVE, AND TWO AFT RT AISLE EMERGENCY LIGHTS ALSO INOPERATIVE. R & R THE BATTERY PACKS, OPS CHECKED GOOD IAW AMM 33-51-11.SDR CALA2017092503327Light · malfunctionedEMERGENCY SLIDE OVERWING LIGHT DOES NOT COME ON. PERFORMED AN OPS CHECK OF THE OVERWING EMERGENCY EXIT LIGHTS AND INDICATION LIGHTS IN FLIGHTDECK IAW AMM 33-18-00 AND 33-51-00. NO DEFECTS NOTED.SDR CALA2017092503326Light · malfunctionedSEAT 21A EMERGENCY LIGHTS GOING ON & OFF. COULD NOT DUPLICATE FAULTS ON THE GROUND. OK TO CONTINUE FOR SERVICE.SDR HNAA2017092500327Light · inoperativeSERVICE DOOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-10, OPS CHECKED GOOD.SDR F3LA2017092500229Battery · failedEPSU TEST FAULT 11WL.. REMOVED AND REPLACED EPSU 11WL BATTERY IAW AMM 33-51-38-PB401. OPS CHECKED GOOD.SDR SIMA20170924002Light · inoperativeEMERGENCY DOME LIGHT BY ROW 16 IS OUT. REMOVED AND REPLACED THE LIGHT IAW AMM 33-51-09 NO FIX. REMOVED AND REPLACED NO 5 CEILING LEVEL FLOOD LIGHT IAW AMM33-51-09 . OPS CHECK GOOD.SDR AALA201709259026Lens · missingEMERGENCY LIGHT LENS ADJACENT TO LAVATORY L73 MISSING. REPLACED THE LIGHT ASSEMBLY.SDR AALA201709269012Light · damagedAIRCRAFT WAS NOT GROUNDED. THE FORWARD GALLEY LEFT HAND EMERGENCY ESCAPE PATH LIGHTING WHITE LENS WIRING WAS BROKEN OFF AT THE ASSEMBLY. THE FORWARD GALLEY LEFT HAND LIGHT ASSEMBLY WAS REPLACED IAW AMM 33-51-05.SDR AALA20170924004Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE R3 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY (PACK) PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR SWAA2017092716682Lens · missingR2 DOOR EMERGENCY EXIT SIGN LENS MISSING. R&R LENS PER AMM.SDR SWAA2017092716659Lens · unsecureL1 DOOR EMERGENCY EXIT LENS FELL OFF. SECURED LENS PER MM.SDR R61A201709240721Battery · faultedEMERGENCY LIGHT BATTERY FAULTED. FAULT CODE 33500004UT1. R & R THE RT AFT EMERGENCY LIGHT POWER SUPPLY.SDR DALA2017092507116Cover · unsecureEXIT SIGN COVER WONT SAY ON. SECURED THE COVER. OPS NORMAL.SDR RAIA201709240001Lens · crackedPAX DOOR SWING ARM EMERGENCY LIGHT LENS IS CRACKED. R & R THE LENS, OPS CHECKED GOOD.SDR SWAA2017092616647Light · inoperativeRT INTERIOR EMERGENCY OVERWING EXIT SIGN INOP. RELAMPED SIGN IAW AMM.SDR SWAA2017092616617Lens · unsecureFORWARD ENTRY EXIT LIGHT LENS FELL OFF. R&R LIGHT PER MM.SDR DALA2017092507100Lens · unsecureR2 DOOR EMERGENCY EXIT SIGN COVER LOOSE. SECURED THE SIGN, CHECKED GOOD, OK FOR SERVICE.SDR AALA201709269005Lens · brokenSEAT 20C AISLE LIGHT LENS BROKEN. INSTALLED A NEW EMERGENCY LENS IAW AMM.SDR REXA2017092401032Light · inoperativeLEFT NR 2 EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-21.SDR QXEA2017092600585Lens · missingEXIT SIGN NEAR THE DITCHING DAM IS MISSING. FOUND COVER AND SECURED IAW CMM 25-23-29. RETURNED TO SERVICE.SDR DALA2017092507084Fuse · blownEMERGENCY LIGHTS SEAT MOUNTED NOT WORKING FROM ROW 24 TO 31. T/S PER WDM 33-51-14, FOUND FUSES BLOWN ON POWER SUPPLY B5-212. REPLACED FUSES. OPS CHECK PER AMM 33-53. CHECKS OK.SDR DALA2017092507083Battery Pack · dischargedCOCKPIT OVERHEAD DOME/PEANUT LIGHTS INOP. RMVD/RPLD EMERGENCY BATTERY PACK B5-23. OPS CK GOOD. OK FOR SVC PER WDM 33-51.SDR SWAA2017092516584Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT COVER LENS BROKEN. R&R LENS PER AMM.SDR ASAA2017092422024Lens · detachedEXIT SIGN LENS LOOSE AT ROW 17DEF. ACFT GROUNDED. ATTACHED THE LENS.SDR AALA201709259025Lens · damagedAIRCRAFT WAS NOT GROUNDED. 3L DOOR EXIT SIGN FELL OFF. REPLACED EMERGENCY LIGHT LENS COVER.SDR UIEA2017092501844Power Supply · failedEMERGENCY LIGHTS AT CREW SERVICE AREA 2 OUT OF 5 INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY POWER SUPPLY M736 AND M735 IAW AMM 33-51-00. OPS CHECKED NORMAL.
Back to JASC 3350