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 SWAA2017080815376Light · inoperativeAFT OVERWING EXTERIOR EMERGENCY EGRESS LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2017080315497Battery · no testEMERGENCY LIGHT BATTERY M1672 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2017080315496Battery · no testEMERGENCY LIGHT BATTERY M1675 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2017080315329Battery · no testEMERGENCY LIGHT BATTERY M1669 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2017080115414Light · damagedFORWARD LAVATORY AFT WALL EMERGENCY EXIT LIGHT DAMAGED. R&R LIGHT IAW AMM.SDR SWAA2017080115366Battery Pack · failedAFT GALLEY AREA EMERGENCY LIGHT FAILED CAPACITY FUNCTION CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2017080115326Lens · brokenLT FORWARD OVERWING DOOR EMERGENCY EXIT SIGN BROKEN. R&R LENS IAW AMM.SDR AALA201707269054Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT BATTERY POWERED SIGN BY THE L2 DOOR HAS A BROKEN LENS COVER. L2 DOOR AFT EXIST SIGN LENS INSTALLED IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201707319006Sign · inoperativeEXIT LOCATION SIGN ON MAIN AISLE FORWARD CABIN AFT FACING FIRST CLASS NEEDS FIVE BULBS REPLACED. MAINTENANCE REPLACED EXIT MARKING SIGN IAW MM 33-51-16-0401. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS GROUNDED.SDR AALA201707319005Sign · inoperativeEXIT MARKING SIGN AT DOOR 2 RIGHT NEEDS FOUR BULBS REPLACED. MAINTENANCE REPLACED EXIT MARKING SIGN IAW MM 33-51-16-0401. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS GROUNDED.SDR AALA201707319004Sign · inoperativeEXIT MARKING SIGN AT DOOR 2 LEFT NEEDS FIVE BULBS RELPACED. MAINTENANCE REPLACED EXIT MARKING SIGN IAW MM 33-51-16-0401. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS GROUNDED.SDR AALA201707319003Sign · inoperativeEXIT MARKING SIGN AT DOOR 1 RIGHT NEEDS FOUR BULBS REPLACED. MAINTENANCE REPLACED EXIT MARKING SIGN IAW MM 33-51-16-0401. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS GROUNDED.SDR AALA201707319002Bulb · inoperativeLEFT FORWARD ENTRY DOOR EXIT SIGN NEEDS TWO BULBS. REPLACED THE BULBS. MAINTENANCE REPLACED EXIT MARKING SIGN IAW MM 33-51-16-0410. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS GROUNDED.SDR HNAA2017073100252Light · inoperativeFLOOR PROXIMITY EMERGENCY LIGHTS AND EXIT DOOR EMERGENCY LIGHTS WILL NOT ILLUMINATESDR HNAA2017073100251Light · inoperativeTHIRD RED FLOOR EMERGENCY LIGHT INOPERATIVE.SDR CALA2017072802385Battery · dischargedMAIN DECK L3 DOOR, TWO EMERGENCY LIGHT POWER PACKS (M33406 & M33405) FOUND LOW CAPACITY. REPLACED, AND OPS TESTED GOOD IAW AMM 33-51-06-960-802, REV 80.SDR R61A201707250543Battery · inoperativeEMERGENCY LIGHT BATTERY FAULT. TROUBLESHOT IAW FIM 33-50-00, SUSPECT FAULTY BATTERY. R & R FAULTY EMERGENCY BATTERY IAW MM 33-50-01. OPS CHECKED GOOD.SDR AALA201707289011Light · brokenEMERGENCY EXIT SIGN BOTTOM BRACKETS BROKEN ON THE R4 DOOR. REPLACED LIGHT ASSEMBLY IAW MM 33-50-00.SDR AALA201707289007Housing · brokenSEAT MOUNTED EMERGENCY LIGHT HOUSING BROKEN AT SEAT 25C. REPLACED LIGHT HOUSING IAW CMM 25-22-52.SDR AALA201707289006Housing · brokenSEAT MOUNTED EMERGENCY LIGHT HOUSING BROKEN AT SEAT 22C. REPLACED LIGHT HOUSING IAW CMM 25-22-52.SDR AALA201707289005Housing · brokenSEAT MOUNTED EMERGENCY LIGHT HOUSING BROKEN AT SEAT 20C. REPLACED LIGHT HOUSING AT SEAT IAW CMM 25-22-52.SDR AALA201707289004Housing · brokenSEAT MOUNTED EMERGENCY LIGHT HOUSING BROKEN AT SEAT 17C. REPLACED LIGHT HOUSING AT SEAT IAW CMM 25-22-52.SDR AALA201707279003Light · crackedCRACKED R1 DOOR EMERGENCY EXIT SIGN LENS COVER. REPLACED R1 EMERGENCY EXIT LIGHT ASSEMBLY IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707279002Light · brokenL1 DOOR EMERGENCY EXIT SIGN IS BROKEN OFF LOWER FASTENER. REPLACED THE EMERGENCY EXIT LIGHT ASSEMBLY IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY, OPS CHECKED GOOD.SDR AALA201707279001Light · brokenEMERGENCY EXIT SIGN, BOTTOM BRACKETS BROKEN ON THE L1 DOOR. REPLACED LIGHT ASSEMBLY IAW MM 33-50-00.SDR AALA201707269034Housing · brokenSEAT MOUNTED EMERGENCY LIGHT HOUSING BROKEN AT SEATS 15C. REPLACED LIGHT HOUSING AT SEAT 15C IAW CMM 25-22-52.SDR AALA201707279027Lens · defectiveFORWARD SERVICE DOOR MISSING LENS FOR THE EMERGENCY EXIT LIGHT. REMOVED AND REPLACED R1 DOOR EMERGENCY LIGHT ASSY IAW MM 33-51-00, OP CHECKED NORMAL.SDR AALA201707279025Sign · detachedEXIT SIGN AT R2 DOOR WILL NOT STAY IN PLACE. REPLACED EXIT SIGN ASSY AT R2 DOOR. OPERATIONAL CHECK GOOD IAW MM 33-51-01.SDR ASOA201707254045Bulb · inoperativeTHE CREW REPORTED THAT THE MAIN CABIN DOOR EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED LIGHT BULB, OPERATIONALLY TESTED WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201707269053Lens · missingEMERGENCY LIGHT AT SEAT 24H HAS A MISSING LENS. INSTALLED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR F3LA2017072700188Battery Pack · no testEPSU 13WL BATTERY FAILED TEST. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED OKAY IAW AMM33-51-38 PB 401.SDR DALA2017072505705Fuse · inoperativeEMERGENCY LIGHTS AT SEAT 18B ARE INOPERATIVE. MAINTENANCE FOUND FUSE OPEN. REPLACED THE FUSE M 1209. SYSTEM OPS NORMAL.SDR SWAA2017072515254Lens · missingRT AISLE EMERGENCY LIGHT LENS MISSING AT ROW 10. INSTALLED LENS PER MM.SDR YENA201707240604Battery · no testEMERGENCY LIGHTS FAILED TO TEST. R & R THE BATTERY PACK AT 11WL LEFT. CHECKED OK IAW AMM 33-51-38.SDR DALA2017072505760Connector · unsecureL2/R2 OVERHEAD EMERGENCY EXIT LOCATOR SIGN INOPERATIVE. TROUBLESHOT IAW WDM 33-51-13. TIGHTENED THE CONNECTOR D4518, AND THE EMERGENCY EXIT SIGNS OPERATE NORMALLY IAW AMM 33-51.SDR REXA2017072400816Battery Pack · dischargedEMERGENCY BATTERY PACKS 3, 4, AND 5 FAILED TO CHARGE. REMOVED AND REPLACED NR 4 BATTERY PACK IAW AMM 33-51-17. OPS TEST OF 3, 4, AND 5 GOOD IAW AMM 33-51-17-710-801, OPS TEST OF THE EMERGENCY LIGHTS GOOD IAW AMM 33-51-00-710-802.SDR HALA2017072600205Sign · detachedEXIT SIGN AT THE L2 DOOR FOUND LOOSE AND HANGING FROM CEILING. ATTACHED THE EXIT SIGN.SDR DALA2017072500204Lens · missingEMERGENCY EXIT COVER DIFFUSE LENS MISSING. REPLACED EMERGENCY LIGHT LENS.SDR DALA2017072500203Lens · missingSEAT 11C MISSING EMERGENCY PROXIMITY LIGHT LENS AND BULBS. REPLACED BULBS AND LENSES.SDR SWAA2017072615284Cover · detachedFORWARD VERTICAL EXIT SIGN COVER FELL OFF. SECURED THE COVER IAW AMM SIP.SDR AALA201707269031Lens · missingEMERGENCY EXIT SIGN LENS ON THE L4 DOOR MISSING. REPLACED THE LENS IAW AMM 33-51-00.SDR SIMA20170724003Light · inoperativeAREA EMERGENCY LIGHT ON GALLEY DOOR HINGE INTERMITTENT. REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT ASSY IAW AMM 33-50-10. OPS CHECK GOOD.SDR SIMA20170724001Battery · dischargedNR 2 EMERGENCY LIGHT BATTERY INOP. REMOVED AND REPLACED NR 2 EMERGENCY LIGHT BATTERY PER AMM 33-51-17.SDR SIMA20170724002Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED BATTERY PACK NR 1 IAW AMM 33-51-17 OPS CHECK GOOD.SDR DALA2017072505695Battery Pack · inoperativeFWD FLIGHT ATTENDANT SWITCH NOT TURNING ON EMERGENCY LIGHTS. FOUND THE OVERWING EMERGENCY LIGHTS BATTERY PACK B5-49 INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-53. ALL FUNCTIONS NORMAL.SDR AALA201707259007Sign · brokenTHE AIRCRAFT WAS NOT GROUNDED. EXIT LIGHT AT FWD L1 DOOR BROKEN AND MISSING. REMOVED AND REPLACED FWD L1 DOOR EXIT SIGN IAW AMM 33-51-00. CHECKS GOOD.SDR AALA201707259006Sign · missingTHE AIRCRAFT WAS NOT GROUNDED. EXIT SIGN AT THE AFT RIGHT SERVICE DOOR IS MISSING. REMOVED AND REPLACED R4 DOOR EXIT SIGN IAW AMM 33-51-00. CHECKS GOOD.SDR AALA201707259003Lens · crackedWING TO FUSELAGE FAIRING 199ML LIGHT LENS COVER IS CRACKED. REPLACED LENS. AIRCRAFT WAS GROUNDED.SDR SWAA2017072515242Lens · crackedL1 DOOR EXTERNAL EMERGENCY EXIT LIGHT LENS CRACKED. R & R THE LENS IAW MM.SDR SWAA2017072515241Light · looseCENTER AISLE EXIT SIGN LOOSE. R & R THE LIGHT ASSEMBLY IAW AMM.
Back to JASC 3350