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 YENA201903280165Battery Pack · failedDURING HEAVY MAINTENANCE, EPSU 12WL FOUND NOT WORKING DURING OPERATIONAL CHECKS; REF LHT NR 005000866220-0010. R & R EPSU 12WL IAW AMM 33-51-38-400-002-A OPS CK'D OAW AMM 33-51-38-710-052-B. CK'S GOOD.SDR AALA20190401001Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS AN ESPU SYSTEM TEST CLASS 1 FAULT. REMOVED AND REPLACED THE EMERGENCY POWER SUPPLY UNIT 11WL IAW AMM 33-51-38. OPS TEST GOOD.SDR AALA2019040199010Power Supply · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE FOUND SEVERAL EMERGENCY AISLE SEAT LIGHTS INOP. REMOVED AND REPLACED EPSU 11WL IAW AMM 33-51-38. ALL LIGHTS TEST OK. OK FOR SERVICE.SDR HNAA2019033000082Light · inoperativeNDIS 637 33-51 0022940 28MAR19 SBY CLOSE FWD EMERGENCY LIGHT ON RT SIDE INOP. FACT 28MAR19 10:24 SBY R & R FWD EMERGENCY LIGHT ON RT SIDE IAW AMM 33-50-10 P/N ON/OFF 8330012 LAMP.SDR REXA20192800340Light · inoperativeLT FWD EXTERNAL EMERGENCY LIGHT OUT. RELAMPED THE LT FWD EXTERNAL EMERGENCY LIGHT IAW AMM 33-51-15. OPS TEST GOOD. P/N 8GH002473-08.SDR AALA201903298002Charger · inoperativeTHE SEAT MOUNTED EMERGENCY LIGHTS WERE INOPERATIVE FROM ROWS 13B TO 23B. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK CHARGER AND BATTERY IAW AMM 33-51-07. OPS CHECKED NORMAL.SDR DALA2019032902015Light · unsecureEMERGENCY SEAT MOUNTED LIGHTING DAMAGED. SECURED EMERGENCY LIGHT AT SEAT 27F/G. SYSTEM OPERATION IS NORMAL.SDR IPXA2019032940564Light · inoperativeINSPECTION TYPE:N/A EMERGENCY EXIT SIGN HAS INOP BULB. RELAMPED EMERGENCY EXIT LIGHT PER AMM 33-51-00 OPS CHECK GOOD.SDR SWAA2019032931198Lens · missingLT AFT OVERWING EMERGENCY EXIT LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2019032931170Lens · missingAFT-FACING OVERWING EXIT SIGN LENS MISSING. R&R SIGN ASSEMBLY PER MM.SDR MASA2019032811786Light · inoperativeROW 6 OVHD EMER LIGHT INOP. PLACED ON MEL.SDR MASA2019032811784Light · inoperativeROW 1 AND 9 OVHD EMER FLOOD LT INOP. PLACED ON MEL.SDR MASA2019032811785Light · inoperativeROW 9 OVHD EMER FLOOD LT INOP. PLACED ON MEL.SDR SWAA2019042632028Housing · damagedDAMAGED EMERGENCY EXIT LIGHT HOUSING COMMON TO MID CABIN CEILING PANELS. / REPLACED EXIT LIGHT HOUSINGSDR SWAA2019041031557Lamp · inoperativeR/H FORWARD OVERWING EMERGENCY EXIT LIGHT ABOVE DOOR INOP. R&R LAMP IAW AMM.SDR DALA2019040752279Housing · detachedSEAT 16 DEF EMERGENCY LIGHT HOUSING NOT INSTALLED UNDER SEAT, REPLACED HOUSING ASSEMBLYSDR DALA2019040702275Light · detachedEMERGENCY FLOOR LIGHTING AT SEAT 19D FELL OFF, RESECURED LIGHT AT 19DSDR SWAA2019040231257Lens · crackedAFT LAVATORY EMERGENCY EXIT LIGHT LENS CRACKED. R&R LIGHT IAW AMM.SDR AALA2019040109001Power Supply · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTING CIDS EMERGENCY POWER SUPPLY UNIT FAILED 13WL. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR YENA2019040170162Battery Pack · failedFT # 740, LEFT OVERWING EMERGENCY POWER SUPPLY UNIT INOPERATIVE. R & R BATTERY EMERGENCY LIGHT AT 11 WL. OPS CHECK GOOD. IAW AMM 33-51-00. A/C OK TO CON'T SVC.SDR YENA2019040170161Lens · missingFWD BULKHEAD ESCAPE PATH LIGHT INOP AND MISSING RED COVER; REPLACED FWD BULKHEAD ESCAPE LIGHT LENS PER AMM 33-51-18. OPS CHK OK. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR ASAA2019032728809Lens · missingAFT CABIN OVERHEAD EXIT SIGN MISSING COVER. GROUNDED - YES. REPLACED AFT OVERHEAD EXIT LIGHT LENS / COVER. OPS CKS GOOD.SDR SCNA20190327030Lamp Socket · corrodedLT AFT OVERWING EMERGENCY EXIT LIGHT INOP, RT AFT GALLEY SERVICE DOOR (EXTERIOR) EMERGENCY EXIT LIGHT INOP. FOUND 465 OHMS OF RESISTANCE AT THE LAMP, CLEANED CORROSION FROM WIRE TERMINALS AND LAMP SOCKET. BOTH LIGHTS CHECK GOOD.SDR R61A201903270308Power Unit · inoperativeCENTER CABIN EMERGENCY LIGHT WILL NOT ILLUMINATE. R&R CENTER CABIN EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR U2RA201903270001Lens · missingRIGHT-HAND AFT OVER WING EMERGENCY HATCH EXIT SIGN MISSING LENS. INSTALLED LENS PER AIRCRAFT MAINTENANCE MANUAL CHAPTER 20-00-00.SDR AALA201903289016Battery · inoperativeFOUND THE FLASHLIGHT LED FLASHED RED AT THE R4 DOOR. MAINTENANCE REPLACED THE FLASHLIGHT BATTERY IAW AMM 25-64-01.SDR AALA201903289015Battery Pack · no testFOUND THE EMERGENCY LIGHT DID NOT WORK PROPERLY. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-29-12, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201903289011Cover · missingTHE L4 DOOR EXIT SIGN WAS INOPERATIVE. MAINTENANCE REPLACED THE EXIT SIGN COVER IAW AMM 33-40-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019032831146Light · inoperativeR2 DOOR EMERGENCY EXIT SIGN LIGHT BULB INOP. R&R LAMP PER AMM.SDR SWAA2019032831126Lens · missingRT EGRESS LIGHT LENS COVER MISSING AT ROW 17. R&R EMERGENCY LIGHT ASSEMBLY IAW AMM.SDR MASA2019032711782Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP. RELAMPED.SDR SWAA2019032731092Lens · missingRIGHT EGRESS LIGHT LENS MISSING AT ROW 17. R&R LIGHT ASSEMBLY PER MM.SDR FDEA2019032760720Charger · no testDURING POST FLIGHT MX WALKAROUND FOUND THE INTERIOR EMERGENCY EXIT LIGHT ABOVE THE L1 DOOR INOP. REPLACED BATTERY CHARGER CPN 3311913 AND BATTERY CPN 3301128 IN POS M731, EMERGENCY LIGHT ABOVE L1 SDR FDEA2019032760719Charger · no testDURING POST FLIGHT MX WALKAROUND FOUND EXTERIOR EMERGENCY EXIT LIGHT INOP AFT OF THE L1 DOOR . REPLACED BATTERY CHARGER CPN 3311913 AND BATTERY CPN 3301128 POS M731, EMERGENCY LIGHT AFT OF L1 SDR DALA2019040752281Battery Pack · inoperativeAFT EMERGENCY LIGHTS INOP, REPLACED EMERGENCY BATTERYPACK 13WLSDR DALA2019040702280Light · detachedSEAT 32D EMERGENCY FLOOR LIGHTING DAMAGED, RESECURED EMER LT AT SEAT 32DSDR DALA2019040702276Light · brokenSEAT 21D EMERG PATH LIGHT BROKEN, RE-ATTACHED EMERGENCY LIGHT ASSEMBLYSDR RAIA201903260002Light · looseFLOOR EMERGENCY LIGHT STRIP LOOSE AT 7A. RESECURED EMG LIGHT STRIP AT 7A.SDR DALA2019032702030Fuse · blownSHIP 654 DURING WALK THROUGH FOUND SEATS 1C 2C 3C EMERGENCY LIGHTS INOP. CORRECTIVE ACTION: FOUND BLOWN FUSE IN M730 EMERG LIGHTS PWR SUPPLY FOR SEATS 1CD 3CD. RPLCD FUSE PER AMM 33-51 OPS CKS GOOD. (5274584)SDR QXEA2019032900146Fastener · looseAFT OVERHEAD EXIT ANNUNICATOR PANEL FELL DOWN. REMOVED FROM SERVICE. FOUND QUARTER TURN FASTENER ON LENS COVER UNSECUERD. RE-SECURED LENS COVER. LIGHT OPS CK GOOD IAW AMM 33-51-00-710-803. A/C OK FOR SVC.SDR AALA201903289010Light · inoperativeEMERGENCY LIGHT AT THE AFT CARGO DOOR WAS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW 33-40-00.SDR DALA2019032701965Power Supply · no testEMERGENCY POWER SUPPLY UNIT 14WL WILL NOT SELF TEST. REPLACED EMERGENCY POWER SUPPLY UNIT. LP 5042861SDR DALA2019032701944Battery Pack · dischargedTHE EMERGENCY LIGHTS ARE NOT WORKING AT THE OVERWING EXIT ON ROW 20 AND THE OVERHEAD EXIT ON ROW 20/21. MAINTENANCE REPLACED THE EMERGENCY BATTERY PACK B5-230. OPERATIONAL CHECKS ARE GOOD IAW AMM 33-51. OK FOR SERVICE. (LP #5824949)SDR AALA201903279019Battery Pack · weakR4 DOOR EXIT SIGN WAS DIM. MAINTENANCE REPLACED THE BATTERY PACK M10801 IAW AMM 33-51-07, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201903279018Battery Pack · weakL4 DOOR EXIT SIGN WAS DIM. MAINTENANCE REPLACED THE BATTERY PACK M10801 IAW AMM 33-51-07, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019032731103Light · dimRT AISLE EMERGENCY EXIT LIGHT DIM AT SEAT 6. R&R LIGHT PER AMM.SDR SWAA2019032731102Switch · brokenAFT GALLEY EMERGENCY LIGHT SWITCH GUARD SPRINGS BROKEN. R&R SWITCH GUARD ASSEMBLY IAW CMM.SDR SWAA2019032731101Light · inoperativeRT EMERGENCY LIGHT INOP. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2019032731096Charger · failedR1 DOOR EMERGENCY LIGHTS WOULD NOT TEST. R&R BATTERY CHARGER PER AMM.SDR SWAA2019032731093Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.
Back to JASC 3350