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 SIMA20170510002Lamp · inoperativeMAIN DOOR OVERHEAD EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM 33-50-06-000-801-A, & 33-50-06-400-801-A. OPS CHECKED GOOD.SDR AALA201705119013Lens · brokenEMERGENCY LIGHT LENS 9D BROKEN. REPLACED THE LENS.SDR AALA201705119012Lamp · inoperativeRED EMERGENCY EXIT LIGHT ON F/C CLOSET, LAMP INOPERATIVE. REPLACED THE LAMP.SDR DALA2017051103764Lens · unsecureEMERGENCY EXIT DIFFUSER LENS FOUND UNSECURE. SECURED THE LENS.SDR DALA2017051103763Lens · missingAFT EMERGENCY LIGHT LENS MISSING ABOVE AFT LAVATORY DOOR. INSTALLED A NEW LENS.SDR SWAA2017051013665Light · inoperativeRT OVERWING EMERGENCY EXIT AFT LIGHT INOP. R&R BULB IAW AMM.SDR SWAA2017053114074Lens · brokenRIGHT AFT EXIT LIGHT LENS BROKEN. R & R THE LENS IAW MM.SDR DALA2017051203857Lens · missingDURING INSPECTION FOUND SEAT MOUNTED EMERGENCY PATH LIGHT AT 2CD MISSING WHITE LENS. MAINTENANCE RPLD LIGHT AT 2CD PER AMM 33-51. CKS GOOD.SDR AALA201705129014Sign · brokenEMERGENCY EXIT SIGN AT R3 DOOR FORWARD IS BROKEN. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201705129013Sign · brokenEMERGENCY EXIT SIGN AT L3 DOOR FORWARD IS BROKEN. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170511001Sign · brokenEMERGENCY EXIT SIGN AT R2 DOOR FORWARD IS BROKEN. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170509001Power Supply · no testDURING EMERGENCY LIGHT TEST, BATTERY AND EPSU AFT LEFT, DISPLAYED ON MCDU AFTER TEST. PERFORMED OPERATIONAL CHECK OF EMERGENCY POWER SUPPLY UNIT AT 13WL IAW AMM 33-51-38.SDR 2WAA2017051203Light · inoperativeDURING SERVICE CHECK FOUND OVERWING EMERGENCY LIGHTS INOPERATIVE. TROUBLESHOOT EMERGENCY LIGHTING SYSTEM PER AWDM 33-51-14. FOUND CONNECTORS AT OVERWING EXIT IDENTIFIERS DISCONNECTED. RECONNECTED CONNECTORS IAW SWPM 20-31-00. PERFORMED FUNCTIONAL TEST IAW AMM SDR AALA201705119002Battery · no testFOUND BATTERY ON EMERGENCY POWER SUPPLY UNIT AT 12WL FAULTING. REPLACED THE BATTERY IAW AMM 33-51-38.SDR SWAA2017051113685Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE BETWEEN ROWS 20 TO 29. REPLACED THE LAMPS IAW AMM.SDR SWAA2017051113684Bulb · inoperativeLEFT FORWARD OVERWING EMERGENCY EXIT LIGHT BULB INOPERATIVE. REPLACED THE BULBS IAW AMM.SDR SWAA2017051113683Bulb · inoperativeAFT GALLEY EMERGENCY EXIT LIGHT BULBS ARE INOPERATIVE. REPLACED THE BULBS IAW AMM.SDR YENA201705090361Switch · failedALL EMERGENCY LIGHT SYSTEMS ARE ON WITH EMERGENCY EXIT LIGHT SWITCH IN ARM. ATTEMPTED RESET IN ALL POSITIONS BUT STILL INOPERATIVE. R & R EMERGENCY LIGHT SWITCH IAW ESPM 20-48-00, OP CHECKED GOOD, & TSM 33-51-00.SDR AALA201705109003Lens · missingFLIGHT ATTENDANT REPORTED EMERGENCY LIGHT LENS MISSING AT ROW 9.SDR AALA201705109017Lens · damagedAIRCRAFT IN BASE MAINTENANCE. MAIN CABIN LOWER CEILING PANEL EXIT SIGN COVER DAMAGED. REPLACED MAIN CABIN LOWER CEILING PANEL 253CLG EXIT SIGN LENS.SDR ASAA2017050920693Light · brokenR1 DOOR EMERGENCY EXIT IDENTIFIER DAMAGED, LAMPS INOP. GROUNDED - YES. REPLACED LIGHT ASSEMBLY. OPS CHECK NORMAL, REF AMM 33-51-01-960-802.SDR ASAA2017050920692Battery Pack · failedWHILE PERFORMING T/C 78233001 ALL MID-CABIN AND FWD GALLEY EMERGENCY LIGHT BATTERY PACKS FAILED THE DEEP CYCLE TEST. TOTAL OF 6 BATTERY PACKS. GROUNDED - YES. REMOVED AND REPLACED FWD GALLEY AND ALL MID-CABIN BATTERY PACKS, REF WDM 33-51-12 THRU 33-51-21 AND ASDR AALA20170509003Power Supply · no testL1 DOOR EMERGENCY POWER SUPPLY M33424 FAILED CAPACITY TEST. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20170509002Power Supply · no testL3 DOOR FORWARD EMERGENCY POWER SUPPLY M33400 FAILED CAPACITY TEST. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR HNAA2017051000157Lamp · inoperativeEMERGENCY LIGHTS ON CENTER FLOOR AT ROW 4 DO NOT ILLUMINATE. REPLACED THE BULBS.SDR HNAA2017051000156Lamp · inoperativeAFT EGRESS LIGHT ON RIGHT SIDE OF AIRCRAFT WILL NOT ILLUMINATE. R & R THE LAMP.SDR AALA201705109005Lens · missingR4 EMERGENCY. LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201705109002Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT HAS A BROKEN LENS. REPLACED THE LIGHT.SDR MASA2017050912282Battery Pack · dischargedEMER EXIT SIGN ROW 13 INOP. CHARGED BATTERY PACK.SDR MASA2017050912280Light · inoperativeROW 6 CEILING EMER FLOODLIGHT INOP. RELAMPED.SDR SIMA20170508007Light · damagedNR 6 EMERGENCY LIGHT STRIP DAMAGED ON THE END. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12.SDR SIMA20170508003Light · damagedNR 5 LT EMERGENCY LIGHT STRIP DAMAGED AT THE WIRE HOLE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12.SDR SIMA20170508004Light · damagedNR 2 LT EMERGENCY LIGHT STRIP DAMAGED AT THE WIRE HOLE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12.SDR SWAA2017052213908Lens · delaminatedRIGHT OVERHEAD STOWAGE BIN EMERGENCY LIGHT LENS DELAMINATED AT ROW 5. R & R THE LENS IAW AMM.SDR DALA2017051203858Lens · missingDURING INSPECTION FOUND ROWS 1 AND 5 CEILING MOUNTED AISLE EMERGENCY LIGHTS MISSING LENSES, MAINTENANCE INSTALLED 2 EACH LENS PER AMM 33-51. OP CHECKS GOOD.SDR AALA201705119027Power Supply · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS IN FORWARD GALLEY FAILED TEST. REMOVED AND REPLACED POWER SUPPLY M33093 IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR R61A201705080345Cover · detachedLIGHT COVER IN EXIT SIGN ON AIRCRAFT RIGHT FELL OFF. SECURED THE COVER IAW AMM 33-50-10. OPS CHECK GOOD.SDR AALA201705119025Sign · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R2 DOOR IS DAMAGED. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201705119024Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R2 DOOR IS DETACHED. REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017051113681Bulb · inoperativeEMERGENCY EXIT SIGN LIGHT BULBS INOPERATIVE IN CABIN. REPLACED THE BULBS IAW AMM.SDR AALA20170508005Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT CEILING LIGHTS FROM ROWS 28 TO 30 FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY B5-107 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170508004Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT CEILING LIGHTS FROM ROWS 7 TO 11 FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY B5-100 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170509004Battery · dischargedAIRCRAFT WAS NOT GROUNDED. CIDS1 EMERGENCY POWER SUPPLY UNIT SYSTEM (12WL) TEST FAULT, EXIT RIGHT. REPLACED POWER SUPPLY BATTERY PER AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017051013671Lens · brokenFORWARD ENTRY INSIDE EMERGENCY LIGHT LENS BROKEN. R&R LIGHT ASSEMBLY IAW MM.SDR AALA201705099007Lens · missingR1 DOOR EXIT LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201705099006Lens · missingEMERGENCY EXIT LIGHT PLATE LENS AT SEAT 3C MISSING . REPLACED LIGHT LENS.SDR A6WA2017051044994Battery Pack · inoperativeEMERGENCY FLOOR TRACK LIGHTNING DIM OUT OF ROW 9-12 AFTER SWITCH FLIPPED ON. R & R THE NR 4 EMERGENCY LIGHT BATTERY PACK IAW MM 33-51-04. OPS CHECKED GOOD.SDR RAIA201705080001Lens · crackedPAX DOOR SWING ARM EMERGENCY LIGHT (1)LENS CRACKED. R & R PAX DOOR SWING ARM EMERGENCY LIGHT (1)ASSEMBLY, OPS CHECK GOOD.SDR AALA201705099026Lens · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY FLOOR NEAR R4 DOOR HAS A LOOSE LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201705099025Power Supply · failedAIRCRAFT WAS IN BASE MAINTENANCE. L4 DOOR EMERGENCY ESCAPE SLIDE LIGHT AND EMERGENCY EXIT SIGN FAILED CHECK. REMOVED AND REPLACED POWER SUPPLY M737 IAW AMM 33-51-07-902-001. OPERATIONAL CHECK GOOD..
Back to JASC 3350