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 SWAA2018010318757Sign · brokenRT OVER WING LOWER EXIT SIGN BROKEN. R&R SIGN PER AMM.SDR SWAA2018010318755Power Supply · inoperativeLT OVERWING INTERIOR EMERGENCY EXIT DOOR FORWARD LOWER EMERGENCY SIGN INOP AT BS 603, LBL 67. R&R POWER SUPPLY IAW AMM.SDR SWAA2018010318752Sign · defectiveR2 EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROWS. R&R SIGN IAW AMM.SDR DALA2018010200039Battery Pack · inoperativeDURING SERVICE CHECK, FOUND THE EMERG LIGHTS AT THE L2 DOOR, CTR AISLE OVERHEAD, & SEATS 15 DEF- 20 DEF INOPERATIVE. REMOVED AND REPLACED BATTERY PACK ASSY M11613 IAW AMM 33-51-07.SDR AALA201801029046Lens · missingMISSING RED LENS ON THE SEAT 15D EMERGENCY LIGHT. REPLACED THE LENS IAW AMM 33-51-14.SDR ASAA2017122923065Retainer · brokenF/A REPORTS FWD F/A OVHD EMERG EXIT LIGHTS LENS COVER KEEPS FALLING DOWN - WILL NOT SECURE. GROUNDED - YES. RETAINING TABS FOR LENS BROKEN ON LIGHT ASSY. REQUIRES P/N 82000-48301 REF WDM 23-42-11. SECURED LENS WITH FIRE PROOF FIBER TAPE PER EA NR 800-33EA-1970SDR QXEA2017010200716Lens · detachedEMERGENCY EXIT SIGN LENS POPPED OFF. REPLACED THE LENS. NO OTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR QXEA2017010200714Light · looseFLOOR TRACK LIGHT IS LOOSE. SECURED THE LIGHT AT ROW 2ED. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR AALA201801029047Lens · missingEMERGENCY EXIT LIGHT LENS MISSING. MAINTENANCE REPLACED THE EMERGENCY LIGHT LENS AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR DALA2017123009014Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED. MAINTENANCE REPLACED LIGHT ASSY IAW DRAWING BR9051. OPS CHECKED GOOD.SDR CALA2017122904664Battery Pack · inoperativeFOUND SEVERAL EMERGENCY LIGHTS NOT WORKING, REPLACED L1 AND LEFT EMERGENCY DOOR BATTERY PACKS. SYSTEM OPS NORMAL.SDR CALA2017122904663Lamp · brokenEMERGENCY EXIT DISARMED LAMP BROKEN ON THE OVERHEAD PANEL. SECURED THE LAMP.SDR CALA2017122904660Battery Pack · failedEMERGENCY LIGHTS AT SEATS 24AB THRU 33AB INOPERATIVE. TROUBLESHOT FOUND THE BATTERY PACK AND CHARGER BAD, REMOVED AND REPLACED AND OPS CHECKED GOOD.SDR CALA2017122904659Lamp · inoperativeDURING AN A CHECK, FOUND SEAT 2D EMERGENCY LIGHT BROKEN. REPLACED THE LAMPS IAW AMM 33-51-05.SDR CALA2017122904658Lamp · inoperativeDURING AN A CHECK, FOUND THE EXETRIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-50-00.SDR FDEA201712283459Lamp · burned outEMERGENCY LIGHTS REMAINED ON DURING PREFLIGHT. RED LIGHT ILLUMINATED IN THE GUARDED SWITCH. PERFORMED AN EMERGENCY LIGHT TEST IAW MM 33-51-00-05, AND FOUND ONE CEILING EMERGENCY LIGHT BURNED OUT. REPLACED THE LAMPS IAW MM 33-51-03-02 AND PERFORMED A TEST. SDR SWAA2018011819180Light · detachedMIDDLE CABIN EMERGENCY EXIT LIGHT FELL OFF. SECURED THE LIGHT IAW AMM.SDR SWAA2018010918926Light · damagedLT EMERGENCY EXIT BIN LIGHT DAMAGED AT ROW 23. R&R LIGHT ASSEMBLY PER AMM.SDR DALA2018010500159Light · detachedEMERGENCY LIGHT STRIP THROWN IN OVERHEAD BINS AT ROW 26. RE-ATTACHED STRIP. OPERATION CHECKS GOOD.SDR DALA2018010500106Battery Pack · inoperativeLEFT AND RIGHT AFT OVER WING EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK B5-241 IAW MM. OPS CHECKED GOOD.SDR SWAA2018010518869Lens · looseLT EXTERNAL EMERGENCY EXIT LIGHT LENS LOOSE. R&R LENS IAW MM.SDR AALA201801029040Sign · damagedRIGHT FORWARD OVERWING ESCAPE HATCH EXIT SIGN DAMAGED. REMOVED AND REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01.SDR SWAA2018010318828Fuse · blownRT EMERGENCY EXIT BIN LIGHTS INOP BETWEEN ROW 3 TO ROW 5. R&R FUSE PER AMM.SDR SWAA2018010318787Battery Pack · dischargedRT FORWARD EMERGENCY LIGHT BATTERY PACK INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018010318759Sign · defectiveL1 DOOR LOWER EXIT SIGN MISSING DIRECTIONAL ARROW. R&R SIGN PER AMM.SDR SWAA2018010318748Cover · unsecureLT FORWARD EMERGENCY EXIT LIGHT COVER FELL OFF ON LANDING. SECURED COVER PER SIP.SDR SWAA2018010318741Lens · looseAFT LT EMERGENCY AISLE LIGHT LENS LOOSE. SECURED LENS PER AMM.SDR SWAA2018010318740Fuse · blownLT EMERGENCY EXIT BIN LIGHTS INOP BETWEEN ROW 1 TO ROW 4. R&R FUSE PER AMM.SDR AALA201801029041Lens · missingEMERGENCY AISLE LIGHT LENS AT BS 727 MISSING. REPLACED LENS ATIAW 25-63-00.SDR AALA201801029039Lens · brokenBROKEN EXIT LIGHT LENS AT THE L4 DOOR. MAINTENANCE REPLACED THE LENS IAW AMM 33-51-00, AND PERFORMED SUCCESSFUL OPERATIONAL CHECK.SDR CALA2017122904655Battery Pack · dischargedR4 DOOR ONE EMERGENCY LIGHT POWER PACK FOUND CAPACITY LOW. REPLACED THE BATTERY AND OPS TEST NORMAL IAW AMM 33-51-06-960-802, REV 81.SDR ASAA2017122823024Lens · brokenAFT GALLEY EMERGENCY EXIT SIGN OVER R2 DOOR IS BROKEN. ACFT GROUNDED. REPLACED THE LENS. OK FOR SERVICE.SDR SIMA20171228001Light · inoperativeRIGHT OVERWING EMERGENCEY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-10. OPS CHECKED GOODSDR CALA2017122804627Lens · missingEMERGENCY LIGHT LENS MISSING NEAR CLOSET 712. REPLACED THE LENS.SDR CALA2017122804641Light · malfunctionedEMERGENCY LIGHTS CAME ON DURING LANDING AND WOULD NOT GO OFF. RESET THE NO SMOKING SWITCH.SDR CALA2017122804640Light · malfunctionedEMERGENCY LIGHTS ILLUMINATED AT THE EXIT ROWS WITH THE SWITCH IN ARM POSITION. CYCLED POWER, ALL EMERGGENCY LIGHTS WORK NORMAL.SDR CALA2017122804639Cids · malfunctionedCABIN EMERGENCY LIGHTS ON REGARDLESS OF SWITCH POSITION. ACCOMPLISHED A CIDS RESET, OPS CHECKED OK.SDR CALA2017122804638Sign · brokenEMERGENCY EXIT SIGN IN THE OVERHEAD 1ST CLASS SECTION, BY THE LIFE RAFT IS BENT AND BROKEN. REMOVED & REPLACED THE SIGN IAW AMM 33-51-01-960-802. OPS CHECKED NORMAL. ACFT OK FOR SERVICE.SDR CALA2017122804637Lamp · inoperativeLEFT FWD OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-04. OPS CHECKED GOOD.SDR CALA2017122804636Lamp · inoperativeROW 27 OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-03. OPS CHECKED GOOD.SDR CALA2017122804634Lamp · inoperativeDURING AN A CHECK, FOUND TWO OVERHEAD CREW REST EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-15.SDR 29GA2017122800001Connector · disconnectedOVERWING EXIT EMERGENCY LIGHT INOPERATIVE. INSPECTED AND FOUND THE CONNECTOR PLUG DISCONNECTED. CONNECTED EMERGENCY LIGHT OPS CHECKED GOOD IAW 33-50-00.SDR SWAA2018010418800Sign · missingL2 DOOR EXIT SIGN MISSING RED ARROW. R&R SIGN IAW AMM.SDR SWAA2018010318789Battery Pack · failedEMERGENCY EXIT BATTERY PACK M1673 FAILED CAPACITY CHECK AT BS 952. R&R BATTERY PACK IAW AMM.SDR SWAA2018010318788Battery Pack · failedLT EMERGENCY EXIT LIGHT BATTERY PACK M1670 FAILED CAPACITY CHECK AT BS 727C. R&R BATTERY PACK IAW AMM.SDR SWAA2018010318784Lens · brokenLT OVER WING EXIT SIGN LENS COVER BROKEN. SECURED SIGN PER SIP.SDR SWAA2018010318775Cover · looseLT EMERGENCY EXIT LIGHT COVER LOOSE. SECURED COVER PER SIP.SDR SWAA2018010318747Cover · brokenFORWARD ENTRY DOOR EXIT LIGHT COVER BROKEN. R&R COVER PER MM.SDR SWAA2018010318729Light · inoperativeLT STOW BIN BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 1. R&R LIGHT IAW AMM.SDR FDEA201712273452Light · unknownL1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. COULD NOT DUPLICATE PROBLEM. PERFORMED EMERGENCY LIGHT TEST AND LIGHT OP'S CHECKED GOOD IAW MM 33-51-00-5.
Back to JASC 3350