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 SWAA2016101108623Lamp · inoperativeRIGHT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR AALA201610109023Lens · brokenEMERGENCY AISLE LIGHT LENS BROKEN AT 22R. EMERGENCY LIGHT ASSY REPLACED IAW AMM 33-51-19-400-003-A, OPS CHECKED GOOD.SDR AALA201610109021Lens · unsecureEMERGENCY LIGHT LENS COVER COMING OFF WALL. REMOVED & REPLACED LENS IAW GPM.SDR AALA201610109020Battery Pack · inoperativeLEFT FWD OVERWING EMERGENCY LIGHT AND RT MID OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY PACK NR 4 IAW MM 33-50-01 OPS CHECKED GOOD.SDR AALA201610109019Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT INOPERATIVE AT 9 ABC. R & R THE EMERGENCY LIGHT ASSY IAW AMM 33-50-00. OPS CHECKED GOOD.SDR ASAA2016100718241Bulb · inoperativeWHILE PERFORMING TASK CARD 78233008, FOUND L2 OVERWING AFT DOWNFACING LIGHT INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS IAW AMM 33-51-01-960-801. OPS CHECKED GOOD.SDR ASAA2016100718240Battery Pack · dischargedR2 DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. ACFT GROUNDED. R & R THE BATTERY PACK IAW AMM 33-51-06. PERFORMED EMERGENCY LIGHT OPS CHECK . SYS CHECKED NORMAL IAW WD 33-51-14.SDR AALA20161010006Sign · brokenL4 DOOR EXIT SIGN COVER BROKEN. REMOVED AND REPLACED SIGN AND ACCOMPLISHED AN OPS CHECK IAW 33-00-00.SDR SIMA20161007001Charger · failedLT AND RT CENTER FAIRING EXTERNAL EMERGENCY LIGHT FAILS TO ILLUMINATE. REMOVED AND REPLACED THE NR 4 EPSU BATTERY CHARGER ASSY IAW AMM 33-50-04. OPS CHECKED GOOD. NO OTHER DEFECTS NOTED.SDR QXEA2016101000648Battery Pack · no testEMERGENCY LIGHTS DON'T TEST CORRECTLY. REPLACED THE AFT EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-51-01. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR MASA2016100712439Light · inoperativeRIGHT FWD EXTERIOR EXIT LIGHT INOPERATIVE.SDR KCSA201610071078Light · inoperativeEMERGENCY LIGHT L1854 MAIN DECK FWD CREW DOOR INOPERATIVE.SDR FDEA201610073499Bulb · inoperativeSERVICE CHECK, R1 DOOR EMERGENCY SLIDE LIGHT INOPERATIVE. REPLACED THE BULB IAW AMM 33-51-06-2-1, OPS NORMAL. OK FOR SERVICE.SDR CALA2016100700733Battery Pack · inoperativeEMERGENCY FLOOR PROXIMITY LIGHTS AT ROWS 1 & 2 AND EXIT LIGHT AT L1 DOOR ARE INOPERATIVE. R & R THE BATTERY PACK IAW MM 33-51-06-960-805. CHECKED NORMAL.SDR CALA2016100700732Charger · failedEMERGENCY LIGHTS INOPERATIVE AT SEAT ROWS 31-40 ABC. BATTERY ON CHARGER FOUND LOOSE, CHARGER FAILED. CHARGER REPLACED AS PER AMM 33-51-07. ALL FUNCTION NOW NORMAL.SDR HNAA2016100700312Bulb · inoperativeFORWARD MOST EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR SWAA2016101108634Cover · faultyL1 DOOR OVERHEAD EMERGENCY EXIT SIGN COVER FAULTY. R & R COVER IAW AMM.SDR SWAA2016101108594Light · looseL2 DOOR EMERGENCY EXIT LIGHT LOOSE. SECURED THE LIGHT IAW MM.SDR VNAA2016100600007Cover · looseEMERGENCY LIGHT COVER LOOSE. SECURED THE LIGHT COVER AND PERFORMED CHECKS IAW THE AMM. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR SWAA2016100708548Battery Pack · no testEMERGENCY LIGHTS BATTERY PACK FAILED CAPACITY CHECK M01672. R & R THE BATTERY PACK IAW DWG.SDR SWAA2016100708547Sign · missingR1 DOOR LOWER EXIT SIGN AT DIRECTIONAL ARROW MISSING. REPLACED THE SIGN IAW AMM.SDR SWAA2016100708546Sign · missingL1 DOOR LOWER EXIT SIGN AT DIRECTIONAL ARROW MISSING. REPLACED THE SIGN IAW MM.SDR SWAA2016100708544Bulb · inoperativeLEFT OVERWING EMERGENCY EXIT LIGHT BULB INOPERATIVE. R & R THE BULB IAW MM.SDR SWAA2016100708524Battery Pack · no testEMERGENCY LIGHTS BATTERY PACK FAILED CAPACITY CHECK M01669. R & R THE BATTERY PACK IAW DWG.SDR SWAA2016100708523Light · brokenEMERGENCY EXIT SIGN LIGHT ASSEMBLY IN CEILING BROKEN. SECURED THE LIGHT ASSEMBLY IAW SIP.SDR MASA2016100612438Bulb · inoperativeEMERGENCY LIGHT AT FWD LT OVERWING EXTERIOR HAS ON BULB OUT.SDR AALA201610079003Lens · crackedCRACKED EMERGENCY LIGHT LENS AT SEAT 8D. REPLACED EMERGENCY LIGHT LENS IAW CMM 25-22-50.SDR REXA2016100601889Light · missingMISSING PART OF EMERGENCY LIGHT TRACK AT ROW 12C . REPLACED THE EMERGENCY LIGHT TRACK IAW AMM 33-51-01. OK FOR SERVICE.SDR REXA2016100601887Bulb · inoperativeLEFT FWD EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE BULB IAW AMM 33-51-21. OPS CHECKED NORMAL.SDR JJBA20161006010Battery Pack · inoperativeEMERGENCY LIGHT OVER SEAT 18A WILL NOT TEST. R & R EMERGENCY BATTERY PACK OPS CHECK GOOD.SDR N6WA2016100601Light · inoperativeCEILING LEVEL EMERGENCY FLOODLIGHT INOPERATIVE AT ROW 4.SDR JJBA20161006008Bulb · inoperativeCEILING EMERGENCY LIGHT AT ROW 18 INOPERATIVE. R & R THE BULB. OPS CHECKED GOOD.SDR JJBA20161006007Battery · inoperativeDURING L CHECK, EMERGENCY LIGHTS FOUND INOPERATIVE. R & R EMERGENCY BATTERIES, OPS CHECKED GOOD. NO OTHER DEFECTS NOTED.SDR DALA2016100607099Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY EXIT SIGN FOR BOTH OF THE AFT OVERWING HATCHES WERE INOPERATIVE. MAINTENANCE REPLACED TWO BATTERY PACKS FOR THE NOTED LIGHTED AREAS AND THE OPERATIONAL CHECK WAS GOOD. (LP #9268508)SDR FDEA201610063476Switch · out of positionEICAS MESSAGE FOR EMERGENCY LIGHTS. ACFT RETURNED TO BLOCKS. FOUND EMERGENCY SWITCH GUIDE RING OUT OF RANK. REPOSITION AND PERFORMED RTS PASSED IAW MM 33-50-00. ACFT OK FOR SERVICESDR MASA2016100612437Bulb · inoperativeMAIN CABIN DOOR LOWER EMERGENCY LIGHT HAS ONE BULB OUT. REPLACED THE LAMPS.SDR REXA2016100601849Light · missingEMERGENCY LIGHT STRIP MISSING AT SEATS 12 A/B. REPLACED THE LIGHT IAW AMM 33-51-00 TS003648SDR PNSA2016100601Power Supply · failedEMERGENCY LIGHTING POWER SUPPLIES FAILED FUNCTION CHECK LOCATIONS 17 LN AND 13 LNSDR 2016FA0000472Lens · missingEMERGENCY AISLE LIGHT LENS MISSING AT POSITION 15C. LIGHT IS OPERATIVE.SDR JJBA20161006006Sign · inoperativeLEFT SIDE VERTICAL EMERGENCY EXIT ROW SIGN INOPERATIVE. EMERGENCY LIGHTS OPS CHECKED GOOD.SDR DALA2016102107450Battery Pack · dischargedDURING WC FOUND 5 BATTERIES THAT WOULD NOT KEEP EMERGENCY LIGHTS ILLUMINATED FOR 15 MINUTES. REPLACED BATTERY PACK AT L1 SEAT 4D, 3A, 20A AND 32G.SDR RAIA201610050001Light · faultyCEILING CENTER CABIN EMERGENCY LIGHT FLICKERING. R&R CEILING CENTER CABIN EMERGENCY LIGHT OPS CHECK GOODSDR DALA2016100607104Battery Pack · inoperativeDURING LINE CHECK, THE PILOT FOUND HE COULD NOT CONTROL THE EMERGENCY LIGHTS IN THE CABIN AT THE L1 DOOR. IT WOULD REACT WHEN CONTROLLING CABIN LIGHTING. MAINTENANCE REPLACED THE BATTERY PACKS FOR THE NOTED LIGHTED AREAS AND THE OPERATIONAL CHECK WAS GOOD.SDR DALA2016100607103Power Supply · failedDURING LINE CHECK, THE PILOT FOUND HE COULD NOT CONTROL THE EMERGENCY LIGHTS IN THE CABIN AT THE L1 DOOR, IT WOULD REACT WHEN CONTROLLING CABIN LIGHTING. MAINTENANCE REPLACED THE POWER SUPPLY FOR THE NOTED LIGHTED AREAS AND THE OPERATIONAL CHECK WAS GOOD.SDR AALA201610069015Light · inoperativeRIGHT EMERGENCY LIGHT STRIP IN FIRST CLASS DOES NOT ILLUMINATE. AIRCRAFT WAS GROUNDED. INSTALLED A NEW LIGHT IAW AMM 33-51-15.SDR AALA201610069012Lens · missingL3 DOOR EMERGENCY EXIT SIGN MISSING LENS ASSEMBLY. REPLACED LENS ASSEMBLY.SDR AALA201610069004Light · inoperativeR3 DOOR EMERGENCY EXIT LIGHT 46WL INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT.SDR AALA201610069003Lens · missingL4 DOOR EMERGENCY EXIT SIGN MISSING LENS ASSEMBLY. REPLACED LENS ASSEMBLY AS REQUIRED.SDR AALA201610069002Battery · no testDURING CIDS 1 EMERGENCY POWER SUPPLY UNIT SYSTEM TEST, EMERGENCY POWER SUPPLY UNIT (15WL) AT DOOR 3L FAILED ITS BATTERY BITE TEST. INSTALLED SERVICABLE EMERGENCY POWER SUPPLY UNIT (15WL) BATTERY IAW AMM 33-51-38SDR AALA201610069001Lens · missingEMERGENCY EXIT MARKER AT DOOR R4 MISSING LENS. INSTALLED LENS IAW AMM 33-51-13.
Back to JASC 3350