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 JJBA20181012002Light · inoperativeEMERGENCY LIGHT ON ROW 18 ON CD SIDE INOP. R&R EMERGENCY LIGHT IN ROW 18 ON CD SIDE. OPS CK SAT NO DEFECTS NOTED.SDR REXA2018101600960Light · missingLUMINESCENT STRIP ON FLOOR MISSING AT SEAT 13B. INSTALLED A SERVICABLE LUMINESCENT STRIP IAW AMM 25-25-01.SDR AALA201810159028Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. DURING EMERGENCY EXIT LIGHTING TEST, FAULT WAS GENERATED. BATTERY AND EMERGENCY POWER SUPPLY UNIT (10WL) FORWARD LEFT TEST DID NOT PASS PER STEP 16 OF PERIODIC SERVICE CHECK. REPLACED EMERGENCY POWER SUPPLY UNIT (10WL) AND BATTERY PESDR AALA201810159026Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. DURING EMERGENCY EXIT LIGHTING TEST, FAULT WAS GENERATED. BATTERY AND EMERGENCY POWER SUPPLY UNIT (10WL) FORWARD LEFT TEST DID NOT PASS PER STEP 16 OF PERIODIC SERVICE CHECK. REPLACED EMERGENCY POWER SUPPLY UNIT (10WL) AND BATTERY PESDR AALA201810159007Battery Pack · inoperativeTWO EMERGENCY LIGHTS AT THE TOP OF THE COCKPIT OVERHEAD PANEL WERE BOTH INOPERATIVE. REPLACED THE B5-23 BATTERY PACK IAW MM 33-53-00. OPS CHECKED OK.SDR SWAA2018101525929Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2018101525928Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2018101525913Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2018101425912Battery Pack · failedCABIN EMERGENCY BATTERY PACK FAILED CAPACITY TEST AT POSITION M01675. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018101425910Battery · failedLT OVERWING EMERGENCY EXIT LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018101425909Battery · failedLT AFT EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018101425908Battery · failedLT FORWARD EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018101425903Sign · looseCENTER AISLE OVERHEAD "EXIT/SALIDA" SIGN LOOSE. SECURED SIGN SRM.SDR SWAA2018101425898Lens · missingRT OVERHEAD BIN EGRESS LIGHT COVER MISSING BETWEEN ROW 17 TO ROW 18. INSTALLED LIGHT LENS IAW AMM.SDR HALA2018101200494Light · malfunctionedFA REPORTS ON TAXI OUT AND TAXI IN, EMERGENCY LIGHT SYSTEM CAME ON FOR A COUPLE MINUTES. PERFORMED FIM TASK 33-50 TASK 801. NO FAULTS NOTED, NO 10 DAY HISTORY OF FAULT NOTED. OPS CHECK OKAY. OK FOR SERVICE.SDR AALA201810129027Light · damagedAIRCRAFT WAS NOT GROUNDED: R1 DOOR LOWER EMERGENCY LIGHT DAMAGED. MAINTENANCE REPLACED R1 DOOR LOWER EMERGENCY LIGHT PER AMM 33-51-13 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201810129022Battery · faultedAIRCRAFT WAS NOT GROUNDED. BATTERY/EPSU (11WL) DOOR 1 FAULT. REPLACED EMERGENCY BATTERY PER AMM TASK 33-51-38 TEST OKAY.SDR SIMA2018101211005Light · inoperativeMAIN DOOR EXTERNAL EMERGENCY LT INOP. -C/A-R&R MAIN DOOR EXTERNAL EMERGENCY LT LAMP IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPS CHECK GOOD.SDR SIMA2018101211004Light · inoperativeSERVICE DOOR CEILING EMERGENCY LT INOP. -C/A-R&R SERVICE DOOR CEILING EMERGENCY LT LAMP IAW AMM 33-50-09-000-801-A AND 33-50-09-400-801-A. OPS CHECK GOOD.SDR SIMA2018101211003Light · inoperativeLT OVER WING EMERGENCY LIGHT INOP. -C/A-REMOVED AND REPLACED OVER WING EMERGENCY LIGHT BULB IAW AMM 33-50-10 OPS CHECK GOOD IAW AMM 33-50-00.SDR SWAA2018101125876Power Supply · inoperativeOVERWING AISLE EMERGENCY EXIT SIGN INOP. R&R POWER SUPPLY PER AMM.SDR DALA2018101105975Light · inoperative8 EMERGENCY LIGHTS INOP AISLE OVHD DURING SVC CK. RELAMPED INOP LTS, NO HELP. FOUND 3 BULBS BURNT OUT. RELAMPED. OPS CKD PER AMM 33-52-00. ALL LIGHTS WORK. OK FOR SERVICE.SDR MASA2018101111440Light · inoperativeROW 18 OH CEILING EMERG LT INOP. PLACED ON MEL.SDR SWAA2018102926284Cover · brokenAFT ATTENDANTS PANEL EMERGENCY LIGHT SWITCH COVER BROKEN. R&R COVER PER SIP.SDR DALA2018102506290Light · broken36F EMERGENCY PATH WAY LIGHT BROKEN OFF. REMOVED AND REPLACED LIGHT ASSY PER AMM 33-51.SDR IPXA2018101204876Battery Pack · inoperativeDURING PREFLIGHT TEST, THE EMERGENCY LIGHT, AN ALERT EMERGENCY LIGHT BATTERY 1 LOW. REPLACED BATTERY PACK IAW AMM 33-51-01, OPS CHECKED GOOD.SDR IPXA2018101214911Power Supply · inoperativeEMERGENCY EXIT SIGN DID NOT ILLUMINATE & WAS CRACKED. REPLACED EMERGENCY EXIT SIGN ASSEMBLY IAW AMM 33-51-01-022-029, & 31-51-01-402-030. REPLACED THE POWER SUPPLY IAW 33-51-00, & CONTROL RELAY IAW 33-51-11, OPS CHECKED GOOD.SDR R61A2018101601036Battery · discharged**DURING MAINTENANCE HEAVY CHECK** MAINTENANCE FOUND 2 OF 3 EMERGENCY LIGHTS NOT WORKING IN CEILING PANEL 227BLC AT L1 DOOR. MAINTENANCE REMOVED AND REPLACED EMERGENCY BATTERY IAW AMM 33-50-01-400-802A, OPS CHECK GOOD.SDR YENA2018101500685Epsu · failedFLT 876, KIN-FLL. LT EMERGENCY EXIT OVER WING (EPSU) EMERGENCY POWER SUPPLY UNIT INOP; R&R EPSU IAW 33-51-00. OPS CHECK GOOD.SDR YENA2018101500684Epsu · failedFLT 876, KIN-FLL. EMERGENCY ESCAPE PATH FLOOR LIGHT IN ROW 3, 7, 15, 19, 21, 23, 25 AND CEILING LIGHT ROW 12 AND 22 INOP (FLOOR PROX EMERG ESCAPE PATH MARK SYS - INCANDESCENT LIGHTING SYS - NOT APPLICABLE TO (N703 AND UP) ); REMOVED AND REPLACED EPSU AND BATTSDR YENA2018101500683Battery · dischargedFLT 876, KIN-FLL. EMERGENCY ESCAPE PATH FLOOR LIGHT IN ROW 3, 7, 15, 19, 21, 23, 25 AND CEILING LIGHT ROW 12 AND 22 INOP (FLOOR PROX EMERG ESCAPE PATH MARK SYS - INCANDESCENT LIGHTING SYS - NOT APPLICABLE TO (N703 AND UP) ); REMOVED AND REPLACED EPSU AND BATTESDR CALA2018101302093Battery Pack · unsecureAFT CENTER GALLEY FLOOR EMERGENCY LIGHTS INOP. SECURED BATTERY PACK AT PWR SUPPLY M1210. OPS NORMAL REF MM 33-51-00.SDR IPXA2018101214910Light · detachedDURING PREFLIGHT, THE EMERGENCY EXIT LIGHT AT THE CABIN DOOR WAS FOUND DETACHED FROM THE HOUSING BRACKET. ATTACHED THE LIGHT IAW SRM 51-30-10-OGSDR AALA2018101219002Lens · missingFORWARD EMERGENCY LIGHT MISSING THE RED LENS. REPLACED THE LENS. CHECKED GOOD IAW AMM 33-51-00.SDR SWAA2018101125890Lens · missingR1 DOOR LOWER EMERGENCY LIGHT LENS MISSING DIRECTIONAL ARROW. R&R LENS PER SIP.SDR SWAA2018101125881Battery · failedEMERGENCY LIGHT BATTERY AT LOCATION M1673 FAILED CAPACITY TEST. R&R BATTERY PER AMM.SDR DALA2018101005979Battery Pack · dischargedEMERGENCY LIGHTS FOR OVERWING W/N ILLUMINATE FOR ROW 25. REMOVED BATTERY PACK AND REPLACED BATTERIES, OP'S CK'S GOOD PER AMM 33-53.SDR DALA2018101005971Battery Pack · dischargedDURING INSPECTION FOUND EMERGENCY LIGHTS OUT ON FIRST CLASS ROWS 1-4, AND R1 OVERHEAD LIGHT, GALLEY SIDEWALL LIGHT AND LIGHT OUTSIDE. MAINTENANCE REMOVED AND REPLACED BATTERY PACK REF AMM 33-51. OPS CHECK GOOD.SDR 29GA2018101100001Power Supply · failedFLIGHT 0091 JAX/TPA REPORT: BACK LIGHT ABOVE RT FORWARD EMERGENCY EXIT SIGN INOP. CORRECTIVE ACTION: R/R 21LN EMERGENCY POWER SUPPLY IAW AMM 33-50-10-04-1. EMERGENCY LIGHTS OPS CHECK GOOD.SDR MASA2018100911439Battery · dischargedALL EMER LIGHTS INOP. RECHARGED BATTERIES OPS CKS GOOD.SDR MASA2018101011438Battery Pack · dischargedALL EMER LIGHTS INOP. RECHARGED LIGHTS.SDR I5EA2018101006Power Supply · inoperativeDISCREPANCY: POWER SUPPLY EMERGENCY LIGHT M1435 INOP AT 727G. CORRECTIVE ACTION: REMOVED AND REPLACED POWER SUPPLY AT STA 727GR, OPS CHECK GOOD REF AMM 33-51-51.SDR I5EA2018101005Battery Pack · dischargedDISCREPANCY: EMERGENCY LIGHT M1435 INOP AT 727G. CORRECTIVE ACTION: REMOVED AND REPLACED BATTERY PACK, OPS CHECK GOOD REF AMM 33-51-51.SDR DALA2018101005960Battery Pack · dischargedEMERGENCY EXIT SIGN INOP. REMOVED AND REPLACED BATTERY PACK B5-232 IAW AMM 33-51-03 OPS CK GOOD. (LP#4253574)SDR SWAA2018111326633Lens · looseRT OVER WING EMERGENCY EXIT DOOR AFT LIGHT LENS LOOSE. SECURED LENS PER AMM.SDR SWAA2018111326632Cover · brokenRT SIDE NR 4 BIN EMERGENCY LIGHT COVER BROKEN. R&R COVER PER AMM.SDR DALA2018102306248Powerpack · inoperative(AIRCRAFT 7006, L/P 4361533) EMERGENCY LIGHTS INOP ON SEVICE CHECK ZONE 3. REMOVED AND REPLACED POWER PACK AND BATTERY IAW WDM 33-51-14 AT LOCATION M33404.SDR SWAA2018101425934Light · brokenAISLE EMERGENCY LIGHT ASSEMBLY BROKEN INOP AT ROW 6. R&R FUSE PER AMM.SDR SWAA2018101425933Battery Pack · dischargedEMERGENCY LIGHT FUSE INOP AT LOCATION M1668. R&R BATTERY PACK PER AMM.SDR SWAA2018101425932Fuse · failedAISLE EMERGENCY LIGHT FUSE FAILED AT BS 500+20, RBL 30. R&R FUSE PER AMM.
Back to JASC 3350