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 SWAA2017021411875Cover · missingR1 DOOR LOWER EMERGENCY EXIT LIGHT COVER MISSING. R&R LIGHT ASSEMBLY IAW MM.SDR SWAA2017021411859Cover · brokenFRONT GALLEY "EXIT" PLACARD COVER BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR DALA2017021301205Light · inoperativeEMERGENCY FLOOR LIGHTING INOPERATIVE. RESECURED 17A - 20A FLOOR LIGHTING. OKAY FOR SERVICE.SDR AALA201702129004Battery · dischargedFLASHLIGHT INOPERATIVE AT 3L DOOR. REPLACED FLASHLIGHT BATTERY.SDR SWAA2017021311832Lens · looseOVERWING OVERHEAD EMERGENCY EXIT LENS LOOSE. SECURED THE LENS IAW AMM.SDR SWAA2017021311783Cover · missingR2 DOOR EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED COVER IAW SIP.SDR SWAA2017021311782Battery Pack · faultyLEFT AFT EMERGENCY EXIT LIGHT CHARGER CIRCUIT BREAKER FAULTY. R & R THE BATTERY PACK IAW MM.SDR SWAA2017021311780Battery Pack · inoperativeRIGHT AFT EMERGENCY FLASHLIGHT INOPERATIVE. R & R THE BATTERY IAW MM.SDR DALA2017021200024Battery Pack · not reportedDURING SERVICE CHECK, FOUND EMERGENCY LIGHTS AT SEAT 2A-7A NOT WORKING CORRECTLY. REPLACED BATTERY FOR 11WL EPSU.SDR HALA2017021100029Light · inoperativeR2 EXTERIOR EMERGENCY LIGHT INOP. RELAMPED R2 EXTERIOR EMERGENCY LIGHT. OPS CHECK GOOD. OK FOR SERVICE.SDR HALA2017021100028Light · inoperativeEMERGENCY GUIDE PATH LIGHTING FROM 11H TO 16H INOP. RESECURED EMERGENCY LIGHT STRIPS AT 11 TO 16H. OPS CK GOOD PER 33-51-10.SDR HALA2017021100027Light · inoperativeEMERGENCY LIGHT STRIP AT FWD GALLEY INOP. REMOVED AND REPLACED FWD GALLEY EMERGENCY LIGHT STRIP PER WDM 33-51-16. OPS CHKS OK.SDR AALA20170212005Battery Pack · no testEMERGENCY LIGHT POWER SUPPLY UNIT AT 12WL FAILED TEST. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA201702129003Lens · detachedEMERGENCY EXIT COVER FOR LIGHT AT ROW 4L POPPED OFF. INSTALLED A NEW LENS.SDR AALA201702129002Lens · brokenEXIT SIGN AT THE L4 ENTRY DOOR IS BROKEN AND POPPED OUT. COVER REPLACEDSDR QXEA2017021300059Light · looseEMERGENCY LIGHT IS LOOSE. SECURED THE LIGHT. ACFT OK FOR SERVICE.SDR DALA2017021301167Battery · dischargedEMERGENCY LIGHTS AFT TAIL UPPER DO NOT TURN ON. CHANGED BATTERIES PACK AFT RIGHT LAV. OPERATIONAL CHECK OK.SDR CALA2017021100324Light · inoperativeLT FWD O/W EMERGENCY EXIT LIGHT IS INOP. REMOVED AND REPLACED LT FWD O/W EMERGENCY EXIT LAMP IAW AMM 33-51-04-960-801. OPS CHECK GOOD IAW AMM 33-51-00-710- 801.SDR SIMA20170210007Battery · dischargedLT AND RT AFT OVERWING EMERGENCY LIGHTS BEHIND EMERGENCY EXITS AND AFT INTERIOR CEILING EMERGENCY LIGHTS BEHIND EMERGENCY EXITS NOT TURNING ON. REMOVED AND REPLACED NR 4 EPSU BATTERY AND CHARGER IAW AMM 33-51-17. OPS CHECK GOOD.SDR AALA20170212015Indicator · damagedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY EXIT FLOOR PROXIMITY INDICATOR IS DAMAGED. REMOVED AND REPLACED INDICATOR. OPERATIONAL CHECK GOOD.SDR AALA20170214003Lens · disconnectedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN FORWARD COMPARTMENT HAS A DISCONNECTED LENS COVER. REMOVED AND REPLACED THE LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170213022Lens · brokenAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHT ON SEAT 15C HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20170213021Lens · brokenAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHT ON SEAT 25D HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20170213001Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN MID AISLE FORWARD FACING IS DETACHED. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR DALA2017021301227Sign · damagedSIDEWALL MOUNTED EXIT SIGN AT RT AFT OVERWING EXIT DAMAGED. REMOVED AND REPLACED EXIT SIGN (L00635) AT RT AFT OVERWING EXIT IAW AMM 33-51-10.SDR SWAA2017021411885Light · inoperativeRT OVERWING ESCAPE GROUND EMERGENCY EXIT LIGHTS INOP. REPAIRED LIGHTS PER SIP.SDR SWAA2017021411880Light · inoperativeLT OVERWING ESCAPE GROUND EMERGENCY EXIT LIGHTS INOP. REPAIRED LIGHTS PER SIP.SDR SWAA2017021411874Lens · brokenRT OVERWING LOWER EMERGENCY EXIT SIGN LENS BROKEN. R&R LENS IAW AMM.SDR SWAA2017021411873Cover · unsecureFORWARD ENTRY EMERGENCY LIGHT COVER FELL OFF. SECURED COVER PER SIP.SDR SWAA2017021411870Lens · mismarkedLT LOWER OVERWING EMERGENCY EXIT LIGHT LENS MISMARKED. R&R LENS ASSEMBLY IAW AMM.SDR SWAA2017021411869Lens · unsecureL1 DOOR EXIT SIGN LENS NEAR FORWARD CABIN JUMPSEAT FELL OFF. R&R LENS PER MM.SDR SWAA2017021411861Light · damagedL1 DOOR EMERGENCY EXIT LIGHT BASE DAMAGED. R&R BASE ASSEMBLY PER MM.SDR SWAA2017021411858Lens · crackedR1 DOOR OVERHEAD EMERGENCY EXIT LIGHT LENS BEZEL CRACKED. REPAIRED LENS PER MM.SDR DALA2017021101190Light · inoperativeEMERGENCY LIGHT AT SEAT 11D INOPERATIVE, REPLACED THE LIGHT ASSY.SDR SWAA2017021311822Lens · detachedOVERWING EMERGENCY EXIT SIGN LENS DETACHED. INSTALLED THE LENS IAW SIP.SDR FDEA201702100507Bulb · inoperativeLEFT EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB IAW MM 33-50-2610. OPS CHECKED NORMAL.SDR AALA201702129009Battery · faultedCIDS 1 EMERGENCY LIGHT POWER SUPPLY UNIT SYSTEM TEST SHOWS FAULT MESSAGE ON BATTERY. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201702119008Lens · looseEXIT SIGN LOCATED ON THE SIDE OF THE L3 DOOR HAS A LOOSE LENS. REPLACED THE LENS IAW AMM 33-51-16.SDR AALA201702119007Power Supply · faultedCIDS 1 EMERGENCY POWER SUPPLY UNIT SYSTEM TEST SHOWS FAULT MESSAGE ON BATTERY. THE POWER SUPPLY UNIT WAS REPLACED IAW AMM 33-51-38.SDR REXA2017021000190Lamp · inoperativeEXTERIOR EMERGENCY LIGHT ON RT SIDE INOPERATIVE. REPLACED THE LAMP IAW CMM 33-52-06. OPS CHECKED GOOD IAW AMM 33-51-00. OK FOR SERVICE.SDR AALA20170213017Light · looseSEAT MOUNTED EMERGENCY LIGHT AT SEAT 11C IS LOOSE. REINSTALLED LIGHT IAW AMM 25-26-09. OPS CHECKED GOOD.SDR AALA20170213016Light · unsecureEMERGENCY LIGHT NEAR THE GALLEY IS UNSECURE. SECURED THE LIGHT IAW AMM 33-50-00. OPS CHECKED GOOD.SDR AALA20170213013Lens · missingEMERGENCY EXIT LIGHT ABOVE CENTER SEATS ROW 36 HAS A MISSING LENS . INSTALLED THE LENS IAW AMM 25-21-06. OPS CHECKED GOOD.SDR AALA20170211001Battery Pack · no testEMERGENCY LIGHT POWER SUPPLY UNIT AT 10WL FAILED TEST. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA20170210020Light · brokenSEAT MOUNTED EMERGENCY LIGHT AT SEAT 5J IS BROKEN. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-50-00. OPS CHECKED GOOD.SDR AALA201702119005Light · unsecureEMERGENCY LIGHT SEAT 1C OUT OF SOCKET. SECURED THE LIGHT ASSEMBLY.SDR AALA201702119003Lens · damagedDOOR EMERGENCY EXIT LIGHT DAMAGED. REPLACED THE LENS.SDR CALA2017021100322Battery · dischargedCABIN, ZONE 3, RT EMER AREA LT FOUND DIM (R4 DOOR M33409). ZONE 3, RT EMER LT (M33409) BATTERY AND CHARGER REPLACED AND CHECK NORMAL IAW AMM 33-51-00.SDR CALA2017021000319Charger · faultyEMERGENCY EXIT LIGHTS ROW 22ABC TO 31ABC INOP. REPLACED BATTERY PACK NO HELP. SUSPECT BATTERY CHARGER. REMOVED AND REPLACED BATTERY CHARGER REF IPC 33-51-06-02 ITM 40 AND MM 33-51-06, OPS CK NORMAL ACP'D IDT INSPECTION OF BATTERY CHARGE INSTALLATION AT LOCATIOSDR CALA2017021000315Light · damagedEMERGENCY LIGHT AT DOOR 1 LEFT AND CROSSOVER AISLE AND FRONT CLOSET DOOR LEFT INOP. REPAIRED DAMAGED ELL POWER STRIP IAW 33-51-10.
Back to JASC 3350