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 REXA2017111801182Lens · crackedAFT EMERGENCY LIGHT LENS CRACKED. R&R AFT EMERGENCY LIGHT LENS IAW AMM 33-51-15. OPS CHECKED GOOD P/N OFF AND INSTALLED 9EL400042-11.SDR SWAA2017112017917Bracket · missingMID CABIN OVERHEAD EMERGENCY EXIT SIGN BRACKET MISSING. SECURED SIGN IAW AMM.SDR DALA2017112008216Power Supply · inoperativeEMERGENCY LIGHTS FOR SEATS ROWS 31 AFT INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY AND BATTERIES IAW AMM 33-53. OPS CHECKED GOOD.SDR MASA2017111812772Light · inoperativeO/H EMER FLOOD LIGHT ROW 9 INOP. PLACED ON MEL.SDR ASAA2017111722626Lens · detachedR1 DOOR EXIT SIGN LENS DETACHED. ACFT GROUNDED. REMOVED AND REPLACED R1 DOOR LOWER FWD EXIT SIGN ASSY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR FDEA201711173253Lens · detachedL1 DOOR AFT EMERGENCY LENS DETACHED. COMPLIED WITH EA G-3350-T0336667, PART 3. INSTALLED THE LIGHT ASSY AND OPS CHECKED GOOD IAW MM 33-51-01-2.SDR SWAA2017112117947Lens · missingR2 DOOR EXIT LIGHT LENS COVER MISSING. INSTALLED LENS PER SIP.SDR SWAA2017112117931Lamp · inoperativeRIGHT INTERIOR EMERGENCY EXIT LIGHT INOPERATIVE AT ROW 12. REPLACED THE LAMPS IAW MM.SDR SWAA2017112117929Cover · missingLEFT LOWER OVERWING DOOR EMERGENCY EXIT SIGN COVER MISSING. REPLACED THE COVER IAW AMM.SDR SWAA2017112117928Lens · brokenFORWARD ENTRY EXIT LIGHT LENS BROKEN. R & R THE LENS IAW AMM.SDR AALA201711199009Battery · faultedEXT R FAULT CODE FOUND DURING EMERGENCY LIGHT TEST. REPLACED THE POWER SUPPLY BATTERY IAW AMM 33-51-00.SDR AALA201711199008Battery · faultedDURING EMERGENCY POWER SUPPLY UNIT SYSTEM TEST, BATTERY 10WL FAULTED. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201711199002Lens · missingL2 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS PER AMM 33-51-13 OPS CHECKED GOOD.SDR ASAA2017111722625Light · out of positionEXTERIOR EMERGENCY LIGHT AFT OF R2 DOOR IS INOP. GROUNDED - YES. REPOSITION BULB IN SOCKET OF LIGHT ASSY, OPS NML REF AMM 33-51-04-960-801 AND REF AMM 33-51-00-720-801.SDR F3LA2017112000258Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT WILL NOT ILLUMINATE. AIRCRAFT CONSIDERED AOG. REMOVED AND REPLACED RT OVERWING EMERGENCY LIGHT ASSY IAW AMM 33-51-15 PB401. OPS CHECK GOOD PER AMM TASK
33-51-00-710-001-A. AIRCRAFT OKAY FOR CONTINUED SERVICE.SDR HALA2017111700260Sign · brokenEXIT SIGN AT SEAT 37L BROKEN, RE-SECURED EXIT SIGN.SDR DALA2017112008234Light · inoperativeDOOR 3R AND 4R EXTERIOR EMERGENCY LIGHTS INOP. RELAMPED AND TEST OK PER AMM 33-51.SDR DALA2017112008232Light · inoperativeDURING INSPECTION FOUND EMERGENCY LIGHT ASSY AT GALLEY G1 INOPERATIVE. MAINTENANCE R&R LIGHT ASSEMBLY IAW B737-800 AMM 33-51. OPS CHK OK.SDR DALA2017112008219Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE, ROW 27 AFT TO REAR DOOR. REPLACED THE BATTERIES IN PAX OVERHEAD BIN 33. OPS CHECKED OK.SDR DALA2017111708214Battery Pack · inoperativeCOCKPIT OVERHEAD EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK IAW AMM 33-53. OPS CHECKED GOOD.SDR REXA2017111701180Charger · inoperativeEXTERIOR EMERGENCY LIGHT BY THE SERVICE DOOR INOPERATIVE. REMOVED AND REPLACED THE BATTERY CHARGER ASSEMBLY FOR BATTERY PACK NR 2 IAW AMM 33-51-17. OPS CHECKED NORMAL. LIGHT WORKS NORMALLY.SDR CALA2017111704136Inverter · inoperativeGREEN EMERGENCY LIGHT INOPERATIVE AT 21F. FOUND INVERTER FAILED (M10950). REPLACED THE INVERTER AND OPS CHECKED GOOD.SDR CALA2017111704135Inverter · failedGREEN EMERGENCY EXIT INDICATOR LIGHT INOPERATIVE AT 20A, FOUND THE INVERTER FAILED (M10950). REPLACED THE INVERTER AND OPS CHECKED GOOD.SDR CALA2017111704131Light · intermittentR3 DOOR SLIDE ARMED LIGHT INTERMITTENT. REPLACED AND SECURED THE LIGHT ASSY. OPS CHECKED OK.SDR CALA2017111704129Battery · faultedDURING AN EMERGENCY LIGHTS TEST, HAD AN EPSU BATTERY MESSAGE. REPLACED THE BATTERY PACK IAW MM 33-51-38. OPS CHECKED GOOD.SDR CALA2017111704126Lens · missingMISSING EMERGENCY EXIT LIGHT LENS UNDER SEAT 32A. INSTALLED THE LENS.SDR CALA2017111704123Light · crackedEMERGENCY EXIT SIGN LIGHT BASE AT THE R2 DOOR CRACKED. R & R LIGHT BASE IAW AMM 33-51-02SDR CALA2017111704122Light · crackedEMERGENCY EXIT SIGN BASE AT THE L2 DOOR IS CRACKED. R & R THE LIGHT BASE IAW AMM 33-51-02.SDR CALA2017111704121Light · inoperativeEMERGENCY LIGHTING CHECK FOUND A LIGHT AT THE OVER HEAD BIN 31ABC TO BE INOPERATIVE. SECURED THE LIGHT ASSY, OPS CHECKED NORMAL.SDR CALA2017111704118Connector · disconnectedEMERGENCY LIGHT INOPERATIVE. FOUND THE CONNECTER DISCONNECTED. CONNECTED IAW CMM 25-4 0-09, OPS CHECKED GOOD.SDR CALA2017111704117Battery Pack · inoperativeEMERGENCY EXIT LIGHTS AT THE L1 DOOR INOPERATIVE. REPLACED THE BATTERY PACK IAW MM 33-51-06. LIGHTS OP CHECKED GOOD.SDR CALA2017111704115Light · crackedLEFT UPPER AND LOWER OVERWING INTERIOR EMERGENCY LIGHT BASE CRACKED. REPLACED THE EMERGENCY LIGHT BASE IAW AMM 33 -51-01-960-802.SDR CALA2017111704114Light · crackedL2 DOOR INTERIOR EMERGENCY LIGHT BASE CRACKED. REPLACED THE EMERGENCY LIGHT BASE IAW AMM 33 -51-01-960-802.SDR CALA2017111704113Light · crackedR2 DOOR INTERIOR EMERGENCY LIGHT BASE CRACKED. REPLACED THE EMERGENCY LIGHT BASE IAW AMM 33 -51-01-960-802.SDR CALA2017111704112Light · crackedRIGHT UPPER OVERWING INTERIOR EMERGENCY LIGHT BASE CRACKED. REPLACED THE EMERGENCY LIGHT BASE IAW AMM 33 -51-01-960-802.SDR CALA2017111704109Lamp · inoperativeR4 DOOR SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-06. OPS CHECKED SATISFACTORY.SDR CALA2017111704104Power Supply · faultyR1 DOOR EMERGENCY EXIT SIGN FOUND DIM. THE POWER SUPPLY M1552 WAS REPLACED AND OPS TESTED NORMAL IAW AMM 33-31-07.SDR CALA2017111704103Light · dimR2 DOOR FWD EMERGENCY LIGHT FOUND DIM. THE EMERGENCY LIGHT REPLACED AND OPS CHECKED NORMAL IAW AMM 33-51-10.SDR CALA2017111704120Light · brokenROW 20C EMERGENCY LIGHT BROKEN. REPLACED THE LIGHT ASSY.SDR CALA2017111704133Lamp · inoperativeR4 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS, TESTED OK.SDR CALA2017111704132Lamp · inoperativeL4 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS , TESTED OK.SDR DALA2017111708202Battery Pack · inoperativeCAT WALK EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW MM. OPS CHECKED GOOD.SDR CALA2017111704098Light · malfunctionedEMERGENCY LIGHT FAILED DURING AN A-10 CHECK IAW 33-51- 38. SIDS PANEL BATTERY TEST PUSHBUTTON ON PTP FAILED. ALL EMERGENCY LIGHTS IN CABIN CHECKED WITH FLIGHT DECK SWITCH & AFT FLIGHT ATTENDANT PANEL. RESET BREAKERS SYSTEM CHECKED GOOD.SDR UIEA2017111702254Power Supply · inoperativeFLOOR EMERGENCY EXIT LIGHT INOPERATIVE AT THE R2 & L2 DOORS. REPLACED THE BATTERY POWER SUPPLY IAW AMM 33-51-07. CHECKED GOOD.SDR MASA2017111712766Light · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. OPS CHECKED GOOD.SDR SIMA20171116006Light · damagedLEFT PROXIMITY LIGHT AT SIDEWALLS NR 1 THRU 8 ARE DAMAGED. REMOVED AND REPLACED THE LIGHT STRIP IAW AMM 33-50-12.SDR SIMA20171116005Bulb · inoperativeRIGHT OVERWING EXIT EXTERNAL AFT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-10. OPS CHECKED GOOD.SDR REXA2017111601205Battery Pack · defectiveEMERGENCY EXIT LIGHTS AT ROW 13 FLICKER. REMOVED AND REPLACED THE BATTERY PACK NR 3 BS 705 IAW AMM 33-51-17, 33-51-17-000-801, AND 33-51-17-400-801. OPS CHECKED GOOD IAW AMM 33-51-17-710-801.SDR SWAA2017112718036Lens · missingRIGHT OVERWING EXIT LIGHT COVER MISSING. INSTALLED A COVER IAW AMM.SDR SWAA2017112718017Sign · brokenR2 DOOR EMERGENCY EXIT SIGN BROKEN. R & R THE BATTERY CHARGER IAW MM.
Back to JASC 3350