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 SIMA20171214002Fuse · failedLH AND RH AFT OVERWING EMERGENCY LIGHTS INOP.-C/A-T/S PER FIM 33-50-00-810-804A. FOUND #4 EMERGENCY BATTERY POWER SUPPLY FUSE F1 INOP. REMOVED AND REPLACED #4 EMERGENCY BATTERY POWER SUPPLY FUSE F1 IAW CMM 25-60-03. OPS CHECK GOOD AT THIS TIME.SDR IPXA2017121424530Panel · malfunctionedINSPECTION TYPE:N/AWHEN EMERGENCY LIGHTS SWITCH PLACED IN DISARM,EMERGENCY LIGHT S ALL ILLUMINATE AND NO DISARM LIGHT IN LIGHT ASSY.TRIED NEW POWER SUPPLY UNIT,NO HELP.INSTALLED AND REMAVED AND INSTALLED ORIGINAL PART PER A300 MM CHPT 33-51-14-0401REPLACED VU4SDR DALA2017121508620Lens · missing(LOG 9818136) DURING INSPECTION FOUND EMERGENCY LIGHT LENS MISSING AT 12C. MAINTENANCE INSTALLED LENS COVER CKS OK.SDR QXEA2017121500703Light · looseLUMINESCENT FLOOR STRIP LIGHTING PULLING UP IN FRONT OF SEAT 2D. REMOVED FROM SERVICE. RE SECURED LUMINESCENT STRIP @ 2D. NO FURTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR SWAA2017121518449Lens · missingLH AFT OVERWING EXIT LIGHT LENS MISSING. / INSTALLED LENS PER MM.SDR MASA2017121412833Light · inoperativeFWD PAX SERVICE DOOR EMERGENCY EXIT LIGHT INOP. RESET LIGHT.SDR MASA2017121412832Light · inoperativeROW 9 OVHD EMER FLOOD LIGHT INOP. REPLACED BULB.SDR CALA2017121404455Power Supply · inoperativeEMERGENCY LIGHT TEST FAILED EPSU BATTERY EMER R ON PTP. REPLACED EPSU 12WL BATTERY AS PER AMM 33-51-38 PB401. NOW OP TEST OK FOR SERVICE.SDR CALA2017121404454Lens · missingLENS COVER LENS COVER TO AISLE PATH EMERG LIGHTING FIRST CLASS LEFT BLKHD. REPLACED MISSING LENS. OPS GOOD. AISLE PATH LIGHTS GOOD.SDR CALA2017121404453Lens · brokenEMERGENCY ISLE PATH LIGHTING BROKEN. INSTALLED LENS COVER. PATH LIGHTING CKED OKSDR CALA2017121404452Light · brokenEMER EXIT LT BROKEN SEAT 20C. SECURED LIGHT ASSY.SDR CALA2017121404451Lens · missingEMERGENCY EXIT LIGHT ON OVERHEAD PANEL FELL OUT. CANNOT FIND REINSTALLED EMERGENCY EXIT LIGHT LENS. CKS GOOD.SDR CALA2017121404450Lens · missingROW 20 MISSING 2 RED EMERG PATH LIGHTING LENSES. INSTALLED RED LENSES.SDR CALA2017121404447Light · brokenAFT GALLEY RT AISLE WALL EEL LIGHT AND EDGE TRIM BROKEN. REPLACED EEL LIGHT AND TRIM.SDR CALA2017121404446Light · inoperativeLT DR2, DR3 AND DR4 EXTERNAL EMERGENCY LIGHT INOP. REPLACED LT DR2, DR3 AND DR4 EXTERNAL EMERGENCY LIGHT AND OPERATIONAL TEST FOUND NORMAL AS PER AMM 33-51-04-710-001 REV 81.SDR V0XD20171214003Light · missingEMERGENCY FLOOR PATH LIGHTING STRIP MISSING FROM ROW 12 ON RH SIDE. CORRECTIVE ACTION: INSTALLED MISSING EMERGENCY FLOOR PATH LIGHTING STRIP (PN:PL1600LH07) AT ROW 12 ON RH SIDE IAW CRJ900 AMM 33-51-01.SDR DALA2017121408607Battery Pack · inoperative(AIRCRAFT 0655, L/P 3869017) DURING WAKE UP CHECK LEFT EMERGENCY LIGHTS ON FOR 2 MINUTES. RECHARGED EMERGENCY LIGHTS BATTERY PACKS IAW B757 AMM 33-51-11.SDR SWAA2017121918535Lens · looseRIGHT STOW BIN EMERGENCY AISLE LIGHT LENS LOOSE AT ROW 3. REPAIRED THE LENS IAW AMM.SDR SWAA2017121818499Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK AT POSITION M01669. R & R THE BATTERY PACK IAW AMM AND DWG.SDR AALA201712159026Lens · damagedEMERGENCY EXIT LIGHT COVER HALFWAY UP THE L4 DOOR DOES NOT STAY ATTACHED. REMOVED THE DAMAGED LENS AND INSTALLED A NEW EMERGENCY EXIT LIGHT LENS ASSY IAW AMM 33-51-00.SDR AALA20171214002Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. AFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT INOPERABLE. REPLACED BATTERY PACK PER AMM 25-64-00.SDR AALA201712149039Lens · damagedAIRCRAFT WAS NOT GROUNDED. SEAT 36B SEAT MOUNTED EMERGENCY LIGHT LENS DAMAGED. REPLACED SEAT 36B EMERGENCY LIGHT ASSEMBLY.SDR AALA201712159042Switch · brokenAIRCRAFT NOT GROUNDED. EMERGENCY LIGHTS SWITCH: SPRING CAME OUT DURING SHUTDOWN. REPLACED EMERGENCY LIGHT SWITCH PER AMM 30-41-02. OPERATIONS CHECKS NORMAL.SDR AALA201712159036Sign · unsecureAIRCRAFT NOT GROUNDED. FORWARD RIGHT OVER WING CABIN WALL-MOUNTED EMERGENCY EXIT MARKER WILL NOT SECURE TO WALL. REPLACED FORWARD RIGHT OVER WING CABIN WALL-MOUNTED EMERGENCY EXIT MARKER PER AMM 33-51-13. OPERATIONS CHECK NORMAL.SDR YENA201712131002Battery Pack · no testFT # 225, JFK-TPA. EMER LIGHT FAILS TEST; R & R EPSU BATTERIES AT 11WL AND 12WL OPS AND BITE CKS GOOD. IAW AMM 33-51-38.SDR YENA201712131001Battery Pack · failedFT # 225, JFK-TPA. EMER LIGHT FAILS TEST; R & R EPSU BATTERIES AT 11WL AND 12WL OPS AND BITE CKS GOOD. IAW AMM 33-51-38.SDR DALA2017121408624Fuse · failedEMERGENCY LIGHTS AT SEAT 1,2,3 RIGHT SIDE ARE INOPERATIVE. FOUND BATTERY PACK F1 FUSE OPEN AND REPLACED FUSE. SYSTEM OPERATION IS NORMAL.SDR YENA201712131000Battery Pack · failedFT # 1282, RIC-BOS. EMERGENCY LIGHT OVER L1 DOOR INOP; R & R #1 EMERGENCY POWER UNIT PER AMM 33-50-01. OPS CHECK GOOD.SDR SWAA2017121518487Lens · missingR2 DOOR EMERGENCY LIGHT LENS MISSING. / INSTALLED LENS PER MM.SDR SWAA2017121518475Lens · looseMID CABIN OVERWING EXIT LIGHT LENS LOOSE. / SECURED LENS PER MM.SDR SWAA2017121518473Lens · missingR2 DOOR EMERGENCY EXIT LIGHT LENS MISSING. / INSTALLED LENS PER MM.SDR SWAA2017121518459Battery Pack · no testEMERGENCY LIGHT BATTERY M1673 FAILED CAPACITY TEST. / R&R BATTERY PACK PER MM.SDR AALA201712149028Lens · missingAIRCRAFT WAS GROUNDED. 2R RED LENS COVER, SLIDE ARMED LIGHT MISSING. REPLACED 2R RED LENS COVER AS REQUIRED PER EA 276057.SDR SIMA20171213005Lamp · inoperativeL/H OVERWING EMERGENCY LT INOP-C/A-REMOVED AND REPLACED L/H OVERWING EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A..OPC GOOD AT THIS TIME.END.SDR AALA201712149035Sign · damagedAIRCRAFT WAS NOT GROUNDED. CABIN SERVICES REPORTS R-1 DOOR ILLUMINATED EXIT SIGN DAMAGED. REPLACED EMERGENCY EXIT DOOR SIGN PER AMM 33-51-01.SDR AALA201712149034Lens · looseAIRCRAFT WAS NOT GROUNDED. F/A REPORTS EXIT ROW CEILING SIGN NEEDS TO BE SECURED. SECURED LIGHT LENS, OPERATIONS CHECK GOOD.SDR DALA2017121408603Battery Pack · inoperative(AIRCRAFT 6811, L/P 3865685) ON SERVICE CHECK EMERGENCY EXIT IDENTIFIER ABOVE DOOR 4 L AND EXTERIOR LIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY PACK M737 IAW B757 AMM 33-51-07-902-001.SDR DALA2017121308601Battery Pack · inoperative(AIRCRAFT 5657, L/P 0336929) R/H EMERGENCY LIGHTS ROWS 27-32, 38-42 AND RH OVER WING DOORS ARE INOP. ROW 27-32, AND RT OVERWING LIGHTS ARE CONTROLLED BY BATTERY PACK M10568 LOCATED BEHIND DADO PANEL AT ROW 27F, STK #55-3300-4-0138, ROW 38-42 EE LIGHTS ARE BATTSDR DALA2017121408596Charger · inoperativeEMERGENCY EXIT LIGHTS AT SEATS 31CD TO 36CD OUT. REMOVED AND REPLACED BATTERY CHARGER PACK AT SEAT 35CD PER MD88 AMM 33-53. FOUND SHORT IN AFT MOST STAIRWAY LIGHT. RE-SECURED LIGHT AND ALL EMERGENCY LIGHTS OPS CHECKS GOOD. (LP4014355)SDR CALA2017121304439Light · inoperativeNR 2 LT MED EXTERIOR EMERGENCY LIGHT INOP REPLACED LAMP, CKS OK.SDR CALA2017121304435Light · inoperativeEMERGENCY LIGHT ABOVE SEAT 20D INOP REPLACED LAMP. OPS CK GOOD.SDR CALA2017121304438Light · missingINTERIOR LT FWD WALL MOUNTED EEL LIGHT FORWARD OF OVERWING ESCAPE DOOR MISSING BULBS RELAMPED PER MM 33-51-01. OPS NORMAL.SDR CALA2017121304437Light · inoperativeLT AFT EXTERNAL EEL LIGHT INOP. RELAMPED OVERWING AFT LT EXTERNAL EEL LIGHT PER MM 33-51-04. OP S NORMAL.SDR CALA2017121304436Lens · missingLENS COVER MISSING ON EMERGENCY LITE AT CORNER OF FIRST CLASS CABIN. REPLACED LENS CKD OK.SDR CALA2017121304433Light · intermittentAISLE PATH LIGHTING IS INTERMITTENT AT AISLE CROSSOVER SEGMENT. REPLACED CROSS-AISLE PATH LITE (EEL). OPS CHK GOOD. PER AMM 33-51-10-400.SDR CALA2017121304432Power Supply · faultyFOUND EMERGENCY LIGHT OUT ON TOP OF BUNKER NR 5. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPS CHECK GOOD.SDR CALA2017121304420Battery · dischargedRT AFT OVERWING EMERGENCY LIGHT INOP. REMOVED AND REPLACED M1671 POWER SUPPLY IAW AMM 33-51-06-960-806. OPS CHECK GOOD IAW AMM 33-51-06-960-806.SDR CALA2017121304419Power Supply · inoperativeRT AFT OVERWING EMERGENCY LIGHT INOP. REMOVED AND REPLACED M1671 POWER SUPPLY IAW 33-51-06-960-806. OPS CHECK GOOD IAW AMM 33-51-06-960-806.SDR CALA2017121304418Light · inoperativeONE LT AFT FUSELAGE EMERGENCY LIGHT FWD OF L4 DOOR IS INOP. REMOVED AND REPLACED LT AFT FUSELAGE EMERGENCY LIGHT FWD OF L4 DOOR IAW AMM 33-51-06-902-082. OPS CHECK GOOD.SDR DALA2017121308557Charger · inoperative(LOG 9839582) DURING INSPECTION FOUND EXTERNAL EMERGENCY LIGHT AFT OF RT WING INOPERATIVE. MAINTENANCE REPLACED BATTERY CHARGER M1671 PER B737-800 AMM 33-51. OPS CKS GOOD.
Back to JASC 3350