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 SWAA2019041231644Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY CHECK AT M1668. R&R BATTERY PACK PER AMM.SDR SWAA2019041231643Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M1672. / R&R BATTERY PACK PER AMM.SDR SWAA2019040931512Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK M1674 FAILED CAPACITY CHECK. / R&R BATTERY PACK PER AMM..SDR SWAA2019040931494Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK M1675 FAILED CAPACITY CHECK. / R&R BATTERY PACK PER AMM..SDR YENA201903030113Battery · failedDURING HEAVY MAINTENANCE, EMERG LIGHT BATTERIES 10WL,12WL AND 13WL FAILED TEST; REMOVED AND REPLACED EMERG LIGHT BATTERIES IAW AMM 33-51-38.SDR YENA201903030112Battery · failedDURING HEAVY MAINTENANCE, EMERG LIGHT BATTERIES 10WL,12WL AND 13WL FAILED TEST; REMOVED AND REPLACED EMERG LIGHT BATTERIES IAW AMM 33-51-38.SDR YENA201903030111Battery · failedDURING HEAVY MAINTENANCE, EMERG LIGHT BATTERIES 10WL,12WL AND 13WL FAILED TEST; REMOVED AND REPLACED EMERG LIGHT BATTERIES IAW AMM 33-51-38.SDR Q2SA20190303414Light · no testAIRCRAFT GROUNDED. EMERGENCY EXIT LIGHT WILL NOT TEST LEFT SIDE OF L1 DOOR. TRANSFERRED TO MDDR #108119 IAW MEL 33-15-01. CAT C. DATE DUE 03-14-19.SDR DALA2019030501459Shroud · brokenEMERGENCY LIGHTS AT SEATS 34FG. PLASTIC MOUNT BROKEN. REPLACED PLASTIC SHROUD. SYSTEM OPERATION IS NORMAL. (LP 5739564)SDR ASAA2019030328432Sign · unsecureMID CABIN OVERWING EMERGENCY EXIT SIGN FELL OFF CEILING. GROUNDED - YES. REPLACED MISSING HARDWARE AND MOUNTED EMERGENCY EXIT SIGN.SDR ASAA2019030328431Light · inoperativeLT FWD OVERWING EXIT EXTERIOR LIGHT INOP. GROUNDED - YES. RELAMPED. OPS CHECK GOOD IAW AMM 33-51-04.SDR ASAA2019030328430Light · inoperativeRT OVERWING EXIT LIGHT FWD BULB INOP. GROUNDED - YES. REPLACED BULB. OPS CHECK GOOD IAW AMM 33-51-04.SDR DALA2019030301398Sign · inoperative(LOG 5768940) DURING INSPECTION FOUND 1R EMERGENCY EXIT SIGN INOPERATIVE. RPLCD SAME OPS CK GOOD IAW AMM 33-50.SDR SIMA20190303004Battery · dischargedFWD FA FLASHLIGHT INOP. C/A-REMOVED AND REPLACED FWD FA FLASHLIGHT BATTERY IN REFERENCE WITH AMM 33-50-16-000-801-A AND 33-50-16-400-801-A OPS CHECK GOOD END.SDR SIMA20190303002Warning System · false activationEMERGENCY LIGHT BATTERY FAULT EICAS ILLUMINATED. C/A-RAN OPS CHECK IAW AMM 33-50-01. OPS CHECK GOOD. NO EICAS MSG OR FAULTS AT THIS TIME.SDR UIEA2019030103416Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK ASSY FOUND LOW CAPACITY(<P>M5170 BATTERY PACK ASSY REPLACED AND TEST NORMAL AS PER AMM 33-51-04</P>)SDR UIEA2019022603387Light · inoperativeL1 DOOR AREA EMERGENCY L OPERATIONAL TEST FAIL.(<P>L1 DOOR AREA EMERGENCY LIGHT ASSY REPLACED AND OPERATIONAL TEST AND SYSTEM TEST NORMAL AS PER AMM 33-51-07 AND 35-51-00.</P>)SDR AALA201903049044Light · brokenAFT EMERGENCY LIGHT AT SEAT 2E WAS BROKEN. REPLACED THE AFT EMERGENCY LIGHT & OPS CHECKED GOOD IAW MM 33-51-00.SDR VNAA2019030211101Light · inoperativeRH EXTERIOR EMERGENCY LIGHT #4 DOES NOT ILLUMINATE. R/R RH EXTERIOR EMERGENCY LIGHT #4 OPS CHECK GOODSDR SWAA2019030630396Lens · unsecureMID CABIN EMERGENCY EXIT LIGHT COVER OFF. REINSTALLED LENS PER SIP.SDR IPXA2019030439698Light · inoperativeINSPECTION TYPE:N/A OPERATIONAL CHECK OF THE SUPERNUMERARY INTERIOR EMERGENCY LIGHTS FAILED. FOUND SEVERAL BULBS BURNT OUT ON EMERGENCY DR EXIT SIGN. RELAMPED BULBS PER AMM 33-51-13. OPS CHECK GOOD.SDR YENA201903020109Power Unit · inoperativeDURING HEAVY MAINTENANCE, INOP FWD SERVICE DOOR ELPU AT FWD GALLEY AREA; INSTALLED NEW EMERGENCY LIGHT POWER UNIT AT FWD GALLEY AREA IAW AMM 33-50-01-400-801-A. OPERATIONAL TEST AND FUNCTIONAL TEST IAW AMM 33-50-01-710-801-A. TEST OK AT THIS TIME. REF NR WO 20SDR AALA201903049038Battery · dischargedAIRCRAFT WAS NOT GROUNDED: DOOR 4L EMERGENCY LIGHT WOULD NOT COME ON. MAINTENANCE REPLACED WIRELESS BATTERY UNIT PER AMM B787-A-33-51-07-01B-520A-A AND B787-A-33-51-07-01B-720A-A AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2019030549029Light · unknownAFTER LANDING, CABIN EMERGENCY LIGHTS CAME ON ARMED POSITION IN COCKPIT. MAINTENANCE ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR SWAA2019030530327Light · inoperativeLT EMERGENCY EXIT LIGHTS INOP BETWEEN ROW 9 TO ROW 12. RELAMPED LIGHT PER AMM.SDR SWAA2019030530317Light · inoperativeRT OVERWING EXIT SIDEWALL LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA2019030530312Lens · missingFORWARD RT SIDE LOWER OVER WING EMERGENCY EXIT SIGN COVER MISSING. INSTALLED LENS IAW AMM.SDR SWAA2019030530288Light · inoperativeRT EMERGENCY EXIT LIGHTS INOP AT ROW 13. RELAMPED LIGHT PER AMM.SDR SWAA2019030530285Sign · unsecureL1 DOOR EXIT SIGN AT WILL NOT STAY ATTACHED. REATTACHED SIGN PER MM.SDR SWAA2019030530278Light · inoperativeLT OVERWING EXIT INTERIOR ILLUMINATION LIGHTS INOP. RELAMPED BULBS PER AMM.SDR SWAA2019030530276Lens · displacedLT OVERWING EXIT FLOOR EMERGENCY EXIT LENS DISPLACED. R&R LENS ASSEMBLY PER MM.SDR DALA2019030401482Bracket · brokenSHIP 6708 EMERGENCY LITE AT SEAT 38 D BROKEN OFF OF SEAT BOTTOM. CORRECTIVE ACTION: REPLACED BRACKET AND REINSTALLED TO SEAT BOTTOM. (5229888)SDR DALA2019030401447Lens · broken(AIRCRAFT 7101, L/P 0966499) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:406 / INTERIOR. REPLACE BROKEN LENS.SDR ASAA2019030228441Light · inoperativeLT AFT DOOR SLIDE EMERGENCY LIGHT INOP. GROUNDED - YES. RE-LAMPED LT AFT DOOR SLIDE EMERGENCY LIGHT REF AMM 33-51-04-960-801OPS CHECK GOOD.SDR DALA2019030201399Block · not reported(LOG 5556648) DURING INSPECTION FOUND DURING EMERGENCY LIGHTS CK FOUND AFT RT DOOR + ROW 26 AFT ISLE LIGHTS INOP. R/R GND BLOCK GD3998. ALL OPS CK NORMAL.SDR MASA2019030211738Light · inoperativeROW 2 EMER FLOODLIGHT INOP. PLACED ON MEL.SDR MASA2019030211737Light · inoperativeROW 8 FLOODLIGHT INOP. FERRIED TO IAH FOR REPAIRS.SDR DALA2019030201362Battery · dischargedCABIN EMERGENCY LIGHTS OUT RELATED B5-105 AND B5-102. R/R BATTERIES FOR EMERGENCY LIGHTS BATTER PACKS B5-105 AND B5-102 IN REF TO AMM 33-53, OPS CHECK GOOD. (LP5758816)SDR VNAA2019030111101Light · inoperativeSUPPLEMENTAL INFORMATION: R/H AFT EMERGENCY EXTERIOR LIGHT INOP. MX REMOVED AND REPLACED RH MOST AFT EXTERIOR EMERGENCY LIGHT IAW CRJ 200 AMM 33-51-21-000/400-801 OPS CHECK GOODSDR SWAA2019032230942Lens · brokenRT EMERGENCY OVER WING EXIT WINDOW LENS DISCOLORED AND BROKEN. R&R LENS IAW MM.SDR SWAA2019032230920Lens · brokenLT EMERGENCY OVER WING EXIT WINDOW LENS DISCOLORED AND BROKEN. R&R LENS IAW MM.SDR SWAA2019030730416Battery · dischargedRT SIDE PASSENGER CABIN FORWARD DROPPED CEILING EMERGENCY LIGHT BATTERY DOES NOT CHARGE. R&R BATTERY IAW AMM.SDR AALA201903062003Light · inoperativeMAINTENANCE FOUND THE L1 DOOR EXIT SIGN INOPERATIVE, DURING TEST. REMOVED AND REPLACED THE THE LIGHT ASSEMBLY IAW AMM 33-51-01-960-802. OPS CHECKED GOOD.SDR AALA2019030549025Switch · unknownCOCKPIT TOGGLE SWITCH FOR EMERGENCY LIGHTS MOVED TO OFF, ARM AND ON, MADE NO DIFFERENCE, THE EMERGENCY EXIT LIGHTS REMAINED ON. MAINTENANCE PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR AALA2019030549024Light · missingSEAT 3L EMERGENCY LIGHT WAS MISSING. MAINTENANCE REPLACED THE EMERGENCY LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-18.SDR SWAA2019030530328Battery Pack · dischargedAFT LT EMERGENCY LIGHT BATTERY PACK INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019030530315Sign · missingOVERWING CENTER AISLE EXIT SIGN MISSING FORWARD FACE. INSTALLED SIGN PER SIP.SDR SWAA2019030530277Battery Pack · dischargedLT EMERGENCY EGRESS LIGHTS FOR AISLE ILLUMINATION INOP BETWEEN ROW 9 TO ROW 12. R&R BATTERY PACK PER AMM.SDR SWAA2019030530265Power Supply · inoperativeRT SIDEWALL 242YAW EMERGENCY EXIT LIGHT INOP. RECONNECTED POWER SUPPLY IAW AMM.SDR SWAA2019030530264Power Supply · inoperativeRT EMERGENCY EXIT LIGHT INOP AT ROW 8. RECONNECTED POWER SUPPLY IAW AMM.
Back to JASC 3350