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 FDEA201610253684Sign · malfunctionedCENTER CEILING EXIT SIGN AND R1 DOOR EXIT SIGN DO NOT ILLUMINATE DURING EMERGENCY LIGHT TEST. EMERGENCY LIGHTS OP CHECKS GOOD IAW MM 33-51-00-5. OK FOR SERVICE.SDR FDEA201610253683Light · malfunctionedEXTERIOR EMERGENCY LIGHT BEHIND R1 DOOR NOT ILLUMINATED DURING EMERGENCY LIGHT TEST. EMERGENCY LIGHTS OP CHECKS GOOD. IAW MM 33-51-00-5. OK FOR SERVICE.SDR DALA2016102507547Battery Pack · inoperativeEPSU BATTERY FAULT AT L1 DOOR, REPLACED BATTERY PACKSDR DALA2016102507500Lens · missingDURING LINE CHECK, MAINTENANCE FOUND THAT THE AFT CABIN DOOR EMERGENCY EXIT SIGN LOST THE LENS/COVER. MAINTENANCE REPLACED THE LENS/COVER AND THE OPERATIONAL CHECK WAS GOOD.SDR DALA2016110108087Switch · brokenEMERGENCY LIGHT SWITCH BROKEN. REPLACED AND TESTED SWITCH.SDR DALA2016110108086Switch · brokenEMERGENCY LIGHT SWITCH ON THE P40 PANEL BROKEN. REINSTALLED SPRINGS ON EMERGENCY SWITCH GUARD AS REQUIRED.SDR AALA201610259022Light · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT, FLOOR LIGHT STRIP AT SEAT 17 IS COMING UP. RESECURED LIGHT STRIP AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201610259020Lens · crackedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHT LENS IS CRACKED AT 5C. REPLACED LENS PER AMM 33-51-19.SDR SWAA2016102609094Light · inoperativeRT OVERWING HATCH INTERIOR EMERGENCY EXIT LIGHT BULB INOP. R&R BULB IAW AMM.SDR AALA20161026014Light · inoperativeAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT R1 DOOR INOPERATIVE. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161026013Light · inoperativeAIRCRAFT NOT GROUNDED. SEAT MOUNTED EMERGENCY EXIT LIGHT AT SEAT 28D INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20161025008Contact · faultyAIRCRAFT WAS IN BASE MAINTENANCE. CABIN G3 GALLEY EMERGENCY LIGHT FOUND INOPERATIVE. RETERMINATED QUICK DISCONNECT CONTACT, REINSTALLED LIGHT ASSEMBLY AND ACCOMPLISHED OPERATIONAL TEST IAW AMM 33-51-05 AND 33-51-00. SYSTEM CHECKS NORMAL.SDR AALA20161025006Sign · inoperativeAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT DOOR L3 INOPERATIVE. SECURED EXIT SIGN COVER. OPERATIONAL CHECK GOOD.SDR DALA2016102507642Lens · wrong partEMERGENCY ESCAPE LIGHTS AT SEAT 26B LENS INCORRECT COLOR. REPLACED CLEAR LENS WITH RED LENS. SYSTEM OPERATION IS NORMAL.SDR DALA2016102507634Lamp · inoperativeEXIT SIGNS ARE INOPERATIVE. REPLACED THE LAMPS. SYSTEM OPERATION IS NORMAL.SDR SIMA20161024002Battery Pack · inoperativeFWD EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE NR 2 EMERGENCY LIGHT POWER SUPPLY BATTERY PACK IAW AMM 33-50-04 AND OPS CHECKED IAW W/C 33-700-17. TESTED SATISFACTORY.SDR DALA2016102507558Lens · looseEMERGENCY LIGHT LENS COVER CENTER AISLE AFT OF OVERWING EXIT CAME LOOSE. REPLACED THE SIGN ASSY IAW AMM 33-51.SDR DALA2016102507557Lens · missingEMERGENCY LIGHT LENS COVER, CENTER AILSE AFT OF OVERWING EXIT MISSING. INSTALLED EXIT SIGN LIGHT LENS PER AMM 33-51.SDR DALA2016102507555Housing · brokenROW 18 DEF EMERGENCY CASE BROKEN. REMOVED AND INSTALLED A NEW LIGHT CASE, OPS CHECKED GOOD.SDR SWAA2016102509076Lens · looseFORWARD ENTRY EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER AMM.SDR SWAA2016102509074Battery Pack · dischargedEXTERIOR LT EMERGENCY LIGHTS AFT OF THE WING INOP AT ROW 17. R&R BATTERY PACK IAW AMM.SDR SWAA2016102509071Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT ROW 27. INSTALLED LENS PER SIP.SDR DALA2016102507548Battery Pack · no testEMERGENCY LIGHT TEST, EPSU L FWD FAULTED, R & R EPSU BATTERY PACKSDR DALA2016102407529Battery Pack · dischargedEMERGENCY LIGHT INOP FROM ROW 31 TO TAIL. REPLACED BATTERY PACK. OPS CKS GOOD.SDR KCSA201610241089Light · inoperativeEMERGENCY LIGHT INOPERATIVE IN STAIRWAY CEILING, GOING FROM MAIN DECK TO UPPER DECK.SDR CALA2016102400813Lens · missingEMERGENCY LIGHT OUT AT 1B. FOUND FWD CLOSET AFT EMERGENCY LIGHT LENS MISSING, LIGHT OPS NORMAL. REPLACED LENS.SDR CALA2016102400810Light · inoperativeRIGHT AISLE EMERGENCY LIGHT INOPERATIVE IN SEAT 5D. REMOVED AND REPLACED THE EMERGENCY LIGHT. OPS GOOD.SDR HNAA2016102400328Bulb · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 4. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR 29EA2016102400001Power Supply · faultyDURING DAILY CHECK FOUND L1 DOOR ENTRY EMERGENCY LIGHT INOPERATIVE. TROUBLESHOOTING FOUND EMERGENCY POWER SUPPLY FAULTY. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06 OPS CHECKED NORMAL.SDR DALA2016110108082Lens · missingFOUND MISSING LENSES FOR EMRGENCY LIGHT AT SEAT 2C, 7B, 10C, 11C, 12D. INSTALLED THE LENSES.SDR DALA2016102507763Lens · damagedR2 EMERGENCY EXIT SIGN DAMAGED. REPLACED LENS.SDR VNAA2016102300027Battery Pack · inoperativeMIDSHIP FORWARD EMERGENCY LIGHT INOPERATIVE. MAINTENANCE INSPECTED, REMOVED AND REPLACED THE NR TWO EMERGENCY LIGHT BATTERY AND PERFORMED CHECKS IAW THE AMM. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR DALA2016102407727Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP. SYSTEM OPERATION IS NORMAL.SDR SCNA20161023249Light · inoperativeSEAT 24DEF OVERHEAD BIN EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED M1672 EMERGENCY EXIT LIGHT BATTERY PACK AND POWER SUPPLY. OPS CHECKED GOOD. OK FOR SERVICE.SDR JJBA20161023032Relay · defectiveEMERGENCY LIGHTS FLICKERING IN FLIGHT AND DURING TAXI. R&R RELAY 2431-K19. OPS CHECK SAT. NO DEFECTS NOTED.SDR DALA2016102507633Light · inoperativeON WAKE UP CHECK, FOUND SLIDE LIGHT AT DOOR R1 NOT ILLUMINATED WHEN ARM/DISARM LEVER IS SELECTED TO ARM. REPLACED THE LAMPS, NO HELP.SDR DALA2016102407586Unknown · malfunctionedDURING CHECK FOUND EXIT LIGHTS ALWAYS ON. RESET CIDS 1 AND 2, OPERATIONAL CHECK OK.SDR AALA201610259017Cover · missingAIRCRAFT WAS NOT GROUNDED. MISSING AFT LEFT EXIT DOOR LIGHT COVER. REPLACED LIGHT COVER.SDR AALA201610249003Cover · brokenAIRCRAFT WAS NOT GROUNDED. LEFT EXIT LIGHT COVER BROKEN AT ROW 27 A THRU C. REPLACED EXIT LIGHT COVER PER AMM 33-50-00.SDR AALA201610249002Cover · missingAIRCRAFT WAS NOT GROUNDED. MISSING AFT RIGHT EXIT DOOR LIGHT COVER. REPLACED LIGHT COVER.SDR SIMA20161023005Connector · disconnectedTWO EMERGENCY LIGHTS RT AFT OVERWING INOPERATIVE. CONNECTED P876 CONNECTOR FOR RH O/W EMERGENCY EXIT LIGHT. OP TEST GOOD IAW 33-51-15-710-801.SDR RAIA201610230001Light · wornEMERGENCY LIGHT STRIP WORN BY 1A. R & R THE EMERGENCY LIGHT STRIP.SDR SWAA2016102509069Battery · low voltageFORWARD ENTRY OVERHEAD EMERGENCY BATTERY PACK M01675 LOW VOLTAGE. R&R BATTERY PACK IAW AMM.SDR DALA2016102407546Battery Pack · no testDURING EMERGENCY LIGHT TEST, A PTP MESSAGE EPSU BATTERY AFT LEFT. R & R EPSU BATTERY.SDR N6WA2016102301Bulb · inoperativeEMERGENCY EXIT LIGHT LOWER LEFT TWO BULBS WERE OUT. R & R THE BULBS IAW 33-51-05. OPS CHECKED GOOD.SDR SWAA2016102409058Light · inoperativeRT AFT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2016102409051Battery Pack · dischargedLT FORWARD OVERHEAD BIN EMERGENCY LIGHT INOP A ROW 7. R&R BATTERY PACK PER AMM.SDR AALA20161024002Power Supply · failedEMERGENCY POWER SUPPLY UNIT AT ZONE 15WL FAILED DURING EMERGENCY LIGHTS CHECK. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR SIMA20161023001Light · inoperativeEMERGENCY LIGHTS STRIP INOPERATIVE SEATS 7-11.SDR SIMA20161023002Charger · inoperativeEMERGENCY LIGHTS INOPERATIVE AT SEATS 7-11. REMOVED AND REPLACED THE NR 3 EMERGENCY POWER SUPPLY AND BATTERY PACK IAW AMM 33-50-04. OPS CHECKED GOOD.
Back to JASC 3350