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 MASA2017051612307Light · inoperativeAFT EMER FLOOD LIGHT INOP. REPLACED BULBS.SDR MASA2017051612306Lamp · inoperativeROW 6 CEILING EMER FLOODLIGHT INOPERATIVE. REPLACED THE LAMP.SDR MASA2017051612305Light · inoperativeROW 21 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR SWAA2017052213882Charger · inoperativeRIGHT FORWARD STOW BIN EMERGENCY AISLE LIGHT INOPERATIVE AT LOCATION M1674. R & R THE BATTERY CHARGER ASSEMBLY IAW AMM.SDR SWAA2017052213862Battery Pack · inoperativeRIGHT FORWARD STOW BIN EMERGENCY AISLE LIGHT INOPERATIVE AT LOCATION M1674. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017052213860Light · looseLEFT EMERGENCY AISLE BULLNOSE PANEL LIGHT LOOSE AT ROW 4. SECURED THE LIGHT IAW DWG.SDR RAIA201705150002Bulb · inoperativePAX DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE BULB, OPS CHECKED GOOD.SDR RAIA201705150001Lens · crackedPAX DOOR EMERGENCY LIGHT LENS CRACKED. R & R THE LENS, OPS CHECKED GOOD.SDR AALA201705169062Lens · brokenEMERGENCY LIGHT BY THE G5 GALLEY LEFT SIDE HAS A BROKEN LENS.SDR AALA201705179005Power Supply · faultedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 10WL FAULTED. REPLACED POWER SUPPLY 10WL PER MM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201705189016Cover · damagedAIRCRAFT NOT GROUNDED. AFT GALLEY A/C RIGHT NEAR SLIDE PACK EXIT SIGNAGE DAMAGED. R&R EXIT SIGN LENS COVER AT AFT, RIGHT SERVICE DOOR IN AFT GALLEY.SDR AALA201705169050Sign · missingEMERGENCY EXIT SIGN AT THE R2 DOOR IS MISSING. REPLACED THE SIGN IAW AMM 33-51-09. OPERATIONAL CHECKED GOOD.SDR AALA201705169047Sign · unsecureEMERGENCY EXIT ARROW SIGN ON THE LOWER LAVATORY HAS PROTRUDING METAL. SECURED THE SIGN. OPERATIONAL CHECKED GOOD.SDR AALA201705169023Lens · damagedEMERGENCY EXIT LIGHT TO THE RIGHT OF THE RIGHT AFT LAVATORY DOOR HAS A DAMAGED LENS. REMOVED AND REPLACED THE LENS IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR AALA201705169017Sign · brokenEMERGENCY EXIT SIGN ON THE RIGHT LOWER SIDE OF THE GALLEY WALL IS BROKEN. REMOVED AND REPLACED LIGHT FIXTURE IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017051713823Sign · looseMID CABIN OVERHEAD EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER SIP.SDR AALA201705179027Light · defectiveEMERGENCY EXIT SIGN ON THE SIDE OF L2 DOOR LENS IS FALLING OFF. CHANGED EMERGENCY LIGHT ASSY PER MM 33-51-01. OPS CHECK OK. THE AIRCRAFT WAS NOT GROUNDED.SDR SWAA2017051613760Lens · missingLEFT EMERGENCY EXIT LIGHT LENS MISSING AT ROW 5. INSTALLED THE LENS IAW MM.SDR SWAA2017051613728Cover · missingFORWARD ENTRY DOOR EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED THE COVER IAW AMM.SDR ASAA2017051520793Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT 17A. ACFT GROUNDED. INSTALLED THE LENS. OPS GOOD.SDR REXA2017051500604Bulb · burned outFWD ENTRANCE EMERGENCY LIGHT BULBS BURNED OUT. REPLACED THE BULBS IAW AMM 33-51-05, OPS CHECKED GOOD.SDR YENA201705150372Battery Pack · failedDURING HEAVY MAINTENANCE, EPSU LT BATTERY FAULT WAS DISPLAYED ON THE PTP EMERGENCY LIGHT TEST. R & R THE BATTERY PACK IAW AMM 33-51-38-000-002-A, & 33-51-38-400-002-A. OPS CHECKED GOOD IAW AMM 33-51-38-710-052-B.SDR AALA201705169016Module · no testEMERGENCY LIGHTS AT SEATS 20D AND 26D THROUGH 36D ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AND CONTROL MODULE AT M10801 IAW AMM 33-51-11. OPS CHECKED GOOD.SDR DALA2017051603929Light · damagedEMERGENCY LIGHT DAMAGED. REPLACED L3 DOOR EMERGENCY LIGHT CAP ASSY IAW AMM 33-51-12.SDR MASA2017051512304Light · inoperativeEMERGENCY CEILING LIGHT ROW 6 INOPERATIVE.SDR AALA201705169012Lens · brokenMAIN CABIN L2 DOOR SURROUND PANEL EXIT LIGHT LENS IS BROKEN. REPLACED THE LENS. AIRCRAFT WAS GROUNDED.SDR AALA201705169011Lens · brokenMAIN CABIN R2 DOOR SURROUND PANEL EXIT LIGHT LENS IS BROKEN. REPLACED THE LENS. AIRCRAFT WAS GROUNDED.SDR JJBA20170515028Bulb · not seatedUPPER FWD EMERGENCY LIGHT INOPERATIVE. RESEATED THE BULB. OPS CHECKED SATISFACTORY.SDR DALA2017051603896Lens · looseEMERGENCY EXIT COVER DIFFUSER LENS LOOSE AT LOCATION 602. SECURED THE LOOSE LENS. CHECKED OK.SDR DALA2017051603895Battery Pack · inoperativeDURING A SERVICE CHECK, OVERWING EMERGENCY EXIT LIGHTS WOULD NOT STAY ILLUMINATED. R & R THE BATTERY PACK AT 22CDE IAW AMM 33-51. OPS CHECKED GOOD.SDR CALA2017051501455Sign · malfunctionedEMERGENCY EXIT SIGN DOES NOT TURN OFF. EXIT SIGN AT EXIT ROWS IS FLICKERING. IT HAS BEEN TURNED OFF. PERFORMED OPS CHECK EMERGENCY LIGHT.NO FAULT NOTED REF AMM 33-51 -00.SDR CALA2017051501453Light · inoperativeRIGHT GND ILLUM EMERGENCY LIGHT INOP. RELAMPED RIGHT GND ILLUMINATION EMERGENCY LIGHT REF AMM 33- 51-04-960-801. OPS CHECKED GOOD.SDR CALA2017051501451Light · inoperativeLEFT OVERWING EMERGENCY LIGHT INOP. RELAMPED LEFT WING OVERWING EMERGENCY LIGHT REF AMM 33-51-0 4-960-801. OPS CHECKED GOOD.SDR CALA2017051501448Light · inoperativeRT OVERWING EMERG EXIT LITE INOP. (ONE LAMP IN ONE LITE ASSY, LOCATED OUTSIDE, ON THE FUSELAGE, THIRD ONE BACK) RELAMPED PER AMM 33-50-96 PAGE BLOCK 401 AND TESTED GOOD.,SDR CALA2017051501447Light · inoperativeEMERG LITE INOP OUTSIDE LAV 100 RT DOOR FRAME. (UPPER OF THE TWO LIGHTS) REPLACED UPPER LED EEL LAMP ON LAV 100. OPS CK GOOD REF AMM 33-5 1-13.SDR CALA2017051501445Light · broken1R LAV 101, EMERGENCY LIGHTS LOWER EDGE BROKEN / HANGING. REPOSITIONED AND SECURED. OPN CHK'D - OK.SDR CALA2017051501444Battery · failedEMER EXIT LIGHT TEST FAILS AFT LEFT BATTERY. REPLACED BATTERY REF AMM 33-51-38, OPS CHECKED OK.SDR CALA2017051501441Power Supply · faultyDURING EMERGENCY LIGHTS TEST, BATTERY UNDER OVERWING EXIT FAILED. REPLACED EMERGENCY LT POWER SUPPLY UNIT BATTERY AS PER AMM 33- 51-38. OK FOR SERVICE.SDR CALA2017051501437Light · defectivePASSENGER COMPARTMENT ILLUMINATION REPORT EMERG WINDOW (SIDEWALL) LIGHTS SYMPTOMS OR PATTERNS ALONG WITH FAULT CODE SIDEWALL LIGHTS AT ROWS 20/21 ON BOTH SIDES FLICKER ON/OFF. REPLACED EMERGENCY EXIT DOOR LAMPS AT SEATS 20-21 CDE OPS CHECKED NORMAL.SDR CALA2017051501454Lens · missingCABIN AISLE OVERHEAD EMERGENCY EXIT SIGN MISSING AFT LENS. REPLACED LENS.SDR CALA2017051501452Light · inoperativeEMERGENCY LIGHTS AT OVERHEAD BIN ROW 11, RELAMPED AT ROW 11 ALL LIGHTS OPS CHECKED GOOD.SDR CALA2017051501450Lens · looseEMERG EXIT SIGN ROW 20/21 DOWN. SECURED LENS COVER.SDR CALA2017051501440Sign · inoperativeEMERGENCY EXIT SIGN INOP AT ROW 21D. REPLACED EXIT SIGN. OPS CHECK GOOD.SDR CALA2017051501439Light · inoperativeOVERHEAD BIN EMERGENCY LT AT ROW 3AB INOP. RELAMPED EMERGENCY LT. OPS CHECK GOOD.SDR SIMA20170514006Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE AT ROWS 1 - 7 ON FLOOR, 3AC BULKHEAD, SERVICE DOOR HINGE, AND RT FWD BELLY PANEL. REMOVED AND REPLACED ALL EMERGENCY LIGHT CHARGERS AND BATTERIES IAW 33-700-19. OPS CHECKED GOOD.SDR SIMA20170514005Strip · missingEMERGENCY LIGHT AT SEAT 3A MISSING FILLER STRIP. INSTALLED THE FILLER STRIP IAW AMM 33-50-12.SDR SIMA20170514004Light · debondedROW 12 CEILING PANEL EMERGENCY LIGHT DISBONDED ON FWD SIDE. BONDED THE EMERGENCY LIGHT CELING PANEL IAW ETN-GN-20-023, AND AMM 25-00-00SDR SIMA20170514003Bulb · not seatedLEFT FLOOR LEVEL EXIT SIGN CRACKED & BURNED OUT LIGHT BULB. RESEATED THE BULBS IAW STANDARD PRACTICES. OPS CHECKED GOOD.SDR AALA201705159028Lens · missingAIRCRAFT NOT GROUNDED. SEAT 3C EMERGENCY LIGHT LENS MISSING. REPLACED EMERGENCY LIGHT LENS SEAT 3C IAW AMM 33-50-00.SDR AALA201705169060Lens · missingEMERGENCY EXIT LIGHT AT SEAT 14D HAS A MISSING LENS. INSTALLED A NEW LENS IAW ESO 21376. OPERATIONAL CHECKED GOOD.
Back to JASC 3350