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 CALA2017102003723Battery · dischargedFOUND STOW BIN 8 CBA EMERGENCY LIGHT TO BE INOP DURING NO. 2 SERVICE CHECK. REPLACED BATTERY OP CKS OK REF AMM33-00-00.SDR CALA2017102003722Power Supply · inoperativeWHEN PERFORMING EMERGENCY LIGHT CK FOR 2 SERVICE GOT MESSAGE EPSU FWD L. REPLACED ESPU AND BATTERY IN FWD POSITION REF 33-51-38 AMM. OPS CK GOOD.SDR CALA2017102003721Battery Pack · faultedON 1SV,ON EMERGENCY LIGHT CHECK. FOUND MSG FWD EMERGENCY BATTERY FAULTED. REPLACED EMERGENCY BATTERY PACK AT DOOR 1L. OPS CHECKED NORMAL.SDR CALA2017102003718Light · inoperativeRIGHT BULB IN THE EMERGENCY LIGHT UNARMED CAUTION LIGHT IS INOP RELAMPED LIGHT, OPS NORM.SDR CALA2017102003717Light · loosePER 2SVC, FOUND EMERGENCY LITE AT 1EF STOW BIN NOT SECURED. EMERGENCY LIGHT AT 1EF IS SECURED.SDR CALA2017102003716Cover · out of positionEMERGENCY LIGHTS COVER SWITCH DOES NOT ARM EMERGENCY LIGHTS WHEN CLOSED REPOSITION EMERGENCY LIGHT SWITCH COVER. OPS CK GOOD.SDR CALA2017102003730Lens · missingEMERGENCY EXIT LIGHT LENS ROW 21F MISSING. REPLACED THE LIGHT LENS.SDR CALA2017102003727Sign · detachedEMERGENCY EXIT SIGN AT 21F DETACHED. INSTALLED THE SIGN.SDR CALA2017102003714Receptacle · dirtyEXTERIOR EMERGENCY LIGHT INOPERATIVE AT THE L2 DOOR. FOUND A DIRTY RECEPTICLE, CLEANED, AND OPS CHECKED GOOD.SDR CALA2017102003711Lamp · inoperativeRED EMERGENCY LIGHT AT SEAT 20D WAS INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED NORMALSDR CALA2017102003710Light · inoperativeEMERGENCY LIGHT AISLE 21 WAS INOPERATIVE. REMOVED AND REPLACED THE EMERGANCY LIGHT. CHECKED NORMAL IAW AMM 33-51-10.SDR CALA2017102003709Lamp · inoperativeOVERHEAD EMERGENCY LIGHT ABOVE SEAT 38B IS INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED NORMAL.SDR CALA2017102003708Lamp · inoperativeOVERHEAD EMERGENCY LIGHT ABOVE SEAT 27K IS INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED NORMALSDR CALA2017102003707Lamp · inoperativeOVERHEAD EMERGENCY LIGHT ABOVE SEAT 2K WAS INOPERATIVE. REPLACED THE LAMP, OPS CHECKED NORMAL.SDR CALA2017102003705Lens · missingL2 DOOR EMERGENCY EXIT SIGN LENS MISSING. REPLACED THE LENS.SDR CALA2017102003704Power Supply · inoperativeDURING CHECK, FOUND SEAT ROW 22 THRU 28 EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY. EMERGENCY LIGHT OPS CHECKED OK.SDR CALA2017102003703Lamp · inoperativeLEFT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD IAW MM 33-51-00.SDR CALA2017102003702Bulb · inoperativeAFT SEAT 15C EMERGENCY LIGHT INOPERATIVE. REPLACED THE BULB AND LENS. EMERGENCY LIGHT OPS CHECKED NORMAL.SDR CALA2017102003701Lamp · inoperativeL2 DOOR EMERGENCY LIGHT INOPERATIVE. EXTERIOR. REPLACED THE LAMPS IAW MM 33-51-00. OPS CHECKED GOOD.SDR CALA2017102003700Battery Pack · dischargedFOUND EMERGENCY LIGHTS AT OVERWING EXITS INOPERATIVE. REPLACED THE BATTERY PACKS IAW AMM 33-5 1-00SDR CALA2017102003699Lens · missingFIRST CLASS CLOSET EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS. OPS CHECKED NORMAL.SDR CALA2017102003698Lens · brokenEMERGNCY LIGHT ON AFT WALL OF FIRST CLASS CLOSET HAS A BROKEN LENS. REPLACED THE LENS.SDR KCSA201710201071Light · inoperativeUPPER DECK EMERGENCY LIGHTS INOPERATIVE.SDR FDEA201710203012Lamp · failedFOWARD STARBOARD EMERGENCY LIGHT DOES NOT WORK. REPLACED THE LAMPS AND TESTED OK IAW AMM 33-51-03-2.SDR DALA2017102007691Battery Pack · faultedR4 DOOR EPSU BATTERY FAULT. REPLACED THE BATTERY.SDR IPXA2017101922766Sign · intermittentAIRBORNE WITH GEAR DOWN EXIT LIGHT BLINKS. LT ENTRY DOOR EXIT LIGHT INOP. RELAMPED EMER EXIT SIGN PER 35-51-04 OPS CK OK.SDR SWAA2017102417323Light · inoperativeLT TRAILING EDGE EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SIMA20171019005Lamp · inoperativeMAIN DOOR ENTRY EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-06-000-801-A, AND 33-50-06-400-801-A.. OPS CHECKED GOOD.SDR SIMA20171019004Flashlight Assy · brokenAFT FA FLASHLIGHT BROKEN AND NOT WORKING. REMOVED AND REPLACED THE FLASHLIGHT IAW AMM 33-50-16. OPS CHECKED GOOD. NO FURTHER DEFECTS NOTED.SDR SWAA2017102317315Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2017102317296Light · inoperativeRT BULL NOSE EMERGENCY LIGHTS INOP BETWEEN ROW 3 TO ROW 6. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2017102317260Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR AALA20171019002Battery · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT LIGHTS FROM SEATS 25H TO 29H ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY M1210 PER AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR CALA2017102003683Battery Pack · dischargedFOUND THE R4 DOOR EMERGENCY LIGHT BATTERY PACK WITH LOW CAPACITY. REPLACED THE BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-06-960-803, REV 80, & AMM 33-51-00-710-801, REV 80.SDR CALA2017102003682Battery Pack · dischargedRIGHT CEILING AREA EMERGENCY LIGHTT BATTERY HAD LOW CAPACITY. REPLACED THE POWER SUPPLY AND OPS TESTED NORMAL IAW AMM 33-51-06-960-803, REV 80, & AMM 33-51-00-710-801, REV 80.SDR CALA2017102003681Battery Pack · dischargedRT CEILING AREA EMERGENCY LIGHT BATTERY PACK HAD LOW CAPACITY. REPLACED THE POWER SUPPLY M33094 AND TESTED NORMAL IAW AMM 33-51-06-960-803, REV 80, & AMM 33-51-00-710-801, REV 80.SDR CALA2017102003680Battery · dischargedLEFT CEILING AREA EMERGENCY LIGHT BATTERY PACK HAD LOW CAPACITY. REPLACED THE BATTERY PACK AND OPS TESTED NORMAL IAW AMM 33-51-00-7 10-801, REV 80, & AMM 33-51-06-960-803, REV 80.SDR CALA2017102003679Battery · dischargedR1 DOOR EMERGENCY LIGHT BATTERY PACK HAD LOW CAPACITY. REPLACED THE BATTERY PACK AND OP TESTED NORMAL IAW AMM 33-51-06-960-803, REV 80, & AMM 33-51-00-710-801, REV 80.SDR CALA2017102003678Light · inoperativeSEAT 44G EMERGENCY LIGHT LIGHT INOPERATIVE. REPLACED THE EMERGENCY LIGHT AND TESTED NORMAL IAW AMM 33-51-05-960-802, REV 80.SDR CALA2017102003677Light · damagedDURING INSTALLATION OF THE EXIT LIGHTS AT THE M1 GALLEY, FOUND ONE LIGHT ASSY DAMAGED. REPLACED THE EMERGENCY LIGHT ASSY, AND TESTED GOOD IAW AMM 33-51-05-960-802, REV 80.SDR CALA2017102003676Light · damagedDURING INSTALLATION OF THE EXIT LIGHTS AT THE M1 GALLEY, FOUND ONE LIGHT ASSY DAMAGED. REPLACED THE EMERGENCY LIGHT ASSY, AND TESTED GOOD IAW AMM 33-51-05-960-802, REV 80.SDR CALA2017102003652Lens · missingFOUND THE SEAT 36G EMERGENCY LIGHT COVER MISSING. REPLACED THE LIGHT ASSY AND TESTED NORMAL IAW AMM 33-51-05-960-802, REV 80.SDR CALA2017102003651Battery Pack · dischargedSEAT EMERGENCY LIGHT BATTERY PACK HAD LOW CAPACITY. REPLACED THE BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-06-960-802, REV 80, & AMM 33-51-00-710-801, REV 80.SDR CALA2017102003650Battery Pack · dischargedLEFT SEAT EMERGENCY LIGHT BATTERY PACK HAD LOW CAPACITY. REPLACED THE BATTERY PACK AND TESTED NORMAL IAW AMM 33-51-06-960-802, REV 80, & AMM 33-51-00-710-801, REV 80.SDR SWAA2017102017233Sign · damagedL1 DOOR EMERGENCY EXIT SIGN DAMAGED. R&R SIGN PER MM.SDR REXA2017101901108Charger · inoperativeEMERGENCY FLOOD LIGHTS 5 AND 6 INOPERATIVE. REMOVED AND REPLACED THE BATTERY CHARGER PS38 IAW AMM 33-51-17, NO DEFECTS NOTED.SDR AALA201710209006Lens · missingEMERGENCY LIGHT LENS MISSING AT SEATS 6A. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM.SDR MASA2017101912706Light · inoperativeCEILING FLOOD LIGHTS INOPERATIVE ROW 11 AND 21.SDR SIMA20171019002Inverter · inoperativeROW 3 EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE NR 3 INVERTER IAW AMM 33-50-11 AND WM 33-50-50. EMERGENCY LIGHTING SYSTEM OPS CHECKED GOOD. NO DEFECTS NOTED AT THIS TIMESDR YENA201710190850Battery Pack · failedRT EPSU BATTERY 12WL FAILED AN EMERGENCY LIGHT TEST. R & R THE BATTERY PACK IAW AMM 33-51-38, OPS CHECKED GOOD.
Back to JASC 3350