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 AALA2018082879024Lens · missingEMERGENCY LIGHT LENS MISSING AT SEATS 3A, C AND 8 ABC. REPLACED THE LENSES IAW 33-50-00.SDR SWAA2018082724629Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER MM.SDR SWAA2018082724628Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER MM.SDR SWAA2018082724623Light · inoperativeRT FORWARD EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018082724588Fuse · inoperativeL1 DOOR EMERGENCY EXIT LIGHT ON LOWER AFT LAV WALL INOP. R&R POWER SUPPLY FUSE PER AMM.SDR SWAA2018082724587Fuse · inoperativeR1 DOOR HEADER PANEL EXIT LIGHT INOP. R&R POWER SUPPLY FUSE PER AMM.SDR SWAA2018082724585Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER MM.SDR SWAA2018082724582Sign · looseMID CABIN CEILING EXIT SIGN LOOSE. SECURED SIGN PER SIP.SDR ASAA2018082745920Sign · detachedEMERGENCY EXIT SIGN AT THE OVERWING EXITS WAS KNOCKED OFF THE CEILING. ACFT GROUNDED. REPLACED THE CONNECTOR AND REINSTALLED SIGN, OPS CHECKED NORMAL.SDR IPXA2018082743198Lamp · inoperativeL1 DOOR, FWD EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE LAMP IAW AMM 33-52-01-000-805, AND 33-52-01-400-805, OPS TESTED IAW AMM 33-52-01-700-805.SDR SIMA201808274002Light · inoperativeEMERGENCEY LIGHT ON THE PAX DOOR WAS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-50-10. OPS CHECKED GOOD. NO DEFECTS NOTED.SDR SIMA201808274001Lamp · inoperativeLEFT AFT EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. R & R THE LAMP IAW AMM 33-50-10. OPS CHECKED GOOD. NO DEFECTS NOTED.SDR AALA201808276001Lamp · inoperativeR2 DOOR EMERGENCY EXIT SLIDE LIGHT WAS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-04. OPS CHECKED GOOD.SDR DALA2018082705275Lens · damagedFLOOR EMERGENCY LIGHT LENS DAMAGED. INSTALLED A NEW LENS, CHECKED GOOD.SDR DALA2018082705274Lens · damagedFLOOR EMERGENCY LIGHT LENS DAMAGED. INSTALLED NEW LENS. CHECKS GOOD.SDR DALA2018082705273Lens · damagedFLOOR EMERGENCY LIGHT LENS DAMAGED. INSTALLED A NEW LENS. CHECKED GOOD.SDR AALA201808279031Battery · no testEPSU SYSTEM TEST FAILED. REPLACED EMERGENCY LIGHT BATTERY IAW AMM 33-51-38. OPS TESTED NORMAL.SDR DALA2018082755268Lens · damagedTHE INTERIOR EMERGENCY EXIT LENS WAS DAMAGED. MAINTENANCE INSTALLED A NEW LENS. AIRCRAFT RETURNED TO SERVICE.SDR CALA2018082701854Battery · dischargedFOUND THE CABIN A4 GALLEY AREA, ALL EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY M33409 AND OP TESTS CARRIED OUT, FOUND NORMAL IAW AMM 33-51-06-960-8, 03, REV 83.SDR SWAA2018082724572Lens · missingRT OVERWING EMERGENCY EXIT LOWER LIGHT COVER MISSING. R&R LENS PER AMM.SDR MASA2018082413515Light · inoperativeAFT CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR AALA2018083124001Battery Pack · inoperativeR1 DOOR SIDE EXIT SIGNS ARE INOPERATIVE. REPLACED THE BATTERY PACK AND POWER SUPPLY M730 IAW 33-51-07. OPS CHECKED NORMAL.SDR RAIA20180829004Fuse · blownNR 1 EMERGENGY LIGHT BATTERY HAD LOW VOLTAGE. R & R THE BATTERY, OPS CHECKED GOOD. THE BATTERY HAD A BLOWN FUSE.SDR AALA201808279062Lamp · inoperativeROW 15D SIDEWALL LIGHT ON EMERGENCY EXIT DOOR WAS INOPERATIVE. MAINTENANCE REPLACED THE LAMPS IAW MM 33-21-00, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR YENA2018082730322Light · inoperativeFLT 1374, ROW 3 EMERGENCY EXIT SEAT LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM 33-51-18. OPS CHECKED GOOD.SDR YENA2018082730321Epsu · failedFLT 1373, 11WL EPSU INOPERATIVE. R & R THE EPSU IAW AMM 33-51-38. R & R THE BATTERY IAW 33-51-38. OPS CHECKED GOOD.SDR AALA201808279027Lamp · inoperativeSEAT 40 HJ, EMERGENCY LIGHT WAS INOPERATIVE, AND MISSING THE LENS. REPLACED THE LAMPS AND LENS IAW 33-51-10.SDR YENA2018082730320Light · inoperativeEMERGENCY LIGHT 204WL WAS INOPERATIVE. R & R THE EMERGENCY LIGHT IAW AMM 33-51-11. OPS CHECKED GOOD.SDR DALA2018082755265Power Supply · inoperativeEMERGENCY EXIT SIGNS OVER THE LT & RT AFT OVERWING EXIT HATCHES WILL NOT ILLUMINATE. MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED SATISFACTORILY IAW AMM 33-51-00.SDR CALA2018082701847Battery · no testEPSU BATTERY LEFT FAILED AN EMERGENCY LIGHT TEST. REMOVED AND REPLACED THE BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR SWAA2018082724576Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2018082724575Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER AMM.SDR SWAA2018082724553Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2018082724551Lens · missingL1 DOOR EMERGENCY LIGHT LOWER LENS MISSING DIRECTIONAL ARROW. R&R LENS IAW MM.SDR AALA201808279021Power Supply · inoperativeL1 DOOR SLIDE EXIT LIGHTS WERE INOPERATIVE. REPLACED THE BATTERY PACK AND POWER SUPPLY IAW MM 33-51-07, OPS CHECKED NORMAL.SDR AALA201808279011Battery Pack · inoperativeL1 DOOR SLIDE EXIT LIGHTS WERE INOPERATIVE. REPLACED THE BATTERY PACK AND POWER SUPPLY IAW MM 33-51-07, OPS CHECKED NORMAL.SDR AALA2018082749019Lens · detachedTHE EXIT SIGN LENS DETACHED AT THE RIGHT AFT DOOR. REPLACED THE SIGN LENS. OK FOR SERVICE.SDR DALA2018082545243Light · looseEXIT LIGHT AT LOCATION 602 WAS LOOSE. SECURED THE LIGHT.SDR SIMA201808243001Lamp · inoperativeLEFT EXTERIOR OVERWING EMERGENCY LIGHT FAILED TO ILLUMINATE. R & R THE LAMP IAW AMM 33-50-10. OPS CHECKED GOOD.SDR AALA201808249025Lens · missingAFT LEFT DOOR FRAME EMERGENCY LIGHT LENS MISSING. MAINTENANCE INSTALLED EMERGENCY LIGHT LENS IAW AMM 33-51-13 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR IPXA201808243164Bulb · inoperativeINSPECTION TYPE:NAEMERGENCY LIGHT HAS TWO INOP BULBSR/R TWO BULBS IN THE EMERGENCY LIGHT PER AMM 33-51-01-2SDR AALA201808249023Control Unit · inoperativeEMERGENCY LIGHT IN THE FORWARD COACH CABIN DOES NOT WORK. REPLACED WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT IAW AMM 33-51-07. OPS CHECKED GOOD. OK FOR SERVICE.SDR ASOA2018082433055Light · inoperativeTHE CREW REPORTED EMERGENCY LIGHT STRIP INOPERATIVE. MAINTENANCE REPLACED FORWARD AILSE PATH EMERGENCY LIGHT STRIP. OPERATIONAL CHECKS WERE GOOD.SDR MASA2018082313509Light · inoperativePHOTOLUMIN STRIP AT FWD FA CLOSET INOP.SDR DALA2018082305215Power Supply · no testEMERGENCY LIGHT TEST FAILED. FAULTED EPSU 10WL, REPLACED THE POWER SUPPLY AND BATTERY 10WL.SDR SWAA2018082724584Cover · missingLT OVERWING EMERGENCY DOOR EXIT COVER ARROW MISSING. R&R COVER PER AMM.SDR F3LA2018082700405Battery · no testDURING A HEAVY CHECK, THE EMERGENCY LIGHT BATTERY AT 15WL FAILED TO TEST THRU MCDU. REMOVED AND REPLACED EPSU ASSY IAW AMM 33-51-38-PB 401, CONF 00. OPS CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE.SDR F3LA2018082700404Battery · failedDURING HEAVY CHECK, EMERGENCY LIGHT BATTERY 13WL FAILED TO TEST THRU MCDU. REMOVED AND REPLACED EPSU ASSY IAW AMM 33-51-38-PB, 401, CONF 00. OPS CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE.SDR F3LA2018082700403Battery · no testDURING A HEAVY CHECK, EMERGENCY LIGHT BATTERY 11WL FAILED TO TEST THRU MCDU. REMOVED AND REPLACED EPSU ASSY IAW AMM 33-51-38-PB 401, CONF 00. OPS CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE.SDR AALA201808274002Battery Pack · no testFIRST CLASS SEAT MOUNTED EMERGENCY LIGHTS WERE INOPERATIVE AT ROWS 1E TO 4E. MAINTENANCE REPLACED THE BATTERY PACK M730 IAW MM 33-51-07, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350