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 I5EA2017070500001Battery · dischargedEMERGENCY LIGHT WOULD NOT TEST AT ROWS 20 THRU 24. REMOVED AND REPLACED BATTERY AND SYSTEM CHECKS GOOD.SDR SWAA2017080315476Light · damagedRT EMERGENCY LIGHT STRIP DAMAGED. R & R THE EMERGENCY LIGHT STRIP IAW MM.SDR SWAA2017080315474Battery Pack · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 6 DEF. R & R THE BATTERY PACK IAW MM.SDR HNAA2017080200259Sign · inoperativeEMERGENCY LIGHT INOPERATIVE ON FWD RT FUSELAGE, FWD AISLE OVERHEAD EMERGENCY EXIT SIGN.SDR DALA2017080205864Battery Pack · inoperativeCEILING EMERGENCY LIGHTS INOPERATIVE ROWS 1-4, AND 17-20. INSTALLED BATTERIES IN THE B5-100 & B5-102 POWER SUPPLIES IAW AMM 33-53. OPS CHECKED GOOD.SDR SWAA2017081615732Housing · brokenAFT ENTRY CENTER CEILING EMERGENCY EXIT LIGHT HOUSING ASSEMBLY BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2017080915549Light · dimR1 DOOR EXTERIOR EMERGENCY EVAC SLIDE LIGHT DIM. R&R LIGHT PER AMM.SDR AALA201708049027Battery Pack · dischargedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY AISLE SEAT LIGHTS DIM FROM ROW 20 AFT. REMOVED AND REPLACED (2) BATTERY PACKS FOR AISLE LIGHT ROW 20 AFT OPS CHECKS GOOD AS PER AMM 33-53-00. (SEE ALSO SDR AALA201708029017)SDR AALA201708029017Battery Pack · dischargedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY AISLE SEAT LIGHTS DIM FROM ROW 20 AFT. REMOVED AND REPLACED (2) BATTERY PACKS FOR AISLE LIGHT ROW 20 AFT OPS CHECKS GOOD AS PER AMM 33-53-00. (SEE ALSO SDR AALA201708049027)SDR AALA201708029016Sign · unsecureTHE AIRCRAFT WAS NOT GROUNDED. FA ADVISED THE EMERGENCY EXIT SIGN FOR R-2 HAS FALLEN. REMOVED AND REPLACED R-2 EMERGENCY EXIT LIGHT ASSY. IAW AMM 33-51-01 OPS CHECKED OK.SDR AALA201708029015Sign · missingTHE AIRCRAFT WAS NOT GROUNDED. AFT SERVICE DOOR EXIT SIGN IS MISSING. REPLACED EMERGENCY EXIT SIGN OK FOR SERVICE REF MM 25 00 00.SDR SWAA2017080415498Lamp · inoperativeRT OVERWING DOOR EXIT LIGHT INOPERATIVE AT 12 DEF. REPLACED THE LAMPS IAW MM.SDR DALA2017080205959Power Supply · inoperativeL3 DOOR OVER DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE POWER SUPPLY AND BATTERY IAW AMM 33-51-07, OPS OK.SDR SWAA2017080315469Lamp · inoperativeR1 DOOR EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM.SDR AALA201708029006Lens · missingSEATS 4C MISSING EMERGENCY LIGHT LENS. INSTALLED A NEW LENS . OK FOR SERVICESDR AALA201708029005Lens · missingFLIGHT ATTENDANT REPORTS THE R4 DOOR IS MISSING THE EMERGENCY EXIT SIGN LENS, REPLACED LENS.SDR SWAA2017080115455Battery Pack · dischargedR1 DOOR EMERGENCY EVAC SLIDE EXIT LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2017080115454Battery Pack · dischargedL1 DOOR EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2017080115453Battery Pack · dischargedFORWARD RT EMERGENCY EXIT AISLE LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR REXA2017080100848Relay · defectiveEMER LIGHT ON STATUS THE LIGTHS ARE TURNING ON & OFF THE WHOLE TIME. REMOVED AND REPLACED EMERGENCY LIGHTS RELAY IAW AMM 33-51-19. OPS CHECK GOOD. A/C OK FOR SERVICE.SDR AALA20170801004Battery Pack · dischargedTHE AIRCRAFT WAS NOT GROUNDED. DURING PS CHECK FOUND BATTERY PACK INOP AT DOOR 4L. REMOVED & REPLACED BATTERY PACK IN AS PER AMM 32-51-06, OK FOR SVC.SDR ASOA201708014046Inverter · inoperativeTHE CREW REPORTED AN EMERGENCY LIGHT TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT INVERTER BEHIND THE F/A COAT CLOSET, OPERATIONALLY TESTED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR REXA2017080100845Battery · dischargedALL FWD EMERG FLOOD LIGHT INOP. R&R NR 2 EMERGENCY LIGHT BATTERY IAW AMM 33-51-17. OP/C GOOD.SDR E07A201802140009Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON.SDR DALA2017080306041Lens · brokenFLOOR PROXIMITY EMERGENCY LIGHT AT SEAT 39C FOUND BROKEN FROM BOTTOM OF SEAT. R & R EMERGENCY LIGHT COVER. OPS CHECKED NORMAL.SDR AALA20170802004Charger · faultyAIRCRAFT WAS NOT GROUNDED. FIRST CLASS SEAT MOUNTED EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED BATTERY (AALA201708049025) AND CHARGER IAW AMM 33-51-07. SYSTEM CHECKS GOOD.SDR AALA201708029014Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING AT ROW 26ABC. INSTALLED EMERGENCY LIGHT LENS AT ROW 26 ABC, OPS CHECK GOOD. OK FOR SERVICE IAW AMM 33-51-00.SDR AALA201708019035Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. EXIT COVER MISSING FROM AFT GALLEY SIGN. REPLACED LT AFT EXIT LIGHT ASSEMBLY IAW AMM 33-51-01, OPS CHECKS NORMAL.SDR AALA201708019034Sign · detachedTHE AIRCRAFT WAS NOT GROUNDED. EXIT COVER WILL NOT STAY ON BY RIGHT AFT SERVICE DOOR. ACCOMPLISHED EXIT SIGN LIGHT ASSY REPLACEMENT IAW AMM 33-51-01 FUNCTIONS NORMAL.SDR AALA201708039007Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT AT SEAT 15D INOPERATIVE. REPLACED 15D SEAT MOUNTED LIGHT PER AMM 33-51-11. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017080315479Lens · brokenMID CABIN EXIT LIGHT LENS BROKEN. R & R THE LIGHT ASSY IAW MM.SDR SWAA2017080315472Lens · looseR1 DOOR EXIT LIGHT LENS LOOSE. REPLACED THE LENS IAW MM.SDR SWAA2017080315471Lens · looseFWD GALLEY EXIT LIGHT LENS LOOSE. REPLACED THE LENS IAW MM.SDR AALA201708019003Light · inoperativeLIGHTS INOPERATIVE ON CENTER EXIT SIGN ABOVE L1 AND JUST AFT OF FA ANNUNCIATOR PANEL. REPLACED EMERGENCY EXIT LIGHT IAW AMM 33-51-11.SDR DALA2017080105933Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING. REINSTALLED THE SIGN COVER. OK FOR SERVICE.SDR DALA2017073105924Guard · brokenFOUND EMERGENCY LIGHT GUARD SWITCH BROKEN. REPLACED TOGGLE SWITCH GUARD. LP# 3434126SDR DALA2017080105902Light · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED. SECURED SEAT MOUNTED LIGHTS. OK FOR SERVICE.SDR DALA2017080105901Light · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED, SEAT 4C. SECURED THE SEAT MOUNTED LIGHTS.SDR DALA2017080105900Light · inoperativeEMERGENCY SEAT MOUNTED LIGHTING DAMAGED AND INOPERATIVE, SEAT 2C. SECURED SEAT MOUNTED LIGHTS.SDR DALA2017080105899Light · unsecureEMERGENCY SEAT MOUNTED LIGHTING DAMAGED AND INOPERATIVE, SEAT 3C. SECURED SEAT MOUNTED LIGHTS.SDR ASOA201707315096Ground Wire · unsecureDURING MX INSPECTION, THE GALLEY FLOOR EMERGENCY EXIT SIGN WOULD NOT ILLUMINATE. MX SECURED GROUND WIRE FOR CONNECTOR P372 WITH OPERATIONAL CHECK GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201708019047Light · damagedEMERGENCY LIGHTS MOUNTED ON THE SIDES OF SEATS 35C AND 36C ARE INOPERATIVE. FOUND LOOSE BROKEN WIRE 7260VC14-A AT LOWER SIDE WALL IN ROW 36L APPEARS TO BELONG TO EFFECTED EMERGENCY LIGHTS. REPLACED SEAT MOUNTED LIGHT AT ROW 36C AND ACCOMPLISHED SATISFACTORY OPSDR AALA201708019046Light · damagedEMERGENCY LIGHTS MOUNTED ON THE SIDES OF SEATS 35C AND 36C ARE INOPERATIVE. FOUND LOOSE BROKEN WIRE 7260VC14-A AT LOWER SIDE WALL IN ROW 36L APPEARS TO BELONG TO EFFECTED EMERGENCY LIGHTS. REPLACED SEAT MOUNTED LIGHT AT ROW 35C AND ACCOMPLISHED SATISFACTORY OPSDR AALA201708019044Cover · unsecureL3 DOOR EMERGENCY EXIT SIGN COVER LOOSE. SECURED THE EMERGENCY SIGN COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708019023Light · inoperativeAIRCRAFT WAS NOT GROUNDED. COCKPIT EMERGENCY LIGHT DOES NOT ILLUMINATE DURING TEST. REPLACED LIGHT ASSEMBLY.SDR AALA201708019022Lens · detachedAIRCRAFT WAS NOT GROUNDED. EXIT SIGN COVER DETACHED FROM BASE. REATTACHED EXIT SIGN AT DOOR L1.SDR CALA2017073102455Light · inoperativeEMERGENCY EXIT SIGN DOES NOT TURN ON, REPLACED LIGHT ASSEMBLY , AND CHECKED OKSDR SIMA20170730003Light · crackedLT NR 8 EMERGENCY LIGHT STRIP IS CRACKED. REMOVED AND REPLACED LT NR 8 EMERGENCY LIGHT STRIP IAW AMM 33-50-12. OPS CHECK GOOD.SDR AALA201708019018Sign · brokenAIRCRAFT WAS NOT GROUNDED. R4 DOOR EMERGENCY EXIT SIGN BROKEN OFF LOWER FASTNER. REPLACED R4 DOOR EXIT SIGN PER AMM 33-51-17. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708019016Cover · brokenAIRCRAFT WAS NOT GROUNDED. LAVATORY L EMERGENCY PATH LENS COVER BROKEN. REPLACED EMERGENCY LT COVER PER MM 33-51-11.
Back to JASC 3350