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 REXA2016101001921Lamp · inoperativeEXTERIOR EMERGENCY LIGHT OUT. REPLACED THE LAMP IAW AMM 33-50-00. OPS CHECKED GOOD.SDR ASAA2016101018261Lamp · failedEMERGENCY EXTERIOR SLIDE LIGHT AT THE R 2 DOOR WAS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-04-960-801. OPS NORMAL.SDR ASAA2016101018260Lamp · failedEMERGENCY LIGHT EXIT SIGN ADJACENT TO LEFT FORWARD OVERWING EXIT HAS MULTIPLE LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801, OPS NORMAL.SDR ASAA2016101018259Sign · detachedEXIT SIGN AT 16F FELL OFF. ACFT GROUNDED. SECURED THE SIGN.SDR IPXA2016101009189Battery · dischargedEMERGENCY LIGHT BATTERY 1 LOW, MESSAGE WHEN PERFORMING EMERGENCY LIGHT TEST. REPLACED EMERGENCY POWER SUPPLY BATTERY IAW AMM 33-51-01-401.SDR JJBA20161010012Circuit Board · inoperative2D & 18D EMERGENCY LIGHT WILL NOT EXTINGUISH. R & R THE PRINTED CIRCUIT BOARD FOR EMERGENCY LIGHT CONTROL BOX. OPS CHECK SAT.SDR MASA2016101012445Bulb · inoperative13A EXIT SIGN ONE BULB INOPERATIVE.SDR MASA2016101012443Light · inoperativeAFT CEILING EMERGENCY LIGHT INOPERATIVE.SDR SWAA2016101108581Lens · looseL1 DOOR EMERGENCY EXIT SIGN LENS LOOSE. SECURED THE LENS IAW AMM.SDR SWAA2016101108580Sign · brokenL1 DOOR EMERGENCY EXIT SIGN LIGHT BROKEN. R & R THE SIGN IAW MM.SDR SWAA2016101108579Cover · missingL1 DOOR EMERGENCY EXIT LIGHT LENS COVER MISSING. INSTALLED COVER IAW MM.SDR SIMA20161010008Sign · inoperativeRIGHT UPPER EMERGENCY EXIT SIGN INOPERATIVE ON EXIT DOOR. REMOVED AND REPLACED THE SIGN IAW AMM 33-50-14. OPS CHECKED NORMAL.SDR DALA2016101107165Power Supply · inoperativeR1 DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED & REPLACED POWER SUPPLY IAW AMM 33-51. OPS CHECKED OK.SDR R61A201610100579Light · damagedMAINTENANCE REPORTED THAT THREE EMERGENCY LIGHTS IN THE FORWARD CABIN WERE DAMAGED. MAINTENANCE REMOVED AND REPLACED IAW AMM AND OPS CHECKED GOOD.SDR REXA2016101001920Lamp · inoperativeDURING WAKE UP CHECK, FOUND EMERGENCY LIGHT NR 6 OUT. REPLACED THE LAMPS IAW AMM 33-51-21, OPS TESTED GOOD.SDR AALA20161010009Power Supply · inoperativeDURING PS2 CHECK, FOUND EMERGENCY POWER SUPPLY M33409 INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR AALA20161010004Power Supply · inoperativeDURING PS2 CHECK, FOUND EMERGENCY POWER SUPPLY M33093 INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR AALA20161010003Sign · missingAFT GALLEY IS MISSING EMERGENCY EXIT SIGN. REPLACED EXIT SIGN AND ACCOMPLISHED AN OPS CHECK IAW AMM 33-51-01. SYSTEM CHECKED NORMAL.SDR CALA2016101000748Battery Pack · inoperativeLH AFT DOOR EMERGENCY LIGHTS WILL NOT COME ON. REMOVED AND REPLACED BATTERY PACK FOR LH AFT DOOR REF AMM 33-51 -06. OPS CHECK GOOD.SDR AALA20161011011Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHTS INOPERATIVE BETWEEN STATIONS 243 AND 1332. REMOVED AND REPLACED BATTERY. OPERATIONAL CHECK GOOD.SDR AALA20161011010Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHTS INOPERATIVE BETWEEN STATIONS 243 AND 1332. REMOVED AND REPLACED BATTERY. OPERATIONAL CHECK GOOD.SDR AALA20161011009Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHTS INOPERATIVE BETWEEN STATIONS 243 AND 1332. REMOVED AND REPLACED BATTERY. OPERATIONAL CHECK GOOD.SDR AALA20161011008Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHTS INOPERATIVE BETWEEN STATIONS 243 AND 1332. REMOVED AND REPLACED BATTERY. OPERATIONAL CHECK GOOD.SDR AALA20161011007Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHTS INOPERATIVE BETWEEN STATIONS 243 AND 1332. REMOVED AND REPLACED BATTERY. OPERATIONAL CHECK GOOD.SDR SWAA2016101308744Fuse · inoperativeLEFT OVER WING EXIT SIDEWALL LOWER LIGHT INOPERATIVE. R & R THE FUSE IAW AMM.SDR DALA2016101007215Battery Pack · inoperativeEMERGENCY EXIT SIGH INOPERATIVE ABOVE DOOR L2 DOOR. REMOVED AND REPLACED BATTERY PACK. OPERATION CHECKED GOOD.SDR ASOA20161009477Light · inoperativeDURING MAINTENANCE INSPECTION, THE RT OUTSIDE OVERWING EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED LIGHT ASSEMBLY, OPERATIONALLY TESTED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2016101107175Wire · brokenROW 17 SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. INSPECTED PLUG AT SEAT FOR EMERGENCY LIGHTING, FOUND WIRE BROKEN. REPAIR THE WIRE, CHECKED GOOD.SDR SWAA2016101108661Lamp · inoperativeLEFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR DALA2016101107164Lens · missingEMERGENCY LIGHT LENS MISSING AT ROW 3 RIGHT OVERHEAD BIN. LIGHT OPS OK. INSTALLED A NEW LENS, OPS & SECURITY CHECKED OK, IAW AMM 33-51.SDR MASA2016100912442Light · inoperativeFWD BULKHEAD EMERGENCY LIGHT INOPERATIVE. MX IS TROUBLESHOOTING.SDR MASA2016100912441Battery Pack · dischargedROW 4A EMERGENCY EXIT SIGN FACING AFT INOPERATIVE. ALLOWED BATTERY TO CHARGESDR SIMA20161008002Socket · crackedTHREE PROXIMITY LIGHT HOLDERS ARE CRACKED. REMOVED AND REPLACED THE LIGHT HOLDERS IAW AMM 33-50-12.SDR SIMA20161008003Battery Pack · inoperativePROXIMITY LIGHTS 2,3,7,8 AND 9 ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY PACK ASSEMBLIES 2 AND 4 IAW AMM 33-50-04, OPS CHECKED GOOD.SDR SIMA20161008001Battery Pack · dischargedEMERGENCY LIGHT IN MAIN DOOR INOP. REMOVED AND REPLACED NR 1 EMERGENCY BATTERY PACK ASSEMBLY IAW AMM 33-50-04, OPC GOOD.SDR AALA201610139021Trim Panel · broken17C EMERG TRACK RAIL LIGHT TRIM BROKEN OFF. REPLACED SEAT 17ABC AISLE BUMPER TRIM IAW GPM NO TECH REF SEE TEXT FOR MAINT OR REPAIR DONE.SDR SWAA2016101108657Light · inoperativeR/H OVERWING EMERGENCY EXIT FLORESCENT LIGHT INOPERATIVE. R & R THE LIGHT IAW SIP.SDR AALA201610119010Lens · looseEMERGENCY EXIT SIGN OVER L3 DOOR CAME LOOSE. REINSTALLED THE LENS.SDR AALA201610119009Lens · crackedSEAT MOUNTED EMERGENCY LIGHT LENS CRACKED AT ROW 18C. REMOVED AND REPLACED THE LENS.SDR AALA201610119007Lens · crackedSEAT MOUNTED EMERGENCY LIGHT LENS AT ROW 4C FOUND CRACKED. REMOVED AND REPLACED THE LENS.SDR AALA201610119006Lens · crackedSEAT MOUNTED EMERGENCY LIGHT LENS AT ROW 1C FOUND CRACKED. REMOVED AND REPLACED THE LENS.SDR AALA201610119002Lens · brokenR1 DOOR EMERGENCY LIGHT COVER BROKEN. R & R THE LENS COVER.SDR DALA2016101007166Charger · inoperativeSHIP 654 F/C EMERG LIGHTS INOPERATIVE. REPLACED BATTERY CHARGER ASSY IAW AMM 33-51. OPS NORMAL.SDR DALA2016101107157Power Supply · inoperativeDURING INSPECTION FOUND EMERGENCY LIGHTS ROW 1-10 INOPERATIVE. MAINTENANCE FOUND POWER SUPPLY BAD. REPLACED POWER SUPPLY. EMERGENCY LIGHTS TEST GOOD.SDR N6WA2016100801Battery Pack · inoperativeEXIT SIGN BY AFT EXIT ROW INOPERATIVE. REPLACED THE BATTERY PACK.SDR CALA2016101000737Lamp · failedELECTRIC BURNING ODOR NEAR OVERWING EXIT. DISSIPATED RAPIDLY. FOUND EMERGENCY EXIT LEFT SIDE SIDE WALL LIGHTS BLACK AT THE END. REPLACED LT EMERGENCY EXIT SIDE WALL LIGHTS IAS AMM 33-21-30SDR UHLA201610080457Light · inoperativeFIRST CLASS EMERGENCY LIGHT STRIPS INOPERATIVE. R & R IAW AMM 33-50-21. OPS TEST GOOD.SDR DALA2016101007122Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT BOTH OF THE MAIN CABIN DOORS EMERGENCY EXIT SIGNS WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND THE OPS CHECKED GOOD.SDR JJBA20161008011Battery · inoperativeNUMEROUS EXIT LIGHTS NOT ILLUMINATING. R & R THE BATTERY PACKS, OPS CHECKED GOOD. NO OTHER DEFECTS NOTED.SDR SWAA2016101108655Lens · missingINSIDE CABIN OVERHEAD EMERGENCY LIGHT MISSING LENS AT BS 380. INSTALLED LENS IAW MM.
Back to JASC 3350