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 AALA201708249020Lens · missingSMALL EMERGENCY LIGHT ON FRONT OF F/C CLOSET LENS COVER MISSING. REPLACED LENS COVER.. OPS CHECKED IAW AMM 33-51-00.SDR AALA201708249019Cover · missingEMERGENCY LIGHT COVER AT REAR MID GALLEY MISSING. REPLACED COVER IAW AMM 33-51-00.SDR AALA201708259022Cover · unsecureSIDE WALL PANEL NOT SECURED FOR EMERGENCY LIGHT BATTERY PACK. SECURED EMERGENCY LIGHT BATTERY PACK COVER AS REQ PER AMM.SDR AALA201708249011Lens · missingMISSING EXIT SIGN LENS COVER AT 4R. REPLACED 4R EXIT LENS.SDR AALA201708249010Lens · missingEXIT LIGHT COVER NEAR THE L4 DOOR SLIDE BUSTLE IS MISSING. INSTALLED EXIT LIGHT LENS COVER AT 4L DOOR IAW AMM.SDR AALA201708249008Bulb · burned outAFT LEFT LAVATORY EMERGENCY LIGHT BULB IS OUT. REPLACED THE BULB, CHECKED OK. AIRCRAFT FOR SERVICE.SDR FDEA201708232329Buss · inoperativeCOURIER EMERGENCY LIGHT WILL NOT TEST. REMOVED AND REPLACED AC SERVICE BUSS IAW AMM 24-42-11-04. OPS CHECKED GOOD.SDR SIMA20170823001Fuse · inoperativeBOTH LT AND RT EXTERIOR OVERWING EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED THE FUSE IN THE NR 4 BPSU IAW CMM 26-60-03. OPS TEST OF EXTERIOR OVERWING EMERGENCY LIGHTS CHECKS OK IAW AMM 33-50-00.SDR DALA2017082406371Light · unsecureEMERGENCY FLOOR LIGHTING INOPERATIVE AT 38F. SECURED THE LIGHTING. SYSTEM OPERATION IS NORMAL.SDR MASA2017082312573Lamp · inoperativeEMERGENCY FLOOD LIGHT AT ROW 23 INOPERATIVE. REPLACED THE LAMPS.SDR MASA2017082312572Lamp · inoperativeEMERGENCY OVERHEAD LIGHT ROW 6 - 16 INOPERATIVE. REPLACED THE LAMP.SDR AALA201708249002Battery · no testAIRCRAFT WAS NOT GROUNDED. MID CABIN EMERGENCY POWER SUPPLY UNIT & BATTERY FAILED AT 11WL. INSTALLED A NEW POWER SUPPLY UNIT & BATTERY IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017082406353Power Supply · inoperativeDURING SERVICE CHECK, MAINTENANCE FOUND L2 MAIN EXIT SIGN AND RIGHT FORWARD SERVICE DOOR EMERGENCY EXIT SIGN INOPERATIVE. THE EMERGENCY EXIT SIGN LIGHT BATTERY WAS REPLACED PER B717 AMM 33-51. NO HELP. THEN THE POWER SUPPLY FOR THE CABIN EMERGENCY EXIT SIGN WASDR MASA2017082312571Lamp · inoperativeAFT EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR MASA2017082312569Battery Pack · dischargedSEVERAL OVERHEAD EMERGENCY FLOOD LIGHTS ARE INOPERATIVE. CHARGED THE BATTERIES.SDR DALA2017082306343Battery Pack · inoperativeTHE EMERGENCY EXIT LIGHTS AT THE FORWARD DROP CEILING, EXIT IDENTIFIER IN FIRST CLASS CABIN AND THE SERVICE DOOR OVERHEAD LIGHT ARE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY B5-529 IAW AMM 33-51. ALL CHECKED GOOD.SDR E07A201802140008Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ONSDR DALA2017083006487Power Supply · inoperativeEMERGENCY LIGHTS POWER SUPPLY M9010 AT SEAT 40G IS INOPERATIVE. REPLACED POWER SUPPLY. SYSTEM OPERATION IS NORMAL.SDR A6WA201745219Light · inoperativeEMERGENCY LIGHTS ROW 6-8 DID NOT OPERATE WHEN INITIALLY TESTED, LIGHTS TURNED ON WHEN LEFT IN ON POSITION FOR EXTENDED PERIOD, APPROXIMATELY 90 SECONDS. R & R THE NR 3 EMERGENCY BATTERY INVERTER IAW AMM 33-51-07, R & R THE NR 4 EMERGENCY BATTERY INVERTER AMM SDR SWAA2017082815942Battery Pack · no testRIGHT OVERWING EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082815941Battery Pack · no testLEFT OVERWING EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082815938Battery Pack · no testRT FORWARD EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082815927Bulb · inoperativeFORWARD ENTRY DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. R & R THE BULB IAW AMM.SDR SWAA2017082815914Lens · detachedFORWARD ENTRY LOWER EXIT LIGHT LENS FELL OFF BASE. SECURED THE LENS IAW MM.SDR DALA2017082306398Lens · detachedL3 EXIT SIGN COVER FELL OFF LIGHT ASSEMBLY. ATTACHED THE COVER. CHECKED NORMAL.SDR AALA201708259021Lens · missingROW 1 LT EMERGENCY LIGHT LENS COVER MISSING. INSTALLED NEW EMERGENCY LENS COVER AT ROW 1 LT IAW AMM.SDR AALA201708239010Cover · missingL1 DOOR EMERGENCY EXIT LIGHT MISSING IT`S COVER. FOUND AND REINSTALLED THE COVER.SDR I5EA2017082400001Battery Pack · dischargedSEAT MOUNTED AISLE LOCATOR LIGHTS INOPERATIVE ON RT SEAT ROWS 11 THROUGH 21. REPLACED THE BATTERY PACK.SDR AALA201708249003Lens · crackedCRACKED R1 DOOR EMERGENCY EXIT LIGHT LENS. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708239034Light · unsecureEMERGENCY EXIT LIGHT OVERHEAD IN THE AFT GALLEY IS DAMAGED. REATTACHED THE LIGHT ASSEMBLY TO CEILING. OPERATIONAL CHECKED GOOD IAW AMM 33-50-00.SDR AALA201708239032Bracket · brokenEMERGENCY EXIT LIGHT BY THE L1 DOOR HAS A BROKEN MOUNTING BRACKET. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201708239021Lens · crackedMAIN CABIN FORWARD LEFT CLOSET EXIT LIGHT LENS COVER IS CRACKED. REPLACED THE LENS. AIRCRAFT WAS GROUNDED.SDR AALA201708239019Sign · missingEXIT SIGN MISSING AT THE R1 DOOR. REPLACED THE SIGN.SDR AALA20170822003Battery · no testEMERGENCY LIGHTS BATTERY FAILED TO TEST. REMOVED AND REPLACED BATTERY ASSEMBLY. OPERATIONAL CHECKED GOOD.SDR SWAA2017082415900Lens · missingCABIN AISLE EMERGENCY LIGHT LENS MISSING. INSTALLED THE LENS IAW MM.SDR SWAA2017082415899Lamp · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR AALA201708239008Light · inoperativeEMERGENCEY LIGHT AT SEATS 15 LEFT INOPERATIVE. REPLAED EMERGENCEY LIGHTSDR AALA201708239007Light · brokenEMERGENCY LIGHT IS BROKEN AT SEAT 11C. REPLACED EMERGENCY LIGHT ASSEMBLY.SDR JJBA20170822019Battery · dischargedEMER LIGHTS ON OVHD NR 2,3,6 INOP. R&R PS 3 POWER SUPPLY AND BATTERY OPS CHECK SAT NO DEFECTS NOTED. POWER SUPPLY UNIT PN 60-3844-3 SN 3600 TT 32579.88 TC 35775.SDR DALA2017082306345Battery Pack · not reportedOVERWING EMERGENCY EVACUATION LIGHT BATTERY PACK OPS CHECK. REPLACED OVERWING EMERGENCY LIGHT POWER SUPPLY AND BATTERY PACK IAW AMM 33-53-00 PERFORMED SATISFACTORY OPS CHECK.SDR SWAA2017082315885Lens · crackedRT EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 10 TO ROW 14. R&R LENS PER AMM.SDR MASA2017082212567Battery Pack · dischargedROW 14 LT OVERWING EMERG EXIT SIGN INOP. REPLACED BATTERY PACK 3.SDR MASA2017082212566Battery Pack · dischargedROW 14 RT OVERWING EMERG EXIT LIGHT INOP. REPLACED BATTERY PACK 3.SDR MASA2017082212565Battery Pack · dischargedROW 13 OVHD EMERG EXIT LIGHT INOP. REPLACED BATTERY PACK 3.SDR A6WA2017091145272Battery Pack · no testEMERGENCY LIGHT BATTERY PACK NR 3 FAILED OPERATIONAL TEST. REPLACED THE BATTERY PACK IAW AMM 33-51-04, OPS CHECKED GOOD IAW AMM 33-51-04-740-801.SDR DALA2017082306369Power Supply · inoperativeEMERGENCY LIGHTING AT SEATS 32AB-41AB &31GF ARE INOPERATIVE. REPLACED M9010 EMERGENCY POWER SUPPLY. SYSTEM OPERATION IS NORMAL.SDR AALA201708239038Mount · unsecureRED EMERGENCY LIGHT IN THE AISLE FLOOR ADJACENT TO SEAT 19D IS COMING OUT OF MOUNT. SECURED THE MOUNT IAW AMM 33-60-98. OPERATIONAL CHECKED GOOD.SDR AALA201708239036Lens · unsecureEMERGENCY EXIT LIGHT BY THE FORWARD SERVICE DOOR HAS AN UNSECURE LENS. SECURED THE LENS IAW AMM 33-20-00. OPERATIONAL CHECKED GOOD.SDR AALA201708229023Light · brokenR1 DOOR EMERGENCY EXIT SIGN IS BROKEN AT LOWER FASTENERS. REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708229022Light · brokenL1 DOOR EMERGENCY EXIT SIGN IS BROKEN OFF LOWER FASTENERS. REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350