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 AALA20161125019Lens · detachedAIRCRAFT NOT GROUNDED. RIGHT FORWARD OVERWING EMERGENCY EXIT LIGHT LENS COVER DETACHED. SECURED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR MASA2016112412499Bulb · inoperativeOVERHEAD CENTER ISLE EMERGENCY EXIT LIGHT THREE BULBS INOPERATIVE. REPLACED THE BULBS.SDR N6WA2016112401Light · inoperativeAFT EMERGENCY CEILING LIGHT INOPERATIVE.SDR MASA2016112412496Light · inoperativeROW 18 EMERGENCY LIGHT INOPERATIVE.SDR VNAA2016112300034Relay · faultedEMERGENCY LIGHTS FLASHING IN ARMED POSITION. MAINTENANCE REMOVED AND REPLACED JB 11 PCBS RELAY K135.SDR SWAA2016112910029Sign · unserviceableR1 DOOR EXIT SIGN MISSING RED ARROW. R&R SIGN PER AMM.SDR SWAA2016112810013Sign · missingL2 LOWER EXIT SIGN MISSING DIRECTIONAL ARROW. R&R SIGN PER AMM.SDR SWAA2016112810012Battery · failedEMERGENCY BATTERY AT LOCATION M1673 FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2016112810009Light · inoperativeL2 DOOR EMERGENCY LIGHT AFT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2016112809978Lens · looseCEILING EMERGENCY LIGHT LENS LOOSE AT ROW 24. SECURED THE LENS IAW AMM.SDR SWAA2016112809931Battery · no testEMERGENCY BATTERY M1675 FAILED CAPACITY CHECK. R & R THE BATTERY IAW AMM.SDR ASAA2016112318818Light · inoperativeFWD OVERWING EMERGENCY EXIT EXTERIOR LIGHT INOP. GROUNDED - YES. REMOVED AND REPLACED RT FWD OVERWING EXIT LIGHT BULB REF AMM 33-51-04.SDR JJBA20161123029Light · inoperativeEMERGENCY LIGHT EXIT ROW 18 INOPERATIVE. R & R THE LIGHT AND OPS CHECKED GOOD.SDR DALA2016112709253Light · damagedRIGHT HAND OVERWING ESCAPE LIGHT INOPERATIVE AND DAMAGED. INSTALLED ROBBED ASSEMBLY AND RELAMPED. OPERATION CHECKS GOOD.SDR AALA201611259011Lens · brokenL1 DOOR EMERGENCY LIGHT COVER BROKEN. REPLACED BROKEN L1 DOOR EMERGENCY LIGHT LENS COVER IAW AMM 33-51-13. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201611259010Power Supply · faultyEMER LIGHTS ON SEATS AT ROW 3, 6, 14, +18 INOP. R&R EPSU & BATTERY ASSY (15WL) IAW AMM 33-51-38-0401-00. OPS CKS GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20161125016Screw · looseAIRCRAFT NOT GROUNDED. SUPPORT BAR FOR EMERGENCY EXIT LIGHT AT 24H HAS A LOOSE SCREW. SECURED SCREW IN SUPPORT BAR IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161125009Battery · dischargedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHTS FAILED CIDS TEST AT 10WL, FORWARD LEFT EPSU. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20161123029Battery Pack · inoperativeEMERGENCY LIGHTS BETWEEN ROWS 9 AND 15 ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW 33-51-07/901-001. OPS CHECKED NORMAL.SDR HALA2016112300215Light · looseEMERGENCY LIGHT STRIP FLIGHT DECK ENTRY IS LOOSE. REPLACED FLIGHT DECK ENTRY AND FIRST CLASS GALLEY EMERGENCY LIGHT STRIP.SDR AALA20161123005Power Supply · inoperativeL3 DOOR EMERGENCY POWER SUPPLY, M33400, IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL TEST IAW AMM 33-51-06.SDR HNAA2016112300359Bulb · inoperativeEMERGENCY SWITCH LIGHT "NORM" BACK LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR HNAAQ201611230035Battery Pack · inoperativeSEVERAL EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY IAW WORK CARD 33-50-05R. OPS CHECKED GOOD.SDR HNAA2016112300357Light · inoperativeTHIRD RED EMERGENCY FLOOR LIGHT IS INOPERATIVE AT ROW 4DF. REMOVED AND REPLACED THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR HNAA2016112300356Bulb · inoperativeLEFT FORWARD EMERGENCY EGRESS LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR ASOA201611221316Charger · failedEMERGENCY CEILING LIGHTS IN FIRST CLASS INOP. REMOVED AND REPLACED NR 2 EPSU BATTERY CHARGER IAW AMM 33-51-17. OPS CHECK GOOD.SDR ASOA20161122237Light · inoperativeLEFT OVER WING EMERGENCY EXIT INTERIOR LOWER LIGHT INOP. REMOVED AND REPLACED LEFT OVER WING EMERGENCY EXIT INTERIOR LOWER LIGHT IAW AMM 33-51-10.SDR SWAA2016120110102Lens · dirtyEMERGENCY LIGHT LENS DIRTY AT BS 1000, LBL 60. CLEANED LENS IAW SOPM.SDR SWAA2016120110101Lens · dirtyEMERGENCY LIGHT LENS DIRTY AT BS 757, LBL 51. CLEANED LENS IAW SOPM.SDR SWAA2016112810015Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER DWG AND AMM.SDR SWAA2016112810014Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER DWG AND AMM.SDR SWAA2016112810007Lens · brokenRT OVERWING EMERGENCY EXIT LIGHT LENS BROKEN. R&R LENS IAW AMM.SDR SWAA2016112810005Cover · missingRT LOWER EMERGENCY EXIT LIGHT LENS COVER MISSING. INSTALLED COVER PER MM.SDR SWAA2016112810002Switch · faultyEMERGENCY LIGHT FAULTY. R&R SWITCH IAW AMM.SDR SWAA2016112809975Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R & R THE BATTERY IAW DWG AND AMM.SDR SWAA2016112809934Cover · crackedL1 DOOR EMERGENCY EXIT LENS COVER CRACKED. R & R THE COVER IAW SIP.SDR SWAA2016112809929Lamp · inoperativeRIGHT EXTERNAL EMERGENCY LIGHT INOPERATIVE AT BS 360. R & R THE LAMP IAW AMM AND WDM.SDR VNAA2016112200032Light · malfunctionedEMERGENCY LIGHTS STAY ON IN ARMED POSITION.SDR AALA20161125005Sign · detachedEMERGENCY EXIT SIGN ABOVE SEATS 21ABC DETACHED. INSTALLED THE SIGN ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201611239022Lens · looseEMERGENCY LIGHT LENS FOUND LOOSE AT 2L DOOR. REPLACED THE LENS AND OK FOR SERVICE.SDR DALA2016112300214Battery Pack · no testEMERGENCY LIGHT BATTERIES FAILED CAPACITY CHECK. REPLACED THE EMERGENCY BATTERY PACKS IAW AMM 33-51.SDR DALA2016112300213Lens · missingDURING SERVICE CHECK FOUND 1 EMERGENCY LIGHT LENS COVER AT AFT R4 DOOR. REPLACED THE LENS.SDR AALA20161122029Battery Pack · inoperativeFIRST CLASS SEAT MOUNTED EMERGENCY LIGHTING IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY PACK IAW AMM 33-51-07. OPERATIONAL CHECKED NORMAL.SDR AALA20161122027Power Supply · inoperativeDOOR INTERIOR EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY IAW AMM 33-51-06.SDR AALA20161122025Power Supply · inoperativeR1 DOOR INTERIOR, R1 DOOR EXTERIOR AND FIRST CLASS SEAT EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY IAW AMM 33-51-06.SDR FDEA201611224186Lamp · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. FOUND ON POST FLIGHT OPS CHECK. REPLACED THE LAMP IAW AMM: 33-51-04-2. LIGHTS TESTED GOOD, OK FOR SERVICE.SDR FDEA201611224184Power Supply · no testEMERGENCY BATTERY 1 LOW, ALERT DURING EMERGENCY LIGHTS TEST ON PREFLIGHT. TEST FAILED FOR POWER SUPPLY ASSY. REMOVED AND REPLACED THE POWER SUPPLY IAW MM 33-51-01-4 AND TESTED IAW MM 33-51-00-5. TEST PASSED. ACFT OK FOR SERVICE.SDR HALA2016112200211Light · brokenEMERGENCY LIGHTING AT FLIGHT DECK ENTRY IS BROKEN. SECURED EMERGENCY LIGHTING.SDR AALA20161122020Battery Pack · faultyEMERGENCY LIGHTING INOPERATIVE BETWEEN ROW 26C AND DOOR R4. REMOVED AND REPLACED TWO CONTROL MODULES AND TWO BATTERY PACKS.SDR AALA20161122019Battery Pack · faultyEMERGENCY LIGHTING INOPERATIVE BETWEEN ROW 26C AND DOOR R4. REMOVED AND REPLACED TWO CONTROL MODULES AND TWO BATTERY PACKS.
Back to JASC 3350