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 SWAA2017052213877Cover · brokenL1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. R & R THE LIGHT ASSEMBLY PER AMM.SDR HNAA2017052200181Bulb · burned outTHIRD EMERGENCY LIGHT AFT IS INOPERATIVE. R & R THE BULB.SDR HNAA2017052200180Bulb · burned outFIRST MOST EMERGENCY LIGHT INOPERATIVE. R & R THE BULB.SDR YENA201705210382Epsu · failedSEVERAL EMERGENCY LIGHTS INOPERATIVE. R & R THE FWD LT EPSU IAW AMM 33-51-38. ALL CHECKED NORMAL. ACFT OK FOR SERVICE.SDR DALA2017052104055Battery · dischargedEMERGENCY EXIT SIGN IN CEILING FORWARD OF 1ST CLASS IS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY IN B5-259 POWER PACK REF AMM 33-51. OPERATIONAL CHECK IS GOOD.SDR REXA2017052000631Wire · brokenRIGHT OVERWING, FWD EMERGENCY LIGHT WIRES BROKEN. REMOVED AND REPLACED THE LIGHT IAW AMM 33-51-15. OPS TESTED GOOD IAW AMM 33-51-15-710-801.SDR ASAA2017052020863Battery Pack · inoperativeR1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. ACFT GROUNDED. REMOVED & REPLACED THE BATTERY PACK & OPS CHECKED GOOD IAW AMM 33-51-06-960-005.SDR AALA201705249047Cover · brokenEMERGENCY LIGHT PANEL COVER G2 GALLEY IS BROKEN. REPLACED EMERGENCY LIGHT PANEL COVER AT G2 GALLEY. OPS CHECK NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705249046Lens · missingFOUND EMERG EXIT LIGHT LENS MISSING OUTSIDE AFT STARBOARD LAV. LIGHT WORKS OK. REPLACED LENS AT LIGHT RIGHT AFT LAV (CLEAR LENS). OK FOR SVC IAW AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705249045Sign · damaged4L EXIT SIGN DAMAGED. REMOVED AND REPLACED 4L EXIT SIGN ASSY IAW AMM 33-51-01, OPS CHECK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705229040Light · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 14 RIGHT OVERHEAD PANEL IS LOOSE. SECURED LIGHT IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201705229037Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R2 DOOR HAS A DETACHED LENS COVER. REINSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR DALA2017052204156Housing · damagedPAX SEAT 31ABC EMERGENCY LIGHT HOUSING DAMAGED, REPLACED THE HOUSING.SDR SWAA2017052313951Light · inoperativeRT OVERWING EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA2017052313948Light · inoperativeL2 DOOR EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2017052313944Light · inoperativeR2 DOOR EXIT LIGHT INOP. R&R LIGHT ASSY PER MM.SDR SWAA2017052313921Light · inoperativeEMERGENCY EXIT LIGHT INOP AT ROW 1 ABC. RELAMPED PER MM.SDR SWAA2017052313917Battery · dischargedLT OVERWING EXIT LIGHT INOP. R&R EXIT LIGHT BATTERY ASSY PER MM.SDR AALA201705239022Lens · missingAIRCRAFT NOT GROUNDED. 10D SEAT EMERGENCY LIGHT LENS MISSING. REPLACED LENS PER AMM 33-51-18.SDR DALA2017052204128Attach Fitting · brokenEXIT SIGN DOOR 2. FOUND ATTACH CLIP BROKEN. R & R EXIT SIGN COVER AT 2R.SDR SWAA2017052213884Lens · looseL/H EMERGENCY EXIT LIGHT LENS COVER LOOSE AT ROW 14. R & R THE LIGHT ASSEMBLY IAW AMM.SDR AALA201705229010Battery · failedEMERGENCY LIGHT BATTERY FAILED AT DOOR 4. REPLACED THE BATTERY. AIRCRAFT WAS GROUNDED.SDR AALA201705229025Lens · brokenEMERGENCY LIGHT LENS BROKEN AT SEAT ROW 1 LEFT. REMOVED AND REPLACED THE LIGHT ASSEMBLY.SDR AALA201705229014Lens · brokenEXIT LIGHT LENS AT THE R2 DOOR IS BROKEN. REPLACED THE LENS.SDR SWAA2017052213875Lens · looseEMERGENCY LIGHT COVER LENS LOOSE. SECURED THE LENS IAW MM.SDR HNAA2017052200179Lens · crackedLOWER EMERGENCY EXIT LIGHT AT SEATS 1 DF HAD A CRACKED LENS AND BULBS INOPERATIVE. R & R THE BULBS AND INSTALLED NEW LENSES.SDR DALA2017052104056Battery Pack · dischargedTHE OVERWING EMERGENCY EXIT LIGHT IS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK PER AMM 33-50. OPERATIONAL CHECK IS GOOD.SDR MASA2017052012318Light · inoperativeCEILING EMER LIGHT ROW 11 INOP. PLACED ON MEL.SDR MASA2017052012317Light · inoperativeEMER EXIT SIGN AT ROW 13, 1 EA BULB INOP. PLACED ON MEL.SDR MASA2017052012316Light · inoperative1 LAMP INOP LT OVERWING EXIT INOP. PLACED ON MEL.SDR DALA2017052004052Lens · looseEMERGENCY EXIT COVER DIFFUSER LENS LOOSE. RE-SECURED DIFFUSER ASSEMBLY.SDR SWAA2017052313952Lens · looseEXIT LIGHT LENS AT FWD F/A'S SEAT LOOSE. REINSTALLED LENS PER MM.SDR DALA2017051904127Battery · dischargedSEAT ROW 43 TO 45 EMERGENCY LIGHT NOT TESTING. REMOVED AND REPLACED BATTERY ASSEMBLY ON M736. OPS CHECK NORMAL PER AMM 33-51.SDR AALA201705229044Lens · brokenEMERGENCY EXIT GROUND ILLUMINATION SLIDE LIGHT BY R2 DOOR IS INOPERATIVE AND HAS A BROKEN LENS. REMOVED AND REPLACED LIGHT ASSEMBLY AND LENS IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201705229042Battery · no testFLIGHT ATTENDANT EMERGENCY FLASHLIGHT AT THE L4 DOOR IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-01. OPS CHECKED GOOD.SDR AALA201705229041Light · inoperativeEMERGENCY EXIT GROUND ILLUMINATION SLIDE LIGHT BY THE R2 DOOR IS INOPERATIVE AND HAS A BROKEN LENS. REMOVED AND REPLACED LIGHT ASSEMBLY AND LENS IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201705229038Lens · detachedEMERGENCY EXIT LIGHT BY THE L2 DOOR HAS A DETACHED LENS. REINSTALLED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201705229009Lens · detachedEXIT SIGN LENS AT THE R3 DOOR DETACHED. INSTALLED THE EXIT SIGN LENS.SDR AALA201705229028Lens · brokenEMERGENCY LIGHT LENS AT THE L4 DOOR BROKEN. REPLACED THE LENS IAW AMM 33-51-11.SDR AALA201705229027Power Supply · failedEMERGENCY POWER SUPPLY UNIT 11WL FAILED. REMOVED AND REPLACED THE EPSU 11W.SDR AALA201705229026Lens · missingRED LENS MISSING FROM R4 DOOR FOR DEPRESS WARNING. REPLACED THE LENS IAW AMM 52-73-22-400-002.SDR HNAA2017052200178Light · unsecureEMERGENCY LIGHTS AT ROW 1 ARE NOT SECURED TO THE FLOOR. FOUND THE LIGHTS BOTTOM TRACK BROKEN, REPLACED REPLACED THE LIGHT, AND INSTALLED NEW LIGHT WIRING COVER.SDR HNAA2017052200177Bulb · burned outRED EMERGENCY LIGHT IN AISLE INOPERATIVE AT ROW 4 AND 2ND RED BULB AFT AT THAT LOCATION. R & R RED EMERGENCY LIGHT BULB AT ROW 4 AND 2ND RED BULB AFTSDR DALA2017052204070Light · inoperativeEMERGENCY LIGHTS AT ROWS 16 AND 23 INOPERATIVE. REPLACED THE EMERGENCY LIGHTS IAW 33-53-01. OPS CHECKED GOOD. OK FOR SERVICE.SDR MASA2017051912315Light · inoperative21AC CEILING EMERGENCY FLOOD LIGHT INOP. PLACED ON MEL WITH CREW.SDR MASA2017051912314Power Supply · faultyEMER LIGHT CAUTION MESSAGE. REPLACED AFT INBD POWER SUPPLY.SDR MASA2017051912313Power Supply · inoperativeAFT GALLEY EMER EXIT LIGHT INOP. REPLACED AFT INBD POWER SUPPLY.SDR MASA2017051912312Light · inoperativeCEILING EMER FLOOD LIGHT INOP ROW 9. RELAMPED.SDR MASA2017051912311Light · inoperativeROW 3 CEILING LVL EMER FLOODLIGHT INOP. PLACED ON MEL.SDR DALA2017052004051Sign · looseEMERGENCY EXIT SIGN LOOSE AT DOOR 3L. RE-SECURED EXIT SIGN.
Back to JASC 3350