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 SIMA20170427003Lamp · inoperativeMAIN DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A. OPS CHECKED GOOD.SDR SIMA20170427004Lamp · inoperativeMAIN DOOR OVERHEAD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM TASK 33-26-04-000-801-A, AND 33-26-04-400-801-A. OPS CHECKED GOOD.SDR DALA2017042803447Lamp · inoperativeEMERGENCY LIGHT AT SEAT 11 DEF INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD.SDR AALA201704289007Light · inoperativeROW 13C AISLE LIGHT INOPERATIVE. INSTALLED A NEW LENS ON EMERGENCY LIGHT AT 13C.SDR AALA201704289006Light · inoperativeAFT RIGHT DOOR LIGHT INOPERATIVE. REPLACED EXIT LIGHT LENS.SDR AALA201704289005Lens · brokenEXIT LIGHT LENS UNDER L1 FLIGHT ATTENDANT JUMP SEAT BROKEN. REPLACED THE LENS.SDR AALA201704289002Lens · missingR1 DOOR EMERGENCY EXIT LIGHT LENS MISSING. REPLACED THE LENS.SDR DALA2017042703441Power Supply · inoperativeON SERVICE CHECK, FOUND THE EXIT LIGHTS OVER SEAT 20 OUT. REPLACED THE EMERGENCY LIGHTS BATTERY POWER SUPPLY IAW AMM 33-51. LIGHTS CHECKED GOOD AT THIS TIME.SDR JJBA20170427032Switch · inoperativeEMERGENCY LIGHTS INOPERATIVE. R&R EMERGENCY LIGHT SWITCH OPS CHECK SAT.SDR SIMA20170524006Inverter · inoperativeEMERGENCY LIGHT IN GALLEY CEILING PANEL 234ARC INOPERATIVE. REMOVED AND REPLACED THE AC/DC INVERTER IAW AMM 33-50-11, EMEGENCY LIGHT CHECKED GOOD.SDR SIMA20170426005Nut Plate · brokenRIGHT FWD OF WING EXTERNAL EMERGENCY LIGHT HAS BROKEN NUT PLATE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-10, SYS CHECKED GOOD.SDR SIMA20170426004Lamp · inoperativeEMERGENCY LIGHT NOT WORKING IN CABIN OVERHEAD AT RT PSU EXIT ROW. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-07, SYS CHECKED GOOD.SDR SWAA2017050913639Sign · damagedFORWARD LAV CEILING EMERGENCY EXIT SIGN DAMAGED. R&R SIGN IAW AMM.SDR HNAA2017042500137Light · inoperativeEMERGENCY CEILING LIGHT AT ROW 4 INOPERATIVE. R & R THE EMERGENCY LIGHT.SDR SWAA2017050113441Light · inoperativeRT OVERWING EXIT LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA2017050113487Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY IAW AMM.SDR SWAA2017050113486Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R & R THE BATTERY IAW AMM.SDR SWAA2017050113485Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R & R THE BATTERY IAW AMM.SDR SWAA2017050113484Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R & R THE BATTERY IAW AMM.SDR SWAA2017050113469Battery · no testRIGHT CENTER BATTERY FAILED TIME TEST. R & R THE BATTERY IAW AMM.SDR SWAA2017050113468Battery · no testRIGHT AFT BATTERY FAILED TIME TEST. R & R THE BATTERY IAW AMM.SDR SWAA2017050113445Light · damagedLEFT FORWARD CABIN EMERGENCY LIGHT DAMAGED AT ROW 1. R & R THE LIGHT AMM.SDR SWAA2017050113423Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R & R THE BATTERY IAW AMM.SDR REXA2017042600549Inverter · inoperativeDURING WAKE-UP CHECK, FOUND EMERGENCY LIGHTS 9 - 13 NOT WORKING. REMOVED & REPLACED THE INVERTER 4 IAW AMM 33-51-07. EMERGENCY LIGHTS OPS CHECKED GOOD IAW AMM 33-51-00.SDR SPAA201704030001Light · inoperativeL1 AND R1 DOOR EMERGENCY ESCAPE SLIDE LIGHTS FAIL TO ILLUMINATE.SDR AALA201704279021Light · inoperativeRIGHT SIDE 5 FEET OF EMERGENCY LIGHT STRIP BY ROWS 1 AND 2, INOPERATIVE. REPLACED THE LIGHT STRIP IAW AMM 33-50-21.SDR AALA201704289035Cover · damagedCOVER EMERGENCY LIGHT AT UPPER MIDDLE FUSELAGE DAMAGED. THE COVER WAS REPLACED IAW AMM 25-63-00. GOOD FOR SERVICE.SDR ASAA2017042620546Sign · detachedEXIT SIGN AT THE R1 DOOR FELL OFF. ACFT GROUNDED. REPLACED THE EXIT SIGN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201704279024Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY R1 DOOR HAS A DETACHED LENS COVER. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201704279023Light · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT PLACARD AT L4 DOOR IS MISSING. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA201704279020Power Supply · inoperativeAIRCRAFT WAS GROUNDED. RIGHT HAND EMERGENCY LIGHT BATTERY FAULT EICAS MESSAGE AT GATE WHEN EMERGENCY LIGHT TEST IS ACCOMPLISHED ON FED FLIGHT ATTENDANT PANEL. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-50-01.SDR SIMA20170426002Charger · failedEMERGENCY FLOOR PROX LIGHT 1 WILL NOT ILLUMINATE. REMOVED AND REPLACED 2 EMERGENCY LIGHT CHARGER AND BATTERY IAW AMM 33-50-04 OPS CK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 85712SDR SPAA20170427001Power Supply · inoperativeL-1 AND R-1 DOOR EMERGENCY ESCAPE SLIDE LIGHTS FAIL TO ILLUMINATESDR DALA2017042703428Fuse · blownLLCR EXIT LIGHTS INOP. RELAMPED LIGHT WORKED ON NORMAL POWER, STILL INOP ON EMERGENCY POWER (LADDER AND COVE EXIT) REPLACED FUSES IN POWER SUPPLY LIGHT CKS OK.SDR DALA2017042703427Battery Pack · dischargedEMER LIGHTS AT 1A-6A WEAK. R&R BATTERY PACK M736 PER AMM 33-52.SDR DALA2017042703424Charger · inoperativeEMERGENCY LIGHTS AT SEAT 21-31 AB INOPERATIVE. REPLACED BATTERY CHARGER ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR QXEA2017042700327Light · inoperativeFORWARD F/A EMERGENCY LIGHT SWITCH "NORMAL" POSITION INOP. RELAMPED. OPERATIONAL CHECKS GOOD. RETURNED TO SERVICE.SDR AALA201704279016Lens · missingAIRCRAFT NOT GROUNDED. EXIT COVER MISSING 4R DOOR AREA. REPLACED DOOR 4R EXIT LIGHT LENS.SDR AALA201704279014Lens · unsecureAIRCRAFT NOT GROUNDED. 4L DOOR LIGHT COVER CAME OFF ITS HOLDER. INSTALLED EXIT COVER ON 4L DOOR.SDR AALA201704279007Light · inoperativeAIRCRAFT NOT GROUNDED. EMERGENCY EXITS LIGHTS OVER 2LAND 2R NOT ILLUMINATING WHILE OTHERS ARE ILLUMINATED. TROUBLESHOT AND PERFORMED OPERATIONAL CHECK OF CABIN EMERGENCY LIGHTING FROM THE FLIGHT DECK. CHECKS GOOD.SDR DALA2017042703415Lens · missingEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS: 19C. FLOOR MOUNTED LIGHTING ALL OK. OVERHEAD EMERGENCY LIGHT AT ROW 19 MISSING LENS, INSTALLED LENS.SDR DALA2017042603400Battery Pack · inoperativeDURING A SERVICE CHECK, FOUND CEILING EMERGENCY LIGHTS AT SEATS 32 AND 34 EXTREMELY DIM. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK B5-107 AND BATTERY IAW AMM 33-53. OPS CHECKED GOOD.SDR DALA2017042603395Lamp · inoperativeFOUND LT EMERGENCY LIGHT INOP. REPLACED THE LAMPS IAW AMM 33-51. OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR SWAA2017050113439Cover · unsecureRT FORWARD GALLEY EMERGENCY LIGHT COVER FELL OFF. R&R LIGHT ASSEMBLY IAW MM.SDR ASOA201704255067Battery Pack · dischargedPILOT REPORTED FORWARD EMERGENCY EXIT LIGHTS COME ON THEN FADE OUT. CONTRACT MX REMOVED NEW BATTERY PACK AND REINSTALLED BATTERY PACK WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2017050103508Battery Pack · inoperativeBOTH OVER WING EMERGENCY LIGHTS WILL NOT ILLUMINATE. REPLACED BATTERY PACK PER MM. OPERATION CHECKS GOOD. (LP# 9957216)SDR DALA2017050103507Light · inoperativeEMERGENCY FLOOR LIGHTNING DAMAGED OR INOPERATIVE. FOUND STRIP AND REATTACHED.SDR SWAA2017050113444Lens · detachedRIGHT FORWARD OVERWING LOWER EMERGENCY EXIT LIGHT LENS FELL OFF. R & R THE LIGHT ASSEMBLY IAW MM.SDR SWAA2017050113433Lens · looseLEFT FORWARD ENTRY EMERGENCY EXIT SIGN LENS LOOSE. SECURED THE LENS IAW MM.SDR SWAA2017050113429Lens · looseR1 DOOR EMERGENCY EXIT FLOOR LENS COVER LOOSE. / SECURED COVER PER MM.
Back to JASC 3350