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 AALA201711089039Power Supply · no testEMERGENCY EXIT LIGHTS POWER SUPPLY M33407 BY THE L4 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201711089038Power Supply · no testEMERGENCY LIGHTS POWER SUPPLY M33401 BY THE R3 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201711089037Lens · missingEMERGENCY EXIT SIGN BY THE R1 DOOR HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201711089011Sign · unsecureTHE EXIT SIGN OVER THE R2 DOOR WAS LOOSE. THE EXIT SIGN SECURED IAW MM 33-51-00.SDR R61A201711070841Power Supply · inoperativeCABIN EMERGENCY LIGHT WILL NOT ILLUMINATE. R & R THE POWER SUPPLY NR 2.SDR HALA2017110808003Light · unsecureEMERGENCY PATH LIGHTING TORN BETWEEN DOOR 4L AND 4R. RESECURED PATH LIGHT.SDR AALA201711089029Lens · missingEMERGENCY LIGHT LENS ON SLIDE BUSSEL MISSING. INSTALLED A NEW LENS IAW AMM.SDR AALA201711089020Lamp · burned outAFT GALLEY EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS AND OPS CHECKED IAW AMM.SDR AALA201711089014Switch · malfunctionedR3 DOOR EMERGENCY EXIT LIGHT WILL NOT SHUTOFF IN FLIGHT. CYCLED EMERGENCY LIGHT SWITCH AT FWD PANEL. LIGHTS OPERATED NORMAL.SDR AALA201711089013Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 9D. REPLACED THE LENS IAW AMM.SDR SWAA2017110817672Battery Pack · dischargedAFT EMERGENCY EXIT LIGHTS FAULTY. R&R BATTERY PACK PER AMM.SDR SWAA2017110817671Battery Pack · dischargedFORWARD EMERGENCY EXIT LIGHTS FAULTY. R&R BATTERY PACK PER AMM.SDR I5EA2017110800002Light · inoperativeR2 DOOR SLIDE FOUND TO HAVE SEVERAL EMERGENCY LIGHTS ON THE SLIDE INOPERATIVE. REMOVED AND REPLACED THE R2 DOOR SLIDE IAW AMM 25-61-35.SDR I5EA20171105Light · inoperativeR1 DOOR SLIDE FOUND TO HAVE SEVERAL EMERGENCY LIGHTS TO BE INOPERATIVE. REMOVED AND REPLACED THE DOOR SLIDE IAW AMM 25-61-35.SDR DALA2017110807995Lamp · inoperativeRT OVERWING ESCAPE HATCH HANDLE EMERGENCY LIGHT INOPERATIVE, REPLACED THE LAMPS.SDR FDEA201711073185Light · inoperativeR1 DOOR EMERGENCY SLIDE LIGHT INOP DURING TEST. RELAMPED AND OPS CHECK NORMAL REF MM 33-51-06-2-1. A/C OK FOR SERVICE.SDR MASA2017110712745Bulb · inoperativeSEAT 18D FLOOR LEVEL EMERGENCY SIGN HAD ONE BULB INOPERATIVE.SDR SWAA2017111517798Housing · damagedFORWARD LAVATORY AFT WALL LOWER EMERGENCY EXIT SIGN HOUSING DAMAGED. R & R THE SIGN IAW AMM.SDR SWAA2017111317711Light · damagedRIGHT CABIN EMERGENCY LIGHT STRIP DAMAGED AT ROW 1. R & R THE LIGHT STRIP IAW AMM.SDR AALA201711089009Battery · failedEMERGENCY LIGHTS 14WL BATTERY FAILED DURING A CIDS TEST. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201711089008Battery · faultyFOWARD LEFT EMERGENCY POWER SUPPLY 10WL BATTERY FAULTED. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201711089006Battery · faultyEMERGENCY LIGHTS POWER SUPPLY 11WL BATTERY FAULTED DURING A CIDS TEST. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201711089032Lens · brokenEMERGENCY EXIT SIGN BY THE L2 DOOR HAS A BROKEN LENS. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201711089031Lens · detachedEMERGENCY EXIT SIGN AT THE ROW 14A HAS A DETACHED LENS. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201711089030Lens · brokenEMERGENCY EXIT SIGN BY THE R1 DOOR HAS A BROKEN LENS. REMOVED AND REPLACED THE SIGN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201711089025Lens · missingEMERGENCY EXIT SIGN BY THE FORWARD GALLEY HAS A MISSING LENS. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201711089023Lens · brokenEMERGENCY EXIT LIGHT BY THE L1 DOOR HAS A BROKEN LENS. REMOVED AND REPLACED THE SIGN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201711089012Cover · looseLEFT OVERWING EXIT LIGHT COVER IS LOOSE. SECURED THE EXIT LIGHT COVER IAW MM 33-50-00.SDR WX0A201711083294Contact · burnedBURNING METAL ODOR IN THE AFT CABIN. FOUND THE AFT CABIN CTR ISLE LIGHT BULB CONTACTS SHORTED. REPLACED THE BULB.SDR DALA2017110808004Battery Pack · no testASPSU BATTERY ONE TEST FAILED. REPLACED NBR 1 ASPSU BATTERY.SDR F3LA2017110800246Bulb · inoperativeCCR EXIT LIGHT SIGN INOPERATIVE. REMOVED AND REPLACED THE BULBS IAW AMM 33-51-16, PB401 AND OPS CHECKED GOOD. AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA20171106003Light · inoperativeFWD NR 1 EMERGENCY LIGHT STRIP AT THE GALLEY FOUND INOPERATIVE. REMOVED AND REPLACED LIGHT IAW AMM 33-50-12. OP CHECKED GOOD.SDR SIMA20171106002Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM 33-50-05-000-801-A, AND 33-50-05-400-801-A. OPS CHECKED GOOD.SDR AALA201711079013Light · unsecureEMERGENCY EXIT LIGHT AT SEAT 11C LOOSE.. SECURED THE EMERGENCY LIGHT ASSY TO THE SEAT, OPS CHECKED OK IAW AMM.SDR R61A201711060816Light · missingSEAT 8 AB, ABOUT 36 INCHES OF THE EMERGENCY LIGHT MISSING. SECURED THE EMERGENCY LIGHT IAW AMM 25-00-00.SDR ASAA2017110622460Lens · missingEMERGENCY EXIT SIGN AT THE L2 DOOR IS MISSING THE LENS. ACFT GROUNDED. REPLACED THE LENS AND TESTED IAW AMM 33-51-01-960-801. OPS NORMAL.SDR ASAA2017110622459Sign · detachedL2 DOOR EXIT SIGN FELL OFF. ACFT GROUNDED. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-14. OPS CHECKED GOOD.SDR DALA2017110607984Power Supply · inoperativeWHILE PERFORMING A SERVICE CHECK, FOUND THE SIDEWALL EMERGENCY EXIT LIGHT AT AFT SERVICE DOOR INOPERATIVE. INSTALLED A NEW BATTERY POWER SUPPLY.SDR YENA201711060885Battery Pack · inoperativeDURING HEAVY MAINTENANCE, EMERGENCY LIGHT TEST WAS PERFORMED, REAR EXIT SIGNS DID NOT ILLUMINATE. OPS TEST WAS PERFORMED RESULTING IN BATTERY FAULT ON EPSU 13WL. REMOVAL OF THE BATTERY WAS PERFORMED IAW AMM TASK 33-51-38-000-002-A. OPS TEST PERFORMED IAW AMMSDR JJBA20171106007Power Supply · inoperativeLEFT AFT EMERGENCY LIGHT INOPERATIVE. R & R THE POWER SUPPLY IAW AMM 33-51-00.SDR CALA2017110603963Cids · malfunctionedEXIT SIGN REMAINS ILLUMINATED FOR ENTIRE TIME IN EXIT ROW RESET CIDS. PERFORMED CIDS SYSTEM TEST. NO FAULTS. NO PREVIOUS L EG FAULTS. ACCOMPLISHED OPERATIONAL TEST OF THE EMERGENCY LIGHTS . PER AMM 33-51-00-710-001-A. SYSTEM CHECK NORMAL. OPERATED EMERGENCY LISDR CALA2017110603962Battery Pack · faultyEMERGENCY LIGHTS BATTERY CAPACITY TEST FAILED, EPSU BAT CAP EMER R. INSTALLED NEW BATTERY PACK AMM33-51-38. INSPECTED BATTERY INSTALLATION/ EMERGENCY EXIT LIGHTING.SDR CALA2017110603961Battery · faultyEMERGENCY LIGHTS BATTERY CAPACITY TEST FAILED, EPSU BAT CAP EMER R & L AFT. REMOVED AND REPLACED LEFT AFT BATTERY 13WL, CHECKED OK AMM33-51-38-400-002A. IDT INSPECTED BATTERY REPLACEMENT/ SYSTEM OPERATION. OK.SDR CALA2017110603960Power Supply · faultyEMERGENCY LIGHTING SYSTEM CHECK, LT OVERWING HATCH EEL EPSU FAILED PUSH TO TEST FUNCTION. REPLACE THE POWER SUPPLY CABIN EMERGENCY LIGHT.SDR CALA2017110603956Lens · missingEXIT/SALIDA SIGN MISSING DOOR 2L NEAR STATION 402. INSTALLED EMERGENCY LIGHT LENS AT DOOR 2L IAW AMM 33-51-01.SDR CALA2017110603955Plate · brokenEMERGENCY EXIT LIGHT COVER AT DOOR 2L FELL OFF. REPLACED BROKEN BASE PLATE, SYSTEM CHKS OK.SDR CALA2017110603952Light · inoperativeLEFT AFT FUSELAGE EMERGENCY EXIT LIGHT INOP. RELAMPED LEFT AFT FUSELAGE EMERGENCY EXIT LIGHT. OPS CKS GOOD AT THIS TIME.SDR CALA2017110603951Light · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED R2 DOOR EXTERIOR EMERGENCY EXIT LIGHT. OPS CKS GOOD AT THIS TIME.SDR CALA2017110603950Lens · missingGALLEY 2 MISSING 2EA LENS COVER FOR EMERGENCY LIGHTS. GALLEY 5 MISSING 2 EA LENS COVERS FOR EMERGENCY LIGHTS. GALLEY 9 MISSING 1 EA LENS COVER FOR EMERGENCY LIGHTS. REPLACED ALL 5 LENS COVERS FOR EMERGENCY LIGHTS IN GALLEY 2,5, AND 9.SDR CALA2017110603949Holder · faultyDOOR L3 EXT EMERGENCY LIGHT INOP. REMOVED AND REPLACED LAMP HOLDER ASSEMBLY IAW AMM 33-51-06-902-08. ALL OPS CHECKS GOOD AT THIS TIME. INSPECTED INSTALLATION AND OPERATIONAL CHECK OF L3 EMERGENCY LIGHT ASSY WITH NO DEFECTS.
Back to JASC 3350