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 SWAA2016120510192Battery · failedEMERGENCY BATTERY FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PER AMM.SDR SWAA2016120510157Light · inoperativeRT EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR AALA20161205014Battery · dischargedAIRCRAFT GROUNDED. COCKPIT EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA201612059010Lens · missingMISSING EMERGENCY EXIT LIGHT LENS AT 3L SEAT. REPLACED LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612059007Cover · missingMISSING EMERGENCY LIGHT COVER AT 4L DOOR. REPLACED LIGHT COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR YENA201612021024Battery Pack · failedDURING MAINTENANCE, THE LEFT EXTERNAL EMERGENCY LIGHT AT MIDDLE POSITION WAS FOUND TO BE INOPERATIVE. R & R EPSU BATTERY IAW AMM 33-50-01. OPS CHECK PASSED.SDR YENA201612021023Battery · failedEMERGENCY LIGHT BATTERY 13WL FAILED TEST. R & R THE BATTERY PACK IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201612021022Battery · failedEMERGENCY LIGHT BATTERY 12WL FAILED TEST. R & R THE BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201612021021Battery · failedEMERGENCY LIGHT BATTERY 11WL FAILED TEST. R & R THE BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR DALA2016120409543Battery Pack · no testDURING SERVICE CHECK, FOUND BATTERY FAIL ON AFT EPSU, REPLACED BATTERY OF THE AFT EPSUSDR JJBA20161202006Power Supply · inoperativeEMERGENCY LIGHT ABOVE MAIN CABIN DOOR INOPERATIVE. R & R THE POWER SUPPLY.SDR JJBA20161202005Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE. R & R THE POWER SUPPLY.SDR DALA2016120209503Light · inoperativeFOUND EMERGENCY LIGHT AT SEAT 14AB UNSERVICEABLE. REPLACED LIGHT AT SEAT 14AB.SDR CALA2016120201001Battery Pack · inoperativeEMERGENCY EXIT LIGHT ON STOW BIN AT SEAT ROW 14DEF INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06, OPS TESTED GOOD.SDR CALA2016120201000Battery Pack · inoperativeEMERGENCY EXIT LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED THE BATTERY PACK M1675 IAW AMM 33-51- 06. OPS CHECKED GOOD.SDR CALA2016120200999Battery Pack · inoperativeEMERGENCY EXIT LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED THE BATTERY PACK M1694 IAW AMM 33-51- 06. OPS CHECKED GOOD.SDR CALA2016120200998Battery Pack · inoperativeEMERGENCY EXIT LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED THE BATTERY PACK M1670 IAW AMM 33-51- 06. OPS CHECKED GOOD.SDR CALA2016120200997Battery Pack · inoperativeEMERGENCY EXIT LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED THE BATTERY PACK M1676 IAW AMM 33-51- 06 OPS CHECKED GOOD.SDR CALA2016120200996Battery Pack · inoperativeEMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED THE BATTERY PACK M1671 IAW AMM 33-51 -06 OPS CHECKED GOOD.SDR CALA2016120200995Battery Pack · inoperativeR2 DOOR, EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 3 3-51-06. OPS CHECKED GOOD IAW AMM 33-51-00.SDR HNAA2016120200370Bulb · inoperativeLOWER EMERGENCY LIGHT IS INOPERATIVE. LEFT EMERGENCY EXIT DOOR. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR HNAA2016120200369Bulb · inoperative19TH. EMERGENCY FLOOR PATH LIGHT IS INOPERATIVE. REMOVED AND REPLACED BULB IN EMERGENCY FLOOR PATH LIGHT. OPS CHECKED GOOD.SDR HNAA2016120200368Bulb · inoperativeLOWER EMERGENCY SIDEWALL LIGHT IS INOPERATIVE AT ROW 4AC... REMOVED AND REPLACED BULB AT ROW 4AC LOWER SIDEWALL. OPS CHECKED GOOD.SDR HNAA2016120200367Control Box · malfunctionedEMERGENCY LIGHTS FLICKERED IN CABIN WITH ICE PROTECTION ON. REMOVED AND REPLACED EMERGENCY LIGHT CONTROL BOX IAW MM 33-51-00. OPS CHECKED GOOD. OK FOR SERVICE.SDR SWAA2016122710775Light · crackedEMERGENCY LIGHT CRACKED AT FWD END. R & R THE EMERGENCY LIGHT STRIP IAW MM.SDR SWAA2016121910622Lens · brokenAFT GALLEY AREA EMERGENCY LIGHT BASE LENS BROKEN. R&R LENS IAW AMM.SDR FDEA201612014300Power Supply · failedDURING PREFLIGHT, RECEIVED AN EMERGENCY LIGHT BATTERY 1 LOW. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-01-4. OPS CHECKED NORMAL, OK FOR SERVICE.SDR SWAA2016120510236Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM.SDR SWAA2016120510235Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2016120510234Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2016120510233Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER AMM.SDR SWAA2016120510232Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR SWAA2016120510231Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2016120510212Lens · missingR2 DOOR EMERGENCY EXIT LIGHT LENS MISSING ARROW. R&R LENS PER AMM.SDR SWAA2016120510209Lens · brokenFORWARD GALLEY R/H LOWER EMERGENCY EXIT LENS COVER BROKEN. R&R COVER IAW AMM.SDR SWAA2016120510175Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER AMM.SDR AALA201612029009Power Supply · no testFORWARD GALLEY LEFT HAND FORWARD EMERGENCY POWER SUPPLY UNIT (10WL) DOES NOT PASS TEST. REPLACED THE POWER SUPPLY UNIT (10WL) IAW AMM 33-51-38.SDR DALA2016120509552Control Panel · inoperativeEMERGENCY LIGHT UNARMED LIGHT DAMAGED ON OVERHEAD PANEL. R & R THE EMERGENCY LIGHT PANEL IAW AMM 33-14. OPS CHECKED NORMAL.SDR ASAA2016120118915Power Supply · failedAFT LEFT DOOR EMERGENCY LIGHT INOPERATIVE. ACFT GROUNDED. R & R THE POWER SUPPLY M1673 IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR DALA2016120209491Battery Pack · inoperativeDURING SERVICE CHECK, FOUND EMERGENCY LIGHTS OUT FWD OF THE R2 DOOR AND ALL EXIT MARKERS AS WELL. REPLACED THE BATTERY BACK IAW AMM 33-51.SDR REXA2016120102339Light · inoperativeEMERGENCY LIGHT AT SEAT 10 INOPERATIVE. REMOVED AND REPLACED THE LIGHT STRIP IAW AMM 33-51-01-04.SDR AALA20161202022Lens · detachedR2 DOOR EMERGENCY EXIT SIGN LENS COVER DETACHED. SECURED THE LENS IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA20161202021Lens · detachedR4 DOOR EMERGENCY EXIT SIGN LENS COVER DETACHED. SECURED THE LENS IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA20161202018Battery Pack · no testEMERGENCY EXIT LIGHTS FORWARD LEFT 10WL EMERGENCY POWER SUPPLY UNIT FAILED TEST. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA20161202017Lens · detachedEMERGENCY EXIT LIGHT IN FIRST CLASS RIGHT SIDE HAS A DETACHED LENS COVER. SECURED THE LENS IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA20161202001Light · inoperativeEMERGENCY LIGHT AT SEAT 27D IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY.SDR DALA2016120209479Bracket · brokenROW 31 DEF EMERGENCY FLOOR PATH LIGHTING ASSY BRACKET IS BROKEN. REPLACED BRACKET.SDR AALA201612029015Lens · missingLIGHT BY BOTTOM OF 1R DOOR IS MISSING A LENS COVER. REPLACED LENS IAW AMM 33-51-00. AIRCRAFT WAS GROUNDED.SDR AALA201612029011Lens · missingMISSING LENS ON SEAT MOUNTED EMERGENCY LIGHT AT ROW 6L. REPLACED THE LENS IAW AMM 33-51-18.SDR AALA201612029010Lens · missingR4 DOOR EMERGENCY LIGHT LENS COVER MISSING. REPLACED THE LENS IAW AMM 33-51-02.
Back to JASC 3350