Airbus A321-231
Service difficulty reports · 20,710
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = 'A321231' 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 aircraft_model_key = 'A321231' 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 USAA2014112500002Connector · loose4L EMER AISLE LIGHT INOPERATIVE. FOUND CONNECTION LOOSE, RECONNECTED. OPERATIONS CHECKED OK.SDR USAA2014112500001Decoder · faulty2L DOOR SLIDE PRESS. EMER EXIT SLIDE BOTTLE PRESS INDICATOR ON FAP INOPERATIVE. SLIDE BOTTLE PRESS VERIFIED. TROUBLE SHOT IAW TSM 25-62-00-810-807-A, FAULT CONFIRMED. REPLACED DECODER & ENCODER UNIT B 300RH4 IAW AMM 23-73-47. OPERATIONS CHECKED GOOD.SDR USAA2014112400012Megaphone · brokenFORWARD MEGA PHONE VOLUME KNOB MISSING. REPLACED FWD MEGA PHONE AS REQUIRED. OK FOR SERVICE.SDR USAA2014112400013Handle · detachedDOOR 1R HANDLE ASSEMBLY LOOSE, CAME OFF. REPLACED R1 DOOR ASSIST HANDLE COVER.SDR USAA2014111700006Bottle · low pressureR4 DOOR ASSIST BOTTLE PRESS LOW. SERVICED DOOR ASSIST BOTTLE TO PROPER PRESS.SDR USAA2014111700015Slide · unserviceableS1 CHECK R1 DOOR SLIDE GAUGE IS OBSCURED BY PACK COVER. INSTALLED NEW SLIDE ON R1 DOOR IAW JOB CARD 26C84152006.SDR USAA2014111700008Battery · dischargedFLASHLIGHT SEAL AT DOOR 4L IS BROKEN. INSTALLED NEW BATTERY IN FLASHLIGHT & SECURED WITH NEW SEAL.SDR USAA2014111200007Terminal · brokenROW 7 - 8 CTR CEILING PANEL EMER LIGHT FEMALE PLUG IS BROKEN OFF THE WIRE. REPLACED TERMINAL ON EMER LIGHT AT ROW 7 - 8 IAW ESPM 20-48-14.SDR USAA2014111200001Bottle · low pressureDOOR 4L CHECK DOOR PRESS. SERVICED DOOR 4R DOOR ASSIST BOTTLE IAW AMM 52-10-00-614-001-A. OPERATIONS CHECKED GOOD.SDR USAA2014111100007Floor Panel · damagedC11 CHECK SOFT AREA ON FLOOR PANEL 222EF BETWEEN FRAME 18 TO 20, Z-500 & BETWEEN -Y1292 TO -Y254. REPLACED FLOOR PANEL 222EF IAW IRM 9702 REV G.SDR USAA2014111100004Floor Panel · delaminatedS1 CHECK DELAMINATION ON FLOOR PANEL 231BF BETWEEN FRAME 20 TO 24, Z-500 BETWEEN Y254 TO -Y254. REPLACED FLOOR PANEL 231BF IAW IRM 9701 REVISION G.SDR USAA2014111000019Floor Panel · delaminatedS1 CHECK DELAMINATION ON FLOOR PANEL 221DF BETWEEN FRAME 16 TO 20, Z-500 BETWEEN -Y254 TO -Y254. REPLACED FLOOR PANEL 221DF IAW IRM 9701 REVISION G.SDR USAA2014111000003Cylinder · low pressureR4 DOOR ASSIST BOTTLE PRESS BORDER LINE LOW. SERVICED R4 DOOR ASSIST BOTTLE IAW AMM 52-10-00-614-001-A.SDR USAA2014111000018Floor Panel · delaminatedS1 CHECK DELAMINATION ON FLOOR PANEL 242MF BETWEEN FRAME 42 TO 43, Z-500 BETWEEN -Y1584 TO -Y1292. REPLACED FLOOR PANEL 242MF IAW IRM 9701 REVISION G.SDR USAA2014111000017Seat Track · corrodedS1 CHECK LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FRAME 64 TO 66 + 6 INCHES, Z-500, Y765. REPLACED SEAT TRACK BETWEEN FRAME 64 TO 66 + 6 INCHES, Z-500, Y765 IAW SRM 51-72-11.SDR USAA2014111000016Floorbeam · corrodedS1 CHECK LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FRAME 66 + 6 INCHES TO FRAME 70, Z-500, Y765. REPLACED FLOORBEAM IAW SRM 51-72-11.SDR USAA2014111000012Light · inoperativeSEAT 5C EMER LIGHT INOPERATIVE. REPLACED SEAT 5C EMER LIGHT ASSEMBLY IAW AMM 33-51-19. OPERATIONS CHECKED GOOD.SDR USAA2014111000011Lens · missingAISLE EMER LIGHT LENS MISSING AT SEAT ROW 12 LT. REPLACED AISLE 12 LT EMER LIGHT AS REQUIRED.SDR USAA2014110700009Door Sill · corrodedS1 CHECK LEVEL 2 GALVANIC CORROSION ON AFT RT SILL PLATE BETWEEN FRAME 68 2 INCHES TO FRAME 68 6 INCHES STRINGER 23R, Z-500, -Y1292. REPAIRED AFT RT SILL PLATE IAW SRM 51-41-14 FIG 201 REPAIR PRINCIPLE NR 5.SDR USAA2014110700008Door Sill · corrodedS1 CHECK LEVEL 2 GALVANIC CORROSION ON AFT LT SILL PLATE AT FRAME 68 STRINGER 23L, Z 500, Y1292. REPAIRED AFT LT SILL PLATE IAW SRM 51-41-14 FIG 201 REPAIR PRINCIPLE NR 5.SDR USAA2014110700010Shear Plate · corrodedS1 CHECK LEVEL 2 EXFOLIATION CORROSION ON AFT RT SHEAR PLATE BETWEEN FRAME 69 TO 70, STRINGER 23R, Z-500, -Y1292. REPLACED AFT RT SILL PLATE IAW SRM 51-75-12.SDR USAA2014110700005Placard · missingPLACARD ON L2 EMER EXIT DOOR MISSING. REPLACED MISSING PLACARD, REQUIRED ON L2 DOOR AS REQUIRED.SDR USAA2014110700004Tachometer · intermittentDURING LG EXTENSION WITH AUTO BRAKES LOW SELECTED, ECAM MSG BRAKES RELEASED. OCCURRED AT 1300 FT AFE, EXECUTED GO AROUND. MSG DID NOT REAPPEAR AT NEXT LG EXTENSION. TROUBLE SHOOTING IAW TSM 32-42-00-810-817A HAD FAULT CODE. USING OHM & MEGGAR WIRING CHECKEDSDR USAA2014110600012Floorbeam · corrodedS1 CHECK LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FRAME 66 TO 70, Z-500, -Y765. REPLACED FLOORBEAM IAW SRM 51-72-11.SDR USAA2014110600011Floorbeam · corrodedS1 CHECK LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FRAME 67 TO 70, Z-500, -Y464.8. REPLACED FLOORBEAM IAW SRM 51-72-11 & SRM 53-11-14 FIG 101.SDR USAA2014110600013Door Sill · corrodedS1 CHECK LEVEL 2 SURFACE CORROSION ON SILL PLATE AT FRAME 66, Z-500, Y1440. REPAIRED SILL PLATE IAW EA 208858 & SRM 53-41-14-201.SDR USAA2014110600008Door Sill · dirtyR4 DOOR DIFFICULT TO ARM. REMOVED DEBRIS FROM R4 DOOR SILL PLATE. R4 DOOR ARMING OPERATIONS OK.SDR USAA2014110600003Arming Lever · loosePOSITIONS 3L & 3R SLIDE ARMING HANDLES ARE LOOSE. TIGHTENED HANDLES AT 3L & 3R DOOR POSITIONS.SDR USAA2014110500003Lens · missingEMERGENCY EXIT LENS MISSING FROM SEAT 22D. REPLACED LAMP, OPERATIONS GOOD.SDR USAA2014110500001Lens · brokenEMERGENCY EXIT LIGHT LENS BROKEN AT SEAT 8 D. REPLACED EMER LIGHT AT SEAT ROW 8 D. OPERATIONS NORMAL.SDR USAA2014110400002Lens · missing2L EXIT DOOR LENS COVER REMOVED. REPLACED 2L DOOR EXIT LENS COVER, CHECKED OK.SDR USAA2014103100012Lens · looseDOOR 4R LOWER LIGHTED EXIT SIGN HANGING LOOSE. REINSTALLED EXIT SIGN LENS.SDR USAA2014103100011Pressure Switch · stuckFAP L2 DOOR ARMED INDICATOR INOPERATIVE IAW LP 8930197. FOUND 2LT DOOR BOTTLE PRESS SWITCH STUCK. CLEANED & CYCLED SEVERAL TIMES. PERFORMED OPERATIONS CHECK IAW AMM 23-73-00-740-005. OK, NO FAULTS FOUND.SDR USAA2014103000001Light · out of positionEMERGENCY EXIT LIGHT POPPED OUT ON ROW 3. REINSTALLED EMER SEAT LIGHT.SDR USAA2014102900006Bottle · low pressureCHECK DOOR PRESS ON L1 DOOR ON CIDS PAGE. SERVICED L1 DOOR IAW AMM 52-22-00-0201-00.SDR USAA2014102900004Lens · missingDOOR R4 EMER EXIT LIGHT LENS MISSING. REPLACED EMER EXIT LIGHT LENS AT DOOR R4.SDR USAA2014102900003Lens · missingROW 9 RT EMER LIGHT LENS MISSING. REPLACED EMER LIGHT LENS AT ROW 9 RT.SDR USAA2014102900002Light · inoperativeEMERGENCY AISLE LIGHTS AT ROW 3 LT & 6 LT ARE INOPERATIVE. REPLACED EMER AISLE LIGHTS AT ROW 3 LT & 6 LT IAW JOB CARD 26C00033004.SDR USAA2014102800003Hinge Pin · crackedFOUND NLG TORQUE LINK CTR HINGE PIN CRACKED DURING PENETRANT INSPECTION. INSTALLED NEW LG TORQUE LINK CTR PIN ASSEMBLY IAW AMM 32-21-27-0401.SDR USAA2014102700007Paddle · looseL2 & R2 DOOR SLIDE ARMING PADDLES LOOSE. SECURED DOOR ARMING PADDLES AT DOORS 2L & 2R AS REQUIRED.SDR USAA2014102700008Lens · brokenSEAT MOUNTED EMER EXIT LIGHT LENS BROKEN AT L2 DOOR. REPLACED LIGHT ASSEMBLY & OPERATIONS CHECKED NORMAL.SDR USAA2014102700009Cover · looseCOVER LOOSE ON EMER FLOOR LIGHTING HARNESS CONNECTOR ROW 16 LT SIDE. SECURED COVER AS REQUIRED.SDR USAA2014102400008Computer · unreliableDURING DESCENT, ECAM MSG FUNCTION CONTROL SPEED BRAKE 3 + 4 FAULT. STS PAGE SAID SPEED BRAKES DO NOT USE. DIVERTED & UPON LANDING ALL SPOILERS OPERATE NORMAL. WHEN REVERSER DESELECTED, SPOILERS STOWED. SYS OPERATIONS CHECKED GOOD AT THIS TIME. REPLACED SESDR GTIA2014102301444Controller · failedCREW REPORTED CABIN PRESSURE EXCESSIVE, CABIN ALTITUDE ON ECAM. PERFORMED EMERGENCY DESCENT AND COMPLIED WITH COM PROCEDURES DUE TO NOT BEING ABLE TO MAINTAIN PRESSURIZATION IN ACFT. TROUBLESHOT CABIN PRESSURIZATION SYS-R & R OUTFLOW VALVE AND BOTH CABIN PRESDR USAA2014102400011Lens · displacedDOOR 4R EMER LIGHT COVER IS OFF ITS USUAL LOCATION. INSTALLED DOOR 4R EMER LIGHT COVER. CHECKED OK.SDR USAA2014102300002Cylinder · low pressureL4 DOOR ASSIST BOTTLE PRESS LOW. SERVICED L4 DOOR ASSIST CYLINDER IAW AMM 25-10-00-614.SDR USAA2014102200002Handle · looseYELLOW DOOR SLIDE ARMING HANDLES LOOSE AT DOOR 3L & 3R. SECURED DOOR SLIDE ARMING HANDLES AT DOOR 3R & 3L AS REQUIRED.SDR USAA2014102100008Lens · brokenEMERGENCY EXIT LIGHT AT SEAT 1D HAS BROKEN LENS. REPLACED EMER EXIT LIGHT ASSEMBLY AT SEAT 1D.SDR GTIA2014101901440Megaphone · intermittentAFT F/A MEGAPHONE INTERMITTENT. R & R AFT MEGAPHONE IAW AMM 25-65-51. ALL CHECKED NORMAL.SDR USAA2014102000013Handle · looseDOOR R2 ARMING LEVER HANDLE IS LOOSE. SECURED DOOR R2 ARMING LEVER HANDLE.
Back to Airbus A321-231