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 SWAA2017101017005Lens · missingRT EMERGENCY EXIT LIGHT COVER LENS MISSING AT ROW 12. INSTALLED LENS PER AMM.SDR SWAA2017101016967Cover · missingMID CABIN EMERGENCY EXIT SIGN COVER MISSING. INSTALLED COVER IAW AMM.SDR SWAA2017101016957Light · inoperativeLT EMERGENCY AREA LIGHT INOP AT ROW 20. RELAMPED LIGHT PER AMM.SDR SWAA2017101016955Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R LIGHT PER AMM.SDR SWAA2017101016954Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M1672. R&R BATTERY PACK PER AMM.SDR AALA201710099029Light · damagedEMERGENCY LIGHT ADJACENT TO FORWARD SIDE OF RIGHT FORWARD DOOR IS DAMAGED. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201710099028Light · damagedEMERGENCY LIGHT ADJACENT TO AFT SIDE OF LEFT AFT DOOR IS DAMAGED. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR DALA2017100607387Lens · missingEMERGENCY LIGHT LENS MISSING, REPLACED THE SEAT MOUNTED EMERGENCY LIGHT AND BULB.SDR YENA201710050819Battery Pack · no testEPSU DIDN'T PASS A TEST, POWER SUPPLY 15WL. R & R THE BATTERY IAW AMM 33-51-38-020-053-A, & AMM 33-51-38-400-002-A. OPS TESTED OK.SDR YENA201710050818Battery Pack · no testEPSU DIDN'T PASS A TEST. . POWER SUPPLY 14WL R & R THE BATTERY IAW AMM 33-51-38-020-053-A, & AMM 33-51-38-400-002-A. OPS TESTED OK.SDR AALA201710069007Lens · detachedEMERGENCY EXIT SIGN BY THE R4 DOOR HAS A DETACHED LENS. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR ASOA201710055117Charger · inoperativeDURING INSPECTION, THE MAIN CABIN DOOR EMERGENCY LIGHT WAS DISCOVERED INOPERATIVE. REMOVED AND REPLACED THE BATTERY CHARGER, OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2017100607329Cover · looseEMERGENCY EXIT SIGN COVER LOOSE. TIGHTENED & ADJUSTED THE SIGN COVER.SDR SWAA2017100616918Cover · crackedR2 DOOR EMERGENCY EXIT LIGHT COVER CRACKED. R&R COVER PER MM.SDR AALA201710069014Battery · inoperativeEMERGENCY POWER SUPPLY UNIT 15WL BATTERY INOPERATIVE.SDR AALA201710069013Lens · brokenSEAT ISLE EMERGENCY LIGHT COVER BROKEN AT SEATS 11. REPLACED THE EMERGENCY LIGHT LENS.SDR AALA201710069012Battery · failedMID RIGHT EMERGENCY POWER SUPPLY BATTERY FAILED. REMOVED AND REPLACED THE BATTERY IAW AMMSDR FDEA201710052869Light · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOP ON SVC CHK. AMM 33-51-06-2-1 RELAMPED, OPS CHK GOOD.SDR JJBA20171005003Lamp · unsecureFIRST CEILING EMERGENCY LIGHT INOPERATIVE. ADJUSTED THE LAMP, OPS CHECKED GOOD.SDR YENA201710050817Power Supply · failedRIGHT EXTERIOR FWD EMERGENCY LIGHT INOPERATIVE. R & R THE NR 3 ELPU IAW MM 33-50-01. OPS CHECKED GOOD.SDR MASA2017100512687Battery Pack · dischargedROW 12 LOWER EMERGENCY EXIT SIGNS INOPERATIVE. CHARGED THE BATTERIES.SDR SIMA20171004011Wire · damagedEMERGENCY LIGHT HAD WIRE INSULATION DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12.SDR SIMA20171004012Light · damagedLEFT CABIN FLOOR, FIVE EMERGENCY LIGHT EXTRUSIONS CRACKED. R & R THE LIGHTS IAW AMM 33-50-12-04.SDR SWAA2017101016976Light · brokenR2 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR AALA201710069018Light · inoperativeEMERGENCY LIGHT AT BS 1040 RIGHT BULKHEAD FOUND INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY.SDR AALA201710069017Light · inoperativeEMERGENCY LIGHT AT BS 1040 LEFT BULKHEAD, IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY.SDR CALA2017100603433Battery Pack · dischargedEMERGENCY BATTERY PACK CAPACITY LOW, REPLACED THE BATTERY PACK AND CARRIED OUT OP TEST, FOUND GOOD IAW AMM 33-51-06-960-803, REV 80.SDR CALA2017100603432Light · brokenEMERGENCY LIGHTS FOUND BROKEN. REPLACED THE M/D M1 GALLEY & A4 GALLEY LOWER EMERGENCY LIGHTS AND OPS CHECKED GOOD IAW AMM 33-51-05-960-802, REV 80.SDR DALA2017100507343Sign · detachedL1 DOOR EXIT SIGN DETACHED. ATTACHED THE SIGN.SDR SWAA2017100616946Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01674. R&R BATTERY PER MM.SDR SWAA2017100616945Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PER MM.SDR SWAA2017100616944Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PER MM.SDR SWAA2017100616943Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PER MM.SDR SWAA2017100616942Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PER MM.SDR SWAA2017100616941Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PER MM.SDR SWAA2017100616938Light · damagedRT PHOTO LUMINESCENT EMERGENCY EGRESS STRIP DAMAGED AT ROW 1. R&R STRIP IAW AMM.SDR SWAA2017100616934Light · damagedLT PHOTO LUMINESCENT EMERGENCY EGRESS STRIP DAMAGED AT ROW 1. R&R STRIP IAW AMM.SDR SWAA2017100616933Battery Pack · dischargedLT OVERWING EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017100616928Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01668. R&R BATTERY PER MM.SDR SWAA2017100616920Sign · brokenMID CABIN EMERGENCY SIGN BROKEN. R&R SIGN PER MM.SDR AALA201710059015Battery · no testEMERGENCY POWER SUPPLY FWD LEFT AND AFT LEFT WOULD NOT TEST. REMOVED AND REPLACED EMERGENCY POWER SUPPLY BATTERY IAW AMM.SDR AALA20171005003Battery Pack · no testDURING CHECK, FOUND CIDS NR 1 EMERGENCY POWER SUPPLY UNIT TEST BATTERY FAULT AT 15WL. INSTALLED SERVICABLE BATTERY PACK IAW AMM 33-51-38. AIRCRAFT WAS GROUNDED.SDR REXA2017100401063Sign · faultyWHITE LIGHT FLICKERING IN OVERHEAD EXIT SIGN. REPLACED EXIT SIGN HOUSING ASSY IAW AMM 33-51-07, OP CHECKS GOOD IAW 33-51-00.SDR UIEA2017100401927Unknown · malfunctionedEMERG LIGHTS FLASHING CONTINUOSLY IN CABIN. INSPECTED EMERGENCY LIGHTS SYSTEM CKD GOOD IAW 33-51-00.SDR SIMA20171004003Bulb · inoperativeEMERGENCY LIGHTS AT MAIN ENTRANCE AND GALLEY INOPERATIVE. R & R THE BULBS IAW AMM 33-50-06, AND 33-50-09. OPS CHECKED GOOD.SDR SIMA20171004002Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EXTERNAL EMERGENCY LIGHT ASSY IAW AMM 33-50-10. OPS CHECKED GOOD.SDR AALA20171004016Battery Pack · inoperativeEMERGENCY EXIT LIGHT IN THE CEILING BY THE AFT SERVICE DOOR IS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK B5-107 IAW AMM 33-53-00. OPS CHECKED GOOD.SDR SWAA2017100516914Light · looseAFT LT LAV EMERGENCY LIGHT ASSEMBLY LOOSE. SECURED LIGHT ASSEMBLY PER AMM.SDR DALA2017100507295Switch · malfunctionedWHEN ARMED, THE EMERGENCY LIGHTS ILLUMINATED CONTINUOUSLY. EXERCISED EMERGENCY LIGHT SWITCH. OPS CHECKED OK.SDR AALA201710059019Lens · missingCABIN CEILING EMERGENCY LIGHT LENS ABOVE ROW 13, MISSING. REPLACED EMERGENCY LIGHT.
Back to JASC 3350