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 DALA2017052004050Cids · malfunctionedDOOR 4L EMERGENCY LIGHTS ILLUMINATED ENTIRE FLIGHT. RESET CIDS, OPERATIONAL CHECK OK.SDR DALA2017052004049Battery · failedEMERGENCY LIGHT BATTERY 15WL FAILED OPERATIONAL TEST, WC 0591-0115. REPLACED DOOR L3 BATTERY 15WL.SDR CALA2017051901506Battery Pack · dischargedFWD RIGHT ROW 20 DEF EMERGENCY LIGHT BATTERYS DEAD. REMOVED & REPLACED EMERGENCY LIGHT BATT PACKS FWD ROW 20DEF REF AMM 33-51-06-960-805, OPS CHECK GOOD.SDR CALA2017051901505Battery Pack · dischargedEMERG LIGHTS ON EXT OF RT SIDE OF A/C INOP. REPLACED M1695 AND M1671 POWER SUPPLY AND BATTERY PACK. OPS CHKS GOOD REF AMM 33-51-06.SDR CALA2017051901504Lens · unsecureEMERGENCY EXIT SIGN OVER AISLE AT OVERWING EMERGENCY ROW FELL OFF. REINSTALLED LENS COVER ON EMERGENCY EXIT COVER AT OVERWING EXITS.SDR CALA2017051901503Light · inoperativeROW 15 RED EMERG PATH LIGHTING INOP. REMOVED AND REPLACED ROW 15 RED EPL LIGHT ASSY. OPS CHECK GOOD.SDR CALA2017051901502Light · out of adjust1L EMERGENCY SLIDE LIGHT WILL NOT ILLUMINATE WHEN ARMED. ADJUSTED LIGHT, OP CKD NORMAL PER 33-10-00.SDR CALA2017051901501Fuse · faultyEMERGENCY LIGHT L568 R AFT OFF WING ESCAPE INOP. REPLACED EE LIGHT POWER PACK M735 FUSE IAW MM 33-51-07. OP CHECK GOOD.SDR CALA2017051901500Light · inoperativeEMERGENCY LIGHT L561 R MID WING ESCAPE INOP. RELAMPED EMERGENCY LIGHT L561 IAW MM 33-51-06. OP CK GOOD.SDR CALA2017051901498Light · inoperativeEXTERIOR SLIDE EMERGENCY LIGHTS AT DOOR 1 RT AND 4 LT IS INOP. RELAMPED EXTERIOR SLIDE LIGHT AT DOORS 1R AND 4L. OPS CHECK GOOD REF AMM 33-51-04.SDR CALA2017051901497Light · inoperativeOPERATIONAL TEST FOUND G5 LT EMER LIGHT INOP. REPLACED G5 L EMER LIGHT AND CABLE ASSY AND OPERATION TEST C/O FOUND NORMAL AS PER AMM 33-51-12-422-005-002 REV 87.SDR CALA2017051901495Light · inoperativeRT FWD EXTERIOR EMERGENCY LIGHT INOP. REPLACED RT FORWARD LIGHT BULB. OPS CHECKED GOOD.SDR CALA2017051901488Cover · missingEMER EXIT LT AT 1B MISSING COVER. REPLACED EMERGENCY EXIT LIGHT MODULE IAW AMM 33-51-18 PB 401. TEST OK.SDR CALA2017051901486Cids · malfunctionedOVERHEAD EMER EXIT LIGHTS ARE FLICKERING ON AND OFF IN THE REAR OF CABIN RESET CIDS. LIGHTS WORKING NORMAL.SDR CALA2017051901496Light · unsecureEMERGENCY LIGHTS ON LAV DOOR 101 NEAR 1R ARE FALLING OFF. SECURED BACK OK.SDR CALA2017051901485Lens · brokenAFT LAV AISLE EEL LIGHT BROKEN. REPLACED LENS. OPS NORMAL REF MM 33-51-19.SDR IPXA2017051917309Sign · inoperativeONE BULB BURNED OUT IN THE FLIGHT DECK EMERGENCY EXIT SIGN IAW AMM 33-51-01-962-001. REPLACEDLAMPED EMERGENCY EXIT SIGN IAW AMM 33-51-01-962-00SDR JJBA20170519030Inverter · failedFWD EMERGENCY LIGHT NOT ILLUMINATING. R & R THE NR 1 INVERTER ASSY OPS CHECKED GOOD.SDR FDEA201705181453Warning Light · false activationDURING A PREFLIGHT, RECEIVED AN ALERT FOR THE EMERGENCY LIGHT BATTERY 1 LOW. COMPLIED WITH FIM 33-51-02-00 EMERGENCY LIGHTS BATTERY POWER SUPPLY TEST. NO FAULTS NOTED, ACFT OK FOR SERVICE. NO HISTORY IN PAST 90 DAYS.SDR AALA201705199004Sign · brokenR1 DOOR EMERGENCY EXIT SIGN BROKEN OFF AT LOWER FASTNER. MAINTENANCE REPLACED THE EXIT SIGN IAW AMM 33-51-13.SDR DALA2017052304162Sign · missingR1 EMERGENCY EXIT SIGN MISSING. REPLACED. OPERATION CHECKED GOOD.SDR SWAA2017052313950Lens · missingRT OVERWING EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2017052313941Sign · brokenR2 DOOR EXIT SIGN BROKEN. R&R SIGN PER MM.SDR N6WA2017051801Light · detachedEMERGENCY LIGHT STRIP IS DETACHED. REPAIRED IAW AMM 52-41-32. OPS CHECKED GOOD.SDR QXEA2017052200367Light · looseEMERGENCY LIGHT STRIP AT ROW 2, SEAT B IS LOOSE. REPLACED THE LIGHT STRIP BETWEEN ROWS 2 - 4. CHECKED GOOD, RETURNED TO SERVICE.SDR DALA2017051904094Fuse · blownEMERGENCY EXIT LIGHT BS 959 INOPERATIVE. TROUBLEHOT IAW FIM B757 33-51-815-802. FOUND THE FUSE BLOWN ON CHARGER. R & R THE CHARGER IAW MM 33-51. LIGHT OPS CHECKED GOOD.SDR AALA20170519004Power Supply · no testR3 DOOR OVERHEAD EMERGENCY LIGHT POWER SUPPLY M33404 FAILED TO TEST. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA20170519003Power Supply · no testL3 DOOR OVERHEAD EMERGENCY LIGHT POWER SUPPLY M33406 FAILED TO TEST. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201705199024Light · brokenEMERGENCY LIGHT LENS BROKEN AT LAVATORY L. REPLACED EMERGENCY LIGHT IAW MM 33-20-00.SDR AALA201705199003Lens · brokenEMERGENCY LIGHT LENS BROKEN AT LAVATORY D. REMOVED & REPLACED THE LIGHT IAW MM 33-20-00.SDR SWAA2017052213873Light · detachedL1 DOOR EXIT SIGN DETACHED. R & R THE LIGHT ASSEMBLY IAW SIP.SDR AALA201705199028Cover · brokenEMERGENCY EXIT LIGHT COVER, LOCATED ON LOWER WALL BEHIND FIRST CLASS GALLEY IS BROKEN. INSTALLED A NEW COVER AND MOUNT PLATE IAW AMM 33-51-14, OPS NORMAL.SDR AALA201705199027Lens · detachedEMERGENCY EXIT LIGHT LENS FELL OFF NEAR FWD SERVICE DOOR AT F/C GALLEY. REPLACED THE EMERGENCY EXIT LIGHT ASSY IAW AMM 33-51-01. OPS CHECKED OK.SDR SIMA20170518001Inverter · inoperativeAFT CEILING EXIT LOCATING SIGN LIGHT INOPERATIVE. REMOVED AND REPLACED THE NR 4 EMERGENCY LIGHT INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD.SDR AALA201705199014Lens · missingEMERGENCY LIGHT LENS ON THE R4 DOOR MISSING. REPLACED THE LENS. CHECKED OK.SDR AALA201705199012Lens · damagedLOWER EMERGENCY LIGHT LENS DAMAGED. REPLACED THE LENS . OK FOR SERVICE.SDR AALA201705199010Bulb · burned outNUMEROUS EXIT SIGNS LIGHT BULBS ARE INOPERATIVE THROUGHOUT CABIN. REPLACED THE BULBS IAW AMM 33-51-17SDR MASA2017051812310Light · inoperativeAFT CEILING EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR YENA201705180374Epsu · inoperativeEMERGENCY LIGHTS AT ROWS 15, 19, 23 INOPERATIVE. R & R 11WL EPSU IAW AMM 33-51-38-000-002. OPS CHECKED GOOD IAW AMM 33-51-00-710-007.SDR SWAA2017051813842Power Supply · inoperativeFORWARD EMERGENCY LIGHT FAULTY. R&R POWER SUPPLY IAW AMM.SDR SWAA2017051813841Power Supply · inoperativeAFT EMERGENCY LIGHT FAULTY. R&R POWER SUPPLY IAW AMM.SDR SWAA2017051813840Power Supply · inoperativeEMERGENCY LIGHT FAULTY AT BS 500. R&R POWER SUPPLY IAW AMM.SDR A6WA201745028Battery Pack · dischargedEMER FLOOR LIGHTING AT ROW 9 AND AFT INOP. R&R BATTERY PACK POSITION 4 IAW AMM 33-51-04. OPS CHECKED GOOD.SDR ASOA201705175076Battery Pack · inoperativeDURING SCHEDULED MX THE EMERGENCY LIGHT AT THE EXIT ROW WAS FOUND INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK, AND OPS CHECKED GOOD. ACFT RETURNED TO SERVICE.SDR SWAA2017052213899Lens · missingRIGHT OVERWING EXIT SIGN LENS MISSING. INSTALLED A NEW LENS IAW AMM.SDR SWAA2017052213881Battery Pack · no testBATTERY PACK FAILED CAPACITY TEST AT LOCATION M01675. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017052213880Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017052213879Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017052213878Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017052213870Battery Pack · no testBATTERY PACK FAILED CAPACITY TEST AT LOCATION M01672. R & R THE BATTERY PACK IAW AMM.
Back to JASC 3350