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 AALA201801049015Lens · missingMISSING EXIT SIGN COVER NEAR FIRST CLASS GALLEY, BENEATH STORAGE AREA. MAINTENANCE INSTALLED EXIT SIGN COVER NEAR FIRST CLASS GALLEY.SDR REXA2018010200008Bulb · inoperativeEMERGENCY LIGHTS IN GALLEY RT SIDE FWD & AFT HAVE BULBS OUT. REPLACED THE BULBS, OP TESTED GOOD IAW AMM 33-51-00. PSDR AALA201801049011Light · noneEMERGENCY LIGHTS ON. PERFORMED OPS TEST OF EMERGENCY LIGHTS. ALL CHECKS OK AND NO FAULTS NOTED PER AMM 33-51-00.SDR AALA201801039033Lens · crackedFORWARD GALLEY ISLE EMERGENCY LIGHT LENS TRIM IS CRACKED. REPLACED AND REMOVED THE EMERGENCY LIGHT TRIM IAW AMM 20 STANDARD PRACTICES. OPS CHECKED GOOD.SDR REXA2018010200003Lens · looseFA REPORTED THE EXIT SIGN OVER ROW 12 HAD FALLEN OFF OF THE CELILING. SECURED THE SIGN COVER IAW AMM 33-51-07. ACFT OK FOR SERVICE.SDR SWAA2018010418843Lens · brokenRT OVERWING EXIT DOOR EXIT/SALIDA LENS BROKEN AT LOWER FORWARD CORNER. R&R LENS IAW AMM.SDR SWAA2018010418842Light · inoperativeLT AFT EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018010418836Strip · looseLT ILLUMINOUS FLOOR LIGHT STRIP LOOSE AT ROW 1. SECURED STRIP PER DWG.SDR SWAA2018010418792Lens · unsecureMID CABIN AISLE EXIT SIGN LENS FELL OFF. INSTALLED LENS IAW AMM.SDR IPXA2018010225061Lamp · inoperativeINSPECTION TYPE: ASE, ENTRY CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR DALA2018010300035Battery · dischargedEMERGENCY CEILING LIGHTS IN TAIL INOP. BATTERIES WOULD NOT HOLD CHARGE. CHANGED 'D' CELL BATTERIES OPERATIONAL CHECK OF TAIL PATH CEILING LIGHTS GOOD IAW AMM 33-50. P/N AD-4002P.SDR JJBA20180102002Battery Pack · inoperativeCENTER AISLE EMERGENCY OVERHEAD LIGHT INOPERATIVE. R & R THE BATTERIES AT POSITION 1 & 2 IAW AMM 33-51-00, OPS CHECKED GOOD.SDR MASA2017801021878Light · inoperativeROW 11 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2018010212877Light · inoperativeROW 8 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR DALA2018011600249Lens · missingL2 DOOR OVERHEAD EMERGENCY EXIT COVER MISSING 2 EA DIFFUSER LENSES. REPLACED L2 DOOR EMERGENCY LIGHT LENS PER AMM 33-51.SDR SWAA2018010518871Lens · missingLT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR AALA20180102001Battery Pack · no testDURING EMERGENCY OPS TEST OF THE EMERGENCY LIGHTS, 14WL POWER SUPPLY BATTERY FAILED. MAINTENANCE REPLACED THE BATTERY IAW AMM 33-51-38 AND PERFORMED SUCCESSFUL OPS CHECK.SDR AALA201801039012Lens · missingAIRCRAFT WAS NOT GROUNDED. EXIT SIGN FLOOR COVER MISSING LIGHT. INSTALLED L-1 DOOR EMERGENCY LIGHT LENS COVER PER AMM 33-50-00.SDR HALA2018010200002Cover · missingDOOR 2R EXIT SIGN LIGHT COVER IS MISSING. DEFERRED PER MEL 25-22-3. REPLACED DOOR 2R EXIT SIGN LIGHT COVER.SDR SWAA2018010418850Light · missingAFT LT EMERGENCY EXIT PATH LIGHTING STRIP MISSING. R&R LIGHT STRIP PER AMM.SDR SWAA2018010418844Light · inoperativeAFT RT EMERGENCY EXIT PATH LIGHTING STRIP INOP. R&R LIGHT PER AMM.SDR SWAA2018010418805Light · inoperativeLT /OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA201801039024Battery Pack · no testEMERGENCY LIGHT TEST 15WL EPSU BATTERY FAILED. REPLACED THE BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA201801039023Battery Pack · no testEMERGENCY LIGHT TEST 14WL EPSU BATTERY FAILED. REMOVED AND REPLACED THE BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR DALA2018010200044Lens · missingFOUND EXIT SIGN LENS MISSING ON EXIT ROW. REPLACED THE LENS.SDR DALA2018010200040Power Supply · inoperativeCABIN SEAT EMERGENCY LIGHTS INOPERATIVE AT ROWS 14 - 20. FOUND THE POWER SUPPLY INOPERATIVE. REPLACED THE POWER SUPPLY AND BATTERY AT M11613 IAW AMM 33-51-07.SDR DALA2018010300033Battery Pack · dischargedDURING SERVICE CK FOUND FWD FLT ATTENDANT EMERGENCY LT SWITCH NOT ILLUMINATING EMERGENCY LIGHTS. VERIFIED WIRING TO SWITCH S1-387 OK IAW MD88 WDG 33-51. REINSTALLED FWD FLT ATTD BULKHEAD. OPS CK DOOR LOCK AND PA SYS IAW AMM 52-52 AND 23-30. R&R OVERWING EMER LSDR DALA2018010300032Battery Pack · dischargedOVERWING AFT UPPER EMG EXIT LIGHTS LEFT AND RIGHT NOT WORKING. REMOVED AND REPLACED BATTERY PACK FOR CONTROLLING AFT UPPER EMG EXIT LIGHTS OVERWING PER AMM 33-53-00. OPS CHECK GOOD. OK FOR SERVICE.SDR DALA2018010200015Not Reported · malfunctionedEMERGENCY LIGHTS ILLUMINATED FROM DOOR 2L BACK, 8 HOURS INTO THE FLIGHT. REPLACED SSPC 506XY.SDR DALA2018010100016Battery · faultedEPSU SYSTEM TEST FAULTED EMERGENCY LIGHT EPSU 19WL. REPLACED EPSU 19WL POWER SUPPLY BATTERY.SDR BUEA20180102004Battery Pack · dischargedDURING AIRCRAFT CREW PREFLIGHT, THE CREW REPORTED NONE OF THE EMERGENCY LIGHTS ILLUMINATED. UTILIZING THE APU GENERATOR AND THE EMERGENCY ARM SWITCH WAS ABLE TO RECHARGE THE FOUR BATTERIES AND GET ALL EMERGENCY LIGHTS ILLUMINATED.SDR QXEA2018010200002Battery Pack · inoperativeF/A EMERGENCY LIGHT SWITCH IN THE ON POSITION BUT NO EMERGENCY LIGHTS ILLUMINATED. REPLACED ALL BATTERY PACKS WITH SERVICABLE ONES IAW AMM 33-51-00-820-001. OPERATIONAL CHECKS GOOD RETURNED TO SERVICE.SDR JJBA20180101001Battery Pack · inoperativeEMERGENCY LIGHT ABOVE THE SERVICE DOOR WILL NOT TEST. R & R THE NR 2 EMERGENCY LIGHT BATTERY IAW 33-50-04, OPS CHECKED GOOD.SDR CALA2018010100006Light · brokenSEAT MOUNTED EMERGENCY LIGHT BROKEN AT ROW 15. REPLACED SEAT MOUNTED EMERGENCY LIGHT PER AMM 33-51-11-960-802. OPS CHECK GOOD.SDR CALA2018010100004Sign · dimCOCKPIT DOOR O/H EMER LIGHT FOUND DIM. COCKPIT DOOR O/H EMERGENCY EXIT IDENTIFIER SIGN REPLACED AND TEST NORMAL AS PER AMM 33-51-09.SDR CALA2018010100007Lens · missingEMERGENCY EXIT LENS COVER AT DOOR 1L MISSING. REPLACED LENS COVER AT DOOR 1L CLOSET.SDR CALA2018010100005Light · inoperativeSLIDE LIGHT AT 4L INOP. REPLACED LAMPS, CHECKS OK AT THIS TIME.SDR MASA2018010112874Light · inoperativeROW 18 O/H EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR AALA20180326008Battery Pack · inoperativeEMERGENCY LIGHTS ON THE SIDE OF SEATS 32AB THROUGH 41AB ARE NOT WORKING. REPLACED ALL THE BATTERY PACKS IAW AMM 33-51-00.SDR AALA20180326007Battery Pack · inoperativeTHE EMERGENCY LIGHT ON THE SIDE OF SEAT 21H IS NOT WORKING. REPLACED THE BATTERY PACKS IAW AMM 33-51-00.SDR SWAA2018011018957Cover · missingRT OVER WING EMERGENCY EXIT SIGN COVER MISSING. INSTALLED COVER IAW AMM.SDR AALA20180102002Battery · no testEMERGENCY LIGHT TEST, THE 15WL EPSU BATTERY FAILED. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA20171231002Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE. IN SEAT EMERGENCY LIGHTS FROM SEAT 7 - 12 INOPERABLE. REPLACED EMERGENCY BATTERY PACK PER MM 33-51-06. OPERATIONS CHECK GOOD.SDR SWAA2018010418823Sign · unsecureOVERHEAD OVERWING EXIT SIGN CAME OFF. INSTALLED SIGN PER SIP.SDR SWAA2018010418806Lens · looseR2 DOOR EMERGENCY SIDE DOOR LIGHT ASSEMBLY LOOSE. R&R LENS ASSEMBLY PER AMM.SDR AALA201801039006Light · inoperativeEMERGENCY LIGHT AT THE FRONT COAT CLOSET IS INOPERATIVE. REPLACED EMERGENCY LIGHT IAW AMM 33-51-05-960-801. GOOD FOR SERVICE.SDR SIMA20171231003Bulb · inoperativeRIGHT OVERWING EXIT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW 33-50-10.SDR AALA201801039010Lens · brokenBROKEN PLASTIC LENS ON THE EMERGENCY EXIT LIGHT. MAINTENANCE SECURED THE EMERGENCY LIGHT LENS.SDR AALA201801039008Lens · missingEMERGENCY EXIT SIGN AT SEAT 1C MISSING. INSTALLED A NEW LENS IAW AMM 33-51-00.SDR DALA2018010300027Battery · dischargedON S/C FOUND FC EMERGENCY LIGHTS INOP. T/S R&R F/C BATTERY ASSY. OPS CHECKS GOOD AS PER AMM 33-53.
Back to JASC 3350