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 CALA2017082502893Bulb · inoperativeFOUND L3 EXTERIOR DOOR SLIDE LIGHT INOP REPLACED LIGHT BULB AND OPS CHECKED GOOD.SDR CALA2017082502886Lamp · inoperativeRIGHT FWD EMERGENCY LIGHT OVERWING ROW 20F INOPERATIVE. REPLACED THE LAMPS. OPS GOOD, OK TO CONTINUESDR DALA2017082506397Sign · inoperativeEMERGENCY EXIT SIGN FWD OF R1 DOOR INOPERATIVE. REMOVED AND REPLACED THE SIGN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR FDEA201708252355Sign · inoperativeON PREFLIGHT FOUND LT FWD EMER EXIT SIGN LED HALF OUT. REMOVED AND REPLACED LT FWD EMER EXIT SIGN PN 702409-101 IAW AMM 323-51-01-2, OPS CHECK GOOD. A/C OK FOR SERVICE.SDR REXA2017082500926Light · inoperativeFORWARD FLOOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD IAW AMM 33-51-00.SDR A6WA2017083145246Battery Pack · inoperativeEXTERNAL EMERGENCY LIGHTS INOPERATIVE, RT AFT OF OVERWING EXIT, LT FWD NR 2 EMERGENCY LIGHT, LT NR 4 EMERGENCY LIGHT, NR 2 & 4 EMERGENCY CEILING LIGHTS. REMOVED AND REPLACED THE BATTERY NR 4 IAW AMM 33-51-04. OPS CHECKED GOOD IAW AMM 33-51-04.SDR SWAA2017082915972Sign · brokenOVERHEAD CEILING EMERGENCY EXIT SIGN BROKEN BETWEEN ROW 11 TO ROW 12. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2017082915967Lens · brokenFORWARD ENTRY EXIT SIGN BROKEN. R&R LENS PER SIP.SDR SWAA2017082915966Light · unsecureL1 DOOR FLOOR EXIT LIGHT COVER FELL OFF. SECURED LIGHT IAW MM.SDR AALA201708289043Power Supply · failedEMERGENCY LIGHTS FAIL SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT IAW AMM.SDR SWAA2017082815956Power Supply · inoperativeR2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE POWER SUPPLY IAW MM.SDR SWAA2017082815955Cover · missingLEFT EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED THE COVER IAW MM.SDR SWAA2017082815954Light · inoperativeLEFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE LIGHT ASSEMBLY IAW MM.SDR SWAA2017082815953Lens · missingRIGHT OVERWING EXIT LIGHT COVER MISSING. INSTALLED THE LENS IAW AMM.SDR SWAA2017082815940Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R & R BATTERY IAW AMM.SDR SWAA2017082815907Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R & R THE BATTERY IAW AMM.SDR AALA201708289056Lens · detachedEMERGENCY EXIT SIGN IN THE FIRST CLASS SECTION HAS A DETACHED LENS. INSTALLED THE LENS. OPS CHECKED GOOD.SDR AALA201708289012Lens · missingEMERGENCY EXIT SIGN AT THE MIDDLE FUSELAGE HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 25-63-00. OPERATIONAL CHECKED GOOD.SDR AALA201708259025Flashlight · not seatedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BETWEEN L3 AND R3 INOPERATIVE. RESEATED FLASHLIGHT PER AMM 25-65-00. OPERATIONAL CHECK GOOD.SDR AALA201708259024Lens · crackedAIRCRAFT WAS GROUNDED. MAIN CABIN R2 DOOR SURROUND PANEL 252HRW EXIT SIGN IS CRACKED. REPLACED EMERGENCY EXIT IDENTIFIER SIGN.SDR AALA201708259006Flashlight · not seatedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BETWEEN L1 AND R1 AISLE INOPERATIVE. RESEATED FLASHLIGHT PER AMM 25-65-00. OPERATIONAL CHECK GOOD.SDR AALA201708259004Lens · brokenAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN FLOOR LEVEL BEHIND FORWARD GALLEY HAS A BROKEN LENS COVER. REMOVED AND REPLACED EXIT SIGN PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170824001Portable Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY PORTABLE LIGHT IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR REXA2017082400928Battery Pack · dischargedFA REPORTED EMERGENCY LIGHTS GO OUT AFTER TEST. FOUND BATTERIES TO BE DEPLETED. SET TO CHARGE AND OPERATIONAL TEST WAS GOOD IAW AMM 25-62-00. NO FURTHER MX IS NECESSARY.SDR DALA2017082406395Power Supply · inoperativeAFT RIGHT CABIN EMERGENCY LIGHTS INOPERATIVE. REMOVED AND INSTALLED POWER SUPPLY M736 IAW AMM 33-51. REPLACED THE BATTERY, OPS CHECKED GOOD IAW AMM 33-51.SDR AALA201708259029Light · dirtyL4 DOOR EMERGENCY SLIDE EVACUATION LIGHTS INOPERATIVE. CLEANED THE LIGHT AND REPLACED THE LAMPS IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA201708259028Light · dirtyL3 DOOR EMERGENCY SLIDE, EVACUATION LIGHTS INOPERATIVE CLEANED THE LIGHT AND AND REPLACED THE LAMPS IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA201708259027Lamp · inoperativeR1 DOOR EMERGENCY SLIDE, EVACUATION LIGHTS INOPERATIVE. CLEANED THE LIGHT AND REPLACED THE LAMPS IAW AMM 33-51-00. OPS CHECKED GOOD.SDR DALA2017082506384Light · inoperativeFOUND EMERGENCY LIGHT AT LAVATORY 1 RIGHT, RED ASSEMBLY BROKEN. REPLACED . SYSTEM OPERATION IS NORMAL.SDR IPXA2017082420918Battery Pack · inoperativeDURING CHECK, FOUND UPPER DECK LT SIDE EMERGENCY POWER SYS BATTERY PACK INOPERATIVE. R & R THE BATTERY PACK IAW AMM 52-23-14. TESTED GOOD, ACFT OK FOR SERVICE.SDR AALA201708259020Lens · damagedSEAT 23 LEFT EMERGENCY LIGHT SHROUD DAMAGED. REPLACED EMERGENCY LIGHT SHROUD AT SEAT 23 LEFT.SDR AALA201708259017Lens · missingWHITE EMERGENCY AISLE LIGHT LENS MISSING AT 22C. REPLACED EMERGENCY LIGHT AT 22C.SDR AALA201708259016Lens · missingRED EMERGENCY AISLE LIGHTS AT 8D AND 20D LENS MISSING.SDR AALA201708259015Light · brokenRIGHT EMERGENCY EXIT ROW LIGHT BROKE. REPLACED RED EMERGENCY LIGHTS AT 8D.SDR YENA201708240690Epsu · failedLOST GROUND POWER AFTER PARKING EMERGENCY EXIT LIGHT AT MID CABIN ISLE WAS NOT WORKING WHILE ON EMERGENCY POWER. WORKS FINE WITH NORMAL POWER. R & R THE ESPU AND EMERGENCY LIGHT BATTERY. SHOWED EVIDENCE OF A CELL THAT HAD SHORTED AND BURNED. FAULT REMOVED IASDR YENA201708240689Battery Pack · failedLOST GROUND POWER AFTER PARKING, EMERGENCY EXIT LIGHT AT MID CABIN ISLE (ABFAM ROW 11) WAS NOT WORKING WHILE ON EMERGENCY POWER. WORKS FINE WITH NORMAL POWER. R & R ESPU AND EMERGENCY LIGHT BATTERY. SHOWED EVIDENCE OF A CELL THAT HAD SHORTED AND BURNED. FAUSDR JJBA20170824022Battery Pack · inoperativeEMERGENCY LIGHTING SYSTEM REQUIRES OPERATIONAL CHECK. . FOUND AFT CENTER AISLE EMERGENCY LIGHT INOPERATIVE. R & R THE NR 4 BATTERY PACK, OPS CHECKED GOOD.SDR JJBA20170824021Light · unknownCABIN EMERGENCY LIGHT IN MID CABIN WILL NOT TEST, CENTER AISLE. PERFORMED OPS CHECK OF EMERGENCY LIGHTING SYSTEM. OPS CHECKED GOOD, NO DEFECTS NOTED.SDR JJBA20170824020Lamp · inoperativeTWO BETA LAMP ASSEMBLIES DO NOT ILLUMINATE ON THE EMERGENY EXIT DOOR HANDLE. R & R LAMP ASSEMBLIES.SDR HNAA2017082500287Light · inoperativeONE WHITE EMERGENCY FLOOR LIGHT AT ROW 4 IS INOPERATIVE. R & R THE EMERGENCY LIGHT. OPS CHECKED GOOD. OK FOR SERVICE.SDR MASA2017082412575Light · inoperativeROW 3 CEILING LEVEL EMERGENCY FLOOD LIGHT INOP. REPLACED BULB.SDR MASA2017082412574Light · inoperativeMULTIPLE EXIT SIGNS 1 BULB INOP. REPLACED BULBS.SDR HNAA2017082400465Light · inoperativeEMERGENCY LIGHT ON HINGE OF MAIN SERVICE DOOR IS NOT ILLUMINATING. REMOVED AND REPLACED MAIN SERVICE DOOR LIGHT ASSY IAW AMM 33-50-10-000-801-A/400-801-A. OPS CHECKED GOOD.SDR SWAA2017092016491Lens · missingRT BIN EMERGENCY BULLNOSE LIGHT LENS MISSING AT ROW 6. INSTALLED LENS PER AMM.SDR SWAA2017090616092Cover · missingPASSENGER CABIN SIDEWALL PANEL 231YHW EMERGENCY EXIT LIGHT LENS COVER MISSING. R&R COVER ASSEMBLY IAW SOPM.SDR DALA2017083106479Battery Pack · inoperativeBOTH FWD OVERWING LIGHTED EXIT SIGNS INOPERATIVE. . INSTALLED NEW BATTERIES IAW AMM 33-53-00/401. ALL CHECKED OK.SDR SWAA2017082815905Fuse · inoperativeRIGHT OVERWING EXIT LIGHT INOPERATIVE. R & R THE FUSE IAW AMM.SDR SWAA2017082815904Cover · missingL1 DOOR LOWER EXIT SIGN COVER MISSING. R & R THE COVER IAW AMM.SDR AALA201708249014Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE LOWER R1 DOOR HAS A DETACHED LENS COVER. REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170823002Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS FROM SEAT ROW 22DEF TO RIGHT AFT LAVATORY AND RIGHT AFT SERVICE DOOR ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY (BATTERY PACK) M1672 PER AMM 33-51-06. OPERATIONAL CHECK GOOD.
Back to JASC 3350