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 SWAA2017050113421Lens · looseRIGHT LOWER EMERGENCY EXIT SIGN LENS LOOSE ON SIDEWALL. SECURED THE LENS IAW MM.SDR ASAA2017042520535Light · inoperativeR2 DOOR SLIDE/EMERGENCY EXIT LIGHT INOP. GROUNDED - YES. RELAMPED R2 DOOR SLIDE/EMERGENCY EXIT LIGHT, REF AMM 33-51-04-960-801. OPS CHECKS GOOD.SDR SIMA20170425002Light · inoperativeNR 3 EMERGENCY LIGHT STRIP INOP, FOUND DURING CLOSE UP. REMOVED AND REPLACED NR 3 EMERGENCY LIGHT STRIP IAW 33-50-12. OPS CHK GOOD.SDR SWAA2017042713418Battery Pack · dischargedRT EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017042713415Light · inoperativeLT LOWER FUSELAGE LOWER EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017042713408Light · inoperativeLT EMERGENCY EXIT BULLNOSE LIGHT INOP AT 18. RELAMPED LIGHT IAW AMM.SDR AALA201704279028Lens · missingAIRCRAFT NOT GROUNDED. R1 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED EMERGENCY LIGHT LENS ON R1 DOOR AS REQUIRED.SDR QXEA2017042700328Light · inoperativeFORWARD F/A EMERGENCY LIGHT SWITCH NOT ILLUMINATED. RELAMPED. CHECKS GOOD. RETURNED TO SERVICE.SDR AALA201704279012Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN LIGHT COVER MISSING 2R SIDEWALL. FOUND LENS ON FLOOR, RE-SECURED LENS.SDR AALA201704269022Cover · detachedAFT RIGHT DOOR EXIT LIGHT COVER DETACHED. SECURED THE LIGHT COVER.SDR AALA201704269019Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT INOPERATIVE AT SEAT 22L. REPLACED SEAT MOUNTED EMERGENCY LIGHT.SDR AALA201704269011Light · inoperativeAIRCRAFT WAS NOT GROUNDED. L4 DOOR EMERGENCY EVACUATION SLIDE LIGHT IS INOPERATIVE. REMOVED AND REPLACED SLIDE LIGHT IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201704269013Lens · detachedEMERGENCY EXIT LIGHT IN THE LEFT AFT CABIN HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-04. OPS CHECKED GOOD.SDR SWAA2017042613400Lens · missingRIGHT AFT GALLEY DOOR EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED LENS IAW AMM.SDR JJBA20170425031Battery Pack · inoperativeEMERGENCY LIGHTS CENTER CEILING ABOVE GALLEY & ROW 18. R & R THE NR 2 EMERGENCY BATTERY PACK, REMOVED AND RESEATED CONNECTOR PLUG ON NR 4 BATTERY PACK. OPS CHECKED SAT, NO DEFECTS NOTED.SDR AALA20170424005Housing · detachedEMERGENCY EXIT SIGN AT R3 DOOR MAIN AISLE IS DETACHED FROM HINGE MOUNT. REMOVED AND REPLACED EXIT SIGN HOUSING ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR MASA2017042512758Light · inoperativeROW 8 CEILING LEVEL EMERGENCY FLOODLIGHT INOPERATIVE.SDR IPXA2017042516458Power Supply · inoperativeDURING PDC EMERGENCY LIGHTS TEST, RECEIVED A BATTERY LOW MESSAGE. DID NOT GO AWAY. R & R THE BATTERY POWER SUPPLY & OPS TEST PASSED IAW AMM 33-51-01.SDR AALA201704289033Lens · brokenTAIL CONE SLIDE RELEASE HANDLE LIGHT LENS MOUNTING CLIP BROKEN ON OUTBD END. REMOVED AND REPLACED TAIL CONE SLIDE HANDLE LIGHT ASSY IAW AMM 33-53-01.SDR AALA201704289032Lens · missingEMERGENCY LIGHT LENS COVER MISSING AT TAIL CONE RELEASE HANDLE. REPLACED THE LENS COVER AND LIGHT ASSY IAW AMM 33-53-01.SDR AALA201704269015Lens · detachedFORWARD GALLEY EMERGENCY LIGHT LENS FELL OFF. REPLACED EMERGENCY EXIT LENS IAW AMM 33-53-01.SDR SWAA2017042713409Light · inoperativeRT EMERGENCY LIGHT INOP AT ROW 16. RELAMPED LIGHT PER AMM.SDR QXEA2017042700325Light · looseFLOOR PATH STRIP BY ROW 2 LOOSE. SECURED FLOOR STRIP BY ROW 2. RETURNED TO SERVICE.SDR AALA201704259013Lens · detachedTHE SMALL EXIT SIGN COVER FROM THE R4 DOOR HAS COME OFF. REPLACED THE EMERGENCY LIGHT LENS COVER.SDR AALA20170424002Light · missingFWD GALLEY LEFT SIDE FLOOR PROXIMITY LIGHT IS MISSING, FWD GALLEY LEFT SIDE FLOOR PROXIMITY LIGHT ASSEMBLY WAS INSTALLED AND TEST WAS SUCCESSFUL IAW AMM 33-51-05.SDR SWAA2017042613384Lens · looseFORWARD ENTRY EMERGENCY LIGHT LENS LOOSE. SECURED THE LENS IAW SIP.SDR SWAA2017042613383Lamp · inoperativeR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR U2RA201704240003Connector · not seatedMAIN CABIN AT ROW 30 EMERGENCY AISLE LIGHT INOPERATIVE. RESEATED ENRGENCY LIGHT CONNECTOR AT SEAT ROW 3 IAW SWPM 20-61-00. THE LIGHT OPS CHECKED GOOD IAW AMM 33-51-00SDR SWAA2017042513328Lens · damagedLEFT CABIN EMERGENCY LIGHT LENS FOUND TO BE DAMAGED AT ROW 23. R & R LENS IAW AMM.SDR SWAA2017042513327Lens · damagedRIGHT CABIN EMERGENCY LIGHT LENS DAMAGED AT ROW 10. R & R THE LENS IAW AMM.SDR DALA2017042503389Power Supply · inoperativeROWS 4, 5, 15, AND 16 EMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT EMERGENCY LIGHTING SYSTEM IAW WDM 33-51-21, PAGE 9B, SHT 1. FOUND M732 POWER SUPPLY INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51. EMERGENCY LIGHTING SYSTEM OPS TESTED GOOD ISDR DALA2017042503379Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS ROW 11-15 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AT ROW 12 CDE OVERHEAD BIN IAW AMM 33-53. THE EMERGENCY LIGHTS OPS CHECKED GOOD.SDR CALA2017042401133Light · brokenEMERGENCY EXIT LIGHT AT SEAT 30C BROKEN. . REMOVED AND REPLACED ROW EXIT LIGHT AT SEAT 30C. OPS GOOD.SDR CALA2017042401132Lens · missingFORWARD COAT CLOSET AFT EMERGENCY EXIT LIGHT LENS MISSING. REPLACED LENS, EMERGENCY EXIT LIGHTS ON FWD COAT CLOSET OPS CHECK NORMAL.SDR CALA2017042401127Light · inoperativeEMERGENCY LIGHTS AT SEAT ROW 15B DO NOT ILLUMINATE. REPLACED THE LIGHT IAW AMM 33-50-00 AND OP CHECKED GOOD IAW AMM 33-5 0-96-704-006.SDR CALA2017042401126Lamp · inoperativeEMERGENCY LIGHTS AT SEAT 16B DO NOT ILLUMINATE. REPLACED THE LAMP IAW AMM 33-50-00, AND OPS CHECKED GOOD IAW 33-50-96-704-006. OPS CHECKED OK.SDR CALA2017042401125Wire · shortedEMERGENCY LIGHTS AT SEATS 45C - 53C DOES NOT ILLUMINATE. FOUND WIRES PINCHED INSIDE THE BOX UNDER SEAT ROW 45K WHICH CAUSED A SHORT. REPAIRED IAW SWPM 20-10-13. OP CHECKED GOOD IAW AMM 33-50-96-704-006. OPS CHECKED OK IAW 33-50-96-704-006.SDR AALA20170423001Sign · missingON PRE-FLIGHT, R2 EMERGENCY EXIT SIGN WAS MISSING. UNABLE TO LOCATE ON AIRCRAFT. OBTAINED LIGHT ASSY FROM STORES, REMOVED AND REPLACED R2 EMERGENCY EXIT SIGN ASSEMBLY. FUNCTIONAL TEST WAS GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704249021Lens · damagedOVERWING EXIT LEFT SIDE SIGN DAMAGED. REPLACED THE LENS.SDR AALA201704249014Lens · missingLENS COVER MISSING EMERGENCY LIGHT SEAT 1A. INSTALLED LENS COVER ON SEAT 1A EMERGENCY LIGHT.SDR SWAA2017042613399Cover · brokenR1 DOOR EMERGENCY EXIT SIGN COVER BROKEN. R & R THE COVER IAW MM.SDR SWAA2017042613382Lens · looseFORWARD ENTRY LOWER EMERGENCY EXIT LENS LOOSE. R & R THE SIGN IAW AMM.SDR AALA201704259040Lens · missingEMERGENCY LIGHT LENS MISSING RIGHT SIDE OF PARTITION AFT 4J. REPLACED THE LENS.SDR AALA201704259039Lens · missingEME LIGHT LENS MISSING FWD OF ROW 33 PARTITION RIGHT SIDE. REPLACED LIGHT LENS RIGHT ROW 33 PARTITION.SDR AALA201704259027Lens · detachedEMERGENCY EXIT LIGHT AT THE L2 DOOR HAS A LENS COVER THAT WILL NOT STAY ON. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201704259024Light · brokenEMERGENCY EXIT SIGN BY THE R4 DOOR IS BROKEN. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR SWAA2017042513376Cover · detachedMID PLATE EMERGENCY EXIT SIGN COVER FELL OFF. SECURED THE LIGHT COVER IAW SIP.SDR SWAA2017042513313Sign · detachedMID CABIN EMERGENCY EXIT SIGN FELL OFF. ATTACHED THE SIGN IAW MM.SDR HNAA2017042500134Battery Pack · dischargedCEILING EMERGENCY LIGHT IN AT C,D,F INOPERATIVE. FOUND BATTERY PACK DISCHARGED.SDR SIMA20170423001Light · inoperativeEMERGENCY LIGHT AFT OF THE EMERGENCY ROW SEATING INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT. OPS CHECKED GOOD IAW AMM 33-50-12.
Back to JASC 3350