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 REXA2017022600293Socket · unsecureAFT BLUE SOCKET ON CNT EXIT LIGHT DAMAGED. RESECURED AFT BLUE SOCKET ON CNT EXIT LIGHT IAW AMM 33-51-14.SDR REXA2017022600292Light · inoperativeRIGHT AFT EXTERIOR EMERGENCY LIGHT INOP. RELAMPED EMERGENCY LIGHT, OPS CKS GOOD IAW AMM 33-51-00. P/N ON/OFF - 1317SDR DALA2017022701634Light · damagedSEAT MOUNTED EMERGENCY LIGHT DAMAGED. R & R IAW AMM REV E.SDR SWAA2017022812202Battery Pack · inoperativeLEFT OVERWING LIGHT INOPERATIVE. CHARGED THE BATTERY PACK IAW AMM.SDR SWAA2017022812182Lamp · inoperativeRIGHT EMERGENCY EXIT AISLE LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR HALA2017022700083Battery Pack · faultedFOUND EPSU BATTERIES 12WL, 15WL, AND 19WL FAULTED. REPLACED THE BATTERY PACKS.SDR AALA201702279012Lens · brokenSEAT ROW 3L EMERGENCY LIGHT BROKEN. REPLACED THE EMERGENCY LIGHT, TESTED GOOD.SDR AALA201702279009Lens · detachedEMERGENCY EXIT LIGHT AT THE L4 DOOR IS MISSING THE COVER. FOUND THE LENS MISSING AND INSTALLED.SDR AALA201702279006Lens · detachedEXIT COVER BY THE L1 DOOR IS OFF. REPLACED EXIT COVER BY 1L DOOR.SDR ASAA2017022619952Lens · deterioratedEMERGENCY LIGHT EXIT SIGNS AT LEFT FORWARD OVERWING EXIT AND LEFT AFT OVERWING EXIT HAVE SCRATCHED AND DETERIORATED LENSES. ACFT GROUNDED. REMOVED AND REPLACED LENSES AND TESTED LIGHT ASSEMBLIES PER B737-800 AMM 33-51-01-960-801 - OPS NORMAL.SDR SWAA2017022712151Lens · missingOVERWING EXIT SIGN LENS MISSING. INSTALLED THE LENS IAW MM.SDR DALA2017022701609Lens · missingSIDEWALL LIGHT LENS MISSING OVER RIGHT SIDE EMERGENCY EXIT WINDOWS. INSTALLED A NEW LENS. OK FOR SERVICE.SDR DALA2017022701584Light · damagedFWD GALLEY EMERGENCY LIGHT FIXTURE DAMAGED. R & R THE EMERGENCY LIGHT IAW AMM 33-28.SDR SWAA2017022712099Lens · missingRIGHT OVERWING EMERGENCY LIGHT LENS MISSING. INSTALLED A LENS IAW AMM.SDR SIMA20170226004Inverter · inoperativeAFT GALLEY AFT SIDE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE NR 3 INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD.SDR MASA2017022612631Light · inoperativeROW 5 CEILING EMERGENCY LIGHT INOPERATIVE.SDR MASA2017022612630Light · inoperativeTHREE FWD EMERGENCY FLOOD LIGHTS INOPERATIVE.SDR JJBA20170226019Inverter · inoperativeEMERGENCY EXIT SIGN AT ROW 18 NOT ILLUMINATING. R & R THE NR 4 INVERTER. OPS CHECKED GOOD. NO DEFECTS NOTED.SDR CALA2017022600492Lens · brokenEMERGENCY FLOOR PROXIMITY LIGHT DOES NOT TURN ON 111 LENS IS BROKEN. REMOVED AND REPLACED BROKEN LENS COVER, FUNCTIONS NORMALLY.SDR CALA2017022600486Unknown · malfunctionedEMER LIGHTING STRIP IN F/C GALLEY AND EXIT LIGHT DOOR 1L FLASHING ON/OFF. INSP CONNECTIONS TO EMERGENCY LIGHT ALL OK. AS PRECAUTION REPLACED BATTERY AS PER AMM 33-51-07 AND PER FORMED OPS TEST ALL OK.SDR SIMA20170225001Charger · inoperativeAFT FLOOR PROXIMITY LIGHTING DOES NOT ILLUMINATE. REMOVED AND REPLACED THE BATTERY HOLDER AND BATTERY CHARGER ASSEMBLY IAW AMM 33-50-04, OPS CHECKED GOOD.SDR A6WA201744820Sign · inoperativeDURING PREFLIGHT INSPECTION, CREW NOTED WHITE FLOOR EXIT SIGN NEAR SERVICE DOOR ON GALLEY BULKHEAD DID NOT ILLUMINATE. INSPECTED CONNECTORS ON SERVICE DOOR FLOOR LEVEL EMERGENCY LIGHTS, NO DEFECTS NOTED. R & R THE SIGN ASSY IAW AMM 33-51-10. OPS CHECKED GOOSDR AALA201702279016Cover · missingEMERGENCY LIGHT CABLE ASSEMBLY 704WL21, INSTALLED CLOSE TO SEAT 15AB, HAS A MISSING PROTECTIVE COVER. REPLACED THE COVER IAW AMM 33-51-12.SDR AALA20170228018Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R2 DOOR HAS A DETACHED LENS COVER. SECURED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170228016Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE CLASS DIVIDER 6EP PARTITION IS MISSING THE LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA20170228014Lens · detachedEMERGENCY EXIT SIGN OVER THE L4 DOOR HAS A DETACHED LENS. SECURED THE LENS IAW AMM 33-50-00. OPERATIONAL CHECKED GOOD.SDR AALA20170228012Lens · missingEMERGENCY EXIT LIGHT ON BULLNOSE BY SEAT 1B HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-05. OPERATIONAL CHECKED GOOD.SDR AALA20170228009Pin · brokenEMERGENCY EXIT SIGN ABOVE SEAT 24J HAS BROKEN PINS. REPAIRED IAW DWG 33-51-01-1. OPERATIONAL CHECKED GOOD.SDR AALA20170226001Light · brokenEMERGENCY EXIT LIGHT AFT GALLEY LEFT SIDE IS BROKEN. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170225005Lens · missingFLOOR PROXIMITY EMERGENCY EXIT LIGHT RIGHT BEHIND MID GALLEY HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-05. OPERATIONAL CHECKED GOOD.SDR AALA20170225004Lens · missingAFT GALLEY FLOOR PROXIMITY EMERGENCY EXIT LIGHT HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-05. OPERATIONAL CHECKED GOOD.SDR AALA20170225003Lens · missingAFT GALLEY FLOOR PROXIMITY EMERGENCY EXIT LIGHT HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-05. OPERATIONAL CHECKED GOOD.SDR DALA2017022701633Sign · detachedEXIT SIGN AT THE L2 DOOR, FELL OFF BULKHEAD, ATTACHED THE EXIT SIGN. OK FOR SERVICE.SDR SWAA2017022812204Battery Pack · inoperativeRIGHT AFT WING EMERGENCY SLIDE LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017022812191Lamp · inoperativeLEFT AFT EMERGENCY EXTERIOR LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017022812190Lamp · inoperativeRIGHT AFT EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS LIGHT IAW AMM.SDR SWAA2017022812169Bulb · inoperativeL2 DOOR SLIDE LIGHT INOPERATIVE. REPLACED THE BULB IAW AMM.SDR SWAA2017022812168Battery Pack · inoperativeLEFT AFT WING EMERGENCY SLIDE LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR AALA201702279011Lens · detachedEXIT SIGN LENS IS MISSING AT THE L2 DOOR. FOUND AND SECURED THE LENS.SDR AALA201702279002Battery Pack · no testWHILE ACCOMPLISHING AN OPERATIONAL CHECK FOR EMERGENCY LIGHTS, FOUND THE BATTERIY AT 17WL FAULTING. REPLACED THE BATTERY PACK AT 17WL IAW AMM 33-51-38.SDR AALA201702279001Battery Pack · no testWHILE ACCOMPLISHING AN OPERATIONAL CHECK FOR EMERGENCY LIGHTS, FOUND BATTERIY AT 14WL FAULTING. REPLACED BATTERY PACK AT 14WL IAW AMM 33-51-38.SDR YENA201702250122Battery Pack · inoperativeDURING ROUTINE MAINTENNACE, DICOVERED THAT AN EPSU BATTERY REQUIRES REPLACEMENT. R & R THE BATTERY 13WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201702250121Power Supply · no testDURING ROUTINE MAINTENNACE, DISCOVERED THAT VARIOUS EMERGENCY LIGHTS WERE NOT WORKING. THE EPSU POSITION 12WL WAS R & R IAW AMM 33-51-38.SDR YENA201702250120Power Supply · failedDURING ROUTINE MAINTENNACE, DICOVERED THAT VARIOUS EMERGENCY LIGHTS WERE NOT WORKING; EPSU POSITION 10WL WAS R & R IAW AMM 33-51-38.SDR SWAA2017022712146Lens · looseRIGHT BULLNOSE EMERGENCY LIGHT LENS IS LOOSE AT ROW 7. SECURED THE LENS IAW MM.SDR SWAA2017022712145Lens · missingRIGHT BULLNOSE EMERGENCY LIGHT LENS MISSING AT ROW 10. INSTALLED THE LENS IAW SIP.SDR DALA2017022701606Lens · damagedEMERGENCY LIGHT LENS DAMAGED. REPLACED THE LENS.SDR DALA2017022701605Lens · damagedEMERGENCY LIGHT LENS DAMAGED. REPLACED THE LENS.SDR DALA2017022701604Lens · damagedEMERGENCY LIGHT DIFFUSER LENS DAMAGED. R & R LIGHT ASSY IAW MM 33-51.SDR DALA2017022701603Lens · damagedEMERGENCY LIGHT DIFFUSER LENS DAMAGED. R & R LIGHT ASSY IAW MM 33-51.
Back to JASC 3350