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 AALA20161214012Charger · no testSEAT MOUNTED EMERGENCY LIGHTING DOES NOT ILLUMINATE DURING TEST AT SEATS 32H THROUGH 41H. REMOVED AND REPLACED BATTERY CHARGER ASSEMBLY AT ROW 41H. OPERATIONAL CHECKED GOOD.SDR AALA20161214010Lens · missingRIGHT OVERWING EMERGENCY EXIT LIGHT AT SEAT 15F IS MISSING THE LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161214009Lens · missingR2 DOOR EMERGENCY EXIT SIGN HAS A MISSING LENS COVER. REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20161214008Sign · detachedRIGHT OVERWING EMERGENCY EXIT SIGN IS DETACHED. SECURED THE EXIT SIGN IAW AMM 33-51-10. OPS CHECKED GOOD.SDR IPXA2016121311682Sign · missingEXIT LIGHT LENS MISSING AT FWD UPPER CORNER OF MAIN ENTRY DOOR. REPLACED THE LENS IAW MM 52-12-00, AND 52-11- 02-10A.SDR AALA20161213031Power Supply · faultyAIRCRAFT WAS NOT GROUNDED. DURING ACCOMPLISHMENT OF CARD 2908 THE EMERGENCY LIGHTS AT 12DEF OVERHEAD, ROWS 13, 14 AND 15 SEAT MOUNTED, AND ALL FOUR OVERWING EXIT LIGHTS FAILED BATTERY TEST. REMOVED AND REPLACED EMERGENCY POWER SUPPLIES M1694 AND M1695 IAW AMM SDR AALA20161213009Sign · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT AISLE SIGN AT ROW 21 IS DETACHED. SECURED EXIT SIGN. OPERATIONAL CHECK GOOD.SDR AALA20161211001Power Supply · faultyAIRCRAFT WAS NOT GROUNDED. DURING ACCOMPLISHMENT OF CARD 2908 THE EMERGENCY LIGHTS AT 12DEF OVERHEAD, ROWS 13, 14 AND 15 SEAT MOUNTED, AND ALL FOUR OVERWING EXIT LIGHTS FAILED BATTERY TEST. REMOVED AND REPLACED EMERGENCY POWER SUPPLIES M1694 AND M1695 IAW AMM SDR AALA201612129010Lens · missingAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT REPORTS SEAT 1C MISSING EMERGENCY LIGHT LENS. REPLACED LIGHT LENS PER CMM 25-40-06.SDR RAIA201612090002Bulb · inoperativeRIGHT OVERWING EMERGENCY LIGHT IS INOPERATIVE. R & R THE BULB, OPS CHECKED GOOD.SDR DALA2016121209788Battery · dischargedEMER CEILING LIGHTS ROW 17-19 INOP. REPLACED BATTERIES FOR B5-102 EMER LIGHTS REF AMM 33-53. OPS CHECK GOOD.SDR DALA2016121209771Light · not reportedEMERGENCY FLOOR LIGHTS AT SEATS 21B AND 23B. REPLACED FLOOR LIGHTS AT 21 AND 23 B AND EPL.SDR DALA2016121209769Cover · detachedDOOR 3 EXIT SIGN FELL OFF ON LANDING. RE-ATTACHED COVER.SDR 7C7A2016121100272Battery Pack · inoperativeTWO EMERGENCY EXIT LIGHTS INOPERATIVE. R & R THE BATTERY PACK. ALL EMERGENCY LIGHTS OPS CHECKED GOODSDR MASA2016121112542Battery Pack · inoperativeCABIN EMERGENCY LIGHTS INOPERATIVE. CHARGED THE BATTERIESSDR UIEA2016121201001Lamp · unsecureSEVERAL EXTERIOR EMERGENCY LIGHTS INOPERATIVE. CLEANED AND RESEATED THE LAMPS IAW AMM 33-51-00-715-200 & BSWPM 20-10-04. OPS CHECKED GOOD.SDR JJBA20161211014Battery · inoperativeSECOND EMERGENCY CEILING LIGHT INOPERATIVE. R & R THE NR 1 BATTERY ASSY, OPS TESTED GOOD.SDR YENA201612101093Light · failedFLT 1512, WHEN PERFORMING EMERGENCY LIGHT TEST, FWD ESCAPE SLIDE LIGHT FAULTED. FOUND THE L1 DOOR ESCAPE SLIDE FAULTY. R & R L1 DOOR SLIDE IAW AMM 25-62-44. PERFORMED OPS TEST OF EMERG LIGHT SYSTEM. OPS TEST PASSED.SDR DALA2016121209862Battery Pack · dischargedEMERGENCY LIGHT BATTERY DISCHARGED. R & R THE BATTERY PACK IAW AMM 33-51.SDR YENA201612101091Battery Pack · failedDURING ROUTINE MAINTENANCE, EPSU FIN 11WL FAILED BATTERY TEST. R & R THE EPSU BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR REXA2016121002465Lamp · inoperativeFOUR LAMPS INOPERATIVE IN GALLEY AND EMERGENCY EXIT SIGNS. REPLACED THE LAMPS. OPS CHECK OK IAW MM 33-51-00-710-802-A02.SDR AALA20161213017Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT L1 DOOR IS MISSING LENS COVER. INSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20161213016Sign · detachedAIRCRAFT NOT GROUNDED. R4 DOOR EMERGENCY EXIT SIGN IS DETACHED. REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161213015Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN BY SEAT 15F HAS A DETACHED LENS COVER. REINSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20161213014Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT ON FORWARD GALLEY WALL AISLE SIDE HAS A MISSING LENS COVER. INSTALLED LENS COVER AND SECURED BASE IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161213013Lens · brokenAIRCRAFT NOT GROUNDED. ESCAPE PATH LIGHTING ON SIDEWALL JUST AFT OF FORWARD GALLEY HAS A BROKEN LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA20161213011Power Supply · inoperativeAIRCRAFT NOT GROUNDED. OVERHEAD EMERGENCY LIGHT BY SEAT 8H IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY AT R2 DOOR IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161213010Sign · detachedAIRCRAFT GROUNDED. EMERGENCY EXIT AISLE SIGN AT ROW 21 IS DETACHED. SECURED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201612119005Power Supply · no testAIRCRAFT IN BASE MAINTENANCE. PASSENGER CABIN EMERGENCY POWER SUPPLY UNIT 12WL WILL NOT PASS TEST. REPLACED POWER SUPPLY PER AMM 33-51-38 AND AMM 33-51-00.SDR AALA201612119004Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 3C INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT PER CMM 25-25-53.SDR AALA201612119001Cover · unsecureAIRCRAFT WAS NOT GROUNDED. INFLIGHT REPORTS: EXIT LIGHT COVER 9L CAME OFF. RESECURED EXIT LIGHT COVER PER AMM 33-51-19.SDR SWAA2016121310443Light · brokenR2 DOOR EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT ASSEMBLY PER MM.SDR DALA2016121209819Light · inoperativeL2 EMERGENCY DOOR LIGHT. REPLACED LIGHT FILAMENT.SDR SWAA2016121210424Sign · brokenRT OVERWING EMERGENCY EXIT SIGN BROKEN. R&R SIGN PER MM.SDR DALA2016121209765Lamp · inoperativeEMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-50.SDR DALA2016121209758Battery Pack · inoperativeEMERGENCY LIGHTS ROWS 23-26 AND OVER WING CEILING EXIT SIGN LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK ON POWER SUPPLY IAW AMM 33-51. OPS CHECKED GOOD.SDR VQIA2017081000039Power Supply · failedDURING AN OVERNIGHT CHECK, FOUND SEATS 11, 12, 15, 16, AND 19-21, EMERGENCY LIGHTS INOPERATIVE. R & R 13WL POWER SUPPLY ASSY IAW AMM 33-51-38-00-00-02, OPS CHECKED, ACFT OK FOR SERVICE.SDR AALA201612109010Light · damagedAIRCRAFT WAS NOT GROUNDED. INOPERABLE SEAT MOUNTED EMERGENCY LIGHT ROW 13 LEFT. MAINTENANCE FOUND LIGHT ASSEMBLY DAMAGED AND WIRE BROKEN ON HARNESS. REPLACED LIGHT ASSY AND HARNESS OPERATIONAL CHECKED GOOD PER AMM 33-51-18 AND AMM SR33-007. (SEE AALA2016121090SDR AALA201612109002Sign · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED MAIN CABIN R1 DOOR SURROUND PANEL, EXIT IDENTIFIER SIGN AT 226CRW. REPLACED EXIT SIGN PER AMM 33-50-15 AND AMM 33-50-00.SDR AALA201612109001Sign · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED MAIN CABIN R2 DOOR SURROUND PANEL, EXIT IDENTIFIER SIGN AT 252HRW. REPLACED EXIT SIGN PER AMM 33-50-15 AND AMM 33-50-00.SDR RAIA201612090001Power Supply · inoperativeLEFT EXTERIOR FWD EMERGENCY LIGHT INOPERATIVE. R & R THE NR 1 BATTERY POWER SUPPLY, OPS CHECKED GOOD.SDR DALA2016121209790Light · inoperativeEMER CEILING LIGHTS FROM ROW 23 THRU 25 INOP. REPLACED EMER LIGHTS BATTERIES NO HELP. R&R BO B5104.SDR DALA2016121209789Battery Pack · dischargedBOTH LEFT AND RIGHT FWD OVERWING UPPER EMER EXIT LIGHTS INOP. REPLACED EMER LIGHT BATTERIES, NO HELP. R&R BP B5103. CKS OK.SDR DALA2016120909773Battery Pack · dischargedCABIN CEILING EMERGENCY STANDBY LIGHT INOP FROM ROW 22 TO 26. REPLACED BATTERY PACK IN THE OVERHEAD BIN 24 RT. LIGHT CHECKS NORMAL.SDR SWAA2016121210431Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT BULB INOP. R&R BULB IAW AMM.SDR SWAA2016121210430Lens · missingL1 DOOR EMERGENCY EXIT LIGHT LENS COVER MISSING ARROW. R&R COVER PER AMM.SDR SWAA2016121210429Battery Pack · dischargedEMERGENCY EXIT LIGHT INOP AT M1672. R&R BATTERY PACK PER AMM.SDR SWAA2016121210428Light · inoperativeL2 DOOR EMERGENCY EXIT LIGHT BULB INOP. R&R BULB IAW AMM.SDR SWAA2016121210417Sign · unsecureR2 DOOR EMERGENCY EXIT SIGN FELL OFF. R&R SIGN PER AMM.SDR SWAA2016121210416Cover · defectiveR1 DOOR EMERGENCY EXIT LIGHT LENS COVER MISSING ARROW. R&R COVER PER AMM.
Back to JASC 3350