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 SWAA2018072623859Charger · inoperativeAFT RT EMERGENCY EXIT SIGN ABOVE DOOR INOP. R&R BATTERY CHARGER PER AMM.SDR SWAA2018072623855Battery Pack · dischargedAFT RT EMERGENCY EXIT SIGN ABOVE DOOR INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018072623853Light · inoperativeLT EMERGENCY AISLE LIGHT INOP AT ROW 20. R&R LIGHT IAW AMM.SDR SWAA2018072623852Light · inoperativeFLIGHT COMPARTMENT EMERGENCY DOME LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2018072623846Strip · delaminatedRT FLOOR ILLUMINATION STRIP DELAMINATED AT ROW 1. R&R STRIP PER DWG.SDR SWAA2018072623832Guard · brokenEMERGENCY LIGHT SWITCH GUARD BROKEN. R&R SWITCH GUARD IAW AMM.SDR AALA201807259005Cover · missingAIRCRAFT WAS NOT GROUNDED. AFT EXIT LIGHT COVERS MISSING OVER BOTH AFT EXIT DOORS. REPLACED BOTH LIGHT COVERS PER AMM 33-51-77.SDR RAIA201807240002Light · inoperativeLT SIDEWALL EMERGENCY EXIT DOOR FLOOD LIGHT NR 21 INOP. R&R EMERGENCY LIGHT BULB AT EMERGENCY ROW EXIT LT CEILING IAW AMM, FUNCTION CHECK GOOD.SDR RAIA201807240001Light · inoperativeLT AFT WING/FUSELAGE FAIRING EXTERIOR EMERGENCY FLOOD LIGHT INOP NR 5. REMOVED AND REPLACED LIGHT BULB IAW AMM 33-50-10. OPS CHECK GOOD.SDR AALA20180725003Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. UPON COMPLETION OF WORK CARD 221N, FOUND 4 EMERGENCY LIGHTS NEAR DOOR 2R NOT WORKING. REPLACED DOOR 2R POWER SUPPLY PER AMM 33-51-06. ALL LIGHTS CHECKED, OK FOR SERVICE.SDR REXA2018072600645Light · inoperativeRT OW E-LIGHT INOP. R&R RH OW E-LIGHT ASSY IAW AMM 33-51-15 OP/C GOOD.SDR SWAA2018072523831Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PACK PER AMM.SDR SWAA2018072523811Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PACK PER AMM.SDR SWAA2018072523806Light · inoperativeLT OVERWING EMERGENCY EXIT SIGN INOP. RELAMPED SIGN IAW AMM.SDR DALA2018072504685Mount · brokenSEAT MOUNTED EMERGENCY EXIT LIGHT AT SEAT 29D (FOR AISLE ILLUMINATION) HAS A BROKEN MOUNT. REPLACED BROKEN EMERGENCY LIGHT BRACKET AT SEAT 29D, PER AMM 33-51.SDR SWAA2018072523804Battery Pack · dischargedRT EMERGENCY LIGHT INOP AT ROW 6. R&R BATTERY PACK PER AMM.SDR SWAA2018072523803Battery Pack · dischargedRT EMERGENCY LIGHT INOP AT ROW 2. R&R BATTERY PACK PER AMM.SDR SWAA2018072523802Light · inoperativeRT OVERWING EMERGENCY LIGHT SIGN INOP. R&R LIGHT ASSEMBLY PER AMM.SDR DALA2018072404637Battery · dischargedTAIL EMERGENCY CEILING LIGHT INOP. REMOVED AND REPLACED BATTERIES IN RIGHT AFT LAV. OPERATIONAL CHECK OK IAW AMM 33-50. P/N:AD4002P.SDR DALA2018072404714Light · inoperativeEMERGENCY LIGHT AT SEAT 26H HOUSING WAS BROKEN, LIGHT WAS OPERATIVE. SECURED SEAT 26H FLOOR EMERGENCY PATH LIST.SDR I5EA20180702Battery Pack · dischargedRT AND LT CABIN AFT OVERHEAD BIN EMERGENCY LIGHTS INOP FROM BS727 AFT. REMOVED AND REPLACED EMERGENCY BATTERY PACKS M1137 AT STA 975R, S/N 50962, AND M1197 AT STA 969L, S/N 41487. OPS CHECK GOOD IAW AMM 33-51-51.SDR SWAA2018072523808Cover · missingRT FORWARD OVERWING EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED COVER IAW MM.SDR DALA2018072404687Light · unsecureEMERGENCY SEAT MOUNTED LIGHTING DAMAGED/INOP LOCATIONS:15D. SECURED EMERGENCY LIGHT SEAT 15D OP CK NORMAL OK FOR SERVICE.SDR SWAA2018072523769Light · inoperativeRT EMERGENCY AFT OF WING SLIDE LIGHT INOP. RELAMPED LAMP PER AMM.SDR N6WA201807252301Light · inoperativeOVERHEAD EMERGENCY FLOODLIGHT ROW 6 INOP. R&R OVERHEAD EMER FLOODLIGHT ROW 6 IAW AMM STANDARD PRACTICE 33-51-09. OPS CHECK GOOD.SDR DALA2018072504673Cover · looseTHE FWD CENTER AISLE CEILING EMERGENCY EXIT SIGN COVER IS LOOSE. MAINTENANCE REATTACHED THE EXIT SIGN. OPERATIONAL CHECK IS GOOD.SDR AALA201807249030Lamp · inoperativeFOUND THE EMERGENCY LIGHT AT THE SERVICE DOOR WAS INOPERATIVE. MAINTENANCE REPLACED THE LAMPS IAW AMM 35-11-11 AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201807249013Cover · missingEMERGENCY EXIT LIGHT COVER MISSING JUST BELOW LEFT OVERWING EXIT. INSTALLED THE COVER. OK FOR SERVICE.SDR AALA201807249012Power Supply · burnedBURNED EMERGENCY POWER SUPPLY. REPLACED THE POWER SUPPLY IAW AMM 33-51-38-400-001-A.SDR DALA2018072404642Power Supply · inoperativeEMERGENCY LIGHTS INOP ROW 10-12 SEATS. REMOVED AND REPLACED POWER SUPPLY M33098 PER AMM 33-51-06.SDR IPXA2018072331976Battery Pack · dischargedINSPECTION TYPE:C4, FOUND L1 DOOR AREA EMERGENCY LIGHTS INOP. IAW AMM 33-51-04-902-001-001 REV 92.04, REPLACED THE EMERGENCY LIGHT BATTERY PACK AND PERFORMED EMERGENCY LIGHT OPERATIONAL TEST, RESULT WAS SATISFACTORY.SDR DALA2018072304609Bracket · out of adjustEMERGENCY SEAT ISLE LIGHT INOP AT SEAT 31 DE. ADJUSTED BRACKET AND BULB FIXTURE AT ISLE SEAT 31 DE. OPS CK GOOD.SDR DALA2018072304608Charger · inoperativeEMERGENCY PATH LIGHTING AT SEATS 13-23 INOP. R&R BATTERY CHAGER AT B5-211 PER 33-50 OPS CK NML.SDR DALA2018073004776Light · inoperativeEMERGENCY SEAT MOUNTED LIGHTING AT 36B ARE INOPERATIVE. REPLACED BUMPER AND LIGHT ASEEMBLY. SYSTEM OPERATION IS NORMAL. MCO/PLAC REMOVED.SDR REXA2018072600644Battery · dischargedFWD GALLEY EMER EXIT LIGHTS PARTIALLY ILLUMINATED. R&R NR 1 EMER BATT PS35 IAW AMM 33-51-01. OPS/CK GOOD.SDR ASOA2018072625164Light · inoperativeFLT 3991 EWR PILOT REPORTED ROW 18 RIGHT SIDE EMERGENCY LIGHT INOP. MX RESECURED RT EMERGENCY LIGHT EXIT IDENTIFIER WITH OPERATIONAL CHECK GOOD.SDR SWAA2018072423726Light · inoperativeFORWARD ENTRY EMERGENCY EXIT SLIDE LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR CALA2018072301686Battery · dischargedEMER LT POWER SUPPLY (M33093) BATTERY FOUND LOW CAPACITY. EMER LT POWER SUPPLY BATTERY REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018072301685Battery · dischargedEMER LT POWER SUPPLY (M33401) BATTERY FOUND LOW CAPACITY. EMER LT POWER SUPPLY BATTERY REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018072301684Charger · inoperativeEMER LT POWER SUPPLY CHARGER (M33093) FOUND INOP. EMER LT POWER SUPPLY CHARGER REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR DALA2018072404639Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT 13D INOP. R&R LIGHT ASSY AT ROW 13 IAW AMM 33-53. OPS CHECKS GOOD.SDR QXEA2018072300263Light · inoperativeFA EMERGENCY LIGHTING BUTTON INOP. NOT INDICATING GREEN/NORMAL. REMOVED FROM SERVICE. RELAMPED FA EMERGENCY SWITCH LIGHT AS REQUIRED. LAMP TEST GOOD. AIRCRAFT RETURNED TO SERVICE.SDR DALA2018072304624Terminal · damagedDURING INSPECTION FOUND EMERGENCY FLOOR EXIT LIGHT INOP SEAT 20D. MAINTENANCE FOUND TERMINAL DAMAGE ON SEAT 20D FLOOR LIGHTING. R&R TERMINAL AND PINS IAW WSPM 20-64. OPS CHECKED LIGHT GOOD.SDR IPXA2018072331979Battery Pack · dischargedEMERGENCY POWER LIGHTS DO NOT WORK OR TEST DURING SHUTDOWN. T/S PER AWD 33-51-01, REMOVED AND REPLACED U1 1756 BATERY PACK AND RELAY R2-5700 PER AMM 33-51-01/ 487. SYSTEM CKS OK FOR SVC REF: 33-51-10-01 ITEM 005J.SDR ASOA201807237134Battery Pack · dischargedNR 2 EMERGENCY LIGHT BATTERY PACK INOPERATIVE. REMOVED AND REPLACED NR 2 EMERGENCY LIGHT BATTERY PACK IN ACCORDANCE WITH AMM 33-50-04. OPERATIONAL CHECK GOOD.SDR MASA2018072113421Light · inoperativeROW 18 CEILING LVL EMER FLOOD LIGHT INOP. RELAMPED.SDR SWAA2018073123931Ballast · inoperativeLT OVERWING EXIT LIGHT INOP. R&R LIGHT BALLAST IAW MM.SDR SWAA2018072523795Battery Pack · failedFORWARD SECTION EMERGENCY LIGHTS FAILED OPS CHECK. R&R BATTERY PACK IAW AMM.SDR AALA2018072539025Light · unknownDOOR AND CEILING EMERGENCY LIGHTS DID NOT ILLUMINATE DURING FLIGHT. ACCOMPLISHED AN OPERATIONAL TEST OF THE EMERGENCY LIGHTS, TESTED OK , IAW MM 33-51-00.SDR AALA201807249018Light · inoperativeTWO SECTIONS OF THE EMERGENCY LIGHT WOULD NOT ILLUMINATE IN THE FIRST CLASS SECTION. MAINTENANCE REPLACED BOTH SECTIONS OF THE DAMAGED EMERGENCY LIGHT STRIP IAW AMM 33-50-21, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350