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 YENA2018060410233Lamp · inoperativeDURING A WEEKLY CHECK, THE R1 DOOR EXIT LIGHT WAS NOT WORKING. REPLACED THE LAMPS IAW AMM 33-51-13. OPS CHECKED GOOD.SDR QXEA2018060101Power Supply · inoperativeEMERGENCY LIGHTS FOR THE SECONDED AND THIRD EXITS, AND CEILING LIGHT FROM FORWARD WERE INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW 33-51-01-000-801/400-801, REPLACED BOTH BATTERY PACKS AT SAME LOCATION IAW AMM 33-51-00-820-801. OPS TESTED GOOD.SDR DALA2018060103771Unknown · unknownTHE OVERHEAD EMERGENCY LIGHTS AT ROW 3, 12, 15, 18, 22, 26, AND AFT LAVATORY AREA WERE INOPERATIVE. OPS TESTED NORMAL AMM 33-51. AIRCRAFT OKAY FOR SERVICE.SDR SIMA2018060131004Light · inoperativeEMERGENCY LIGHT AT ROWS 7 & 8 WERE INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12. OPS CHECKED GOOD. NO DEFECTS NOTED.SDR CALA2018060601412Battery Pack · no testDURING AN EMERGENCY LIGHT BATTERY CAPACITY CHECK, FOUND THE R2 DOOR AREA BATTERY TO HAVE LOW CAPACITY. REPLACED THE BATTERY PACK M33098 & CHARGER. PERFORMED AN EMERGENCY LIGHT TEST, TESTED GOOD IAW AMM 33-51-06-960-802, & AMM 33-51-00-710-801, REV 82.SDR CALA2018060601411Lamp · inoperativeFOUND THE L2 DOOR SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP, OPS TESTED NORMAL IAW AMM 33-51-04-960-801, REV 82.SDR CALA2018060601410Light · crackedFWD FLOOR EMEGENCY LIGHT ASSY WAS CRACKED. REPLACED THE LIGHT ASSY, OPS TESTED NORMAL IAW AMM 33-51-00-710-801, AND AMM 33-51-05-960-802, REV 82.SDR CALA2018060601408Light · crackedLAVATORY RIGHT SIDE, AFT FLOOR EMERGENCY LIGHT ASSY WAS CRACKED. REPLACED EMERGENCY LIGHT ASSY. OPS TESTED NORMAL IAW AMM 33-51-00-710-801, REV 82, AND AMM 33-51-05-960-802, REV 82.SDR CALA2018060601407Light · crackedLEFT SIDE AFT LAVATORY FLOOR EMERGENCY LIGHT ASSY WAS CRACKED. REPLACED THE EMERGENCY LIGHT ASSY, OPS TESTED NORMAL IAW AMM 33-51-00-710-801, REV 82, & AMM 33-51-05-960-802, REV 82.SDR CALA2018060601406Light · crackedLEFT SIDE, FWD FLOOR EMERGENCY LIGHT ASSY WAS CRACKED. REPLACED THE EMERGENCY LIGHT ASSY. OPS TESTED NORMAL IAW AMM 33-51-00-710-801, REV 82, & AMM 33-51-05-960-802, REV 82.SDR AALA201806051005Power Supply · no testEMERGENCY LIGHTS AT THE LEFT AISLE, SEATS 1 - 6, FAILED TO CHECK. REMOVED AND REPLACED THE POWER SUPPLY M33044 IAW AMM 33-51-06-960-803. OPERATIONS CHECK GOOD.SDR AALA201806051004Power Supply · no testEMERGENCY LIGHT POWER SUPPLY M33099 FAILED A CHECK. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-803. OPS CHECKED GOOD.SDR SWAA2018060522537Lens · crackedRT MID CABIN EMERGENCY EXIT SIGN LENS CRACKED. R&R LENS PER AMM.SDR SWAA2018060522464Charger · inoperativeCEILING EMERGENCY EXIT LIGHT INOP AT ROW 11. R&R CHARGER ASSEMBLY PER AMM.SDR AALA2018060519017Light · inoperativeSEAT 1C MOUNTED EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE LIGHT IAW AMM 33-51-19. OPS CHECKED NORMAL.SDR AALA201806041010Power Supply · no testEMERGENCY LIGHT POWER SUPPLY M33406 AT THE L3 DOOR FAILED TO TEST. REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-803. OPS CHECKED GOOD.SDR AALA201806041008Power Supply · no testEMERGENCY LIGHT POWER SUPPLY M33405 ABOVE THE L3 DOOR FAILED TO TEST. REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-803. OPS CHECKED GOOD.SDR AALA201806041011Power Supply · no testEMERGENCY LIGHT POWER SUPPLY UNIT M33409 FAILED TO TEST. REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-803.SDR SWAA2018060422461Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01672. R&R BATTERY PACK PER AMM.SDR SWAA2018060422459Battery Pack · dischargedR1 DOOR EXIT LIGHT INOP. R&R BATTERY PACK PER MM.SDR SWAA2018060422454Light · inoperativeLT OVERWING EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018060422426Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01669. R&R BATTERY PACK PER AMM.SDR SWAA2018060422425Sign · looseMID CABIN CEILING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER AMM.SDR DALA2018060103799Lens · unsecureEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS: 3C. SEAT MOUNTED EMERGENCY LIGHT AT 3C IS DAMAGED/ PUSHED IN/ INTERIOR. RESECURED SEAT 3C SEAT MOUNTED EMERGENCY PATH LIGHT LENS AS REQUIRED; OPS CHECK NORMAL.SDR DALA2018060103798Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:302. RED EMERGENCY PATH LIGHT ON THE AISLE EDGE OF THE 1R CLOSET IS DAMAGED / INTERIOR. RESECURED RED EMERGENCY PATH LIGHTING LENS AS REQUIRED; OPS CHECK NORMAL.SDR AALA2018060419005Lamp · burned outSIGN INOPERABLE AT ROW 5. REPLACED THE LAMPS IAW AMM 33-24-00.SDR AALA2018060419004Light · brokenCOVER FOR THE EMERGENCY LIGHT IN THE FORWARD ENTRY GALLEY AREA, MISSING SOME CONNECTION TABS CAUSING COVER TO FALL OFF ON OCCASION. REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-14.SDR REXA2018053100430Lens · missingOVERHEAD EMERGENCY EXIT ROW SIGN LENS WAS MISSING. SECURE THE EMERGENCY LIGHT LENS.SDR REXA201806010429Battery Pack · inoperativeEMERGENCY LIGHT IN CENTER CABIN DOES NOT STAY ILLUMINATED. REMOVED & REPLACED THE BATTERY PACKS PS37 & PS38 IAW AMM 33-51-17. OPS CHECKED GOOD. REMOVED & REPLACED PS37 BATTERY CHARGER IAW AMM 33-51-17. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR AALA201806019007Guard · looseP5 PANEL EMERGENCY LIGHT SWITCH GUARD LOOSE. TIGHTENED LIGHT SWITCH GUARD, OPS CHECKED GOOD IAW STANDARD INDUSTRY PRACTICE.SDR AALA201806019010Guard · brokenEMERGENCY LIGHT SWITCH GUARD BROKEN. MAINTENANCE REPLACED LIGHT SWITCH GUARD AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR R61A2018060010623Module · faultedEMERGENCY LIGHT BATTERY FAULT. R & R DISCRETE I/O MODULE SPDA 1 SLOT 11 IAW AMM 24-61-05.SDR IPXA2018060130224Bulb · inoperativeEMERGENCY LIGHT IN THE LAVATORY, BULBS WERE OUT. REPLACED THE BULBS IAW AMM 33-51-21.SDR SIMA2018060131007Light · inoperativeEMERGENCY LIGHTS 4 AND 6 WERE INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHTS IAW AMM 33-50-12. OPS CHECKED GOOD IAW AMM 33-50-12-400-801.SDR SIMA2018060131003Light · inoperativeLEFT AFT OVERWING EMERGENCY LIGHT WAS INOPERATIVE. R & R THE LIGHT IAW AMM 33-50-07 , OPS CHECKED GOOD.SDR MASA2018060113282Light · inoperativeROW 21 OVERHEAD EMERGENCY FLOOD LIGHT WAS INOPERATIVE.SDR DALA2018053103719Battery Pack · inoperativeAFT EMERGENCY LIGHTS WERE INOPERATIVE. R & R THE BATTERY PACK AND POWER SUPPLY IAW AMM 33-51-03-401. OPS CHECKED GOOD.SDR MASA2018053113280Battery Pack · dischargedNUMEROUS INTERIOR EMERGENCY LIGHTS WERE INOPERATIVE. ALLOWED BATTERIES TO CHARGE AND THE LIGHTS TESTED NORMALLY.SDR SWAA2018060522484Lens · brokenRT EMERGENCY EXIT LENS ASSEMBLY BROKEN AT ROW 18. R&R LENS PER SIP.SDR CALA2018060531387Battery · no testDURING AN EMERGENCY LIGHTS TEST, FOUND THE L4 DOOR EXIT SIGN INOPERATIVE. REPLACED THE BATTERY PACK M33407, & PERFORMED AN EMERGENCY LIGHT TEST. TESTED GOOD IAW AMM 33-51-06-960- 802, & AMM 33-51-00-710-801, REV 82.SDR CALA2018060531386Battery · dischargedDURING AN EMERGENCY LIGHTS TEST, FOUND THE R3 DOOR EXIT SIGN INOPERATIVE. REPLACED THE BATTERY PACKS M33404, & M33401. PERFORMED AN EMERGENCY LIGHT TEST IAW AMM 33-51-06-960-802, & AMM 33-51 -00-710-801, REV 82. TESTED GOOD.SDR CALA2018060501385Battery Pack · dischargedDURING AN EMERGENCY LIGHTS TEST, FOUND AN EXIT SIGN INOPERATIVE. REPLACED THE BATTERY PACKS M33400 & M33405. CARRIED OUT AN EMERGENCY LIGHT TEST, TESTED GOOD IAW AMM 33-51-06-9 60-802, & AMM 33-51-00-710-801, REV 82.SDR CALA2018060501384Battery Pack · dischargedDURING AN EMERGENCY LIGHT CAPACITY TEST, FOUND ZONE 1 RT CEILING EMERGENCY LIGHT BATTERY TO HAVE LOW CAPACITY. REPLACED THE BATTERY PACK M33094 & PERFORMED AN EMERGENCY LIGHT TEST. TESTED GOOD IAW AMM 33-51-06-960-802, & AMM 33- 51-00-710-801, REV 82.SDR CALA2018060501383Battery · dischargedDURING AN EMERGENCY LIGHTS TEST, FOUND THE R4 DOOR EXIT SIGN INOPERATIVE. REPLACED THE BATTERY PACKS M33408 & M3309. PERFORMED AN EMERGENCY LIGHT TEST, TESTED GOOD IAW AMM 33-51- 06-960-802, & AMM 33-51-00-710-801, REV 82SDR SWAA2018060422456Lens · missingR2 DOOR EXIT SIGN LENS MISSING. INSTALLED LENS PER AMM.SDR SPAA2018060400502Light · inoperativeAFT CABIN OVERHEAD EMERGENCY EXIT LIGHT INOPERATIVE.SDR SPAA201806040001Light · inoperativeOVERWING EMERGENCY EXITS LIGHTS INOPERATIVE.SDR AALA201806019003Power Supply · no testEMERGENCY SUPPLY POWER 10WL FAILED DURING OPERATIONAL TEST. REPLACED THE EPSU AND BATTERY IAW AMM 33-51-38.SDR DALA201806013760Battery Pack · weakEMERGENCY LIGHTS AT SEATS 43 - 45 ONLY ILLUMINATE FOR LESS A MINUTE. REPLACED THE BATTERY PACK AT POWER SUPPLY M9102 IAW AMM 33-51.SDR AALA201805319017Light · brokenSEAT 9 RIGHT EMERGENCY LIGHT WAS FOUND BROKEN. REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW 33-51-18. OPS CHECKED GOOD.
Back to JASC 3350