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 CALA2017060901764Fuse · faultyBUSINESS CLASS EMERGENCY LIGHTS ON SEATS AND DOOR EXIT EMERGENCY LIGHTS INOP. REPLACED POWER SUPPLY FUSE. OPS CHECK PASSED. REF FIM 33-51-00-8 10-805, WDM 33-51-58 AND SSM 33-51-13.SDR CALA2017060901763Light · unsecureEMERG EXIT LT NEXT TO LAV 101 LOOSE AND DANGLING. REINSTALLED AND FUNCTIONAL CHECK OK.SDR CALA2017060901762Light · inoperativeEMERGENCY LIGHTS, UPPER DECK, BETWEEN UPPER DECK DOORS, TWO EACH CEILING LIGHTS INOP. RELAMPED LIGHTS. OPS CK GOOD REF AMM 33-51-00.SDR CALA2017060901761Fuse · faultyOVERWING EMERGENCY LIGHTS, RT, TWO UPPER LIGHT ASSY, TWO BULBS PER ASSY INOP. REPLACED FUSE ON POWER SUPPLY M7920 FOR OUTPUT PIN 15. REF WDM 3 3-51-41. REF AMM 33-51-04. OPS CK GOOD REF AMM 33-51-00.SDR CALA2017060901760Light · missingAISLE EMERGENCY LIGHT AT SEAT 23 LT MISSING. REPLACED EEL STRIP ON AISLE SEAT 23 LT. OPS CHECK GOOD REF AMM 3 3-51-00.SDR CALA2017060901759Light · damagedCORNER OF LAV 101 EMERGENCY LIGHT STRIP DAMAGED. SECURED FILLER STRIP ON CORNER OF LAV.SDR CALA2017060901736Cover · brokenFOUND OVERHEAD EMERGENCY EXIT LIGHT COVER ON THE FLOOR LOCATED BETWEEN COACH AND FIRST CLASS FOUND EMERGENCY EXIT ASSY TABS BROKEN. REPLACE ASSY REF 33-51-00.SDR QXEA2017060900407Lamp · inoperativeFORWARD FA EMERGENCY LIGHT SWITCH INOPERATIVE. REPLACED THE LAMPS. CHECKED GOOD.SDR DALA2017061304729Light · looseIAW SAFA INSPECTION EMERGENCY LIGHTS LOOSE AT SEAT 25FG. REPLACED SHROUD AND MOUNT BOX. SYSTEM OPERATION IS NORMAL.SDR AALA201706099027Control Unit · faultedAIRPLANE HEALTH MONITORING ALERT MESSAGES FOR AN INTERNAL FAULT ON THE L3 DOOR AFT SEAT REMOTE WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT. FAULT CODES 33-12125 AND 33-12127. ACCOMPLISHED SYSTEM CONFIGURATION IAW AMM DMC-B787-A-33-51-00-03A-300D-A AND ESDR SWAA2017061414354Fuse · blownRT EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 8. R&R FUSE PER AMM.SDR DALA2017060904646Battery Pack · inoperativeTAIL EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY AND BATTERY PACK IAW MM. OPERATION CHECKED GOOD.SDR SWAA2017061214286Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2017061214281Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR AALA201706129034Light · brokenR4 DOOR EMERGENCY LIGHT LOWER COVER BROKEN. REPLACED EMERGENCY LIGHT.SDR SWAA2017061214234Sign · looseCENTER OVERWING EMERGENCY EXIT SIGN LOOSE. R&R SIGN PER AMM.SDR AALA201706099042Cover · detachedTHE AIRCRAFT WAS NOT GROUNDED. COVER FOR EXIT SIGN OVER AFT LEFT ENTRY DOOR FELL OFF. R&R AFT LEFT EMER EXIT LIGHT ASSEMBLY IAW AMM 33-51-01. OK FOR SVC.SDR AALA201706099040Light · brokenTHE AIRCRAFT WAS NOT GROUNDED. EXIT LIGHT COVER AT AFT LEFT EXIT WILL NOT STAY IN PLACE. FOUND LIGHT ASSY BROKEN. REMOVED AND REPLACED AFT LT EXIT LIGHT ASSY REF MM 33-51-01. OPS CHECK NORMAL. OK FOR SERVICE.SDR AALA201706099041Sign · detachedTHE AIRCRAFT WAS NOT GROUNDED. THE EXIT SIGN ABOVE THE RIGHT AFT GALLEY DOOR FELL OFF. R&R LIGHT ASSY IAW AMM 33-51-01.SDR CALA2017060901746Lens · brokenEMERGENCY AISLE LIGHT BROKEN AT SEAT 8-C. PUSHED INTO HOUSING. REPLACED LENS AT SEAT 8C, OPS CHECKS GOOD REF AMM33-51-14.SDR DALA2017060904612Light · faultedRIGHT EMERGENCY LIGHT EXTERNAL FAULT, REPLACED 1 OVERWING LAMP.SDR AALA201706099016Light · brokenAFT EMERGENCY EXIT LIGHT AT THE L4 DOOR IS BROKEN. REMOVED AND REPLACED EXIT LIGHT IAW AMM 33-51-11. OPERATIONAL CHECK GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201706099010Lens · missingR4 DOOR EXIT LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201706099008Battery · inoperativeAFT FLASHLIGHT INOPERATIVE. REPLACED THE BATTERY.SDR AALA201706099007Lens · unsecureAISLE EMERGENCY LIGHT LENS UNDER SEAT 26C IS BROKEN. SECURED THE LENS. OK FOR SERVICE.SDR AALA201706099005Battery · no testLEFT OVERWING EMERGENCY POWER SUPPLY UNIT FAILED EMERGENCY LIGHT TEST. REPLACED EMERGENCY POWER SUPPLY BATTERY.SDR N6WA2017060801Light · detachedEMERGENCY LIGHT STRIP AT 18AB DETACHED. SECURED THE EMERGENCY LIGHT STRIP IAW AMM 33-51-01.SDR DALA2017060904591Power Supply · inoperativeTHE L3 DOOR EMERGENCY LIGHTS ARE INOPERATIVE. R & R THE POWER SUPPLY.SDR DALA2017060904590Charger · inoperative2R AND 3R EXTERIOR EMERGENCY LIGHTS INOPERATIVE. R & R THE CHARGER AND BATTERY.SDR SIMA20170608004Light · inoperativeROW 12 BC OVERHEAD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-08-000-801-A, AND 33-50-08-400-801-A. OPS CHECKED GOOD.SDR SIMA20170608003Light · inoperativeCABIN CEILING AISLE EMERGENCY EXIT LIGHT AT ROW 12 INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY EXIT LIGHT IAW AMM 33-50-08, OPS CHECKED GOOD.SDR SIMA20170608002Lamp · inoperativeRIGHT EXTERIOR AFT EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM 33-50-10. OPS TESTED GOOD IAW AMM 33-50-00.SDR MASA2017060812362Light · looseEMER LIGHT AT ROW 18 INOP. SECURED BULB.SDR MASA2017060812361Light · inoperativeROW 6 CEILING EMER FLOODLIGHT INOP. REPLACED BULBS.SDR DALA2017060804555Power Supply · inoperativeAFT EMERGENCY EXIT DOOR OVERWING LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY. OPS OK IAW AMM 33-51.SDR MASA2017060812360Battery Pack · dischargedALL EMERGENCY LIGHTS INOPERATIVE. CHARGED THE BATTERIESSDR FDEA201706071588Battery Pack · failedDURING A DAILY CHECK, FOUND THE R1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW MM 33-51-07-2, ALL TESTED GOOD.SDR SWAA2017061214284Battery Pack · failedBATTERY PACKS FAILED CAPACITY TEST AT POSITION M01669. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2017061214283Battery Pack · failedBATTERY PACKS FAILED CAPACITY TEST AT POSITION M01674. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2017061214253Lens · discoloredRT EMERGENCY DOOR LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR SWAA2017061214248Battery Pack · failedBATTERY PACKS FAILED CAPACITY TEST AT POSITION M01668. R&R BATTERY PACK PER AMM AND DWG.SDR AALA20170608009Light · inoperativeEMERGENCY LIGHT AT SEAT 4H IS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-1-05. OPERATIONAL CHECKED GOOD.SDR ASOA201706075084Ballast · inoperativePILOT REPORTED EMERGENCY EXIT LIGHTS AT THE GALLEY DOOR FOUND INOPERATIVE. MX RESET BALLAST AND OPS CHECKED GOOD.SDR AALA201706099039Light · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT OVERHEAD AISLE LIGHT ROW 14 WILL NOT ILLUMINATE. T/S REPLACED LIGHT ASSY AT ROW 10 PER MM 33-51-03 ACCOMPLISHED TEST ROW 14 LIGHT CHKS NORMAL. (SEE ALSO SDR AALA201706099038)SDR AALA201706099038Light · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT OVERHEAD AISLE LIGHT ROW 10 WILL NOT ILLUMINATE. T/S REPLACED LIGHT ASSY AT ROW 10 PER MM 33-51-03. ACCOMPLISHED TEST ROW 101 LIGHT CHKS NORMAL. (SEE ALSO SDR AALA201706099039)SDR AALA201706089013Lens · missingAFT GALLEY RIGHT EMERGENCY EXIT LENS MISSING. REPLACED THE LENS. AIRCRAFT NOT GROUNDED.SDR R61A201706070400Light · fadedEMERGENCY LIGHT AT THE FWD AT WARDROBE IS FADED. R & R IAW AMM 33-50-21. OPS CHECKED GOOD.SDR AALA201706089035Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L4 DOOR HAS A DETACHED LENS COVER. RESECURED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201706089007Power Supply · failedAIRCRAFT WAS NOT GROUNDED. EXTERIOR EMERGENCY EXIT LIGHT AT L1 DOOR IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M371 IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR ASAA2017060720978Sign · damagedRT FWD OVERWING EMERGENCY EXIT SIGN INOP. GROUNDED - YES. FOUND RT FWD OVERWING EMERGENCY EXIT SIGN DAMAGED. REMOVED AND REPLACED RT FWD OVERWING EMERGENCY EXIT SIGN, REF AMM 33-51-01. OPS CHECK GOOD.
Back to JASC 3350