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 AALA201706199041Light · not seatedEXTERNAL EMERGENCY EXIT SLIDE LIGHT AT THE L4 DOOR IS INOPERATIVE. RESEATED THE LIGHT IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR SWAA2017061914477Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM AND DWG.SDR SWAA2017061914476Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM AND DWG.SDR SWAA2017061914475Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM AND DWG.SDR SWAA2017061914415Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM AND DWG.SDR SWAA2017061914414Cover · unsecureFORWARD ENTRY EMERGENCY EXIT LIGHT COVER FELL OFF. REPLACED COVER PER MM.SDR SWAA2017061914396Lens · unsecureLT AFT ENTRY EMERGENCY EXIT SIGN LENS CAME OFF. R&R LIGHT IAW AMM.SDR AALA201706169014Light · missingSEAT 11C MOUNTED EMERGENCY LIGHT IS MISSING. INSTALLED THE LIGHT ASSEMBLY IAW AMM 33-51-18. OPS CHECKED GOOD.SDR AALA201706169003Lens · looseEMERGENCY EXIT LIGHT BY THE L3 DOOR HAS A LOOSE LENS. REMOVED AND REPLACED LENS IAW AMM 33-50-00. OPS CHECKED GOOD.SDR AALA20170616001Sign · unsecureEMERGENCY LIGHT, LOWER LEFT, BY THE R1 DOOR IS NOT SECURE. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-13. OPERATIONAL CHECKED GOOD.SDR MYWA2017061900253Lamp · inoperativeFOUND INTERIOR LT AFT EXIT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP.SDR AALA201706169020Lens · missingEMERGENCY LIGHT AT ROW 25D HAS A MISSING LENS. INSTALLED THE LENS IAW AMM 33-51-05-002-001. OPS CHECKED GOOD.SDR AALA201706169019Lens · looseEMERGENCY EXIT SIGN BETWEEN L2 AND R2 DOORS HAS A LOOSE LENS COVER. SECURED THE LENS COVER. OPS CHECKED GOOD.SDR AALA201706169047Cover · missingLEFT AFTER GALLEY EXIT SIGN COVER IS MISSING. REMOVED AND REPLACED LEFT AFT GALLEY EXIT SIGN CHECKED GOOD IAW AMM 33-51-01.SDR AALA201706169046Light · inoperativeSEAT 12G, EMERGENCY LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT IAW ESO 21195, PAGE 1007. CHECKED OK FOR SERVICE.SDR AALA201706169005Lens · missingR2 DOOR EXIT COVER MISSING OFF THE EMERGENCY LIGHT. REPLACED THE LENS.SDR AALA201706169012Mount · brokenEMERGENCY LIGHT AT THE R4 DOOR HAS A BROKEN MOUNT. REMOVED AND REPLACED THE EMERGENCY LIGHT 90WL7 IAW AMM 33-51-13. OPS CHECKED GOOD.SDR AALA201706169011Light · brokenEMERGENCY LIGHT AT THE R1 DOOR HAS A MISSING LENS AND A BROKEN MOUNT. REMOVED AND REPLACED THE EMERGENCY LIGHT 90WL2 IAW AMM 33-51-13. OPS CHECKED GOOD.SDR AALA201706169010Lens · missingEMERGENCY LIGHT BY THE L1 DOOR HAS A MISSING LENS. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-13. OPS CHECKED GOOD.SDR MASA2017061512384Light · inoperativeROW 23 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR SWAA2017062114550Light · inoperativeLT FUSELAGE MOUNTED EMERGENCY LIGHT AFT OF OVERWING EXIT INOP. R&R LAMP PER MM.SDR SWAA2017062014508Cover · missingRIGHT EMERGENCY EXIT DOOR SIGN COVER MISSING. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2017062014498Battery · inoperativeLEFT OVERWING FUSELAGE MOUNTED EMERGENCY EXIT LIGHT INOPERATIVEF. RESET POWER SUPPLY BATTERY IAW AMM.SDR SWAA2017061914481Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM AND DWG.SDR SWAA2017061914480Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM AND DWG.SDR SWAA2017061914479Battery Pack · dischargedL1 DOOR EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017061914478Battery Pack · dischargedRT FORWARD BULLNOSE EMERGENCY EXIT AISLE LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017061914461Cover · brokenR1 DOOR EXTERIOR EMERGENCY LIGHT LENS COVER BROKEN. R&R COVER PER AMM.SDR SWAA2017061914456Battery Pack · dischargedR1 DOOR EMERGENCY EXIT SLIDE LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017061914455Light · inoperativeEXTERNAL EMERGENCY LIGHT INOP AT BS 727F+12, BETWEEN STR 21R TO STR 22R. RELAMPED LIGHT PER AMM.SDR SWAA2017061914452Charger · inoperativeLT EMERGENCY LIGHT BASE UNIT BATTERY RETENTION HARDWARE INOP AT ROW 17. R&R CHARGER PER AMM.SDR SWAA2017061914451Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER AMM AND DWG.SDR SWAA2017061914467Light · crackedMAIN CABIN PHOTO LUMINESCENT TRACK LIGHT DIRTY CRACKED. R&R LIGHT PER MM.SDR SWAA2017061914464Lens · crackedFORWARD EMERGENCY EXIT SIGN LENS CRACKED. R&R LENS IAW AMM.SDR SWAA2017061914450Light · looseRT FLOOR LIGHT LOOSE AT ROW 11. SECURED LIGHT STRIP PER SIP.SDR SWAA2017061914427Battery Pack · dischargedR1 DOOR EMERGENCY LIGHT FAILED. R&R BATTERY PACK IAW AMM.SDR SWAA2017061914410Battery · failedFORWARD LT EMERGENCY BATTERY FAILED TIME TEST. R&R BATTERY PER AMM.SDR SWAA2017061914409Battery · failedAFT LT EMERGENCY BATTERY FAILED TIME TEST. R&R BATTERY PER AMM.SDR SWAA2017061914407Cover · missingOVERWING CEILING EXIT SIGN COVER MISSING. SECURED COVER PER SIP.SDR AALA201706199015Light · missingMISSING SEAT 11C MOUNTED EMERGENCY LIGHT. REPLACED THE SHROUND AND ATTACHED RED LIGHT ASSEMBY AND BEZEL IAW ESO 33414, ITEM 9. ACCOMPLISHED EMERGENCY LIGHT CHECK IAW AMM 31-51-00.SDR DALA2017061504759Battery Pack · faultedEPSU BATTERY EMERGENCY MESSAGE DURING AN EMERGENCY LIGHT TEST, REPLACED EPCU BATTERY.SDR AALA201706159041Battery Pack · dischargedCOCKPIT EMERGENCY LIGHT DOES NOT WORK WITH EMERGENCY LIGHT SWITCH ON. REMOVED & REPLACED THE FWD GALLEY OVERHEAD EMERGENCY LIGHT BATTERY PACK IAW MM 33-50-00.SDR AALA201706159040Light · inoperativeRT AFT EMERGENCY LIGHT LENS INOPERATIVE. REMOVED AND REPLACED THE LIGHT BASE PLATE IAW AMM 33-51-00. OPS TESTED NORMAL.SDR AALA201706159039Sign · missingRIGHT AFT SERVICE DOOR EXIT SIGN MISSING. INSTALLED A NEW SIGN, CHECKED OK IAW GPM.SDR SWAA2017061514368Cover · missingCENTER AISLE OVERWING EXIT SIGN ACCESS PANEL MISSING COVER. INSTALLED COVER PER SIP.SDR SWAA2017061514367Lens · missingBULLNOSE AISLE EMERGENCY LIGHT LENS MISSING. INSTALLED LENS PER SIP.SDR AALA201706159031Light · detachedEMERGENCY LIGHT ON FLOOR BY ROW 17AB FOUND DETACHED. CLEANED AND ATTACHED THE LIGHTS AT SEATS 15 TO 17AB IAW AMM 33-51-15. OPERATIONAL CHECKED GOOD.SDR DALA2017061504726Lens · missingRED EMERGENCY FLOOR LIGHTS MISSING AT THE L3 AND R3 DOORS. REPLACED RED EMERGENCY LIGHT COVERS.SDR AALA201706159018Switch · faultyAIRCRAFT NOT GROUNDED. EXIT LIGHT OUT AT R3, R2 DOORS. RESET EXIT LIGHT SWITCH IN COCKPIT, INDICATION NORMAL OK FOR CONTINUED SERVICE.SDR AALA201706159011Lens · missingEMERGENCY EXIT SIGN LENS MISSING AT L2 DOOR. INSTALLED A SERVICEABLE EMERGENCY EXIT SIGN LENS.
Back to JASC 3350