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 SWAA2019010328172Battery · failedEMERGENCY EXIT LIGHT BATTERY M1675 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010328042Sign · unsecureOVERWING AISLE EMERGENCY EXIT SIGN FELL OFF. RESECURED SIGN PER MM.SDR SWAA2019010328022Battery · failedEMERGENCY EXIT LIGHT BATTERY M1670 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010228054Lens · missingMID CABIN EMERGENCY EXIT CEILING LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2019010227935Sign · missingR1 DOOR LOWER EXIT SIGN DIRECTIONAL ARROW MISSING. R&R SIGN PER MM.SDR DALA2018122647401Light · brokenSHIP 3878 TWO ESCAPE PATH LIGHTS 28D AND 29D BROKEN OFF . CORRECTIVE ACTION: REPLACED LIGHT HOUSINGS AT 33D AND 29D (5099290).SDR QXEA2018122400466Light · looseCREW REPORTS CLEAR PLASTIC COVER ON LH FLOOR LIGHT STRIPS IS LIFTING AT ROW 18AB. REMOVED FROM SERVICE. RESECURED CLEAR PLASTIC COVER ON LH FLOOR LIGHTING STRIP @ 18B. NO OTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR IPXA2018122427160Bulb · inoperativeEMERGENCY LIGHT HAD ELEVEN BULBS INOPERATIVE. REPLACED THE BULBS IAW AMM 33-51-01-2.SDR IPXA2018122137153Lamp · inoperativeCREW BERTH EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE LAMPS & OPS TESTED OK IAW AMM 33-52-01.SDR REXA2018122411313Battery · dischargedEMER LTS ONLY STAY ON FOR 2 SECONDS WHEN PUT IN ON POSITION
CHARGED EMERGENCY LIGHTS FOR 4 HRS TEST GOOD PER AMM 33-51-00 OK FOR SERVICESDR SIMA201812241002Light · inoperativeRH TOP EXTERIOR EMERGENCY LIGHT INOP-C/A-RAR RH TOP EXTERIOR EMERGENCY LIGHT, OPC GOOD IAW AMM 33-50-10SDR DALA2018122427376Charger · defective(LOG 4818569) DURING INSPECTION FOUND DURING EMERGENCY LIGHT CHECK FOUND RT L7 OVERWING ESCAPE LIGHT RT OVERWING GROUND ILLUMINATION LIGHT INOPERATIVE. FOUND DEFECTIVE FUSE IN M1671 BATTERY CHARGER. REPLACED SAME PER B737 AMM 33-51-06. OPS CHECK GOOD.SDR CALA2018122432624Power Supply · inoperativeREFER TO NRC LOG PAGE NO.: 9130369, B777-33-3-0018 CABIN RH DR4 EMERG PWR SUPPLY M33409 CHARGE CAP CHECK FOUND FAIL. RH DR4 EMERG PWR SUPPLY M33409 POWER SUPPLY CHARGER REPLACED AND OPERATIONAL TEST RESULT NORMAL IAW AMM 33-51-06. ADD EMP:V898173 INSPECTED BY SDR CALA2018122432623Battery · dischargedREFER TO NRC LOG PAGE NO.: 9130371, B777-33-3-0018 CABIN LH DR2 EMERG PWR SUPPLY (M33099) BATTERY CAP CHECK FOUND FAIL. LH DR2 EMERG PWR SUPPLY (M33099) BATTERY PACK REPLACED AND OPERATIONAL TEST RESULT NORMAL IAW AMM 33-51-06. ADD EMP:V898173 INSPECTED BY HX1SDR DALA2018122407363Battery Pack · inoperativeEMERGENCY LIGHTS IN CEILING PANELS BETWEEN ROWS 22-31 NOT ILLUMINATING. REPLACED BATTERIES TO CHARGERS PER MD88 AMM 33-53. (LP5243663)SDR DALA2018122407359Lens · missingTRANSIT CHECK FOUND R1 DOOR EXIT IDENTIFIER LENS MISSING, REPLACED R1 DOOR EXIT IDENTIFIER LENSSDR DALA2018122417358Battery Pack · faultedEMERGENCY LIGHT TEST FAILED EPSU 15WL, REPLACED EPSU FAULTS BATTERYSDR SIMA20181221001Light · inoperativeEMERGENCY LIGHT BY ROW 4-6 ON THE FLOOR INOP-C/A-EMERGENCY LIGHT STRIP BY ROWS 4-6 DEFERREDSDR SWAA2019010327837Battery · failedEMERGENCY LIGHT BATTERY M1675 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010228148Battery · failedEMERGENCY EXIT LIGHT BATTERY PACK M1672 FAILED TEST. R&R BATTERY PER MM.SDR SWAA2019010227873Lens · unsecureCENTER AISLE EXIT SIGN LENS DISPLACED. SECURED LENS PER MM.SDR SWAA2019010227834Battery · failedEMERGENCY EXIT LIGHT BATTERY PACK M1673 FAILED TEST. R&R BATTERY PER MM.SDR ASAA20181227582Battery Pack · no testL/H ROWS 18-23 BULLNOSE, LH OUTSIDE OVERWING AND LH OUTSIDE OVERWING SLIDE EMERGENCY LIGHTS FAILED CAPACITY CHECK. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M1670 S/N 83621 IAW B737-800 AMM 33-51-06-960-805 STEP 4D(1) - (4).SDR AALA201812271003Battery Pack · inoperativeEMERGENCY LIGHT BATTERY IN THE MID CABIN, ABOVE THE L3 DOOR WAS INOPERATIVE. REPLACED THE POWER SUPPLY BATTERY PACK IAW AMM 33-51-06-960-802. OPS CHECKED GOOD.SDR YENA2018122600884Light · inoperativeDURING HEAVY MAINTENANCE, PAX CABIN SEAT 1C EMERGENCY PATH LIGHT LENS AND FIXTURE DAMAGED; REMOVED AND REPLACED SEAT ROW 1 LH EMERGENCY LIGHT ASSY IAW A320 AMM 33-51-18-000-001-A & 33-51-18-400-001-A. NR 440518-22312 FOR WORK PERFORMED. SUPPLEMENTAL INFORMATIOSDR AALA201812249007Control Unit · failedDURING AN A-CHECK, IAW WORKCARD 2803, FOUND THE EMERGENCY LIGHT AT THE L4 DOOR INOPERATIVE. MAINTENANCE PERFORMED FIM 33-50-F1-M8A-421A, AND FOUND THE WIRELESS CONTROL UNIT DEFECTIVE. REMOVED AND REPLACED THE CONTROL UNIT IAW AMM 33-51-07. CHECKED OK FOR SSDR AALA201812241002Lens · brokenR4 DOOR EMERGENCY LIGHT LENS WAS BROKEN. RELACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED OK.SDR AALA20181221009Charger · no testDURING AN EMERGENCY LIGHT TEST, FOUND SEVERAL SECTIONS OF THE EMERGENCY LIGHTS FAILED. THE AIRCRAFT WAS GROUNDED. REPLACED THE BATTERY AND CHARGER, OPS CHECKED OK IAW AMM 33-51-07, AND AMM 33-51-10.SDR AALA20181221008Charger · inoperativeLOST OF EMERGENCY LIGHTS AT SEVERAL SECTIONS DURING A TEST. THE AIRCRAFT WAS GROUNDED. REPLACED THE BATTERY AND CHARGER. OPS CHECKED OK IAW AMM 33-51-07, AND AMM 33-51-10.SDR AALA201812241004Charger · inoperativeEMERGENCY BATTERY CHARGER M33093 WAS INOPERATIVE ABOVE THE L1 DOOR. REPLACED THE BATTERY CHARGER IAW AMM 33-51-06-960-803. OPS CHECKED OK.SDR DALA201812217353Light · damagedSHIP 659 DURING S/C FOUND ROW 24 EMERGENCY SEAT TRACK LIGHT DAMAGED. CORRECTIVE ACTION: REPLACED SEAT 24 PATH LIGHT ASSY. OPS CK. (5006654)SDR DALA2018122107339Battery Pack · inoperativeFOUND LLCR EMERGENCY BATTERY FOR LIGHTS ARE INOPERATIVE. REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR REXA201812211312Relay · malfunctionedEMERGENCY LIGHT SYSTEM INOP
REMOVED AND REPLACED K1XD AC-ESSENTIAL BUS SENSE RELAY IAW CRJ 200 AMM 24-51-22 AND SLAVED IN PASSENGER SIGN/EMERGENCY LIGHT PANEL IAW CRJ 200 AMM 33-24-10.STILL NO HELP DEFECT REMAINS OPEN. INSTALLED ORIGINAL EME LIGHT PANEL BACK.SDR HNAA2018122100327Bulb · malfunctionedR/H FWD FUSELAGE EMERGENCY LIGHT DIM. R/R BULB IAW AMM 33-50-10-400-801-ASDR HNAA2018122100326Bulb · inoperativeMAIN DOOR EMERGENCY LIGHT INOP. R&R LIGHT BULBSDR MASA2018122011603Battery Pack · inoperativeEMERGENCY LIGHTS INOP. R&R 4 EMERGENCY BATTERIES, OPS CHECK GOODSDR MASA2018122011602Charger · inoperativeMULTIPLE CABIN EMER LIGHTS INOP. REPLACED EMER BATTERY AND CHARGER, OPS CK GOODSDR DALA2018122007297Cover · brokenTHE RIGHT AFT OVERWING EXIT SIGN COVER IS BROKEN. MAINTENANCE REPLACED THE EXIT SIGN COVER AT THE RIGHT AFT OVERWING EXIT HATCH PER AMM 33-50.SDR SWAA2019010427897Light · damagedRT FWD EEPLS STRIP DAMAGED. R&R EEPLS STRIP PER MM.SDR SWAA2019010328176Battery · failedEMERGENCY LIGHT BATTERY M1673 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010328175Battery · failedEMERGENCY LIGHT BATTERY M1672 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010328174Battery · failedEMERGENCY LIGHT BATTERY M1674 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010327831Light · inoperativeRT OVERWING EXTERIOR EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA2019010327820Battery · failedEMERGENCY LIGHT BATTERY M1672 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010227889Sign · looseMID CABIN CEILING EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA2018123127905Light · looseLT AFT LAV EXTERNAL EMERGENCY EXIT LIGHT LOOSE. SECURED LIGHT ASSY PER MM.SDR SWAA2018122827931Battery · failedEMERGENCY LIGHT BATTERY M1674 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR SWAA2018122827930Battery · failedEMERGENCY LIGHT BATTERY M1673 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR SWAA2018122827929Battery · failedEMERGENCY LIGHT BATTERY M1672 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR SWAA2018122827928Battery · failedEMERGENCY LIGHT BATTERY M1670 FAILED CAPACITY CHECK. R&R BATTERY PER MM.
Back to JASC 3350