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 SWAA2017122818614Lens · looseL1 DOOR EXIT LIGHT LENS FOUND LOOSE. R & R THE LENS IAW MM.SDR SWAA2017122818612Lamp · inoperativeTHE FWD RT EXTERIOR EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE LAMP IAW MM.SDR IPXA2017122124704Light · inoperativeEVACUATION SLIDE WARNING SYSTEM LIGHT INOPERATIVE AT THE L1 DOOR. PERFORMED BITE TEST OF ASPSU AND OPS TEST OF SLIDE RELEASE WARNING SYS IAW MM 52-73-00-05 OPS CHECKED NORMAL.SDR AALA201712229025Lens · missingAIRCRAFT WAS NOT GROUNDED. AFT GALLEY DOOR MISSING EXIT PLATE. REPLACED EXIT SIGN LENS PER AMM 33-51-00.SDR YENA201712201015Battery Pack · inoperativeFWD CABIN EMERGENCY LIGHTS FAIL TO ILLUMINATE DURING TEST WHEN CIRCUIT BREAKERSS 1WL (H5) & 2WL (H6) WERE OPENED. R & R EPSU BATTERY IAW AMM 33-51-38-000-002-A & 33-51-38-400-002-A. OPS CHECKED GOOD IAW AMM 33-51-38-710-052-B, & 33-51-00-710-057-A.SDR AALA201712219028Lens · missingAFT GALLEY EMERGENCY EXIT SIGN LENS IS MISSING ADJACENT TO THE TRASH CONTAINER. REPLACED EXIT SIGN LENS IAW AMM 33-51-01.SDR AALA201712219029Light · malfunctionedCEILING EMERGENCY EXIT LIGHT AT ROW 21 ABC STAYS ILLUMINATED. PERFORMED OPERATIONAL CHECK IAW AMM 33-51-00. OPS CHECKED NORMAL.SDR AALA201712219011Lens · missingMISSING EMERGENCY LIGHT LENS AT SEAT 4C. INSTALLED NEW THE LENS AT SEAT 4C IAW AMM 33-51-18 AND PERFORMED SUCCESSFUL OPS CHECKS.SDR DALA2017122208800Battery Pack · inoperativeTAIL EMERGENCY LIGHTS IN CEILING NOT WORKING. TESTED POWER SUPPLY AND FOUND THE BATTERYS NOT TAKING A CHARGE. REPLACED THE BATTERIES, OPS CHECKED GOOD IAW AMM 33-50.SDR BJNA2017122001Sign · detachedLT EMERGENCY EXIT ROW SIGN DETACHED. RE-ATTACHED EMERGENCY EXIT ROW SIGN IAW AMM.SDR REXA2017122001273Bulb · inoperativeEMERGENCY LIGHT ON OVERHEAD PANEL INOPERATIVE. REMOVED AND REPLACE THE BULBS IAW AMM 31-11-00. OPS CHECKED GOOD.SDR AALA201712219023Lens · not reportedEMERGENCY LIGHT LENS ADJACENT TO THE L3 DOOR. REPLACED EMERGENCY LIGHT COVER.SDR SIMA20171220002Light · inoperativeDURING PS-2 CHECK, FOUND THE LT AND RT OVERWING EMERGENCY LIGHTS INOPERATIVE. . R & R THE RT EMERGENCY LIGHT ASSEMBLY IAW AMM 33-50-10,. OPS CHECKED GOOD.SDR MASA2017122012846Light · inoperativeROW 21 CEILING EMERGENCY LIGHT INOP. PLACED ON MEL.SDR F3LA2017122000271Epsu · inoperativeEPSU AT FIN 13WL OPS CHECK INOP - DURING HEAVY CHECK - RON MAINTENANCE, EPSU AT FIN 13WL FAILED OPS CHECK. NO FLIGHT EFFECTED, NO GROUNDING. REMOVED AND REPLACED EPSU AT FIN 13WL AND ALL OPS CHECK OK IAW AMM 33-51-38 PB 401. NO FURTHER MX REQUIRED.SDR CALA2017122004556Light · loose5B EMERGENCY LT LOOSE SECURED LIGHT ASSY.SDR CALA2017122004555Light · brokenFWD EMERG EXIT LIGHT LENS BROKEN LIGHT ON FWD CLOSET. REPLACED OPS CK OK.SDR CALA2017122004552Switch · defectiveEMER EXIT LIGHTS WILL NOT ARM PROPERLY FOUND SWITCH ON P11 OVERHEAD PANEL AT FAULT. REMOVED AND REPLACED SWITCH PER AMM. ALL OPS CHKS GOOD.SDR CALA2017122004551Guard · out of adjustEMER LIGHTS WILL NOT ARM. ADJUSTED GUARD ON EMERGENCY LIGHT SWITCH. OPS CK NORMAL.SDR CALA2017122004550Battery · dischargedDURING CHECK THE EMERGENCY LIGHTS, FIND THAT THE AISLE LIGHTS AT STA1582 & 1666, RBL51 NOT COME ON. REPLACED THE CABIN 3R DOOR AREA M33401 BATTERY & POWER SUPPLY AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-960-802 REV 81 & AMM 33-51-06-960-803 RESDR CALA2017122004549Battery Pack · dischargedDURING CHECK THE EMERGENCY LIGHTS, FIND THAT BOTH DOOR 4R EXIT IDENT SIGNS DOES NOT COME ON. REPLACED THE CABIN 4R AREA M33408 EMERGENCY BATTERY PACK AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-960-803 REV 8 1.SDR CALA2017122004548Battery · failedEMER BAT PACK M33093 FAILED IN CAPACITY CHECK. REPLACED THE CABIN 1L DOOR AREA M33093 EMERGENCY BATTERY AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-960-802 REV 8 1.SDR CALA2017122004554Light · inoperativeEMER EXIT NOT ARMED LT INOP. RELAMPED EMERG LIGHT NOT ARM, OPS CKS GOOD.SDR CALA2017122004553Light · inoperativeDOOR 3L FUSELAGE EMERGENCY EXIT LIGHT INOP. RELAMPED 3L EMERGENCY LIGHT. OPS CK NORMAL.SDR DALA2017122008755Battery Pack · inoperativeWHILE PERFORMING EMERGENCY LIGHT CHECK, FOUND ALL OF ECONOMY COMFORT LIGHTS OUT. MAINTENANCE FOUND THE BATTERY PACK AT M1676 INOPERATIVE , S WAPPED WITH KNOWN GOOD BATTERY , OPS CHECKED GOOD.SDR SWAA2017122918646Lens · looseEMERGENCY LIGHT LENS ABOVE R1 DOOR LOOSE. R & R THE LENS IAW MM.SDR SWAA2017122818678Light · looseCENTER CABIN EMERGENCY EXIT LIGHT LOOSE AT ROW 11. SECURED LIGHT ASSY PER MM.SDR AALA201712269035Lens · missingAIRCRAFT NOT GROUNDED. DOOR 2L EXIT LENS MISSING. REPLACED DOOR 2L EXIT LIGHT LENS.SDR ASAA2017121922986Latch · brokenOVERWING EMERGENCY EXIT SIGN HANGING FROM THE CEILING ABOVE THE CENTER ISLE, THE SIGN HOUSING ACCESS PANEL LATCH IS BROKEN. ACFT GROUNDED. ACCOMPLISHED TEMPORARY REPAIR IAW EA 88-33EA-19666.SDR AALA201712229020Cover · missingAIRCRAFT NOT GROUNDED. EMERGENCY LIGHT COVER AT DOOR 2L MISSING. REPLACED EMERGENCY LIGHT COVER AT DOOR 2L PER AMM 33-51-01.SDR AALA20171221002Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT AT 7DEF-12DEF INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY AND RESECURED CONNECTOR AT SEAT 12DEF PER AMM 33-51-06. OPERATIONAL CHECK NORMAL.SDR AALA201712229027Cover · unsecureAIRCRAFT WAS NOT GROUNDED. RIGHT AFT DOOR EXIT SIGN COVER WILL NOT STAY IN PLACE. MAINTENANCE RESECURED RIGHT AFT EXIT SIGN PER WORKCARD 2904.SDR AALA201712229012Battery · no testWHILE ACCOMPLISHING JOBCARD 33C22033002, EMERGENCY POWER SUPPLY UNIT BATTERY AT 2L FAILED TEST. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201712229011Battery · no testAIRCRAFT WAS NOT GROUNDED. WHILE ACCOMPLISHING JOBCARD 33C22033002, EMERGENCY POWER SUPPLY UNIT BATTERY AT 4L FAILED TEST. REPLACED BATTERY PER AMM 33-51-38.SDR AALA201712219027Sign · missingEMERGENCY EXIT SIGN MISSING AT AFT GALLEY DOOR LEFT SIDE. REPLACED EXIT SIGN IAW AMM 33-51-00.SDR AALA201712219025Lens · missingMISSING EMERGENCY EXIT LENS AT R1 DOOR. REPLACED LENS IAW AMM 25-63-00.SDR DALA2017121908749Power Supply · inoperativeAFT CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED AFT CABIN EMERGENCY BATTERY POWER SUPPLY.SDR DALA2017122008748Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED AT ROW 41. REPLACED SIGN SYSTEM OPERATION IS NORMAL.SDR DALA2017121908745Light · burnedEMERGENCY LIGHTS ALL BURNED. REPLACED THE EMERGENCY LIGHTS.SDR AALA201712219009Light · unknownEMERGENCY EXIT LIGHTS AT L3 DOOR FLASH ON & OFF DURING FLIGHT. SYSTEM OPS CHECKED GOOD, NO FAULT FOUND.SDR AALA201712219010Lens · brokenEMERGENCY LIGHT LENS AT SEAT 32C IS BROKEN. REPLACED THE LENS CHECKED OK.SDR SWAA2017122118608Power Supply · inoperativeL2 EMERGENCY EXIT LIGHT INOP. R&R POWER SUPPLY PER MM.SDR SWAA2017122118606Lens · missingAFT BULKHEAD EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2017122118605Battery Pack · dischargedAFT BULKHEAD EMERGENCY EXIT LIGHT INOP. INSTALLED BATTERY PACK PER MM.SDR SWAA2017122118604Lens · missingFORWARD BULKHEAD EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2017122118603Battery Pack · dischargedFORWARD BULKHEAD EMERGENCY EXIT LIGHT INOP. INSTALLED BATTERY PACK PER MM.SDR SWAA2017122118598Light · inoperativeLT EXTERNAL LOWER SLIDE LIGHT AFT OF WING INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2017122118590Lens · distortedRT OVERWING EMERGENCY EXIT LIGHT LENS DISTORTED. R&R LENS PER AMM.SDR AALA201712219034Shroud · damagedROWS 8C, 9C, 10C, 11C, 12C AND 13C EMERGENCY LIGHT SHROUDS DAMAGED. MAINTENACE REPLACED THE SHROUDS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201712219033Shroud · damagedROWS 8C, 9C, 10C, 11C, 12C AND 13C EMERGENCY LIGHT SHROUDS DAMAGED. MAINTENACE REPLACED THE SHROUDS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350