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 AALA2018083099018Lens · looseAIRCRAFT WAS NOT GROUNDED. EXIT LENS FOR LIGHT NEAR L1 FELL OFF. REATTACHED L1 EXIT LIGHT LENS.SDR ASAA2018082982949Battery Pack · no testWHILE PERFORMING T/C 78233001, FOUND THE EMERGENCY LIGHTS DID NOT PASS A CAPACITY TEST, OVERWING, AFT EXIT, EXTERNAL LEFT AND RIGHT, LEFT AND RT OVERHEAD BIN ROWS 16 - 25, ENTRY OVERHEAD EXIT, AND L1 DOOR LIGHTS. ACFT GROUNDED. REMOVED & REPLACED THE BATSDR ASAA2018082982948Lens · missingEMERGENCY LIGHT EXIT SIGN FOR THE NR 4 GALLEY, ADJACENT TO THE L2 DOOR WAS MISSING THE LENS. ACFT GROUNDED. REPLACED THE LENS AND TESTED THE LIGHT IAW AMM 33-51-01-960-801. OPS NORMAL.SDR ASAA2018082982945Sign · detachedEMERGENCY EXIT SIGN ON THE CABIN CEILING, BETWEEN THE OVERWING EXITS WAS DETACHED. ACFT GROUNDED. REINSTALLED AND TESTED THE SIGN IAW AMM 33-51-01-960-801, OPS NORMAL.SDR AALA201808299015Bulb · burned outL1 EXIT SIGN HAD BURNED OUT BULBS. REPLACED THE BULBS IAW AMM 33-50-00.SDR DALA2018082905353Lens · missingR1 DOOR EMERGENCY EXIT LIGHT LENS WAS MISSING. INSTALLED THE LENS IAW AMM 33-51-02.SDR IPXA2018082933337Warning Light · false activationAFTER ENGINE START, PRIOR TO TAXI, AN EICAS MESSAGE FOR THE EMERGENCY LIGHTS, UNARMED THE LIGHTS ON OVERHEAD PANEL. PERFORMED AN ADJUSTMENT AND TEST OF THE EMERGENCY LIGHTS IAW AMM 33-51-00. NO DEFECTS NOTED.SDR SWAA2018082924683Battery · dischargedLT EMERGENCY LIGHT INOP AT M2335. R&R BATTERY IAW MM.SDR SWAA2018082924680Cover · dislodgedMID CABIN CENTER AISLE OVERHEAD EMERGENCY EXIT SIGN DISLODGED. REINSTALLED COVER PER SIP.SDR SWAA2018082924678Lens · missingFORWARD OVERWING CEILING EXIT SIGN LENS MISSING. INSTALLED LENS IAW SIP.SDR SWAA2018082924677Cover · missingRT OVERWING EMERGENCY EXIT LOWER SIGN COVER MISSING. INSTALLED COVER PER MM.SDR SWAA2018082924676Lens · looseRT OVERWING EMERGENCY EXIT LENS LOOSE. SECURED LENS PER SIP.SDR SWAA2018082924670Cover · missingR1 DOOR EMERGENCY EXIT LIGHT LOWER LENS COVER MISSING DIRECTIONAL ARROW. R&R COVER PER AMM.SDR SWAA2018082924669Cover · missingL1 DOOR EMERGENCY EXIT LIGHT LOWER LENS COVER MISSING DIRECTIONAL ARROW. R&R COVER PER AMM.SDR SWAA2018082924668Lens · missingL2 DOOR EMERGENCY EXIT LIGHT LOWER LENS COVER MISSING DIRECTIONAL ARROW. R&R COVER PER AMM.SDR SWAA2018082924666Battery · dischargedLT EMERGENCY LIGHT INOP AT M1673. R&R BATTERY IAW MM.SDR SWAA2018082924665Light · inoperativeRT OVERHEAD EMERGENCY LIGHT INOP AT BIN 22. REPAIRED LIGHT PER MM.SDR SWAA2018082824632Cover · unsecureOVERHEAD AISLE EMERGENCY EXIT SIGN COVER FELL OFF. REINSTALLED COVER PER SIP.SDR MASA2018082813532Light · inoperativeROW 18 OVERHEAD EMERGENCY LIGHT INOPERATIVE.SDR QXEA2018082800310Light · looseONE PIECE OF THE FLOOR EMERGENCY LIGHT STRIP, JUST INSIDE MAIN CABIN DOOR WAS NOT SECURE. REMOVED FROM SERVICE. SECURED THE EMERGENCY LIGHT STRIP. NO OTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR DALA2018082805312Battery Pack · inoperativeFOUND CELING EMERGENCY LIGHTS OUT A ROWS 22 - 25. REPLACED THE BATTERY PACK IAW AMM 33-53.SDR SWAA2018090424752Sign · brokenAFT LOWERED CEILING PANEL CENTER EMERGENCY EXIT SIGN BROKEN. R&R SIGN IAW AMM.SDR DALA2018082805387Rccb · malfunctionedMULTIPLE LIGHT FAILURES IN CABIN AND PILOT REST FACILITY AND SEVERAL EMERGENCY LIGHT ILLUMINATED ON CAPTAIN SIDE OF CABIN. REPLACED RCCB 102XP AND EPSU. LP 4782366, 4782369SDR IPXA2018082983292Power Supply · malfunctionedAFTER ENGINE START, PRIOR TO TAXI, EICAS MESSAGE FOR EMERGENCY LIGHTS ILLUMINATED. UNARMED EMERGENCY LIGHT SWITCH ON OVERHEAD PANEL ON. REPLACED THE POWER SUPPLY IAW MM 33-51-08, OPS CHECKED NORMAL.SDR AALA2018083099031Sign · brokenEMERGENCY EXIT SIGN WAS BROKEN AT ROW 15F. MAINTENANCE REPLACED THE SIGN AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 35-51-14.SDR YENA201808270326Battery · failedFT# 1048, SDQ-FLL. FWD (LI, R1) EMERGENCY EXIT SIGNS NOT WORKING: R & R FWD L/H EPSU BATTERY IAW AMM 33-51-18 OPS CK GOOD AT THIS TIME. OK TO CONT SVC.SDR YENA20180830325Battery Pack · no testEMERGENCY LIGHT TEST FAILED FOR THE EPSU BATTERY AT FIN 12WL. REMOVED & REPLACED THE BATTERY IAW AMM 33-51-38.SDR YENA20180830324Power Supply · failedEMERGENCY LIGHT TEST FAILED. POWER SUPPLY 11WL FAULTED. REMOVED & REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR YENA20180830323Lamp · inoperativeR1 DOOR EMERGENCY SIGN LED LIGHTS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-16, OPS CHECKED GOOD.SDR ASAA2018082972947Sign · detachedEXIT SIGN FROM ROW 16, RIGHT WING SIDE WAS FOUND BY FA'S TO BE ON THE FLOOR. ACFT GROUNDED. REINSTALLED THE EXIT SIGN. OPS CHECKED GOOD.SDR AALA201808299005Lens · missingL4 DOOR EMERGENCY LIGHT LENS WAS MISSING. INSTALLED THE LENS. OPS CHECKED GOOD.SDR AALA201808299004Lens · missingL2 DOOR EMERGENCY LIGHT LENS WAS MISSING. INSTALLED THE LENS IAW AMM 33-51-13-400-001-A, LIGHT OPS CHECKED OK.SDR DALA2018082985351Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE FROM SEATS 16A TO 19A. REMOVED AND REPLACED THE BATTERY PACK AT M736 IAW AMM 33-51-07.SDR IPXA2018082983326Warning Message · false activationRT EMERGENCY LIGHT AND RT POWER SUPPLY INOPERATIVE EICAS MESSAGES, CHECKED IAW MM 33-51-07, OPS CHECKED NORMALSDR SWAA2018082924672Light · looseLT OVERWING EMERGENCY EXIT LIGHT LOOSE. R&R LIGHT PER AMM.SDR AALA2018082989018Light · missingEMERGENCY LIGHT ASSEMBLY WAS MISSING AT SEAT 3ABC. INSTALLED AN EMERGENCY LIGHT IAW AMM 33-51-19. OPS CHECKED OK.SDR SWAA2018082824636Light · inoperativeLT EMERGENCY CABIN ROW LIGHT INOP AT ROW 9. RELAMPED LIGHT PER AMM.SDR SIMA201808287002Sign · inoperativeRIGHT CABIN OVERWING EXIT SIGN WAS INOPERATIVE. REMOVED AND REPLACED THE RT WING EXIT SIGN IAW AMM 33-50-14, OPS CHECKED GOOD.SDR AALA201808289003Shroud · damagedROW 15ABC AND 16ABC EMERGENCY LIGHT SHROUDS WERE DAMAGED. THE AIRCRAFT WAS GROUNDED. REPLACED ROW 15ABC EMERGENCY LIGHT SHROUD IAW CMM 25-22-52.SDR AALA201808289004Panel · looseFORWARD LEFT ENTRY EXIT LIGHT PANEL WAS KICKED LOOSE. SECURED THE PANEL.SDR AALA201808289013Shroud · damagedROW 15ABC AND 16ABC EMERGENCY LIGHT SHROUDS WERE DAMAGED. THE AIRCRAFT WAS GROUNDED. REPLACED THE SHROUDS IAW CMM 25-22-52.SDR DALA2018082805323Lens · damagedEMERGENCY EXIT LENS WAS DAMAGED. REPLACED THE EMERGENCY LIGHTING LENS.SDR AALA201808289002Lens · missingSEAT 7 ABC MOUNTED EMERGENCY LIGHT DISLODGED AND MISSING THE LENS. INSTALLED THE EMERGENCY LIGHT, AND REPLACED THE LENS IAW AMM 33-51-19. OPS CHECKED GOOD.SDR MASA2018082713526Bulb · inoperativeROW 14AB EXIT SIGN BULBS WERE INOPERATIVE.SDR ASOA201808277156Battery Pack · inoperativeFOUND THE FLOOR LIGHTS AT ROWS 7 THRU 18, AND ALL EXIT SIGNS AT ROW 18 WERE OUT. MAINTENANCE R & R THE EMERGENCY BATTERY NR 3 IAW 33-50-04. R & R THE NR 5 INVERTER IAW 33-50-11. OPS CHECK GOOD AND WAS RELEASED FOR SERVICE.SDR DALA2018082705269Battery Pack · no testMAINTENANCE FOUND THAT THE FWD EMERGENCY LIGHTS FAILED DURING A SERVICE CHECK TEST. MAINTENANCE REPLACED THE EMERGENCY LIGHTS BATTERY PACK IAW AMM 33-51. OPS CHECKED NORMAL. AIRCRAFT OK FOR SERVICE.SDR JJBA20180827013Sign · detachedFORWARD OVERHEAD EMERGENCY EXIT SIGN DETACHED. ATTACHED THE FORWARD OVERHEAD EMERGENCY EXIT SIGN. OPS CHECKED SAT.SDR CALA2018082701860Power Supply · inoperativeTHE EMERGENCY LIGHTS FAILED TO ILLUMINATE. REMOVED AND REPLACED THE POWER SUPPLY.SDR CALA2018082701857Light · brokenLWR EMERGENCY LIGHTS, FOUND BROKEN. REPLACED THE MAIN DECK PARTITION LOWER EMERGENCY LIGHTS, OPS TESTED NORMAL IAW AMM 33-51-05-960-802, REV 83.SDR SWAA2018090424798Sign · unsecureEXIT SIGN PLACARD FELL OFF. SECURED SIGN PLACARD PER MM.
Back to JASC 3350