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 AALA201702159007Lens · missingAISLE SEAT 3C EMERGENCY LIGHT LENS IS MISSING. INSTALLED THE LENS.SDR AALA201702159005Lens · brokenR2 DOOR EMERGENCY LIGHT LENS BROKEN. REPLACED EMERGENCY LIGHT LENS.SDR AALA201702159004Lens · missingEMERENGENCY EXIT FLOOR LIGHT AT THE L1 DOOR MISSING THE LENS. REPLACED THE LENS COVER.SDR AALA201702159003Lens · looseEMERGENCY LIGHT LENS AT L2 DOOR LOOSE. REPLACED THE LENS.SDR AALA201702159002Sign · detachedEXIT SIGN FELL OFF R4 DOOR PANEL. REINSTALLED THE EXIT SIGN.SDR AALA201702159001Power Supply · failedDURING PERIODIC SERVICE CHECK, FOUND RIGHT EMERGENCY LIGHT POWER SUPPLY INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY.SDR DALA2017021501232Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE CABIN DOOR OVERHEAD EMERGENCY EXIT LIGHTS AT BOTH L1 AND R1 WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK FOR THE NOTED LIGHTED AREAS AND THE OPERATIONAL CHECK WAS GOOD.SDR SWAA2017021411845Lens · missingRT EMERGENCY EXIT BULLNOSE LIGHT LENS COVER MISSING AT ROW 14. INSTALLED COVER PER MM.SDR MASA2017021412606Bulb · inoperativeSERVICE DOOR EXIT SIGN HAD ONE BULB INOPERATIVE.SDR MASA2017021412604Light · inoperativeAFT TWO EMERGENCY CEILING LIGHTS INOPERATIVE.SDR SWAA2017022211992Battery Pack · dischargedLEFT SIDEWALL PANEL EMERGENCY EXIT LIGHTS INOPERATIVE. CHARGED THE BATTERY PACK IAW AMM.SDR SWAA2017022211991Battery Pack · dischargedLEFT SIDEWALL PANEL EMERGENCY EXIT LIGHTS INOPERATIVE. CHARGED THE BATTERY PACK IAW AMM.SDR SWAA2017022211990Battery Pack · inoperativeRIGHT OVERWING EXTERIOR FUSELAGE EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017022211989Battery Pack · inoperativeLEFT OVERWING EXTERIOR FUSELAGE EMERGENCY EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2017022211988Battery Pack · dischargedLEFT LOWER SIDEWALL EMERGENCY EXIT SIGN INOPERATIVE. CHARGED THE BATTERY PACK IAW AMM.SDR SWAA2017022211987Battery Pack · dischargedRIGHT LOWER SIDEWALL EMERGENCY EXIT SIGN INOPERATIVE. CHARGED THE BATTERY PACK IAW AMM.SDR SWAA2017022211986Lamp · inoperativeLEFT EMERGENCY STOWAGE BIN BULLNOSE LIGHT INOPERATIVE AT ROW 14. REPLACED THE LAMPS IAW AMM.SDR SWAA2017022211985Battery Pack · dischargedRIGHT EMERGENCY STOWAGE BIN BULLNOSE LIGHT INOPERATIVE AT ROW 13. CHARGED THE BATTERY PACK IAW AMM.SDR SWAA2017022211984Battery Pack · dischargedRIGHT EMERGENCY STOWAGE BIN BULLNOSE LIGHT INOPERATIVE AT ROW 11. CHARGED THE BATTERY PACK IAW AMM.SDR SWAA2017022211983Battery Pack · dischargedRIGHT SIDE STOWAGE BIN EMERGENCY BULLNOSE LIGHT INOPERATIVE AT ROW 8. CHARGED THE BATTERY PACK IAW AMM.SDR AALA20170215016Light · brokenFIRST CLASS GALLEY EMERGENCY EXIT LIGHT LEFT OF BI-FOLD DOOR CLOSET IS BROKEN. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-00. OPS CHECKED GOOD.SDR RAIA201702130001Light · inoperativeLEFT FWD WING TO FUSELAGE FAIRING EXTERIOR FLOOD LIGHT INOPERATIVE. R & R THE LIGHT, OPS CHECKED GOOD.SDR SWAA2017021611910Lens · brokenFORWARD ENTRY DOOR EMERGENCY EXIT LIGHT LENS COVER BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2017021611907Sign · missingMID CABIN EMERGENCY CEILING EXIT SIGN MISSING. INSTALLED SIGN PER SIP.SDR AALA20170215025Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN ON UPPER FUSELAGE HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 25-63-00. OPERATIONAL CHECK GOOD.SDR AALA20170215019Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY L4 DOOR HAS A DETACHED LENS COVER. SECURED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20170215017Pin · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN RIGHT SIDE OF ROW 24 IS DETACHED. REPLACED DAMAGED ROLL PINS IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170215009Lens · damagedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHT AT SEAT 28D HAS A DAMAGED LENS COVER. REMOVED AND REPLACED LENS COVER IAW 33-60-98. OPERATIONAL CHECK GOOD.SDR AALA20170214001Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 10WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20170213003Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. LEFT AND RIGHT OVERWING EMERGENCY EXIT LIGHTS ABOVE DOORS FAILED TEST. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECK GOOD.SDR DALA2017021501258Lens · missingDURING INSPECTION, FOUND R2 DOOR EXIT SIGN IS MISSING. MAINTENANCE INSTALLED NEW EXIT LENS. ACFT OK FOR SERVICE.SDR ASAA2017021319805Light · inoperativeEMERGENCY LIGHT EXIT LOCATOR SIGN AT LEFT AFT OVERWING EXIT HAS MULTIPLE LAMPS INOP AND LENS IS BROKEN. GROUNDED - YES. RELAMPED, REPLACED LENS, AND TESTED PER MM 33-51-01-960-801 - OPS NORMAL.SDR SWAA2017021511894Lamp · inoperativeLEFT EMERGENCY LIGHT INOPERATIVE AT ROW 24. / REPLACED THE LAMP IAW SIP.SDR SWAA2017021511891Sign · detachedL1 DOOR EXIT SIGN BY FELL OFF. INSTALLED THE SIGN IAW MM.SDR QXEA2017021500063Light · detachedEMERGENCY LIGHT STRIP IN FRONT OF SEATS 2D & 2E IS LIFTING OFF THE CARPET. REMOVED & REPLACED THE EMERGENCY LIGHT ASSY IAW AMM TASK 33-51-16-000-801/400-801. RETURNED TO SERVICE.SDR AALA201702149013Power Supply · no testEMERGENCY POWER SUPPY DIDN'T PASS TEST AT FWD GALLEY AREA. REPLACED EMERGENCY POWER SUPPLY.SDR AALA201702149012Battery Pack · no testEMERGENCY POWER SUPPLY DIDN'T PASS TEST AT FWD GALLEY AREA. REPLACED BATTERY.SDR AALA201702149010Bracket · brokenEMERGENCY LIGHT BROKEN LOOSE. REPLACED EMERGENCY LIGHT BRACKET AT ROWS 9.SDR AALA201702149009Bracket · brokenEMERGENCY LIGHT BROKEN LOOSE. REPLACED EMERGENCY LIGHT BRACKET AT ROW 13.SDR AALA201702149008Bracket · brokenEMERGENCY LIGHT BROKEN LOOSE. REPLACED EMERGENCY LIGHT BRACKET AT ROW 22.SDR AALA201702149007Bracket · brokenEMERGENCY LIGHT BROKEN LOOSE. REPLACED EMERGENCY LIGHT BRACKET AT ROW 24.SDR AALA201702149006Bracket · brokenEMERGENCY LIGHT BROKEN LOOSE. REPLACED EMERGENCY LIGHT BRACKET AT ROW 25.SDR AALA201702149005Bracket · brokenEMERGENCY LIGHT BROKEN LOOSE. REPLACED THE LIGHT BRACKET AT ROW 26.SDR R61A201702130122Light · inoperativeMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT STRIP WAS DULL AND DID NOT LIGHT UP. REMOVED AND REPLACED THE LIGHT IAW AMM AND OPS CHECKED GOOD.SDR AALA201702149004Lens · missingAIRCRAFT IN BASE MAINTENANCE. MISSING EMERGENCY EXIT LENS ON AFT WALL OF L-61 LAVATORY. INSTALLED LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201702149002Lens · damagedAIRCRAFT IN BASE MAINTENANCE. DAMAGED EMERGENCY EXIT LIGHT LENS AT L3 DOOR. REPAIRED EXIT SIGN AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017021401225Cover · detachedDOOR 2R EMER EXIT LIGHT CAME OFF. REINSTALLED EXIT LIGHT COVER OK FOR SVC.SDR DALA2017021401223Fuse · blownR4 EXT SLIDE LIGHT INOP. REMOVED AND RELAMPED FUSE IN M736 POWER SUPPLY. OPS CHECK GOOD IN REF TO AMM 33-51-00.SDR SWAA2017021411842Lens · missingOVERHEAD BIN EMERGENCY EXIT LIGHT LENS MISSING BETWEEN ROW 19 TO ROW 20. INSTALLED LENS PER MM.SDR SWAA2017021411841Cover · missingAFT MID CABIN EMERGENCY EXIT SIGN COVER MISSING. INSTALLED SIGN PER SIP.
Back to JASC 3350