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 AALA20161215002Battery Pack · dischargedAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHTING IS VERY DIM ON SEATS 26D THROUGH 36D. REMOVED AND REPLACED AFT POWER SUPPLY BATTERY PACK IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR DALA2016121509886Battery Pack · inoperativeFORWARD EMERGENCY LIGHT AT THE L1 AND R1 DOORS INOPERATIVE. REPLACED BATTERY PACK IAW AMM 33-55. OPS CHECKED GOOD.SDR DALA2016121509882Battery Pack · inoperativeCEILING EMERGENCY LIGHTS INOPERATIVE AT ROW 26-28. REPLACED THE BATTERY PACKS IAW AMM 33-53. OPS CHECKED GOOD.SDR ASOA201612141358Bulb · burned outRIGHT WING FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-51-15. OPS CHECKED GOOD.SDR SWAA2016121910572Light · inoperativeRT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOP. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2016121910545Light · inoperativeLT OVERWING ESCAPE HATCH EMERGENCY LIGHT IN MID PASSENGER CABIN INOP. RESEATED LIGHT IAW AMM.SDR IPXA2016121411750Control Panel · malfunctionedEMERGENCY LIGHTS REMAIN ON WHEN SELECTED TO DISARM. R & R 436VU PANEL IAW AM 31-14-00. SYSTEM OPS CHECKED NORMAL.SDR DALA2016121509952Bulb · inoperativeTWO BULBS INOPERATIVE AT R1 DOOR EMERGENCY EXIT. REMOVED AND REPLACED THE BULBS. OPERATION CHECKED OKAY.SDR DALA2016121609922Power Supply · inoperativeUPPER DECK CEILING EMERGENCY LIGHTS BETWEEN SEAT 73 WILL NOT TURN-OFF AFTER 20 SEC. REPLACED BATTERY-POWER SUPPLY AT M335. FUNCTIONAL CHECK OK AS PER B747-400 AMM 33-51. AFFECTED LTS STAY ON AFTER 20 SEC. (7856385)SDR DALA2016121609920Charger · inoperativeAFT GALLEY 4 CTR EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY CHARGER IAW AMM 33-51.SDR AALA201612159008Cover · missingFLIGHT ATTENDANT REPORTS PLASTIC COVER OVER EMERGENCY EXIT 4L DOOR MISSING. REPLACED EXIT LIGHT COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR MASA2016121412551Light · inoperativeEMERGENCY PHOTO LIGHT STRIP UNDER COAT CLOSET INOP. PLACED ON MEL.SDR MASA2016121412550Battery · dischargedALL CABIN EMER LIGHTS INOP. CHARGED BATTERIES.SDR SIMA20161214001Light · inoperativeSERVICE DOOR CEILING EMERGENCY LT INOP. R&R SERVICE DOOR EMERGENCY LIGHT LAMP IAW AMM 33-50-09-000-801-A & 33-50-09-400-801-A. OPS CHECK GOOD AT THIS TIME.SDR AALA20161215019Sign · detachedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN OVER WING EXIT IS DETACHED FROM CEILING MOUNT. RESECURED EXIT SIGN. OPERATIONAL CHECK GOOD.SDR AALA20161215017Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT AFT GALLEY HAS A DETACHED LENS COVER. REINSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161215015Sign · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT R1 DOOR IS BROKEN. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-16. OPERATIONAL CHECK GOOD.SDR AALA20161215009Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT R2 DOOR IS MISSING THE LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201612159007Lens · crackedAIRCRAFT IN BASE MAINTENANCE. L4 EXIT LIGHT LENS CRACKED. REPLACED EXIT LIGHT LENS PER AMM 33-51-16.SDR AALA201612159005Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. DOOR 2L EMERGENCY EXIT SIGNS, DOOR AND OVERHEAD PATHWAY SIGN, INOPERABLE DURING OPERATIONS CHECK. REPLACED EMERGENCY POWER SUPPLY UNIT 13WL PER AMM 33-51-38 AND AMM 33-51-00.SDR SWAA2016121510535Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1672. R&R BATTERY PER AMM.SDR SWAA2016121510534Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1670. R&R BATTERY PER AMM.SDR SWAA2016121510533Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R&R BATTERY PER AMM.SDR SWAA2016121510516Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1669. R&R BATTERY PER AMM.SDR SWAA2016121510509Sign · defectiveL2 DOOR EMERGENCY LIGHT EXIT SIGN MISSING ARROW. R&R SIGN PER AMM.SDR FDEA201612144446Control Panel · failedDURING PREFLIGHT, FOUND OVERHEAD EMERGENCY LIGHT SWITCH INOP. REPEAT WRITE UP. SWAPPED EMERGENCY LIGHT/PASENGER OXY CONTROL PANEL PER MM 33-51-08-4. PERFORMED TEST PER MM 33-51-00-05.SDR FDEA201612144426Module · defectiveREPEAT WRITE UP-UNARMED LIGHT DOES NOT ILLUMINATE WHEN COCKPIT OVERHEAD EMERGENCY LIGHTS SWITCH PLACED TO OFF POSITION. R&R BOTH OF FUSE DIODE MODULE AND LENS CAP ASSEMBLY PER STANDARD WIRING PRACTICES MANUAL 20-84-18. OPS CHECK GOOD. A/C OK FOR SERVICE.SDR FDEA201612144425Light · not seatedEMERGENCY EXIT 'UNARMED' LIGHT DOES NOT ILLUMINATE WHEN EMERGENCY LIGHT SWITCH IS POSITIONED TO OFF. LIGHT CHECKS OK WHEN LIGHTS ARE TESTED, ITS NOT A BURNT OUT BULB. EMERGENCY 'UNARMED' CAUTION LIGHT FILAMENTS RESEATED. EMERGENCY LIGHTS TESTED FROM PILOTS SDR AALA20161214025Pin · shearedEMERGENCY EXIT SIGN AT LEFT FORWARD SIDE OF L3 DOOR IS DETACHED DUE TO ATTACHMENT PIN SHEARED. REMOVED AND REPLACED PIN IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20161214014Sign · brokenEMERGENCY EXIT MARKER ON R1 DOOR IS BROKEN. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-16. OPERATIONAL CHECKED NORMAL.SDR IPXA2016121311722Relay · inoperativeEXIT LIGHT OVER L1 DOOR INOPERATIVE. R & R 69WL 107VU RELAY IAW ESPM 20-46-50. OPS CHECKED GOOD.SDR SWAA2016121910683Light · inoperativeRT EMERGENCY EXIT AREA LIGHT INOP AT ROW 22. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2016121910615Fuse · blownEMERGENCY EXIT SIGN LIGHT BATTERY PACK M1672 INOP. R&R FUSES IAW WDM & AMM.SDR SWAA2016121910614Light · inoperativeRT OVERWING LOWER EMERGENCY EXIT SIGN INOP. R&R LIGHT IAW AMM.SDR SWAA2016121910613Light · inoperativeLT EMERGENCY EXIT AREA LIGHT INOP BETWEEN ROW 14 TO ROW 24. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2016121910561Fuse · blownL2 DOOR EMERGENCY EXIT SIGN LIGHT BATTERY PACK ON LOWER AFT LAV NEAR INOP. R&R FUSES IAW WDM.SDR SWAA2016121910560Fuse · blownR2 EMERGENCY EXIT SIGN LIGHT BATTERY PACK INOP. R&R FUSES IAW WMD & AMM.SDR AALA201612149014Light · unsecureEMERGENCY EXIT LIGHT UNSECURE. MAINTENANCE SECURED THE EMERGENCY LIGHT AND TRIM AT SEAT 9D AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161214003Power Supply · inoperativeEMERGENCY EXIT LIGHT AT L3 DOOR IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT M33405 IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161214002Power Supply · inoperativeEMERGENCY EXIT LIGHT AT L2 DOOR TRANSITION PANEL IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT M33099 IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161214001Power Supply · failedEMERGENCY POWER SUPPLY UNIT M33424 FAILED CAPACITY CHECK. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR R61A201612130733Light · inoperativeCREW REPORTED THAT THE EMERGENCY LIGHT IN ROW 9 WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM AND OPS CHECKED GOOD.SDR A6WA2016121644663Light · inoperativeFLOOR LEVEL EMERGENCY LIGHTS DOES NOT ILLUMINATE FROM ROW 7 TO AFT OF ACFT.SDR AALA20161215005Mount Bracket · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN MOUNTING BRACKET BROKEN IN AISLE BY SEAT 24J. REMOVED AND REPLACED MOUNTING BRACKET. OPERATIONAL CHECK GOOD.SDR DALA2016121409895Light · inoperativeDURING INSPECTION FOUND EMERGENCY FLOOR PATH LIGHT AT SEAT 16D INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY FLOOR PATH LIGHT AT SEAT 16D. OPS CKS GOOD PER AMM 33-51.SDR SCNA20161215330Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 3 ABC. REMOVED AND REPLACED THE EMERGENCY LIGHT. OK FOR SERVICE.SDR SWAA2016121510526Lens · crackedLT EMERGENCY LIGHT LENS CRACKED AT ROW 2. R&R LENS IAW AMM.SDR SWAA2016121510510Light · inoperativeLT EMERGENCY BULLNOSE LIGHT INOP AT ROW 2. RELAMPED LIGHT IAW SWPM.SDR UHLA201612130507Light · brokenFLOOR EMERGENCY LIGHT ON LEFT SIDE IS BROKEN. R & R IAW AMM 33-50-21-4. PERFORMED OPERATIONAL TEST IAW AMM 33-50-21. NO FURTHER DEFECTS NOTED.SDR ASAA2016121319028Battery Pack · failedINTERIOR EMERGENCY LIGHTS INOPERATIVE RIGHT SIDE OF PASSENGER CABIN, INCLUDING R2 DOOR AREA. ACFT GROUNDED. REPLACED THE BATTERY PACK & POWER SUPPLY IAW AMM 33-51-51. OPS NORMAL.
Back to JASC 3350