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 R61A201807030739Battery · dischargedEMERGENCY LIGHT INOP. R&R EMERGENCY LIGHT POWER UNIT BATTERY IAW AMM 33-50-01. OPS CHECK GOOD.SDR ASAA2018070225238Power Supply · inoperativeL1 DOOR EMERGENCY LIGHT DOES NOT COME ON WHEN TESTED. GROUNDED - YES. REMOVED AND REPLACED POWER SUPPLY FOR L1 DOOR EMERGENCY LIGHTS (SN: 39787) IAW AMM 33-51-06-960-806.SDR AALA201807029050Lens · missingL4 DOOR, EMERGENCY EXIT LIGHT MISSING THE LENS. MAINTENANCE INSTALLED THE LENS IAW AMM 33-51-13-400-001-A, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018070230001Power Supply · malfunctionedEMERGENCY POWER SUPPLY AT THE L2 DOOR DOES NOT WORK PROPERLY. REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD. OK FOR SERVICE.SDR DALA2018070204306Lens · missingEMERGENCY EXIT SIGNS INOPERATIVE, LOCATIONS:606 INTERIOR. EMERGENCY SIGN IS MISSING LENS COVER. INSTALLED LENS COVER, OPERATION NORMAL.SDR IPXA2018070231311Light · inoperativeEMERG LIGHT IN LAV BURNT OUT. R&R EMERGENCY EGRESS LIGHT IN LAV REF AMM 33-51-21. OPS CHECK NORMAL.SDR MASA2018062913360Light · inoperativeROW 11 CEILING EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR ASAA2018062825280Battery Pack · dischargedL2 DOOR EMERGENCY LIGHT DOES NOT COME ON WHEN TESTED. GROUNDED - YES. REMOVED AND INSTALLED SERVICEABLE EMERGENCY BATTERY PACK S/N 69455 IAW AMM 33-51-06-960-805 FOR L2 DOOR EMERGENCY LIGHTS. OPS CK GOOD IAW AMM 33 51 06 960 805 STEPS 4 D 5, B, 1.SDR SWAA2018070223267Battery Pack · dischargedFORWARD EMERGENCY LIGHT BATTERY PACKS INOP AT LOCATION M1675. R&R BATTERY PACK PER AMM.SDR SWAA2018070223266Power Supply · inoperativeAFT EMERGENCY LIGHT OUTBOARD INOP. R&R POWER SUPPLY PER AMM.SDR SWAA2018070223209Battery Pack · dischargedFORWARD EMERGENCY LIGHT BATTERY PACKS INOP AT LOCATION M1674. R&R BATTERY PACK PER AMM.SDR SWAA2018070223176Battery Pack · dischargedAFT EMERGENCY LIGHT OUTBOARD INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018070223174Power Supply · inoperativeFORWARD ENTRY DOOR EMERGENCY LIGHT INOP AT BS 317, LBL 10. R&R POWER SUPPLY IAW AMM AND WDM.SDR CALA2018070301553Lens · missingM/D DOOR 1 CTR PARTITION 1EA CTR LWR EMER LIGHT LENS FOUND MISSING. REPLACED THE CABIN DOOR 1 CTR PARTITION 1EA CTR LWR EMERGENCY LT AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-05-960- 802 REV 83.SDR CALA2018070301552Light · brokenM/D L2 FWD & AFT L3 DOOR FWD EXIT IDENT 3EA FOUND BROKEN. REPLACED THE DOOR L2 FWD & AFT L3 DOOR FWD EXIT INDICATOR LIGHT AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-01-960- 802 REV 83.SDR CALA2018070301551Housing · brokenM/D L1 & L4 DOOR AREA 2EA EXIT IDENT'S HOUSING FOUND BROKEN. REPLACED THE CABIN L1 FWD & L4 DOOR AFTER AREA 2EA EXIT INDICATORS AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-01-960-802 REV 83.SDR CALA2018070301550Battery · lowFOUND CABIN LT NR 3 DOOR AREA EMEERGENCY PWR SUPPLY M33400 LOW CAPACITY. REPLACED THE CABIN L3 DOOR AREA EMERGENCY PWR SUPPLY BATTERY M33400 AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06 -960-802 REV 83.SDR CALA2018070301549Battery · lowFOUND CABIN RT NR 4 DOOR AREA EMERGENCY LT PWR SUPPLY M33409 LOW CAPACITY. REPLACED THE CABIN R4 DOOR AREA EMERGENCY LIGHT PWR SUPPLY BATTERY M33409 AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06 -960-802 REV 83.SDR CALA2018070301548Battery Pack · lowFOUND CABIN LT NR 3 DOOR AREA EMERGENCY POWER SUPPLY M33406 LOW CAPACITY. REPLACED THE CABIN L3 DOOR AREA EMERGENCY POWER SUPPLY BATTERY M33406 AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06 -960-802 REV 83.SDR CALA2018070301547Battery · lowFOUND CABIN RT NR 3 DOOR AREA EMERGENCY LT PWR SUPPLY M33401 LOW CAPACITY. REPLACED THE CABIN R3 DOOR AREA EMERGENCY PWR SUPPLY BATTERY M33401 AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06 -960-802 REV 83.SDR CALA2018070301546Battery · lowFOUND CABIN LT NR1 DOOR AREA EMERGENCY LT POWER SUPPLY M33093 LOW CAPACITY. REPLACED THE CABIN L1 DOOR AREA EMERGENCY LIGHT POWER SUPPLY BATTERY M33093 AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-960-802 REV 83.SDR CALA2018070301545Battery Pack · lowFOUND CABIN RT NR 1 DOOR AREA EMERGENCY LT PWR SUPPLY M33094 LOW CAPACITY. REPLACED THE CABIN RT NR1 DOOR AREA EMERGENCY LIGHT PWR SUPPLY BATTERY M33094 AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-960-802 REV 83.SDR ASAA2018070225245Lens · brokenL2 EXIT SIGN LENS BROKEN, WILL NOT ATTACH & STAY IN PLACE. GROUNDED - YES. REMOVED AND REPLACED L2 EXIT SIGN LENS.SDR DALA2018070204318Battery Pack · dischargedDURING INSPECTION FOUND EMERGENCY LIGHTS ABOVE AISLE AT SEATS 10, 12 AND 14 ABC INOPERATIVE. MAINTENANCE FOUND BATTERY PACK INOPERATIVE. R&R BATTERY PACK PER AMM 33-51. OPS CKS OK.SDR DALA2018070204308Sign · unsecure2R DOOR EMERGENCY EXIT SIGNAGE FELL OFF IN FLIGHT. REATTACHED 2R DOOR EMERGENCY EXIT SIGNAGE.SDR DALA2018062904273Power Supply · inoperativeTWO EMERGENCY LIGHTS WERE INOPERATIVE. REPLACED THE POWER SUPPLY IAW MM 33-50. OP CHECKED GOOD.SDR IPXA2018062983153Light · malfunctionedEMERGENCY LIGHTS NOT WORKING, IN BOTH AUTO AND ON . LIGHTS OPS CHECKED GOOD IAW AMM 33-51-00, NO FAULTS NOTED.SDR SWAA2018070223184Light · inoperativeRT OVERWING EXIT INTERIOR LOWER FORWARD EMERGENCY EXIT LIGHT BULB INOP. R&R BULB IAW AMM.SDR REXA2018070300589Sign · missingEXIT SIGN OVER EXIT ROW MISSING. MAINTENANCE PROCEDURES COMPLIED WITH. INSTALLED EMERGENCY EXIT SIGN COVER IAW AMM 335107. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR REXA2018070200585Light · inoperativeLT OVERWING EMER LIGHT OUT. R&R LT WING INSPECTION LIGHT IAW 33-51-15. OPS CHECK NORMAL.SDR YENA201807020273Light · inoperativeFLT 1905, EWR-FLL. EMERGENCY LIGHTING ON SEAT 1C & 19C INOP (FLOOR PROX EMERG ESCAPE PATH MARK SYS - INCANDESCENT LIGHTING SYS - NOT APPLICABLE TO (N703 AND UP). REPLACED ESCAPE LIGHT ROW 1L AND 19R HARNESS REF ESPM 20-70-00. OPS CHECK GOOD.SDR ASOA201807024034Inverter · inoperativeIAH - FLIGHT 4085, DURING MAINTENANCE INSPECTION, NUMEROUS EMERGENCY LIGHTS FAILED TO ILLUMINATE. MAINTENANCE REMOVED AND REPLACED AN EMERGENCY LIGHT INVERTER, OPERATIONALLY TESTED WITH NO DEFECTS NOTED AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2018063004298Light · inoperativeSEAT ROW 21 EMERGENCY LIGHT INOP. RELAMPED SEAT 21 EMER BULBS PER AMM 33-53-01. CHECKS GOOD.SDR AALA20180629003Battery Pack · failedAIRCRAFT WAS GROUNDED. FAILED BATTERY PACK (M1695), SIC 2908. MAINTENANCE REPLACED BATTERY PACK (M1695) PER AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR ASAA2018062725227Sign · unsecureEXIT SIGN CAME OFF EXIT ROW AREA AIRCRAFT LEFT. GROUNDED - YES. REATTACHED EXIT SIGN AT MID CABIN AC LEFT OK FOR SERVICE.SDR SIMA20180627004Light · inoperativeNR 3 EMERGENCY FLOOR LIGHT STRIP INOP. REMOVED AND REPLACED NR 3 EMERGENCY FLOOR LIGHT STRIP IAW AMM 33-50-12. OPC GOOD.SDR SIMA20180627005Power Unit · failedEMERGENCY LIGHT ON CEILING PANEL BETWEEN OVERHEAD BIN 12 AND 13 INOP. FOUND EMERGENCY LIGHT AT CEILING PANEL BETWEEN OVHD BIN 12 AND 13 INOP. REMOVED AND REPLACED EMERGENCY LIGHT LAMP IAW AMM 33-50-13. OPS CHK NO GOOD IAW AMM 33-50-00. REINSTALLED ORIGINAL EMESDR SWAA2018062823171Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM.SDR SWAA2018062823170Bezel · crackedLT PASSENGER CABIN EMERGENCY LIGHT BEZEL CRACKED AT ROW 19. R&R LIGHT PER AMM.SDR SWAA2018062823164Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2018062823157Lens · crackedLT PASSENGER CABIN EMERGENCY LIGHT LENS CRACKED AT ROW 23. R&R LENS PER AMM.SDR SWAA2018062823156Bezel · crackedRT PASSENGER CABIN EMERGENCY LIGHT BEZEL CRACKED AT ROW 25. R&R LIGHT PER AMM.SDR SWAA2018062823154Charger · inoperativeL1 EMERGENCY ESCAPE SLIDE LIGHT INOP. R&R BATTERY PACK CHARGER PER AMM.SDR DALA2018062704238Light · inoperativeEMERGENCY LIGHT IN TAIL CONE AREA INOP. RELAMPED PER 33-50. CKS OK.SDR DALA2018062704237Battery Pack · dischargedFOUND AFT OVERWING EXIT LIGHTS INOP. R&R BATTERY PACK B5-105 PER AMM 33--53, CHK OK.SDR DALA2018062704233Light · inoperativeSEAT ROW 16 EMERGENCY LIGHT INOP. REPLACED LIGHT ASSY PER AMM 33-50.SDR MASA2018062713355Light · inoperativeROW 6 OVHD EMERG LIGHT INOP. PLACED ON MEL.SDR DALA2018072404644Lens · missingRED LENS COVER MISSING ON FLOOR PROXIMITY LIGHT ON SIDE OF GALLEY NEXT TO THE 4R DOOR. REPLACED LENS COVER PER AMM 33-51-05.SDR HNAA2018070400129Sign · inoperativeEMERGENCY LIGHT ABOVE SERVICE DOOR WILL NOT ILLUMINATE. R&R EMERGENCY EXIT MARKING SIGN IN REF TO AMM 33-50-14-000/400-801-A. P/N ON EXIT SIGN 1013834, P/N OFF EXIT SIGN 1013834.SDR YENA201807020264Battery · dischargedDURING HEAVY MAINTENANCE, EMERGENCY LIGHT FAIL MESSAGE "EPSU INT LOAD FWD L" AND "EPSU ARMED / ON AFT L" DURING PTP TEST; REMOVED AND REPLACED EPSU 13WL IAW AMM 32-51-38. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-38. RE-TERMINATED PIN C OF 13WL-A CONNECT
Back to JASC 3350