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 AALA201808019009Lens · missingSEAT 11C MOUNTED EMERGENCY LIGHT LENS WAS MISSING. REPLACED THE LENS IAW AMM 33-51-19.SDR AALA2018080219011Battery · dischargedAFT LEFT EMERGENCY POWER SUPPLY UNIT BATTERY INOPERATIVE IAW EMERGENCY SYSTEM TEST. REPLACED AFT LEFT EMERGENCY POWER SUPPLY BATTERY IAW AMM 33-51-33. OPS TESTED GOOD.SDR AALA201808019012Guard · out of adjustEMERGENCY LIGHT SWITCH DOES NOT ARM WHEN CLOSING THE RED GUARD. THE SWITCH STAYS IN OFF POSITION WHEN THE RED GUARD IS CLOSED. ADJUSTED THE EMERGENCY LIGHT SWITCH GUARD CENTERING BAR. OPS CHECKED NORMAL IAW AMM 33-51-00.SDR 2DYA2018080131003Battery Pack · dischargedDURING DAILY CHECK INSPECTION, MECHANIC FOUND SEVERAL (6)EXTERIOR EMERGENCY LIGHTS INOPERATIVE. PERFORMED T/S AS PER FIM 33-51 FAULT TREE 804. REMOVED AND REPLACED BATTERY PACK M733. M736, AND M738 PER AMM 33-51-07. OPS CHECK GOOD.SDR SIMA2018080131002Light · inoperativeFOUND LT REAR EXTERNAL EMERGENCY LIGHT TO BE INOP. REPLACED LIGHT IAW AMM 33-50-10. OPS CHECK GOOD IAW AMM 33-50-00. NO FURTHER DEFECT NOTED.SDR SWAA2018080123990Battery Pack · dischargedRT FORWARD EMERGENCY LIGHTS INOP AT LOCATION M2816. R&R BATTERY PACK PER AMM.SDR SWAA2018080123989Charger · inoperativeRT FORWARD EMERGENCY LIGHTS INOP AT LOCATION M2816. R&R BATTERY CHARGER PER AMM.SDR SWAA2018080123988Battery Pack · dischargedLT FORWARD EMERGENCY LIGHTS INOP AT LOCATION M1675. R&R BATTERY PACK PER AMM.SDR SWAA2018080123987Charger · inoperativeRT FORWARD EMERGENCY LIGHTS INOP AT LOCATION M1675. R&R BATTERY CHARGER PER AMM.SDR SWAA2018080123986Charger · inoperativeLT FORWARD EMERGENCY LIGHTS INOP AT LOCATION M2816. R&R BATTERY CHARGER PER AMM.SDR SWAA2018080123985Charger · inoperativeLT FORWARD EMERGENCY LIGHTS INOP AT LOCATION M1675. R&R BATTERY CHARGER PER AMM.SDR SWAA2018080123984Battery Pack · dischargedLT FORWARD EMERGENCY LIGHTS INOP AT LOCATION M2816. R&R BATTERY PACK PER AMM.SDR SWAA2018080123978Powerpack · inoperativeL2 DOOR SLIDE EMERGENCY LIGHT INOP. R&R POWER PACK PER AMM.SDR SWAA2018080123974Battery Pack · dischargedRT FORWARD EMERGENCY LIGHTS INOP AT LOCATION M1675. R&R BATTERY PACK PER AMM.SDR SWAA2018080123973Sign · unsecureAFT FACING OVERHEAD EMERGENCY EXIT ROW SIGN FELL OFF. ADJUSTED SIGN PER AMM.SDR DALA2018080104804Light · inoperativeSEAT EMER LIGHT INOP 20DE. R&R EMER LIGHT AS PASS SEAT 20 DE PER AMM 33-53 OPS CK GOOD.SDR 29GA2018080100002Sign · unsecureFLT 0123 FLL/FLL, FWD RT EMERGENCY EXIT DOOR SIGN IS LOOSE. RE-SECURED RT FWD EMERGENCY EXIT SIGN IAW AMM 25-25-15.SDR 29GA2018080100001Sign · unsecureFLT 0068 MHH/FLL, EMERGENCY EXIT SIGN HANGING 2D. SECURED EXIT SIGN IAW AMM 33-50-50-04 OPS CHECK GOOD.SDR R61A201807310838Light · inoperativeOVERHEAD EMERGENCY LIGHT MID CABIN INOP. R&R OVERHEAD EMERGENCY LIGHT ASSEMBLY IAW AMM 33-50-13.SDR MASA2018073113439Battery · dischargedROW 12 AND 13 OVERWNG EXIT SIGNS INOP. CHARGED BATTERIES.SDR SWAA2018082024327Cover · damagedR2 DOOR EMERGENCY LIGHT COVER DAMAGED. R&R COVER IAW AMM.SDR DALA2018080304843Lens · damagedL2 DOOR EXIT SIGN LENS HAS DAMAGED ATTACH HOOK. REMOVED & REPLACED L2 DOOR EMER EXIT SIGN LENS. OPS CHECK GOOD.SDR ASAA2018080125612Cover · detachedEXIT LIGHT COVER AT ROW 16ABC FELL OFF. GROUNDED - YES. FOUND EXIT LIGHT COVER AT ROW 16 DEF DETACHED, INSPECTED FOR DEFECTS, NONE NOTED, INSTALLED EXIT LIGHT COVER BACK ON LIGHT.SDR SIMA2018073130005Light · looseOVERHEAD EMERGENCY LIGHT ON ROW 16 IS NOT ILLUMINATING. RESECURED CEILING EMERGENCY LIGHT ABOVE ROW 16 IAW AMM 33-51-09. OPC GOOD IAW AMM 33-51-00. NO OTHER DEFECTS NOTED AT THIS TIME.SDR AALA201807319025Light · inoperativeSEAT 24L EMERGENCY LIGHT WAS INOPERATIVE . REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19.SDR AALA201807319024Light · malfunctionedCABIN EMERGENCY EXIT LIGHTS DID NOT REPOND PROPERLY TO FLIGHT DECK EMERGENCY LIGHT SWITCH. ACCOMPLISHED A RESET OF EMERGENCY LIGHT SYSTEM IAW AMM 33-51-00.SDR SIMA2018073130004Light · inoperativeLT OVERWING EMERGENCY EXIT LT INOP AT SEAT 12A. REMOVED AND REPLACED LT OVERWING EMERGENCY LAMP (12A PSU PANEL) IAW AMM 33-50-07-000-801-A/33-50-07-400-801-A OPC GOOD.SDR HALA2018073100353Sign · detachedEXIT SIGN ABOVE FLIGHT DECK DOOR DETACHED. ATTACHED THE SIGN. OPS TESTED GOOD.SDR AALA201807319015Lens · damagedEMERGENCY LIGHT LENS WAS DAMAGED AT SEAT 34C. REPLACED THE EMERGENCY LIGHT LENS.SDR SWAA2018073123941Light · inoperativeLT OVERWING EXIT EMERGENCY LIGHT INOP. R&R LIGHT PER AMM.SDR R61A20187310835Light · defectiveWHILE THE AC WAS OUT OF SERVICE FOR A MID C CHECK. FWD SERVICE DOOR EMERGENCY EXIT LIGHT AT FLOOR LEVEL DID NOT FULLY LIGHT UP. REPLACED FWD SERVICE DOOR EMERGENCY LIGHT IAW AMM 33-50-07.SDR YENA201807300295Terminal · out of positionFLT 2829, BOS-SDQ. EMERGENCY EXIT LKIGHT 2L INOP. FOUND EMERGENCY EXIT LIGHT AND DOOR EXIT LIGHT TERMINALS SWAPPED. SWAPPED TERMINALS TO CORRECT POSITION. OPS CHK GOOD. A/C OK FOR SVC.SDR DALA2018073004757Battery Pack · dischargedOVERWING EMERGENCY EXIT LIGHT W/N TEST AT SEATS 25ABC AND 25ED. REMOVED AND REPLACED BATTERY PACKS IAW AMM 33-53.SDR DALA2018080604879Lens · damagedEMERGENCY EXIT LENS WAS DAMAGED.SDR UIEA2018080301617Light · inoperativeEMERGENCY LIGHT "UNARMED" LIGHT HALF ILLUMINATED. RELAMPED LIGHT IAW AMM 33-13-00, OPS CKECK GOOD.SDR SCNA2018080229099Battery Pack · dischargedEMER LIGHT BATTERY PACKS AT 13 ABC, 13 DEF INOP. REMOVED AND REPLACED BATTERY PACKS. OPS CHECK GOOD.SDR 2DYA2018080129002Battery Pack · dischargedDURING INSPECTION, EMERG LIGHT INOP LH9 BATTERY PACK FAULT. 5 REQUIRED FOR POSITIONS M1208, M1210, M961, M735, AND M734. NO FURTHER INCIDENT. R2 BATTERY PACK.SDR REXA2018073100648Light · inoperativeCABIN FLOOR EMERGENCY LIGHT STRIPS OUT. REMOVED AND REPLACED SECOND TO AFT ARROW SEGMENT IAW AMM 33-51-01 OPS CHECKS GOOD AT THIS TIME.SDR DALA2018073104785Battery Pack · dischargedEMERGENCY LIGHT EXIT SIGN AT SEAT 34 INOP. REMOVED AND REPLACED EMERGENCY BATTERY PACK AT SEAT 32C IAW AMM 33-51-03.SDR SWAA2018073023903Sign · missingRT OVERWING EMERGENCY SMALL EXIT SIGN MISSING. INSTALLED SIGN PER MM.SDR SWAA2018073123889Light · inoperativeRT WING EXTERIOR EMERGENCY LIGHT AFT INOP. RELAMPED LIGHT PER AMM.SDR HALA2018073000409Light · detachedEMERGENCY EXIT LIGHT STRIP, CAME OFF AT ROWS 28 AND 29 SEATS HJ. REINSTALLED THE EMERGENCY LIGHT STRIP. CHECKED GOOD. OK FOR SERVICE.SDR CALA2018073001733Charger · inoperativePACK M33405 BATTERY CHARGER FUNCTION INOP. REPLACED CABIN DOOR 3L AFT PWR PACK M33405 BATTERY CHARGER & C/OUT OPERATIONAL TEST WITH THE TEST SWITCHED FND THE RESULT NORMAL.SDR DALA2018073004758Cradle · defectiveDURING SERVICE FOUND ROWS 1-4 AND 10-13 EMERGENCY LIGHTS INOP. REMOVED AND REPLACED EMERGENCY POWER SUPPLY CRADLE PER AMM 33-50 OPS CHECK GOOD ACFT IS OKAY FOR SERVICE.SDR DALA2018073004752Battery Pack · dischargedDURING SVC CK, FOUND CEILING EMERGENCY LIGHTS OUT AT ROWS 16-20. REMOVED AND REPLACED BATTERY PACK AT ROW 17DC PER AMM 33-53. LIGHTS CK GOOD.SDR 29GA2018073000002Light · brokenFLIGHT 0106 MHH/FLL REPORT, FLOOR EMERGENCY LIGHT BROKEN. R&R CABIN EMERGENCY ESCAPE PATH LIGHT STRIP IAW AMM 33-50-20. EMERGENCY LIGHT OPS CHECKED NORMAL IAW 23-50-00.SDR 29GA2018073000001Panel · failedFLIGHT 0051 MHH/FLL REPORT: EMERGENCY LIGHT RIGHT FRONT EMERGENCY EXIT DOOR NOT WORKING. REMOVED AND REPLACE EMERGENCY EXIT LIGHT PANEL OPS CHECK OK IAW 33-50-45-04 AMM.SDR K11A2018100500006Battery Pack · low voltageEMERGENCY LIGHT FAIL FUNCTIONAL TEST, LT/RT EMERGENCY BATTERY PACKSSDR DALA2018080204824Light · unsecureEMERGENCY FLOOR LIGHTING DAMAGED AT SEAT 31C, RESECURED EMERGENCY EXIT.SDR SCNA2018080128098Light · inoperativeFOUND 13F EXIT DOOR LAMP INOP. R&R THE BULB AT 13F EXIT DOOR. OP CHK GOOD. OK FOR SVC.
Back to JASC 3350