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 AALA2018051749032Power Supply · no testLEFT EMERGENCY POWER SUPPLY UNIT INOPERATIVE. MAINTENANCE REPLACED THE LEFT AFT EMERGENCY POWER SUPPLY UNIT IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPS CHECK.SDR SWAA2018051521909Lens · detachedOVERWING EXIT SIGN LENS DETACHED. INSTALLED THE LENS IAW AMM.SDR DALA201805153334Battery Pack · no testDURING A SERVICE CHECK, FOUND THE VENTRAL DOOR EXIT SIGN AND SOME CEILING LIGHTS INOPERATIVE, DURING AN EMERGENCY LIGHT TEST. TROUBLESHOT AND FOUND THE BATTERY PACK B5-237 TO BE FAILED. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-03 AND WDM 33-51-1SDR ASAA201805144591Sign · unsecureEXIT SIGN ON CEILING AT ROW 16, & 17 HAS PARTIALLY FALLEN DOWN. ACFT GROUNDED. FOUND ROW 16 EMERGENCY EXIT SIGN ON CEILING HAS LOOSE FASTENERS. ADJUSTED THE SIGN AND TIGHTENED ALL LOOSE FASTENERS. OK FOR SERVICE IAW AMM 33-51-01.SDR DALA2018051403307Lens · damagedFLOOR EMERGENCY LIGHT LENS AT SEAT 27B WAS FOUND DAMAGED. REPLACED THE LENS.SDR DALA2018051403306Light · out of positionFLOOR EMERGENCY LIGHT AT SEAT 27B WAS FOUND OUT OF POSITION. REPOSITIONED THE LIGHT.SDR DALA2018051403304Lamp · inoperativeLEFT OVERWING SLIDE LIGHT WAS FOUND INOPERATIVE. REPLACED THE LAMPS.SDR DALA2018051403301Lamp · inoperativeCREW REST EMERGENCY EXIT SIGN INOPERATIVE. REPLACED THE LAMPS.SDR DALA201805143300Battery Pack · inoperativeEMERGENCY LIGHTS AT ROWS 32 - 39 WILL NOT ILLUMINATED. REPLACED THE BATTERY PACK AT SEAT 39R.SDR SWAA2018061122690Sign · damagedG1 GALLEY LOWER EMERGENCY EXIT SIGN DAMAGED. R&R SIGN PER AMM.SDR HNAA2018052500110Switch · stickingEMERGENCY LIGHT PUSH BUTTON IN THE CABIN WAS STICKING IN THE ON POSITION. R & R THE LIGHT SWITCH ASSEMBLY,SDR AALA201805119011Lens · damagedTHE AIRCRAFT WAS NOT GROUNDED. LIGHT LENS/COVER/BEZEL IS DAMAGED. SIGN DANGLING ON DOOR NEAR FLOOR. REMOVED AND REPLACED EMERGENCY EXIT LIGHT AT 4R DOOR PER AMM 25-23-45.SDR DALA2018051003237Cover · missing15 C/D EMERGENCY LIGHT COVER MISSING. REPLACED COVER PER AMM 33-51.SDR MASA2018051603208Bulb · inoperativeROW 11 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE BULB.SDR MASA2018051603207Bulb · inoperativeROW 18 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE BULB.SDR SWAA2018051421897Guard · brokenP5 OVERHEAD PANEL EMERGENCY EXIT LIGHT ARMING SWITCH GUARD ON BROKEN. R&R SWITCH GUARD IAW SOPM.SDR SWAA2018051421859Light · inoperativeR1 DOOR OVERHEAD EMERGENCY EXIT SIGN BULB INOP. R&R BULB IAW AMM.SDR SWAA2018051521934Sign · looseMID CABIN OVERHEAD EMERGENCY EXIT SIGN LOOSE. SECURED THE SIGN IAW AMM.SDR SWAA2018051521905Lens · missingLEFT AFT EMERGENCY EXIT LIGHT LENS WAS MISSING. INSTALLED THE LENS IAW SIP & AMM.SDR DALA2018051003236Sign · inoperativeEMERGENCY EXIT SIGNS INOPERATIVE, LOCATIONS:37C INTERIOR. REINSTALLED EXIT SIGN COVER UP RIGHT.SDR MASA2018051603204Bulb · inoperativeROW 8 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE BULB.SDR MASA2018051603203Light · unknownROW 13 EMERGENCY LIGHTS INOPERATIVE. OPS CHECKED GOODSDR AALA2018051649005Fuse · failedG2 GALLEY AREA EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE M33093 POWER SUPPLY FUSE. OPS CHECKED OK IAW AMM 33-51-06-960-801.SDR SWAA2018051521942Light · inoperativeR2 DOOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018051521908Lens · missingLEFT OVERWING EXIT SIGN LENS MISSING. REPLACED THE LENS IAW AMM.SDR DALA201805153327Lens · missingR1 DOOR EMERGENCY LIGHT LENS FOUND MISSING. MAINTENANCE INSTALLED A NEW LENS, RETURNED TO NORMAL.SDR SIMA2018051409004Battery Pack · failedFLOOR EMERGENCY LIGHT, WAS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT BATTERY IAW AMM 33-50-04. OPS CHECKED GOOD.SDR DALA2018050903220Light · inoperativeCREW REST EMERGENCY LIGHT STRIP ON LADDER IS INOPERATIVE. REPLACED STRIP. MCO/PLAC REMOVED.SDR DALA2018050803216Battery Pack · dischargedEMER EXIT INOP AT ROW 19,21 & 27-32. R&R EMER. BATTERY PACK AT M11486 & M11488 IAW AMM 33-51.SDR DALA2018051403299Lens · damagedEMERGENCY LIGHT LENS DAMAGED. MAINTENANCE REPLACED THE LENS. OK FOR SERVICE.SDR SWAA2018051421944Charger · failedLT EMERGENCY LIGHTING BATTERY PACK FAILED OPS CHECK AT ROW 17. R&R CHARGER IAW AMM.SDR SWAA2018051421880Battery Pack · failedLT EMERGENCY LIGHTING BATTERY PACK FAILED OPS CHECK AT ROW 17. R&R BATTERY PACK IAW AMM.SDR SWAA2018051421867Lens · out of positionL2 DOOR EXTERIOR EMERGENCY LIGHT LENS OUT OF POSITION. R&R LENS ASSEMBLY IAW MM.SDR SWAA2018051021829Light · inoperativeLT AFT EXTERNAL EMERGENCY DOOR LIGHT INOP. R&R LIGHT PER AMM.SDR YENA201805080200Lens · unsecureFLT 566, FLL-ORD. FLOOR PATH LIGHTING ON SEAT 1 C IS HANGING DOWN. REPLACED ISLE EMERGENCY LIGHTING LENS AT 1C AS REQUIRED. PERFORMED OPS CHECK OF EMERG LIGHTING SYS REF AMM 33-51-00. OK FOR SERVICE. (FILED BY EMAIL ON 5/14/2018).SDR ASOA2018F00002Light · inoperativeRIC FLIGHT 5529 DURING SCHEDULED MAINTENANCE INSPECTION THE EMERGENCY EXIT SIGN AT ROW 15 WAS FOUND INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY EXIT SIGN BULB WITH OPERATIONAL CHECK GOOD. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR HNAA2018052500108Inverter · inoperativeEMREGENCY EXIT SIGN ABOVE THE SERVICE DOOR DID NOT ILLUMINATE. R & R THE INVERTER IAW AMM 33-50-11. OPS CHECKED GOODSDR E07A201805210002Battery Pack · failedEMERGENCY LIGHTS FLASHING ON AND OFF WITH SYSTEM IN THE ARM POSITION. REPLACED THE BATTERY PACK.SDR E07A201805210001Battery Pack · failedAIRCRAFT EMERGENCY LIGHTS FLASHES ON AND OFF WITH SYSTEM IN THE ARM POSITION. REPLACED THE BATTERY PACK.SDR DALA2018050803147Power Supply · faultyEMERGENCY LIGHT BULBS OUT 3C, ROW 10 THRU 12 EMERGENCY LIGHTS OUT. TROUBLESHOOTING PERFORMED IAW FIM 33-51-00-810-803, FOUND POWER SUPPLY M33098 FAULTY. R&R POWER SUPPLY IAW AMM 33-51-06-960-803, R&R BATTERY PACK IAW AMM 33-51-06-960-802. FOUND POWER SUPPLY FRSDR DALA2018051403298Lens · looseTHE EMERGENCY EXIT SIGN LENS IN THE CABIN WAS FOUND LOOSE. MAINTENANCE REPAIRED THE SIGN LENS AT THE L1 DOOR. OPS CHECKED OK IAW AMM 33-51. OK FOR SERVICE.SDR DALA201805143263Lens · missingTHE OVERHEAD EMERGENCY LIGHT LENS AT ROW 17ABC WAS MISSING. MAINTENANCE REPLACED THE LENS. OK FOR SERVICE.SDR SWAA2018051021854Charger · inoperativeFORWARD EMERGENCY CABIN LIGHTS INOP. R&R BATTERY CHARGER ASSEMBLY PER AMM.SDR SWAA2018051021852Battery · dischargedFORWARD EMERGENCY CABIN LIGHTS INOP. R&R BATTERY PER AMM.SDR SWAA2018051021850Battery · corrodedG1 GALLEY EMERGENCY EXIT SIGN INOP. R&R BATTERY PER MM.SDR SWAA2018051021848Battery Pack · dischargedLT FORWARD ENTRY DOOR EXIT SIGN INOP. R&R BATTERY PACK PER MM.SDR SWAA2018051021833Light · damagedLT AFT GALLEY AISLE FLUORESCENT EMERGENCY EXIT FLOOR LIGHTING DAMAGED. R&R STRIP PER DWG.SDR SWAA2018051521801Lens · looseLT OVERHEAD BIN EMERGENCY LIGHT LENS LOOSE AT ROW 12. SECURED LENS PER MM.SDR DALA2018051403199Light · inoperativeAFTER A POWER INTERRUPTION AT THE GATE, THE CABIN LIGHTS BETWEEN THE R1 AND R2 DOORS WERE NOT WORKING. THE EMERGENCY LIGHTS WILL GO ON WHEN THE SWITCHES ARE IN THE ARMED POSITION. REPLACED RCB 1024XP.SDR DALA201805173141Light · detachedSEAT 23C EMERGENCY LIGHT FELL OFF AND IS DANGLING FROM WIRES. REPLACED THE LIGHT ASSEMBLY.
Back to JASC 3350