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 SCNA20180301069Charger · inoperativeON RON CHECK FOUND THE FWD EMG FLOOR LIGHT INOP. DEACTIVATED THE FWD LEFT WIND SCREEN PROX LIGHT. PLACED DEACTIVATION OF LT FWD PROX LIGHT ON GMM/MTI FOR TRACKING PURPOSES. R&R FWD LEFT EMERG LIGHT BATT CHARGER. OP CHKS GOOD. OK FOR SVC, THIS CLEARS MTI/GMM.SDR R61A201803030279Power Supply · defectiveAFT SERVICE DOOR FLOOR EXIT LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-50-01. EMERGENCY LIGHT OP CHECKED GOOD IAW AMM 33-50-00.SDR AALA201803029030Sign · malfunctionedRIGHT FORWARD SERVICE DOOR, EMERGENCY EXIT SIGN NOT WORKING PROPERLY. REPLACED THE SIGN. THE AIRCRAFT WAS GROUNDED.SDR R61A201803010275Sign · brokenL2 DOOR EXIT SIGN FOUND BROKEN. R & R THE SIGN IAW AMM 33-50-15.SDR DALA2018030101329Power Supply · inoperativeEMERGENCY LIGHTS ROW 15 & 16 WILL NOT TURN ON. REMOVED AND REPLACED THE POWER SUPPLY AND BATTERY PACK IAW AMM 33-51-07.SDR DALA2018030101314Light · detachedROWS 24 & 31 EMERGENCY LIGHTS HANGING DOWN, INSTALLED THE LIGHTS.SDR SCNA20180301068Power Supply · inoperativeR2 DOOR EMERGENCY LIGHT SIGN DOES NOT ILLUMINATE. REMOVED AND REPLACED R2 DOOR EMERGENCY LIGHT POWER SUPPLY. OPS CK'D OK. A/C OK FOR SERVICE.SDR QXEA2018030100081Light · looseEMERGENCY LIGHT IN FWD GALLEY IS LOOSE. REMOVED FROM SERVICE. SECURED THE EMERGENCY LIGHT STRIP. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR CALA2018030100835Battery Pack · inoperativeAISLE EMERGENCY LIGHTS AT ROW 31 AND ROW 34 RIGHT HAND SIDE ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AT ROW 31R IAW AMM 33-51-06, OPS CHECKED GOOD.SDR DALA2018030101294Battery Pack · dischargedTHE EMERGENCY PATH LIGHTS WERE FOUND TO BE INOPERATIVE AT THE FWD RIGHT GALLEY OVERHEAD, THE EXIT LOCATOR IN THE CEILING AT ROW 1, AND AT THE FWD DROP DOWN CEILING NEXT TO THE LAVATORY. MAINTENANCE REPLACED THE BATTERY PACK B5-259 IAW AMM 33-51 AND THE EMERGENSDR AALA20180410006Charger · inoperativeEMERGENCY LIGHTS, FIRST CLASS LEFT SIDE, SEATS 2A TO 4A FAILED A 10 MINUTE ILLUMINATION TEST. REPLACED THE BATTERY AND CHARGER IAW AMM 33-51-00.SDR AALA20180410005Battery · inoperativeEMERGENCY LIGHTS, FIRST CLASS LEFT SIDE SEATS 2A TO 4A FAILED A 10 MINUTE ILLUMINATION TEST. REPLACED THE BATTERY AND CHARGER IAW AMM 33-51-00.SDR AALA20180410004Charger · inoperativeEMERGENCY LIGHTS, LEFT CEILING LIGHTS AT L1 DOOR TO SEAT ROW 13 FAILED AN ILLUMINATION TEST. REPLACED THE BATTERY AND CHARGER IAW AMM 33-51-00.SDR AALA20180410003Battery · inoperativeEMERGENCY LIGHTS, LEFT CEILING LIGHTS AT L1 DOOR TO SEAT ROW 13 FAILED AN ILLUMINATION TEST. REPLACED THE BATTERY AND CHARGER IAW AMM 33-51-00.SDR AALA201803029026Lens · damagedAIRCRAFT WAS NOT GROUNDED. FORWARD ENTRY WAY EMERGENCY FLOOD LIGHT LENS (HOUSING) DAMAGED. REPLACED LIGHT ASSEMBLY FORWARD ENTRY FLOOD LIGHT PER AMM 33-51-01 .SDR AALA201803029025Light · damagedAIRCRAFT WAS NOT GROUNDED. R1 DOOR EMERGENCY EXIT SIGN IDENTIFIER LENS MISSING (LIGHT ASSEMBLY DAMAGED). REPLACED LIGHT ASSEMBLY R1 DOOR PER AMM 33-51-01.SDR AALA201803029024Cover · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER BROKEN AT RIGHT AFT SERVICE DOOR. SECURED EMERGENCY EXIT LIGHT LENS AT AFT RIGHT SERVICE DOOR.SDR SWAA2018030520205Lens · crackedR2 DOOR THRESHOLD EMERGENCY EXIT LIGHT LENS CRACKED. R & R THE LENS IAW AMM.SDR SWAA2018030520204Lens · crackedL1 DOOR THRESHOLD EMERGENCY EXIT LIGHT LENS CRACKED. R & R THE LENS IAW AMM.SDR SWAA2018030520192Light · inoperativeLEFT EMERGENCY LIGHT ON STOW BIN INOPERATIVE, BETWEEN ROWS 6 & 7. R & R THE LIGHT IAW AMM.SDR SWAA2018030520189Battery Pack · no testBATTERY PACK AT M1669 FAILED A CAPACITY TEST. R & R THE BATTERY PACK IAW AMM.SDR AALA201803019026Battery Pack · faultyDOOR 5 POWER SUPPLY BATTERY PACK FAULTY. REPLACED POWER SUPPLY BATTERY PACK PER AMM 33-29-12.SDR AALA201803019014Lens · brokenSEAT ROW 30D EMERGENCY LIGHT SHROUD BROKEN. REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-60-98.SDR AALA201803019013Lens · brokenSEAT ROW 23D EMERGEMCY LIGHT SHROUD BROKEN. REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-60-98.SDR AALA201803019012Lens · brokenSEAT ROW 21D EMERGENCY LIGHT AFT SHROUD BROKEN. REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-60-98.SDR AALA201803019028Lens · brokenEMERGENCY EXIT LIGHT LENS BROKEN AT RIGHT AFT SERVICE DOOR. SECURED THE LENS.SDR AALA201803019023Lens · brokenEMERGENCY LIGHT LENS BROKEN AT SEAT ROW 20D. MAINTENANCE REPLACED THE LENS IAW AMM 33-60-98 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803019021Light · inoperativeL1 LAVATORY EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REINSTALLED THE LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-20-10.SDR R61A201802280273Lens · missingEMERGENCY LIGHT ABOVE THE AISLE IN FIRST CLASS WAS MISSING THE COVER. R & R THE EMERGENCY LIGHT ASSEMBLY AT ROW 3D WAS REPLACED IAW AMM 33-50-13.SDR DALA2018022801330Power Supply · inoperativeEMERGENCY LIGHTS AT SEAT ROWS 1, 2 AND 3 INOPERATIVE. REPLACED THE POWER SUPPLY M731 IAW AMM 33-51. OPS CHECKED NORMAL.SDR DALA2018030101310Battery · dischargedON PDC FORUM ROW 1-12 EMERGENCY PATH LIGHTS INOP. R&R BATTERY AND BATTERY CHARGER PER AMM 33-53. OPS NML. OK FOR SVC.SDR QXEA2018022800074Light · looseEMERGENCY LIGHT STRIP AT ROW 2 IS LOOSE. RESECURED AS REQUIRED. RETURNED TO SERVICE. NO PARTS REPLACED.SDR SWAA2018022820154Lens · crackedLT OVERHEAD EMERGENCY LIGHT LENS BEZEL CRACKED AT ROW 16. R&R LENS IAW AMM.SDR SWAA2018022820146Lens · crackedRT OVERHEAD EMERGENCY LIGHT LENS BEZEL CRACKED BETWEEN ROW 2 TO ROW 25. R&R LENS IAW AMM.SDR AALA201803019002Light · inoperativeSEAT MOUNTED SEAT EMERGENCY LIGHT 2 E/F INOPERATIVE. REPAIRED THE SEAT MOUNTED EMERGENCY LIGHT.SDR SWAA2018031420397Sign · damagedAFT ENTRY LOWERED CEILING EMERGENCY EXIT SIGN DAMAGED. R & R THE SIGN IAW AMM.SDR FDEA201802270501Light · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSY IAW MM 33-51-06-2-1. OPS CHECKED GOOD.SDR FDEA201802270500Battery Pack · inoperativeL1 DOOR INTERIOR EMERGENCY EXIT SIGN LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK IAW MM 33-51-07-2-0.SDR SWAA2018030620230Lens · missingR2 DOOR EMERGENCY EXIT LIGHT LENS MISSING. REINSTALLED THE LENS IAW AMM.SDR SWAA2018030520225Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1169. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018030520213Sign · looseOVERWING EMERGENCY EXIT SIGN LOOSE. R & R THE SIGN ASSEMBLY IAW MM.SDR SWAA2018030520211Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1668. R & R THE BATTERY PACK IAW AMM.SDR AALA201803019032Lens · brokenEMERGENCY AISLE LIGHTS LENS AT ROW 15DEF IS BROKEN. REPLACED THE LENS IAW AMM 33-21-03.SDR AALA201803019031Lens · brokenEMERGENCY AISLE LIGHTS LENS AT ROW 23ABC IS BROKEN. REPLACED THE LENS IAW AMM 33-21-03.SDR AALA201803019030Lens · brokenEMERGENCY AISLE LIGHTS LENS AT ROW 25DEF IS BROKEN. REPLACED THE LENS IAW AMM 33-21-03.SDR AALA201803019029Lens · brokenEMERGENCY AISLE LIGHTS LENS AT ROW 27ABC IS BROKEN. REPLACED THE LENS IAW AMM 33-21-03.SDR AALA201803019027Lens · brokenEMERGENCY AISLE LIGHTS LENS AT ROW 14DEF IS BROKEN. REPLACED THE LENS IAW AMM 33-21-03.SDR AALA201803019011Lens · brokenSEAT 27DEF EMERGENCY LIGHT LENS BROKEN. REPLACED THE LENS IAW AMM 25-27-03.SDR AALA201803019010Lens · brokenSEAT 26DEF EMERGENCY LIGHT LENS BROKEN. REPLACED THE LENS IAW AMM 25-27-03.SDR AALA201803019009Lens · brokenSEAT 23DEF EMERGENCY LIGHT LENS BROKEN. REPLACED LENS IAW AMM 25-27-03.
Back to JASC 3350