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 SIMA202002265006Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT IAW EMB AMM 33-50-09-000-801-A AND 33-50-09-400-801-A OPC GOOD ENDSDR SIMA202002265007Fuse · inoperativeL/H FWD EXTERIOR EMER LIGHT, OVERHEAD COCKPIT EMER LIGHT AND ROW 3 OVERHEAD EMER LIGHT ARE INOP-C/A-REMOVED AND REPLACED FUSE ON #1 BATTERY POWER SUPPLY IAW CMM 25-60-03 AND WM 33-50-00. OPS CHECK GOODSDR DALA2020022601416Battery Pack · inoperativeREAR AIRCRAFT, ABOVE JUMPSEAT, THE EXIT LIGHT IS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND POWER SUPPLY PER AMM 33-51-03. OPERATIONAL CHECK IS GOOD. THE AIRCRAFT IS OK FOR SERVICE. (LP #6396492)SDR QXEA2020022500117Light · no testEMERGENCY LIGHTS FROM ROW 13 TO AFT GALLEY DO NOT ILLUMINATE DURING FUNCTIONAL CHECK.SDR MASA2020022500081Sign · inoperativeMID OH AFT PART OF EXIT SIGN INOPSDR DALA2020022501396Battery Pack · inoperativeOVERHEAD EMER LIGHTS OUT FROM SEATS 11-15. R/R EMER BATT PACK BATTERIES PER MD88 AMM 33-53. (LP6465677)SDR AALA2020025000178Module · weakSEAT MOUNTED EMERGENCY LIGHT IN FIRST CLASS VERY DIM. REPLACED BATTERY AND CHARGER REF AMM 33-51-07. FIRST CLASS SEAT MOUNTED EMERGENCY LIGHTS CHECK NORM. BATTERY PACK EQUIPTMENT M10798.SDR AALA202002540182Battery Pack · weakSEAT MOUNTED EMERGENCY LIGHT IN FIRST CLASS VERY DIM. REPLACED BATTERY AND CHARGER REF AMM 33-51-07. FIRST CLASS SEAT MOUNTED EMERGENCY LIGHTS CHECK NORM. BATTERY PACK EQUIPTMENT M10798.SDR SIMA2020040224008Light · inoperativeRH OVERWING EMERGENCY LIGHT INOP-C/A-RH OVERWING EMERGENCY LIGHT LAMP REPALCED IAW AMM 33-50-01 REFER TO TASK CARD 33-2047 FOR TESTSDR CALA2020022900546Lamp · inoperativeEMEREXIT AREA LIGHT IN CEILING AT ROW 39 INOP. RELAMPED REF AMM 33-51-03-960-801 OPSCHECKED OK. ACP IDT INSP OF REPLACING EPL LAMP AT CEILING ABOVE ROW 39 REF GMM 09-10-05 AND AMM 33-51-03. OPS CHKD GOOD.SDR REXA2020022840215Relay · inoperativeEMERGENCY LIGHTS KEEP CYCLING OFF AND ON IN ARM POSITION
R&R'D RELAY PCB5 ON CIRCUIT BOARD 5 IN JB-11 IAW AMM 24-06-11. OPC GOOD. OK FOR SVC.SDR YENA2020022840201Epsu · failedFT # 391, BOS-TPA. EPSU UNIT EMER L (11WL) FAILED BITE TEST; REPLACED EPSU (11WL) IAW AMM 33-51-38.SDR SWAA2020022874915Battery Pack · inoperativeEMERGENCY LIGHT BETWEEN L/H OVER WING DOORS INOPERATIVE. / R&R BATTERY PACK IAW AMM.SDR SWAA2020022874914Lens · brokenFORWARD SERVICE DOOR EMERGENCY EXIT LIGHT LENS BROKEN. / INSTALLED NEW LENS PER AMM.SDR SWAA2020022874901Bulb · burned outAFT ENTRY EMERGENCY EXIT SIGNS HAD BURNED OUT BULBS. / R&R BULBS PER AMM.SDR SWAA2020022874859Lens · brokenFORWARD SERVICE DOOR EMERGENCY EXIT LIGHT LENS BROKEN. / INSTALLED NEW BASE PER AMM.SDR SWAA2020022874841Light · inoperativeEMERGENCY LIGHT BETWEEN R/H OVER WING DOORS INSIDE CABIN INOPERATIVE AT BS. 616. / R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2020022874840Bulb · inoperativeEMERGENCY LIGHT BETWEEN L/H OVER WING DOORS INOPERATIVE. / RELAMPED BULB IAW AMM.SDR AALA2020022759002Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: OVERWING EXIT LIGHTS INOPERATIVE. MAINTENANCE TROUBLESHOT AND FOUND BATTERY PACK DEFECTIVE AND REPLACED BATTERY PACK PER AMM 33-51-07.SDR ASAA2020022643275Sign · detachedEMERGENCY EXIT SIGN CAME OFF EMERGENCY EXIT ROW. GROUNDED - YES. REINSTALLED EMERGENCY EXIT SIGN COVER ON EMERGENCY EXIT ROW REF B737-800 AMM 33-51-01.SDR SWAA2020022641847Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACKS M1675 INOPERATIVE. / R&R BATTERY PACK IAW AMM.SDR SWAA2020022641846Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACKS M2335 INOPERATIVE. / R&R BATTERY PACK IAW AMM.SDR SWAA2020022641830Lens · damagedFORWARD GALLEY LOWER EMERGENCY EXIT INDICATOR SIGN LENS WAS DAMAGED. / R&R LENS PER AMM.SDR SWAA2020022641823Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACKS M2816 INOPERATIVE. / R&R BATTERY PACK IAW AMM.SDR SWAA2020022641818Lamp · inoperativeEMERGENCY EXIT AREA LIGHT AT 9ABC INOPERATIVE. / RELAMPED AREA LIGHT AT 9ABC IAW AMM.SDR AALA2020022659004Ballast · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND, FORWARD, EMERGENCY EXIT WINDOW LIGHT BALLAST INOPERABLE. MAINTENANCE REPLACED LIGHT BALLAST PER AMM 33-21-00.SDR DALA2020022601423Connector · disconnected(AIRCRAFT 7002, L/P 7147314) EMERGENCY FLOOR PROXIMITY LIGHT INOP 7B. CORRECTIVE ACTION: RECONNECTED CONNECTOR. OPS GOOD.SDR DALA2020022501415Lens · missingTHE CABIN SIDEWALL EMERGENCY LIGHT IS MISSING IT'S COVER. MAINTENANCE INSTALLED A NEW COVER. OPERATIONAL CHECK WAS GOOD. (LP #1503125)SDR MASA2020022400079Light · inoperativeEMER FLOOD LIGHT ROW 15 INOPSDR MASA2020022400078Battery Pack · dischargedEMERGENCY LIGHTS INOP. CHARGED BATTERY PACKSSDR MASA2020022400077Lamp · inoperativeROW 19 OVERHEAD EMERGENCY LIGHT INOP. RELAMPEDSDR WX0A2020022473480Epsu · no testEPSU BATTERY FAILED EMERGENCY LIGHT TEST / REPLACED EPSU BATTERY"SDR SWAA2020030542155Lens · damagedG-4 GALLEY EXIT LIGHT LENS IS DAMAGED. REMOVED AND REPLACED G-4 EXIT LIGHT LENS IAW AMM 33-51-01-960-801SDR YENA2020022730199Battery · failedFT # 2662, BGI-JFK. FAILURE OF EPSU 11WL AND 13WL BATTERY; R & R EPSU BATTERY AT 11WL AND 13WL PER AMM 33-51-38. OPS TEST GOODSDR YENA2020022730198Battery · failedFT # 2662, BGI-JFK. FAILURE OF EPSU 11WL AND 13WL BATTERY; R & R EPSU BATTERY AT 11WL AND 13WL PER AMM 33-51-38. OPS TEST GOODSDR YENA2020022730197Battery · failedFT # 2662, BGI-JFK. FAILURE OF EPSU 10WL AND 15WL BATTERY; R & R EPSU BATTERY AT 10WL AND 15WL PER AMM 33-51-38. OPS TEST GOOD.SDR YENA2020022730196Battery · failedFT # 2662, BGI-JFK. FAILURE OF EPSU 10WL AND 15WL BATTERY; R & R EPSU BATTERY AT 10WL AND 15WL PER AMM 33-51-38. OPS TEST GOOD.SDR SWAA2020022641821Sign · brokenEMERGENCY EXIT SIGN MID CABIN CEILING BROKEN. / R&R SIGN PER AMM.SDR DALA2020022651432Lens · missing(AIRCRAFT 5635, L/P 6381728) 5C SEAT MOUNTED EMERGENCY LENS COVER MISSING. CORRECTIVE ACTION: R/R 5C SEAT EMERGENCY LIGHT ASSY. PER B757 AMM 33-51.SDR DALA2020022641427Light · unsecure(AIRCRAFT 5642, L/P 6225778) CEILING EMERGENCY LIGHT 15DEF INOP. CORRECTIVE ACTION: FOUND LIGHT ASSEMBLY NOT SECURED TO CEILING PANEL. RESECURED ASSEMBLY REF B757 AMM 33-51.SDR DALA2020022501403Bulb · brokenEMERGENCY LIGHT 2R DOOR HAS BROKEN COVER AND BROKEN BULB, REPLACED COVER AND BULBSDR MASA2020022430076Lamp · inoperativeFLOOR EMR LGHT BULB AT EXT ROW 13F INOP. RELAMPEDSDR SWAA2020022441655Lamp · inoperativeRH WING TO BODY EMERGENCY LIGHT WAS INOPERATIVE. / RELAMPED PER AMM.SDR SWAA2020022441647Lamp · inoperativeAFT R/H EMERGENCY LIGHT INOPERATIVE. / RELAMPED LIGHT IAW AMM.SDR DALA2020022431360Battery Pack · inoperative(LOG 7181203) WHILE WORKING EMERG LIGHT WORK CARD FOUND SEVERAL EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERG BATTERIES AT FWD GALLEY AND AT SEAT 24D SIDEWALL PER B737 AMM 3-51-06. ALL EMERG LIGHTS OPS CHECKED GOOD.SDR VNAA2020022311101Inverter · failedR&R #2 EMERGENCY LIGHT INVERTER IAW CRJ 200 AMM 33-51-07-000/400-801 OPS CHECK GOOD AT THIS TIME.SDR SWAA2020022641845Bulb · inoperativeEMERGENCY EXIT LIGHT ASSEMBLIES L1188 HAD BULBS OUT. / R&R LIGHT BULBS IAW AMM.SDR SWAA2020022641844Bulb · inoperativeEMERGENCY EXIT LIGHT ASSEMBLIES L1189 HAD BULBS OUT. R&R LIGHT BULBS IAW AMM.SDR SWAA2020022641829Battery Pack · inoperativeALL EMERGENCY EXIT LIGHTS ASSOCIATED WITH M1674 BATTERY PACK WERE INOPERATIVE. / R&R BATTERY PACK M1674 PER MM.SDR SWAA2020022641828Battery Pack · faultyALL EMERGENCY EXIT LIGHTS ASSOCIATED WITH M1672 BATTERY PACK TURN ON MOMENTARILY. / R&R BATTERY PACK M1672 PER MM.
Back to JASC 3350