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 CALA2017052201549Battery Pack · dischargedL2 DOOR AND AFT GALLEY EMER LIGHTS INOP. REMOVED AND REPLACED AFT BATTERY PACK AS REQD. OPS CK GOOD.SDR CALA2017052201548Battery Pack · malfunctionedEMERGENCY LIGHTS ILLUMINATED IN RANDOM SECTIONS THRU AIRPLANE CABIN. RESET CABIN EMERGENCY LIGHTS BATTERY PACK ASSEMBLIES FWD AND AFT. OPS CHECKS GOOD AS PER MM 33-51-00. OK TO CONTINUE.SDR CALA2017052201547Cover · missingLEFT OVERWING EMERGENCY EXIT DOOR LOWER INTERIOR EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED A NEW LIGHT COVER ON THE LOWER INTERIOR EMERGENCY EXIT LIGHT ON THE LEFT EMERGENCY EXIT DOOR. OK FOR SERVICE.SDR CALA2017052201546Cover · brokenMID CABIN EMERGENCY EXIT SIGN COVER BROKEN AND FELL OFF. RESECURED EXIT SIGN COVER ACFT OK TO CONTINUE.SDR CALA2017052201543Light · dirtyOUTSIDE DOOR 4R EMERGENCY LIGHT INOP. CLEANED CONTACTS ON THE BULB OPS CHECK GOOD PER AMM 33-51-06.SDR CALA2017052201542Fuse · burnedFOUND 1ST CLASS EMERGENCY AISLE LIGHTING NOT OPERABLE. (ROWS 1,2 AND 3) FROM FLIGHT ATTENDANT PANEL. OPENED OVERHEAD CEILING PANEL FOR ACCESS TO BATTERY PACK. FOUND 1 BURNT FUSE. REPLACED ALL 4 FUSES BITE CHECK FROM BATTERY PACK PROVES GOOD. DOES NOT OPERATE WSDR CALA2017052201550Light · looseEMERG LITE STRIP ON SEAT 35H IS LOOSE APPLIED TAPE, OPS CHKD GOOD.SDR CALA2017052201523Battery Pack · dischargedCABIN, ZONE 3 LAV PROXIMITY LIGHT FOUND DIM. M33401 & M33400 EMER BATTERY PACK REPLACED AND LAMP TEST NORMAL PER AMM 33-51-00.SDR CALA2017052201522Battery Pack · dischargedCABIN, ZONE 3 LT AISLE EMER LIGHT FOUND DIM. ZONE 3 M33406 BATTERY PACK REPLACED AND EMER LT LAMP TESTED NORMAL AS PER AMM 33-51-00.SDR CALA2017052201521Battery Pack · dischargedCABIN, ZONE1 LT AISLE EMER LIGHT LAMP TEST FAILED PER AMM 33-51-00. ZONE 1 M33424 BATTERY PACK REPLACED AND EMER LIGHT LAMP TESTED NORMAL PER AMM 33-51-00.SDR CALA2017052201520Battery Pack · dischargedCABIN, DOOR 4 RT EXIT SIGN FOUND DIM. M33409 EMER BATTERY PACK REPLACED AND EXIT SIGN LAMP TESTED NORMAL PER AMM 33-51-00.SDR CALA2017052201519Battery Pack · dischargedCABIN, DOOR4 LT EXIT SIGN FOUND DIM. M330407 BATTERY PACK REPLACED AND EXIT SIGN LAMP TEST NORMAL PER AMM 33-51-00.SDR CALA2017052201518Battery Pack · dischargedZONE 2 RT EXIT SIGN FOUND DIM. ZONE 2 M33097 EMER BATTERY PACK REPLACED AND LAMP TESTED NORMAL PER AMM 33-51-00.SDR CALA2017052201517Battery Pack · dischargedCABIN, ZONE 2 RT AISLE EMER LIGHT FOUND DIM. ZONE 2 M33098 BATTERY PACK REPLACED AND EMER LT LAMP TEST NORMAL PER AMM 33-51-00.SDR CALA2017052201516Charger · inoperativeZONE 3 RT AISLE EMER LIGHT FOUND DIM. M33404 BATTERY CHARGER REPLACED AND EMER LIGHT LAMP TEST NORMAL PER AMM 33-51-00.SDR CALA2017052201514Battery Pack · dischargedCABIN, ZONE 1 LT EXIT SIGN FOUND DIM. ZONE 1 M33093 BATTERY PACK REPLACED AND EXIT SIGN TESTED NORMAL PER AMM 33-51-00. ZONE 1 M33093 BATTERY PACK REPLACED AND EXIT SIGN TESTED NORMAL PER AMM 33-51-00.SDR SWAA2017052213876Lens · brokenR2 DOOR EMERGENCY EXIT SIGN LIGHT LENS BROKEN. R & R THE LENS IAW MM.SDR YENA201705220384Battery · failedEMERGENCY LIGHTS FAILED TO TEST. R & R THE BATTERY IAW AMM 33-51-38.SDR YENA201705220383Battery · failedEMERGENCY LIGHTS FAILED TO TEST. R & R THE BATTERY IAW AMM 33-51-38.SDR MASA2017052212320Lamp · inoperativeROW 23 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR DALA2017052204069Battery Pack · inoperativeAFT FUSELAGE EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-53. OPS CHECKED GOOD.SDR DALA2017052204063Battery · dischargedOVERWING EMERGENCY EXIT LIGHTS INOP AT 25ABCDE. REPLACED BATTERIES PER AMM 33-53. OPS CHECK GOOD.SDR AALA201705259029Cover · brokenEMERGENCY EXIT LIGHT COVER AT FWD SERVICE DOOR BROKEN. THE COVER WAS REPLACED IAW AMM 25-63-00, GOOD FOR SERVICE.SDR AALA201705259028Cover · damagedEMERGENCY EXIT LIGHT COVER AT CENTER FUSELAGE DAMAGED. THE COVER WAS REPLACED IAW AMM 25-63-00, GOOD FOR SERVICE.SDR AALA201705259027Light · brokenRIGHT AFT GALLEY EMERGENCY LIGHT ASSY BROKEN. REPLACED THE EMERGENCY LIGHT IAW STANDARD PRACTICES 20-30-12. OPS NORMAL IAW AMM 33-15-00.SDR AALA201705259026Light · brokenAISLE MOUNTED EMERGENCY LIGHT ASSY AT FWD GALLEY LENS AND FIXTURE BROKEN. REPLACED AISLE MOUNTED EMERGENCY LIGHT ASSY AT FWD GALLEY IAW STANDARD PRACTICES 20-30-12. OPS NORMAL IAW AMM 33-15-00.SDR AALA201705259025Lens · missingEMERGENCY EXIT LIGHT LENS MISSING FWD GALLEY. REPLACED THE LENS IAW AMM 33-51-00. OPS CHECKED OK.SDR AALA201705259024Lens · detachedAFT RIGHT CABIN DOOR EMERGENCY EXIT COVER DOES NOT STAY ON. REPLACED THE LIGHT ASSEMBLY, OPS CHECKED GOOD IAW AMM 33-51-01.SDR AALA201705259023Battery · no testEMERGENCY TAIL CONE AREA LIGHTS INOPERATIVE DURING TEST. EMERGENCY TAIL CONE AREA LIGHTS OP CHECKED NORMAL, IAW MM 33-53-00 AFTER BATTERIES RECHARGED.SDR AALA201705259021Battery Pack · no testEMERGENCY CEILING LIGHTS INOPERATIVE FROM ROWS 29 TO 31, DURING TEST. REMOVED AND REPLACED THE BATTERY PACK IAW MM 33-53-00, EMERGENCY CEILING LIGHTS OP CHECKED NORMAL.SDR AALA201705259020Cover · missingSEAT 10D EMERGENCY LIGHT COVER IS MISSING. REPLACED EMERGENCY LIGHT COVER SEAT 10D IAW AMM 33-51-05. OK FOR SVC. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705259019Light · inoperativeEMERGENCY FLOOR PROXIMITY LIGHT ASSYS AT GALLEY G3 RT AND LT POSITION INOPERATIVE. REPLACED EMERGENCY LIGHT ASSY IAW AMM 33-51-05, CHECKED OK.SDR AALA20170522007Battery · dischargedCEILING EMERGENCY LIGHTS INOP FROM ROW 28 TO 31 ON TEST . REMOVED AND REPLACED BATTERY PACK. CEILING EMERGENCY LIGHTS FROM RO 28 TO 31 OP CHK NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170522005Lens · brokenAISLE MOUNTED EMERGENCY LIGHT ASSEMBLY AT FWD GALLEY BROKEN. REPLACED EMERGENCY LIGHT ASSEMBLY AT FWD GALLEY ISLE LOCATION IAW 20-30-12. OPS NORMAL IAW 33-51-00. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170522004Lens · brokenRT AFT GALLEY EMERGENCY LIGHT LENS AND ASSEMBLY BROKEN, REPLACED RT AFT GALLEY EMERGENCY LIGHT LENS AND ASSEMBLY IAW 20-30-12. OPS NORMAL IAW AMM 33-51-00. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705239020Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN OVER R2 DOOR HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20170521001Light · brokenBROKEN EMERGENCY EXIT LIGHT AT THE R1 DOOR, FLOOR LEVEL. REPLACED EMERGENCY EXIT LIGHT IAW AMM 33-51-16.SDR JJBA20170521032Sign · unknownEMERGENCY EXIT SIGN, ROW 18 OVERHEAD FWD SIDE, INOPERATIVE. PERFORMED AN OPS TEST, OPS TESTED GOOD. NO DEFECTS NOTED.SDR DALA2017052204141Cids · malfunctionedEMERGENCY EXIT SIGNS INOPERATIVE. RESET CIDS.SDR SWAA2017052313949Light · inoperativeR1 DOOR EVAC SLIDE LIGHT INOP. RELAMPED PER MM.SDR SWAA2017052313916Lens · looseL2 DOOR EXIT LIGHT LENS LOOSE. R&R LIGHT ASSY PER MM.SDR SWAA2017052313914Light · inoperativeL1 DOOR EXIT LIGHT INOP. RELAMPED PER MM.SDR N6WA2017052101Lamp · inoperativeSECOND LAST EMERGENCY LIGHT CEILING INOPERATIVE. REPLACED THE LAMPS IAW AMM 20-41-00, NO FURTHER DEFECTS NOTED.SDR 7C7A2017052100329Battery Pack · dischargedFORWARD & MIDDLE OVERHEAD CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY IN POWER SUPPLY 3351-PS2 & OPS CHECKED GOOD IAW MM 33-52-00. OK FOR SERVICE.SDR SWAA2017052213913Charger · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOP. R&R BATTERY CHARGER PER AMM.SDR SWAA2017052213912Lens · missingL1 DOOR LOWER EMERGENCY EXIT SIGN LIGHT COVER MISSING. INSTALLED THE LENS IAW AMM.SDR SWAA2017052213911Battery · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY IAW AMM.SDR DALA2017052204075Lens · damagedEMERGENCY LIGHT LENS DAMAGED. REPAIRED THE LENS. LIGHTS TESTED IAW AMM 33-51, SATISFACTORY.SDR IPXA2017052217381Lamp · inoperativeCREW DOOR FWD EMERGANCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM 33-51-05.SDR AALA201705229024Lens · missingEMERGENCY EXIT ROW LIGHT AT SEAT 9ABC MISSING THE LENS. REPLACED THE LENS.
Back to JASC 3350