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 MASA2017091112616Light · inoperativeROW 15 CEILING LEVEL EMERGENCY LIGHT INOPERATIVE.SDR JJBA20170911005Light · inoperativeFWD EMERGENCY LIGHT INOPERATIVE. PERFORMED ADJUSTMENT AND TEST. OPS CHECKED GOOD, NO OTHER DEFECTS NOTED.SDR DALA2017091106783Light · brokenDURING INSPECTION, FOUND THE EMERGENCY EXIT IN THE MID CABIN BROKEN. MAINTENANCE REPLACED THE EMERGENCY LIGHT ASSY AT SEAT ROW 22 IAW AMM 33-51. LIGHT CHECKED NORMAL.SDR SWAA2017091816348Cover · looseENTRY DOOR EMERGENCY EXIT LIGHT COVER LOOSE. SECURED THE COVER IAW MM.SDR SWAA2017091816338Cover · brokenFORWARD GALLEY EMERGENCY EXIT LIGHT COVER BROKEN. R & R THE LIGHT IAW AMM.SDR AALA201709129011Battery · dischargedAIRCRAFT WAS GROUNDED. CEILING EMERGENCY EXIT LIGHTS FROM ROWS 8 TO 10 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY AT SEAT 8DEF PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA201709129009Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE L2 DOOR HAS A DETACHED LENS COVER. REPLACED LIGHT PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR ASOA201709105105Sign · brokenTHE FLOOR LEVEL EMERGENCY EXIT SIGN WAS FOUND HANGING OUT OF ITS COVER. MX REMOVED AND REPLACED THE EXIT SIGN ASSY AND OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2017091216266Cover · detachedCENTER AISLE EXIT SIGN COVER FELL OFF. INSTALLED THE SIGN COVER IAW AMM.SDR SWAA2017091216265Cover · detachedOVERWING EXIT SIGN COVER FELL OFF. REINSTALLED THE SIGN COVER IAW SIPSDR SWAA2017091216262Lamp · inoperativeRIGHT FORWARD EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR DALA2017091100010Lamp · inoperativeTHREE EMERGENCY EXIT MARKERS IN LOWER CREW REST NOT ILLUMINATING WHEN SELECTED ON. REPLACED THE LAMPS.SDR DALA2017091100008Lamp · inoperativeEXIT SIGNS INOPERATIVE. REPLACED THE LAMPS.SDR DALA2017091100006Lamp · inoperativeSEAT 31GF AND 28GF EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS. CHECKED GOOD.SDR MASA2017091012615Lamp · inoperativeROW 17 EMERGENCY CEILING FLOOD LIGHT INOPERATIVE. REPLACED THE LAMP.SDR AALA201709119013Cover · missingAT DOOR 4L THE EMERGENCY EXIT COVER IS MISSING. INSTALLED MISSING EMERGENCY LIGHT COVERS AT 4L.SDR JJBA20170910004Power Supply · inoperativeCENTER AISLE CEILING EMERGENCY LIGHT FWD FACING INOPERATIVE. R & R THE NR 3 EMERGENCY LIGHT POWER SUPPLY.SDR AALA201709119027Lens · brokenAIRCRAFT WAS NOT GROUNDED. FOUND RIGHT-HAND CEILING EMERGENCY LIGHT AFT LENS TO BE BROKEN ABOVE DOOR 3R.SDR AALA201709119018Shroud · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT PROXIMITY LIGHT AT ROW 7 DEF FORWARD HAS A MISSING LENS AND SHROUD. INSTALLED LENS (AALA20170910006) AND SHROUD PER AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR AALA20170910009Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE CEILING LIGHTS FROM FUSELAGE STATION 1130 TO 1300 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK B5-27 (AALA20170910008) AND BATTERY ASSEMBLY B5-107 PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170910008Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE CEILING LIGHTS FROM FUSELAGE STATION 1130 TO 1300 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK B5-27 AND BATTERY ASSEMBLY B5-107 (AALA20170910009) PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170910006Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT PROXIMITY LIGHT AT ROW 7 DEF FORWARD HAS A MISSING LENS AND SHROUD. INSTALLED LENS AND SHROUD (AALA201709119018) PER AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR AALA20170910005Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE R4 GALLEY RIGHT SIDEWALL IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-10 AND WDM 33-51-15. OPERATIONAL CHECK GOOD.SDR AALA20170910003Lens · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT ROW 18 ABC OVERWING EXIT SIDEWALL HAS A DAMAGED PLACARD. REPLACED LENS COVER (PLACARD) PER AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR AALA20170910002Lens · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT ROW 17 DEF OVERWING EXIT SIDEWALL HAS A DAMAGED PLACARD. REPLACED LENS COVER (PLACARD) PER AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR AALA20170910001Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT ROW 17 ABC OVERWING SIDEWALL HAS A MISSING LENS PLACARD. REPLACED LENS COVER (PLACARD) PER AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR JJBA20170910003Battery Pack · dischargedMULTIPLE EMERGENCY EXIT LIGHTS INOPERATIVE. FOUND THE BATTERY LOW. CHARGED THE BATTERY. OPS CHECKED GOOD. NO OTHER DEFECTS NOTED.SDR CALA2017091003122Battery Pack · dischargedFWD LEFT SIDE OF COACH SEATS EMER LIGHTS INOP. R&R EMERGENCY LIGHTS BATTERY PACK OPS CHECK GOOD REF AMM 33-51-06.SDR CALA2017091003121Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK AT M1672 IS DEAD. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK AT M1672. OPS CHECK GOOD.SDR CALA2017091003120Power Supply · inoperativeR2 EMERGENCY DOOR SLIDE LIGHT INOP. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY (M732), REF AMM 33-51-07. OPS CK GOOD.SDR CALA2017091003119Battery Pack · dischargedDOOR 4 RIGHT EMERGENCY EXTERIOR LIGHT INOP. R&R BATTERY PACK FOR EMERGENCY EXTERIOR LIGHT AT DOOR 4 RIGHT OPS CHECKED NORMAL. REF WDM 33-51-21.SDR CALA2017091003117Light · damagedEMERGENCY LIGHT IS DAMAGED ON RT AISLE DIVIDER AFT OF BUSINESS CLASS. REPLACED EMERGENCY LIGHT ON RT AISLE DIVIDER AFT OF BUSINESS CLASS. OPS CHECK NORMAL.SDR CALA2017091003115Light · inoperativeLT EXTERIOR EMERG EXIT LIGHTS, 2EA LOWER AFT LIGHTS INOP. REPLACED BOTH LT LOWER OVERWING EMERG EXIT LIGHTS ASSEMBLIES, CORRECTED PROBLEM AND OPS CHECK GOOD. REF AMM33-51-03-004-034, AMM33-51-03-404-007.SDR SWAA2017091916448Lens · looseOVERWING CENTER AISLE AFT EXIT SIGN LENS LOOSE. SECURED SIGN IAW AMM.SDR HNAA2017091400305Cover · detachedFLOOR EMERGENCY LIGHT AT ROW 5 & 6, FOUND THE WIRES PULLED OUT AND PLASTIC COVER SECTION DETACHED. REPLACED THE LAMPS. INSTALLED THE PLASTIC COVERS. OPS CHECKED GOOD. OKAY FOR SERVICE.SDR AALA201709129030Shroud · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 21H HAS A MISSING LENS AND SHROUD. INSTALLED LENS (AALA201709129007) AND SHROUD PER AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR AALA201709129015Light · brokenAIRCRAFT WAS NOT GROUNDED. FORWARD EMERGENCY ESCAPE PATH FLOOR PROXIMITY FLOODLIGHT ACROSS FROM THE R4 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201709129007Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 21H HAS A MISSING LENS AND SHROUD. INSTALLED LENS AND SHROUD (AALA201709129030) PER AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR AALA201709129004Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE L1 DOOR IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY. OPERATIONAL CHECK GOOD.SDR AALA201709119011Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. FAILED SELF TEST OF EMERGENCY POWER UNIT SYSTEM TEST 11WL. REPLACED 11WL BATTERY PACK PER AMM 33-51-38.SDR SWAA2017091216316Battery Pack · dischargedR2 OVER DOOR EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2017091216312Light · inoperativeRT OVERHEAD BINS EMERGENCY EXIT AISLE LIGHTS INOP BETWEEN ROW 11 TO ROW 13. RELAMPED LIGHT IAW AMM.SDR SWAA2017091216311Battery Pack · dischargedRT AFT GALLEY EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2017091216310Battery Pack · dischargedL2 OVER DOOR EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2017091216306Light · inoperativeRT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. R&R LIGHT PER AMM.SDR SWAA2017091216300Cover · missingL1 DOOR LOWER EMERGENCY EXIT LIGHT COVER MISSING. R&R COVER ASSEMBLY PER MM.SDR SWAA2017091216277Ballast · inoperativeRT EMERGENCY EXIT SIDEWALL LIGHT INOP. R&R BALLAST IAW AMM.SDR SWAA2017091216264Bulb · inoperativeLEFT AFT ENTRY EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE BULB IAW MM.SDR DALA2017091106818Guard · malfunctionedWHEN PLACING THE EMERGENCY LIGHTS SWITCH IN ARMED POSITION AND THEN CLOSING THE BLACK COVER TO THE CLOSED POSITION, THE EMERGENCY LIGHTS BECOME UNARMED AS THE UNARMED ILLUMINATES AND THE EMERGENCY LIGHTS SWITCH IS FORCED BACK TO OFF. REMOVED & REPLACED THE SDR AALA201709119015Lens · crackedEMERGENCY EXIT LIGHT LENS CRACKED AND FELL OFF LIGHT NEAR DOOR L1. REPLACED EMERGENCY EXIT LIGHT LENS L1 DOOR.
Back to JASC 3350