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 AALA20170203002Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT BATTERY AT 13WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20170203001Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT BATTERY AT 10WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR CALA2017020300234Lens · damagedFOUND CABIN ZONE A PARTITION LOWER AREA TWO EMERGENCY LIGHT LENS DAMAGED. REPLACED THE MERGENCY LIGHT ASSY AND OP TESTED NORMAL IAW AMM 33-51-05-960 -802, REV 78.SDR CALA2017020300233Lens · damagedFOUND ZONE B PARTITION LOWER AREA TWO EMERGENCY LIGHT LENSES DAMAGED. REPLACED LIGHT AND OP TESTED NORMAL IAW AMM 33-51-05-960-802, REV 78.SDR CALA2017020300232Lens · damagedFOUND CABIN AFT CENTER GALLEY A4 AREA 3EA EMERGENCY LIGHT LENS DAMAGED. REPLACED THE EMERGENCY LIGHT , FOUND NORMAL IAW AMM 33- 51-05-960-802, REV 78.SDR CALA2017020300231Charger · faultyON 2 SERVICE INSPECTION, FOUND 4 OVERWING DOOR EXIT IDENTIFIER EMERGENCY LIGHTS INOPERATIVE. IAW WDM 33-51-22, FOUND M10699 EMERGENCY LIGHTS POWER SUPPLY FAULTY. REPLACED IAW AMM 33-51-07, OPS NORMAL.SDR CALA2017020300241Light · crackedLAVATORY 3A-LC EMERGENCY LIGHT SURROUND FOUND CRACKED IN FOUR PLACES. REPLACED AND TESTED NORMAL IAW AMM 33-51-00SDR CALA2017020300240Battery Pack · dischargedAFTER POWER RESUME EMERGENCY LIGHT OP TEST FOUND ZONE 1 RT EXIT IDENTIFIER DIM, ZONE 1. RT BATTERY PACK REPLACED AND EXIT IDENTIFIER LAMP TESTED NORMAL IAW AMM 33-51-00SDR CALA2017020300239Light · malfunctionedTEST FOUND EMERGENCY LIGHT M8533 BATTERY LOW. REPLACED THE LIGHT AND TESTED GOOD IAW AMM 33-51-00-715-004, REV 182.SDR CALA2017020300238Lamp · inoperativeEMERGENCY LIGHT TEST FOUND L4 DOOR FWD DOOR SILL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS AND FOUND GOOD IAW AMM 33-51-962-031 REV 182.SDR CALA2017020300237Lamp · inoperativeEMERGENCY LIGHT TEST FOUND CREW REST AREA EMERGENCY POWER PACK LIGHT INOPERATIVE. REPLACED THE LAMP OF THE LIGHT AND PERFORMED OPERATIONAL TEST OF EMERGENCY LT FOUND "SATIS" PER AMM 33-51-00-715-004 REV 182.SDR CALA2017020300236Lamp · inoperativeTEST FOUND EMERGENCY LT X323 LAMP BURN OUT REPLACED THE LAMP AND TESTED GOOD IAW AMM 33-51-06-962-040.SDR CALA2017020300235Lens · brokenGALLEY RT ONE LOWER EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT AND INSTALLATION TEST FOUND NORMAL IAW AMM33-51-05-960-802, REV 78.SDR DALA2017020300925Lens · brokenEMERGENCY LIGHT LENS BROKEN AT SEATS 1B, 2B, 5B, REPLACED LENS.SDR IPXA2017020313642Lamp · inoperativeLAVATORY EMERGENCY EXIT LIGHT IS BURNED OUT. REPLACED THE LAMP IAW MM 33-24-01 OPS CHECKED GOOD.SDR R61A201702020085Light · out of positionCREW REPORTED THAT THE EMERGENCY LIGHT STRIP AT SEAT 23 A & B FOUND OUT OF POSITION. MAINTENANCE REPOSITIONED THE LIGHT IAW AMM AND OPS CHECKED GOOD.SDR AALA20170202005Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS IN FIRST CLASS ARE DIM. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR DALA2017020200841Battery Pack · malfunctionedDURING LINE CHECK, MAINTENANCE FOUND THEY COULD NOT CONTROL THE EMERGENCY LIGHTING IN THE TAILCONE; THEY WOULD FLASH ON AND THEN GO OFF. MAINTENANCE REPLACED THE BATTERY AND THE OPERATIONAL CHECK WAS GOOD. (LP #9118010)SDR SWAA2017032112556Light · damagedAFT CENTER CEILING EMERGENCY EXIT LIGHT DAMAGED. R & R THE LIGHT IAW AMM.SDR SIMA20170201006Battery Pack · intermittentRIGHT OVERWING EMERGRENCY LIGHT INTERMITTANT. REMOVED AND REPLACED THE NR 4 BATTERY ASSEMBLY AND CHARGER IAW W/C 33-700-19. OPS CHECKED GOOD.SDR SWAA2017020611698Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR DALA2017020300915Battery Pack · failedEMERGENCY LIGHTS BATTERY PACK BAD. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-16. OPS CHECKED GOOD.SDR SCNA20170201032Light · damagedEMERGENCY LIGHT HOUSING AND LENS ABOVE THE R1 DOOR FOUND BROKEN. REMOVED AND REPLACED THE HOUSING AND LENS ABOVE R1 DOOR. OP CHECKED GOOD.SDR AALA201702029010Flashlight · inoperativeFLASHLIGHT AT THE L2 DOOR INOPERATIVE. REPLACED THE FLASHLIGHT.SDR SCNA20170201002Lens · brokenEMERGENCY EXIT LIGHT HOUSING AND LOOK DOWN LIGHT/LENS ABOVE L1 DOOR BROKEN. REMOVED AND REPLACED EMERGENCY EXIT LIGHT HOUSING AND LOOK DOWN LIGHT LENSE ABOVE L1 DOOR. OP CHECKED GOOD.SDR AALA201702029007Power Supply · failedEMERGENCY LIGHT TEST FAILED. LT EMERGENCY POWER SUPPLY UNIT WAS REPLACED IAW AMM 33-51-38-0401.SDR AALA201702029003Lens · missingL4 EMERGENCY EXIT DOOR COVER MISSING. REPLACED EMERGENCY.LIGHT LENS.SDR AALA201702029002Lens · missingLENS MISSING FROM EMERGENCY EXIT SIGN LIGHT R4 DOORS. INSTALLED THE LENS IAW AMM 33-51-13, .SDR AALA201702029001Lens · missingLENS MISSING FROM EMERGENCY EXIT MARKER LIGHTS AT L1 DOOR.INSTALLED LENS AT L1 DOOR EMERGENCY. MARKER LIGHTS PER AMM 33-51-13SDR A6WA2017020344779Light · inoperativeEMERGENCY FLOOR LIGHT INOPERATIVE BEHIND ROW 8SDR HALA2017020100021Light · inoperativeOVERHEAD EMERGENCY LIGHT INOP AT 26GE. OK TO CONTINUE PER MEL 33-51-1A.SDR AALA20170202025Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT MIDDLE RIGHT IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW ESO 60849. OPERATIONAL CHECK GOOD.SDR AALA20170202024Light · disconnectedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY L2 DOOR IS DISCONNECTED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170202017Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGNS AT L1/R1 DOORS AND FIRST CLASS SEAT MOUNTED EMERGENCY LIGHTS ARE VERY DIM. REMOVED AND REPLACED CONTROL MODULE (AALA20170201018) AND BATTERY PACK AT M10798 IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA20170202013Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ON THE FORWARD GALLEY WALL HAS A MISSING LENS COVER. REPLACED LENS COVER IAW 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA20170202003Indicator · crackedAIRCRAFT IN BASE MAINTENANCE. R3 DOOR FLOOR PROXIMITY EXIT INDICATOR IS CRACKED. REMOVED AND REPLACED INDICATOR IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170202002Indicator · crackedAIRCRAFT IN BASE MAINTENANCE. L4 DOOR FLOOR PROXIMITY EXIT INDICATOR IS CRACKED. REMOVED AND REPLACED INDICATOR IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170202001Indicator · crackedAIRCRAFT IN BASE MAINTENANCE. L1 DOOR FLOOR PROXIMITY EXIT INDICATOR IS CRACKED. REMOVED AND REPLACED INDICATOR IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170201018Control Module · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGNS AT L1/R1 DOORS AND FIRST CLASS SEAT MOUNTED EMERGENCY LIGHTS ARE VERY DIM. REMOVED AND REPLACED CONTROL MODULE AND BATTERY PACK AT M10798 IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR DALA2017020200858Light · inoperativeEMERGENCY FLOOR LIGHTING IS INOPERATIVE AT SEAT 33B. SECURED EMERGENCY LIGHT HOUSING. SYSTEM OPERATION IS NORMAL.SDR SWAA2017020211647Lens · defectiveR1 DOOR LOWER EMERGENCY EXIT SIGN LENS MISSING DIRECTIONAL ARROW. R&R LENS IAW AMM.SDR SWAA2017020211646Light · inoperativeRT EMERGENCY EXIT BULB INOP. R&R BULB IAW AMM.SDR SWAA2017020211642Sign · disconnectedOVERWING OVERHEAD EXIT LIGHT SIGN DISCONNECTED FROM MOUNT. RECONNECTED SIGN PER SIP.SDR SWAA2017020211638Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01672. R&R BATTERY PACK PER AMM & DWG.SDR SWAA2017020211624Lens · defectiveL2 DOOR EXIT SIGN COVER LENS MISSING ARROW. R&R LENS IAW AMM.SDR SWAA2017020211623Lens · defectiveR2 DOOR EXIT SIGN COVER LENS MISSING ARROW. R&R LENS IAW AMM.SDR SWAA2017020211622Lens · defectiveL1 DOOR LOWER EMERGENCY EXIT SIGN LENS MISSING DIRECTIONAL ARROW. R&R LENS IAW AMM.SDR SWAA2017020211617Light · inoperativeLT EMERGENCY EXIT HATCH BULB INOP. R&R BULB IAW AMM.SDR DALA2017020200848Lens · looseEMERGENCY EXIT SIGN COVER LOOSE. SECURED LENS COVER.SDR DALA2017020200847Cover · looseEMERGENCY EXIT SIGN COVER LOOSE. ATTACHED THE COVER.
Back to JASC 3350