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 SWAA2017022712117Lamp · inoperativeRIGHT EMERGENCY EXIT OVERWING DOOR SIDEWALL LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR DALA2017022401602Lens · missingEMERGENCY LIGHT MISSING A RED LENS AT THE R1 DOOR. INSTALLED THE RED LENS.SDR DALA2017022401593Lens · missingFOUND R1 AND L1 RED EMERGENCY LIGHT MISSING. REPLACED THE MISSING LENS.SDR AALA20170227011Battery Pack · inoperativeSEAT MOUNTED EMERGENCY LIGHTS AT SEATS 20H, 21H, AND 22H ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY M732 IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.SDR AALA20170227010Lens · detachedEMERGENCY LIGHT AT THE L4 DOOR HAS A DETACHED LENS. SECURED THE LENS IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170227009Power Supply · inoperativeEMERGENCY EXIT LIGHTS AT LEFT OVERHEAD BINS SEATS 16, 18, AND 21 ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY AT RIGHT SEAT 21 IAW AMM 33-51-06-201. OPERATIONAL CHECKED GOOD.SDR AALA20170227008Lens · detachedEMERGENCY EXIT SIGN AT R2 DOOR HAS A DETACHED LENS. SECURED THE LENS. OPS CHECKED GOOD.SDR AALA20170227006Lens · looseEMERGENCY EXIT LIGHT AT R1 DOOR HAS A LOOSE LENS. SECURED THE LENS IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170227002Battery Pack · no testEMERGENCY POWER SUPPLY UNIT AT 13WL FAILED TEST. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-38. OPERATIONAL CHECKED GOOD.SDR UIEA2017022400240Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE ROW 14-19. REMOVED AND REPLACED THE BATTERY PACK AT BS 774, SYS OPS CHECKED GOOD IAW AMM 33-51-10.SDR IPXA2017022414385Lamp · inoperativeCREW ENTRY DOOR EXIT SIGN HAS INOPERATIVE LAMPS. REPLACED THE LAMPS IAW AMM A300-33-51-13-0401. OPS CHECKED GOOD.SDR SWAA2017022712066Cover · detachedRIGHT AFT EMERGENCY EXIT COVER DETACHED. INSTALLED THE COVER IAW MM.SDR AALA201702249008Lens · missingSEAT ROW 16L MISSING EMERGENCY LIGHT LENS. REMOVED AND REPLACED SEAT MOUNTED EMERGENCY LIGHT.SDR AALA201702249007Cover · missingR4 DOOR EMERGENCY COVER MISSING. REPLACED AND SECURED EMERGENCY LIGHT COVER.SDR AALA201702249006Sign · inoperativeEMERGENCY EXIT SIGN OUT OVER THE L2 DOOR. REMOVED AND REPLACED DOOR 2L EMERGENCY EXIT SIGN. AIRCRAFT WAS GROUNDED.SDR AALA201702249005Cover · missingAFT COVER MISSING ON EMERGENCY LIGHT LOWER LEFT CORNER. REPLACED LIGHT COVER.SDR AALA201702249002Sign · missingEMERGENY EXIT SIGN MISSING BY AFT LAVATORY. REPLACED EMERGENCY EXIT SIGN LENS.SDR AALA201702249001Light · inoperativeEMERGENCY LIGHT 18L INOPERATIVE. REPLACED LIGHT IAW AMM.SDR MASA2017022312626Light · inoperativeROW 18 CEILING EMERGENCY LIGHT INOPERATIVE. RELAMPED.SDR FDEA201702230641Light · inoperativeON SERVICE CHECK, FOUND EMERGENCY LIGHT SYSTEM INOPERATIVE.SDR IPXA2017022414373Light · inoperativeLAVATORY EMERGENCY LIGHT IS BURNED OUT. R & R THE LIGHT IAW MM 33-51-21-0401. OPS OK.SDR 29GA2017022400001Bulb · inoperativeEMERGENCY EXIT LIGHTS INOPERATIVE. SECURED THE SWITCH AND LIGHT BULB IAW AMM 33-00-00, OPS CHECKED GOOD.SDR DALA2017022401525Power Supply · failedEPSU FWD LEFT UNIT FAILED LIGHT ILLUMINATED EMERGENCY LIGHT CHECK, REPLACED EPSU.SDR JJBA20170223016Bulb · inoperativeMAIN ENTRANCE CEILING EMERGENCY LIGHT IS INOPERATIVE. R & R THE BULBS, OPS CHECKED GOOD.SDR DALA2017022401519Power Supply · inoperativeLOWER SIDEWALL EXIT IDENTIFIERS AT BOTH AFT EMERGENCY OVERWING DOORS INOP. REPLACED B5-119 PWR SUPPLY & BATTERY PER B717 AMM 33-51. CKS GOOD PER AMM.SDR MASA2017022312625Light · malfunctionedALL EMERGENCY LIGHTS ON, WHEN ARMED.SDR YENA201702220115Power Supply · failedDURING ROUTINE MAINTENANCE, IT WAS FOUND THAT THE L2 & R2 LOWER EXIT MARKER LIGHTS INOPERATIVE. TROUBLESHOOTING FOUND PIN H OUTPUT DAMAGED ON ESPU 14WL. R & R THE EPSU IAW 33-51-38. OPS CHECKED PASSED.SDR YENA201702220114Battery Pack · failedDURING ROUTINE WEEKLY CHECK, FOUND L1 & R1 LOWER EXIT MARKER LIGHTS INOPERATIVE. REMOVED & REPLACED EPSU (10WL) & BATTERY ASSYS IAW AMM 33-51-38. OPS CHECK PASSED.SDR YENA201702220113Power Supply · failedDURING ROUTINE MAINTENANCE WEEKLY CHECK, FOUND L1 & R1 LOWER EXIT MARKER LIGHTS INOPERATIVE. REMOVED & REPLACED EPSU (10WL) & BATTERY ASSYS IAW AMM 33-51-38. OPS CHECKED PASSED.SDR YENA201702220112Power Supply · failedDURING ROUTINE MAINTENANCE, DURING WEEKLY CHECK FOUND L3 & R3 EMERGENCY LIGHTS EXIT MARKER LIGHTS ON DOORS INOPERATIVE. THE ESPU (12WL) SHOWING UNIT FAULT DURING BITE TEST. REMOVED & REPLACED THE ESPU (12WL) IAW AMM 33-51-38. OPS CHECKED GOOD.SDR SWAA2017022712153Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1975. R & R THE BATTERY IAW MM.SDR SWAA2017022712142Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R & R THE BATTERY PACK IAW MM.SDR SWAA2017022712107Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2017022712106Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2017022712105Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2017022712104Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2017022712095Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2017022712071Battery Pack · no testRIGHT OVERWING EMERGENCY LIGHT FAILED DEEP CYCLE CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017022712067Lens · missingAFT GALLEY WINDSCREEN EMERGENCY EXIT SIGN LIGHT LENS MISSING. INSTALLED THE LENS IAW MM.SDR AALA20170224029Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 10WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20170224026Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY R1 DOOR HAS A MISSING LENS COVER. REINSTALLED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170224024Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT UPPER L2 DOOR HAS A MISSING LENS COVER. REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170224015Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE LOWER FORWARD GALLEY HAS A DETACHED LENS COVER. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-53-01. OPERATIONAL CHECK GOOD.SDR AALA20170223003Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 12WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20170222030Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT R2 DOOR HAS A DETACHED LENS COVER. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170222008Battery · dischargedAIRCRAFT WAS NOT GROUNDED. AFT THREE EMERGENCY EXIT LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY IAW AMM 33-53-00-401. OPERATIONAL CHECK GOOD.SDR YENA201702220117Battery · no testDURING ROUTINE WEEKLY CHECK, A FAULTY EPSU BATTERY WAS FOUND. R & R THE BATTERY IAW AMM 31-51-00. OPS CHECK PASSED.SDR C77A20170224001Battery · defectiveR1 F/A FLASHLIGHT INOPERATIVE. R & R THE FLASHLIGHT BATTERY IAW SMPE 175-25-016 REV 1R. ACFT OK FOR SERVICESDR SCNA20170222054Light · missingTRACK LIGHTING HAS BUBBLES AND A GAP ROW 11 ABC. THE LIGHT IS MISSING AT ROW 4. REPAIRED.SDR ASOA201702225013Bulb · blownDURING MX INSPECTION THE RIGHT SIDE EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. MX REMOVED AND REPLACED THE BULB WITH OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.
Back to JASC 3350