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 AALA20170206010Lens · brokenFLOOR PROXIMITY EMERGENCY EXIT LIGHT BETWEEN FIRST CLASS AND THE FORWARD GALLEY HAS A BROKEN LENS COVER. REPLACED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170206009Sign · detachedEMERGENCY EXIT SIGN BY L2 DOOR IS DETACHED. SECURED EXIT SIGN. OPERATIONAL CHECK GOOD.SDR AALA20170206008Pin · brokenCEILING MOUNTED EMERGENCY EXIT SIGN ABOVE SEAT 21B IS LOOSE DUE TO A BROKEN ROLL PIN. REMOVED AND REPLACED ROLL PIN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170206005Power Supply · inoperativeFLOOR PROXIMITY EMERGENCY EXIT LIGHTS IN THE BUSINESS CLASS ARE INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY M33098 IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170204003Lens · brokenEMERGENCY EXIT LIGHT NEAR L2 DOOR HAS A BROKEN LENS COVER. REMOVED AND REPLACED EXIT LIGHT IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017020611719Battery Pack · damagedRT EMERGENCY EXIT LIGHT INOP BETWEEN BS 380 TO BS 360, BETWEEN STR 14R TO STR 15R. REPAIRED BATTERY PACK IAW AMM.SDR SWAA2017020611718Battery Pack · dischargedLT EMERGENCY EXIT LIGHT INOP AT REAR WING TO BODY FAIRING. RECHARGED BATTERY PACK IAW AMM.SDR SWAA2017020611717Light · inoperativeAFT GALLEY AREA EMERGENCY EXIT LAVATORY B LIGHT BULB INOP. R&R BULB IAW AMM.SDR SWAA2017020611709Light · inoperativeRT OVERWING EXIT SIDEWALL LIGHT INOP. R&R LIGHT PER AMM.SDR SWAA2017020611694Cover · brokenRT OVERWING EMERGENCY EXIT DOOR LIGHT COVER BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2017020611684Lens · brokenL1 DOOR LOWER EMERGENCY EXIT LIGHT LENS BROKEN. R&R LENS PER MM.SDR AALA201702049003Lens · damagedEMERGENCY LIGHT MANGLED. SECURED EMERGENCY LIGHT IAW AMM 33-51-18.SDR SIMA20170203003Charger · failedFOUND NR 2 AND 3 EMERGENCY LIGHT STRIPS INOPERATIVE. REMOVED AND REPLACED DC/AC INVERTER IAW AMM 33-50-11. REMOVED AND REPLACED THE NR 2 BATTERY PACK AND HOLDER ASSY IAW W/C 33-700-19. OPS CHECEDK GOOD. NO FURTHER DEFECTS FOUND.SDR SIMA20170203004Charger · failedFOUND NR 4 AND 5 EMERGENCY LIGHT STRIPS INOPERATIVE. REMOVED AND REPLACED NR 3 BATTERY AND CHARGER IAW W/C 33-700-19. OPS CHECKED GOOD, NO FURTHER DEFECTS FOUND.SDR SIMA20170203002Battery Pack · inoperativeLEFT AND RIGHT OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY BATTERY PACK IAW 33-700-19. OPS CHECKED GOOD.SDR JJBA20170203002Light · malfunctionedROW 18 EMERGENCY LIGHTS INOPERATIVE. CHECKED SPLICES 9124, 9125, 9126 & 9127. NO DEFECTS NOTED. OPS CHECK PERFORMED. OPS CHECK GOOD.SDR CALA2017020300255Lens · looseEMERGENCY EXIT SIGN DOES NOT TURN OFF. OVERWING EXIT SIGN FALLING OFF ACTUAL PROBLEM IS AISLE CENTER EMERG EXIT SIGN LENS LOOSE. REATTACHED AND SECURED LENS.SDR CALA2017020300254Light · malfunctionedEMERGENCY EXIT SIGN DOES NOT TURN OFF 3B F/C OVERHEAD EXIT SIGN LENS FALLEN OUT. PERFORMED OPS TEST OF EMERGENCY EXIT SIGNS, ALL LIGHTS CHECKS NORMAL ON AND OFF.SDR CALA2017020300253Lamp · inoperativeSLIDE OVERWING LIGHT DOES NOT COME ON, REPLACED THE LAMPS CHECKED NORMALSDR CALA2017020300252Lamp · inoperativeEMERGENCY LIGHTS INOPERATIVE AT EXTERIOR DOORS 1 RIGHT AND 4 LEFT. REPLACED THE LAMPS IAW AMM 33-51-06-962-001-002SDR CALA2017020300257Light · malfunctionedEMERGENCY EXIT LIGHT FOR LEFT OVERWING EXIT IS ON IN FLIGHT RESET SYSTEM, OPS CHECKED NORMALSDR CALA2017020300251Lamp · looseMID LEFT SIDE FWD EMERGENCY EXIT DOOR LAMP OUT. REPOSITIONED THE LAMP, OPS CHECKED GOODSDR CALA2017020300265Power Supply · faultyEMERGENCY LIGHT TEST FAILS. REPLACED BATTERY AND POWER SUPPLY IAW AMM 33-51-38, REF AMM 33-5 1-39. LIGHTS FUNCTIONED NORMAL.SDR CALA2017020300264Battery Pack · faultyEMERGENCY LIGHTS INOPERATIVE ROWS 21, 10, 11, 35, 34, 33, 28, 27, 26. REPLACED THE EPSU BATTERY PACK.SDR CALA2017020300263Battery Pack · faultyEMERGENCY LIGHTS ABOVE SEATS UNDER BINS INOPERATIVE. REPLACED EPSU BATTERY PACK LEFT OW EXITSDR CALA2017020300262Battery Pack · faultyEMERGENCY EXIT LIGHT ABOVE OVERWING EXIT DOOR AC LEFT INOPERATIVE. REPLACED THE BATTERY PACK ON EPSU AT LEFT EMERGENCY OVERWING EXIT IAW MM 33-51-38. LIGHT OPS CHECKED GOOD.SDR CALA2017020300261Battery Pack · faultyOVERHEAD OVERWING EMERGENCY EXIT SIGN INOPERATIVE. WILL NOT AUTOMATICALLY ILUMINATE REPLACED ESPU BATTERY PACK LEFT OVERWING EXITSDR CALA2017020300260Light · malfunctionedOVERWING EMERGENCY EXIT SIGN INOPERATIVE. PERFORMED RESET OF CIDS SYSTEM AT FLT ATTENDANTS PANEL. LIGHT TEST CHECKED OK.SDR CALA2017020300259Battery · faultyEMERGENCY LIGHTS TEST FAIL AT PTP PANEL. REPLACED THE BATTERIES AT EPSU UNITS 10WL AND 13WL IAW AMM 33-51-38 PB401. OK FOR SERVICESDR CALA2017020300258Light · malfunctionedUNABLE TO SHUT OFF EMERGENCY EXIT LIGHTS.SDR DALA2017020300906Bulb · inoperativeMULTIPLE EMERGENCY CEILING BULBS ARE OUT. REPLACED THE BULBS.SDR MASA2017020312853Lamp · inoperativeEMERGENCY OVERHEAD LIGHT ROW 15 INOPERATIVE. REPLACED THE LAMP.SDR HNAA2017020300039Bulb · inoperativeEMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR A6WA201744782Light · inoperativeEMERGENCY FLOOR TRACK LIGHTS FROM ROW 9 AFT WILL NOT ILLUMINATESDR YENA201702020063Power Supply · failedDURING MAINTENANCE, AN EMERGENCY LIGHTS TEST WAS CONDUCTED AND VARIOUS LIGHTS FAILED TO ILLUMINATE. R & R EPSU 10WL IAW AMM 33-51-38-000-001-A, AND 33-51-38-400-001-A. OPS CHECKED GOOD IAW AMM 33-51-38-740-050.SDR DALA2017022201467Housing · damagedEEPLS HOUSING DAMAGED AT 22 DEF. R&R HOUSING AT SEAT 22DEF.SDR YENA201702020062Power Supply · failedALL EMERGENCY LIGHTS LOCATED IN THE REAR OF THE AIRCRAFT WERE INOPERATIVE. R & R THE ESPU 13WL IAW AMM 33-51-38. PERFORMED OP CHECKS. OPS CHECKED NORMAL.SDR HNAA2017020800050Bulb · dimLOWER SIDEWALL EMERGENCY LIGHT DIM AT 4AC. R & R THE BULB.SDR ASAA2017020219669Lens · missingROW 16A EMERGENCY EXIT SIGN COVER ON SIDEWALL MISSING. ACFT GROUNDED REPLACED EXIT SIGN LENS, OPS CHECKED GOOD IAW AMM 33-51-01-960-801.SDR SWAA2017020611693Light · inoperativeRT OVERWING EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR DALA2017020300980Fuse · failedCABIN EMERGENCY AISLE LIGHTS INOPERATIVE ROWS 18DEF-22DEF. FOUND BATTERY PACK FUSE BAD. REPLACED FUSE. OPS CHK. GOOD. I/A/W B757 AIM 33-51.SDR YENA201702020058Battery Pack · failedCENTER AISLE OVERHEAD EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY. ACCOMPLISHED SATISFACTORY CHECK OUT IAW AMM 33-50-01.SDR SWAA2017020311675Sign · defectiveL1 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROW. R&R SIGN PER AMM.SDR SWAA2017020311655Light · inoperativeRIGHT OVERWING INTERIOR EMERGENCY EXIT FLOOD LIGHT BULB INOPERATIVE. R & R THE LIGHT IAW AMM.SDR SWAA2017020311653Sign · wrong partR1 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROW. R & R THE SIGN IAW AMM.SDR SWAA2017020311652Light · inoperativeRIGHT EMERGENCY LIGHT INOPERATIVE AT ROW 22. REPLACED THE LAMP IAW AMM.SDR SWAA2017020311650Lamp · inoperativeLEFT WING TO BODY FAIRING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR AALA20170203013Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT L2 DOOR HAS A MISSING LENS COVER. RESECURED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20170203007Light · damagedAIRCRAFT IN BASE MAINTENANCE. G2 GALLEY FLOOR PROXIMITY FLOODLIGHT IS DAMAGED. REMOVED AND REPLACED FLOODLIGHT IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA20170203003Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 14WL MIDDLE RIGHT FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38-401. OPERATIONAL CHECK GOOD.
Back to JASC 3350