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 SWAA2019021329571Sign · damagedPASSENGER CABIN EXIT SIGN ON FORWARD LAV AT ENTRY DOOR DAMAGED. R&R SIGN IAW AMM.SDR R61A201901160130Sign · inoperative***WHILE A/C WAS OUT OF SERVICE FOR HEAVY CHECK*** AFT ENTRY HOUSING EXIT LOCATOR SING INOP. AFT ENTRY HOUSING LOCATOR SIGN REPLACED AND TESTED SERVICEABLE IAW AMM 33-50-19-400-801-A. A/C REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR YENA201901160028Power Unit · failedFLT 2167, HPN-PBI. RT AFT EXTERIOR OVERWING EMERG. LIGHT INOP ( EXTERNAL EMERGENCY-OPS NOT CONDUCTED AT NIGHT ); R & R EMERGENCY LIGHT POWER UNIT 243GLC PER AMM 33-50-01 OPS CHECKS OK. MDDR 375476 CLEARED, MX-4 UPDATED. PLACARD REMOVED.SDR AALA2019012217006Battery Pack · inoperativeR2 DOOR EMERGENCY EXIT SIGN INOPERATIVE., REMOVED & REPLACED BATTERY PACK. OPS CHECKED GOOD IAW AMM 33-51-06-710-002.SDR SWAA2019012128728Light · inoperativeL2 DOOR SLIDE LIGHT INOP. R&R BULB PER AMM.SDR SWAA2019012128692Battery Pack · dischargedLT OVERWING EXIT FORWARD EXIT SIGN INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019012128684Battery Pack · dischargedLT OVERWING EXIT LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019012128667Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01674. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019012128666Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01673. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019012128665Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01672. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019012128664Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01670. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019012128663Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01669. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019012128662Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01668. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019012128618Battery Pack · failedCABIN EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01675. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019012128612Cover · looseRT OVERWING EMERGENCY EXIT LIGHT COVER LOOSE. SECURED COVER PER MM.SDR DALA2019011700368Power Supply · inoperativeAFT EMERGENCY BATTERY CHARGER BAD. LEFT AND RIGHT EXIT/THRESHOLD LIGHT IS INOPERATIVE. FOUND POWER SUPPLY CHARGER M1210 PARTIALLY INOPERATIVE, FUSE 9-10 BAD. REPLACED POWER SUPPLY. SYSTEM OPERATION IS NORMAL. (LP 5247410)SDR CALA2019011800120Light · brokenREFER TO NRC LOG PAGE NO.:9130124, B777-33-3-6026: RT DR4 PARTITION AFT FLOOR EMER LIGHT FOUND BROKEN. RT DR NO.4 PARTITION AFT FLOOR EMER LIGHT REPLACED & TEST OKAY IAW AMM 33-51-05.SDR CALA2019011800119Charger · inoperativeREFER TO NRC LOG PAGE NO.:9130125, B777-33-3-6026: LT DR1 EXIT SIGN CAPACITY CHECK FOUND FAIL. LT DR1 EMER PWR SUPPLY M33093 CHARGER REPLACED AND OP TEST CARRIED OUT RESULT NORMAL IAW AMM 33-51-06.SDR CALA2019011800118Battery Pack · dischargedREFER TO NRC LOG PAGE NO.:9130127, B777-33-3-6026: CABIN SEAT 1DEFG TO 3DEFG EMER LT CAPACITY CHECK FOUND FAIL. CABIN SEAT 1DEFG TO 3DEFG EMER LT BATTERY PACK REPLACED AND OPERATIONAL TEST RESULT NORMAL IAW AMM 33-51-06.SDR CALA2019011800117Battery Pack · dischargedREFER TO NRC LOG PAGE NO.:9130126, B777-33-3-6026: CABIN SEAT 1LK TO 4LK CEILING EMER LT CAPACITY CHECK FOUND FAIL. CABIN SEAT 1LK TO 4LK CEILING EMER LT BATTERY PACK REPLACED AND OPERATIONAL TEST RESULT NORMAL IAW AMM 33-51-06.SDR DALA2019011600346Lens · missing(AIRCRAFT 5654, L/P 0905768) EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:27A / ACARS TEXT: EMERGENCY EXIT SIGN MISSING / INTERIOR. INSTALLED NEW EXIT LIGHT COVER. OPS CK GOOD.SDR AALA201901179007Relay · inoperativeEMERGENCY EXIT LIGHT IN CEILING ABOVE L1 DOOR INOPERATIVE. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED R-47 RELAY IN P-6-4 AND PERFORMED SATISFACTORY OPERATIONAL PER WDM 33-29-11.SDR AALA201901176002Battery Pack · no testEMERGENCY POWER SUPPLY BATTERY PACK FAILED A TEST. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-38, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019011728585Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PACK PER MM.SDR SWAA2019011728584Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PACK PER MM.SDR SWAA2019011728583Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PACK PER MM.SDR SWAA2019011728582Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PACK PER MM.SDR SWAA2019011728581Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PACK PER MM.SDR SWAA2019011728580Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PACK PER MM.SDR SWAA2019011728579Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PACK PER AMM.SDR SWAA2019011728578Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PACK PER AMM.SDR SWAA2019011728577Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PACK PER AMM.SDR SWAA2019011728576Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PACK PER AMM.SDR SWAA2019011728575Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PACK PER AMM.SDR SWAA2019011728574Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PACK PER MM.SDR SWAA2019011728570Light · inoperativeLT EMERGENCY EXIT SIDEWALL LIGHT INOP. R&R LIGHT BALLAST PER AMM.SDR SWAA2019011728569Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PACK PER AMM.SDR SWAA2019011728562Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR DALA2019011700309Power Supply · inoperativeDURING SERVICE CHECK FOUND CEILING MOUNTED EMERGENCY LIGHTS INOP AFT OF L2 SERVICE DOOR. R&R POWER SUPPLY & BATTERY B5-237. OPS CHECK GOOD. OK FOR SERVICE. (LP 4679589)SDR N6WA2019011601Light · not reportedCEILING EMER EXIT SIGN ABOVE SERVICE DOOR REQ RELAMP. RELAMPED CEILING EMER EXIT SIGN ABOVE SERVICE DOOR IAW AMM 20-41-00. OPS CHECK GOOD AT THIS TIME.SDR DALA2019011700303Battery Pack · dischargedOVHD EMER LIGHTS INOP ROWS 20 - 26. REPLACED BATTERY PACK B5-104 AND BATTERIES PER AMM 33-53-00 EMERGENCY LIGHTS CHECK GOOD. (LP4765229)SDR QXEA2019011600018Light · looseEMERGENCY FLOOR PATH LIGHTING STRIP AT ROW 2DE IS LOOSE. AIRCRAFT REMOVED FROM SERVICE. RE-SECURED EMERGENCY PATH LIGHTING STRIP AT 2DE. NO OTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR DALA2019011600275Battery · dischargedOVER WING EXIT SIGN AFT RT SIDE INOP. REPLACED BATTERY'S AT RIGHT AFT BATTERY PACK OVER WING. CHECKS OKAY. (LP4765169)SDR DALA2019011600271Battery Pack · dischargedBOTH LT AND RT FWD OVERWING EMERG LIGHTS INOP. R/R BATTER PACKS FOR THE OVERWING EMERGENCY EXIT LIGHTS. OK FOR SVC. (LP5000086)SDR SWAA2019012328843Lens · brokenRT STOW BIN EMERGENCY LIGHT LENS BROKEN JUST AFT OF ROW 4. R&R LENS IAW AMM.SDR YENA201901150036Light · inoperativeDURING HEAVY MAINTENANCE, 15C- EMERGENCY LIGHT ON ISLE INOP; RELAMPED EMERGENCY LIGHT AT 15C IAW AMM CH. 33-51-16. OPS CHECK GOOD.SDR CALA2019011800116Battery · dischargedREFER TO NRC LOG PAGE NO.:9130128, B777-33-3-6026: RT DR3 EMER PWR SUPPLY M33401 BATTERY FOUND FAIL. RT DR3 EMER PWR SUPPLY M33401 BATTERY REPLACED AND INSTALLATION TEST CARRIED OUT RESULT NORMAL IAW AMM 33-51-06.SDR CALA2019011800115Charger · failedREFER TO NRC LOG PAGE NO.:9130130, B777-33-3-6026: RT DR2 EMER PWR SUPPLY M33098 CHARGER FOUND FAIL. RT DR2 EMER PWR SUPPLY M33098 CHARGER REPLACED AND INSTALLATION TEST CARRIED OUT RESULT NORMAL IAW AMM 33-51-06.HX284042.SDR CALA2019011800114Battery · dischargedREFER TO NRC LOG PAGE NO.:9130129, B777-33-3-6026: RT DR2 EMER PWR SUPPLY M33098 BATTERY FOUND FAIL. RT DR2 EMER PWR SUPPLY M33098 BATTERY REPLACED AND INSTALLATION TEST CARRIED OUT NORMAL I.A.W AMM 33-51-06.SDR SWAA2019011728599Light · disconnectedRT OVERWING EXIT AFT EMERGENCY EXIT SIGN INOP AT BS 651. RECONNECTED LIGHT IAW WDM & AMM.
Back to JASC 3350