Airbus A320-214
Service difficulty reports · 10,616
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 = 'A320214' 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 = 'A320214' 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 AALA201708179012Cover · missingCOVER MISSING ON AFT FLIGHT ATTENDANT FLASHLIGHT. REPLACED MISSING COVER.SDR AALA201708169014Spar · crackedCRACK ON RIGHT PYLON, AFT FIXED FAIRING UPPER SPAR BETWEEN RIBS 14 AND 15. REPAIRED THE SPAR IAW EA 272485A AND SRM 54-54-12. ACCOMPLISHED DVI PER NDT 51-90-00.SDR AALA201708179023Floor Support · corrodedCORROSION ON AFT CARGO BAY FLOOR SUPPORT PROFILE ABOVE STRINGER 38R, BETWEEN FRAMES 48 AND 53. REPAIRED THE FLOOR SUPPORT IAW SRM 51-42-11.SDR AALA201708179022Floor Support · corrodedCORROSION ON AFT CARGO BAY FLOOR SUPPORT PROFILE ABOVE STRINGER 38L, BETWEEN FRAMES 58 AND 59. REPLACED THE FLOOR SUPPORT IAW SRM 51-42-11.SDR AALA201708179021Floor Support · corrodedCORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT PROFILE AT FRAME 58. REPLACE FLOOR SUPPORT IAW SRM 51-42-11.SDR AALA201708179020Floor Support · corrodedCORROSION ON AFT CARGO BAY FLOOR SUPPORT PROFILE AT STRINGER 38L, BETWEEN FRAMES 56 AND 58. REPAIRED THE FLOOR SUPPORT PROFILE IAW SRM 51-42-11.SDR AALA201708179019Door Sill · corrodedCORROSION ON UPPER SURFACE OF R1 DOOR CUT-OUT LOWER SILL AREA, UNDER GIRT BAR PLATES, AT -Y1732 AND FRAME 20. REPLACED DOOR SILL IAW SRM 53-11-14, SRM 51-42-11, AND SRM 51-44-11.SDR AALA201708179026Profile · corrodedCORROSION ON AFT CARGO BAY FLOOR SUPPORT PROFILE AT STRINGER 38L, BETWEEN FRAMES 53 AND 56. REPAIRED THE PROFILE IAW SRM 51-42-11.SDR AALA201708149032Nut Plate · corrodedR1 DOOR FWD AND AFT GIRT BAR FITTINGS NUTPLATE ASSEMBLIES ARE CORRODED. REPLACED THE GIRT BAR FITTINGS NUTPLATE ASSEMBLIES.SDR AALA201708149028Seal · faultyDOOR PRESSURE MESSAGE INDICATED ON THE CIDS PANEL. REMOVED & REPLACED DOOR OPENING ASSIST MECHANISM SEALS IAW 52-10-00-610-001, LEAK CHECKED GOOD.SDR AALA201708179008Profile · corrodedCORROSION ON AFT CARGO FLOOR SUPPORT PROFILE BETWEEN FRAMES 56 AND 58, ABOVE STRINGER 38R. REMOVED AND REPLACED CORNER PROFILE IAW SRM 51-42-11.SDR AALA201708179009Profile · corrodedCORROSION ON AFT CARGO FLOOR SUPPORT PROFILE AT FRAME 58, ABOVE STRINGER 38R. REMOVED AND REPLACED CORNER PROFILE IAW SRM 51-42-11.SDR AALA201708119008Door Sill · corrodedCORROSION ON THE L2 DOOR SILL UPPER SURFACE AT Y1732, BETWEEN FRAMES 66 AND 68. REPLACED L2 DOOR SILL IAW SRM 53-41-14, SRM 51-44-11, AND SRM 51-42-11.SDR AALA201708119006Seat Track · corrodedCORROSION ON FORWARD CABIN SEAT TRACK CORRODED AT FRAME 20 AND -Y765. REPLACED SEAT TRACK IAW SRM 53-00-15, SRM 51-42-11, AND SRM 51-44-11.SDR AALA201708119005Seat Track · corrodedCORROSION ON FORWARD CABIN SEAT TRACK, FRAME 20 AND -Y765. REPLACED THE SEAT TRACK IAW SRM SRM 53-00-15, SRM 51-42-11, AND SRM 51-44-11.SDR AALA201708089025Bottle · low pressureR2 DOOR ASSIST BOTTLE LOW, REQUIRES SERVICE. SERVICED R2 DOOR ASSIST BOTTLE.SDR AALA201708079013Pump · leakingTHERE HAVE BEEN SEVERAL CREW REPORTS OF AN OIL OR FUEL LEAK FROM THE RIGHT ENGINE. FOUND LEAK COMING FROM FUEL PUMP PAD DRAIN. REPLACED ENGINE FUEL PUMP.SDR WX0A201708073284Fan · failedBURNING RUBBER ODOR DURING FLT. R & R AEVC BLOWER FAN.SDR 2017FA0000326Sensor · failedTHE FLIGHT CREW REPORTED THE NR 1 A/C PACK 1 REGULATOR FAULT DISPLAYED ON ECAM DURING CRUISE. REMOVED AND REPLACED COMPRESSOR TEMP SENSOR 12HH IAW AMM 216111. NO FURTHER REPORTS ON SUBSEQUENT FLIGHTS.SDR AALA201708029008Door · unsecureESCAPE ROPE DOOR OVER CAPTAIN WILL NOT STAY SECURE. INSTALLED ESCAPE ROPE DOOR. OK FOR SERVICE.SDR AALA201708029006Lens · missingSEATS 4C MISSING EMERGENCY LIGHT LENS. INSTALLED A NEW LENS . OK FOR SERVICESDR AALA201708019009Light · damagedEMERGENCY LIGHTS AT SEAT 13C INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY AT 13C IAW AMM 33-51-19. ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201708019007Washer · missingL4 DOOR ARM-DISARM HANDLE IS LOOSE. REPLACED MISSING WASHER AT L4 SERVICE DOOR ARM-DISARM HANDLE IAW AMM 52-13-00.SDR AALA201708019027Light · damagedEMERGENCY LIGHTS AT SEAT 22C ARE INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-19. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707309004Fan · failedDURING DESCENT, ENGINE IDLE, SMELLED A STRONG ODOR IN THE COCKPIT. HAPPENED AGAIN IN IDLE ON RAMP. SMELLED LIKE ENGINE EXHAUST. MAINTENANCE PERFORMED JOB CARD 26L00021001 CABIN AIR QUALITY AND 26L00021002 APU ODOR IN CABIN. REPLACED COOLING FAN IAW AMM 49-52-5SDR AALA201707319047Strap · out of positionAFT RIGHT DOOR WILL NOT CLOSE OR ARM. FOUND THE R2 DOOR SAFETY STRAP NOT RETRACTED, OBSTRUCTING THE DOOR CLOSURE. REMOVED SAFETY STRAP FROM DOOR IAW AMM 52-13-11. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707319043Computer · malfunctionedFUEL CENTER TANK PUMP NR 1 INTERMIT LOW PRESSURE WARNING WITH NO FUEL IN CENTER TANK. REPLACED FQIC IAW AMM 28-42-34. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR F3LA2017072700188Battery Pack · no testEPSU 13WL BATTERY FAILED TEST. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED OKAY IAW AMM33-51-38 PB 401.SDR AALA201707269046Pressure Switch · false activationAIRCRAFT WAS NOT GROUNDED. FUEL CENTER TANK PUMP NR 1, LOW PRESSURE ECAM APPEARED AND DISAPPEARED MULTIPLE TIMES DESPITE HAVING NO FUEL IN CENTER TANK. MAINTENANCE REPLACED LEFT CENTER TANK PRESSURE SWITCH (39QA) PER AMM 28-21-15. ACCOMPLISHED SATISFACTORY OPESDR VQIA201711140057Transceiver · failedWEATHER RADAR INTERMITTENT. REMOVED AND REPLACED 1SQ1 RADAR TRANSCEIVER IAW AMM 34-41-33. OPS CHECKS GOOD NO FAULTS NOTED. NO FURTHER DEFECTS NOTED ON SUBSEQUENT LEGS.SDR AALA201707269014Sliding Window · bindingAIRCRAFT WAS GROUNDED. FIRST OFFICER WINDOW IS VERY DIFFICULT TO OPEN AND EVEN MORE DIFFICULT TO CLOSE. REMOVED AND REPLACED WINDOW PER AMM 56-12-11-400-001. LEAK AND OPERATIONAL CHECK GOOD.SDR AALA201707269004Cooling Fan · malfunctionedAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED A STRONG OBNOXIOUS ODOR WITH APU ON THROUGHOUT FLIGHT DECK AND CABIN. MAINTENANCE FOUND APU AIR INTAKE CONTAMINATED WITH DIRT AND FLUIDS. MAINTENANCE FOUND COOLING FAN LEAKING ON APU, REPLACED COOLING FAN PER AMM 49-SDR AALA201707269003Computer · failedAIRCRAFT WAS NOT GROUNDED. DURING CRUISE, CENTER FUEL PUMP NR 1 FAILED, LOW PRESSURE ECAM. MAINTENANCE REPLACED FUEL QUANTITY INDICATING COMPUTER (3QT) PER AMM 28-42-34.SDR AALA201707219006Mechanism · missingPANEL 316AR DOOR MECHANISM MISSING HARDWARE. REMOVED AND INSTALLED THE RT DOOR MECHANISM HANDLE LOWER IAW AMM.SDR AALA201707189011Girt Bar · dirtyR2 DOOR SLIDE ARM LEVER IS HARD TO MOVE. CLEANED DEBRIS FROM THE R2 GIRT BAR HOOKS AND LUBED. OPERATIONAL CHECKED GOOD IAW AMM.SDR AALA201707189010Lamp · inoperativeL1 DOOR WINDSCREEN FLOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP.SDR AALA201707179017Skin · delaminatedDELAMINATION ON PREVIOUSLY INSTALLED REPAIR. RIGHT WING OTBD TRAILING EDGE FLAP UPPER SURFACE, OTBD OF FLAP TRACK NR 3, 92 INCHES OTBD OF INBD END BETWEEN RIBS 5 AND 6. REPAIRED IAW SRM 57-53-00-300-014.SDR AALA201707179016Skin · corrodedCORROSION ON RIGHT SIDE OF AIRCRAFT BELOW OUTFLOW VALVE, 9 INCHES AFT OF FRAME 65, BETWEEN STRINGER 31R AND 32R. REPAIRED THE SKIN IAW EA 271745, AND SRM 53-00-11. AIRCRAFT WAS GROUNDED.SDR AALA201707109062Floor Panel · delaminatedDELAMINATION ON FORWARD CARGO FLOOR PANEL 131EF. REPLACED FLOOR PANEL IAW SRM 53-02-00-300-011.SDR AALA201707109017Anchor Fitting · corrodedCORROSION ON THE RIGHT WING MAIN LANDING GEAR RETRACTION JACK ANCHORAGE FITTING, LOWER SURFACE. REPAIRED FITTING IAW SRM 57-26-13-300-007.SDR AALA201707109016Anchor Fitting · corrodedCORROSION ON LEFT WING MAIN LANDING GEAR RETRACTION JACK ANCHORAGE FITTING, LOWER SURFACE. REPAIRED FITTING IAW SRM 57-26-13-300-007.SDR AALA201707109019Filter · cloggedTWO MINUTES AFTER TAKEOFF, THE NR 2ENGINE FUEL FILTER CLOG ECAM ILLUMINATED FOR APPROXIMATELY 10 SECONDS , THEN WENT OUT. REPLACED THE NR 2 FUEL FILTER IAW AMM 73-11-10.SDR AALA201707109026Girt Bar · obstructedR1 DOOR SLIDE ARMED LIGHT INTERMITTENT. F/A HAS TO KEEP PUSHING DOWN ON THE LEVER. FOUND AND REMOVED DEBRIS FROM 1R AFT GIRT LATCH.SDR AALA201707069011Lens · brokenEMERGENCY LIGHT COVER AT THE R2 DOOR FELL OFF. REPLACED BROKEN LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR 2017FA0000330Bearing · lack of lubeL1 DOOR REPORTED DIFFICULT TO OPEN & CLOSING & STICKING DURING OPERATION. LUBRICATED HINGE ARM SUPPORT FITTING BEARINGS IAW ANM 12-22-52-640-016-A. OPERATIONS CHECKED GOOD. NO DEFECTS NOTED AT THIS TIME.SDR AALA201707109014Bolt · corrodedCORROSION ON THE LT WING SLAT TRACK NR 5 UPPER BOLT. REPLACED THE BOLT IAW AMM 27-84-64.SDR AALA201707109012Bolt · corrodedCOROSSION ON LEFT WING SLAT TRACK NR 3 LOWER BOLT. REPLACED THE BOLT IAW AMM 27-84-63.SDR AALA201707109011Seat Track · corrodedCORROSION ON MAIN CABIN SEAT TRACK, HARD POINT AREA, AT Y1292 BETWEEN FR 65 AND FR 66. REPLACED SEAT TRACK PER SRM 53-00-14, SRM 51-42-11, AND SRM 51-44-11.SDR AALA201707109010Fitting · corrodedCORROSION FOUND ON THE L2 DOOR AFT CORNER FITTING AT Y1732 AND FRAME 68. REPLACED THE CORNER FITTING IAW SRM 53-41-79, AND SRM 51-42-11.SDR AALA201707039043Computer · faultyAIRCRAFT WAS GROUNDED. REJECTED TAKEOFF BELOW 60 KNOTS DUE TO POSSIBLE AVIONICS VENTILATION SKIN VALVE FAULT. REMOVED AND REPLACED AVIONICS EQUIPMENT VENTILATION COMPUTER IAW AMM 21-26-34. OPERATIONAL CHECK GOOD.
Back to Airbus A320-214