N713UW
Service difficulty reports · 319
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 n_number = 'N713UW' AND registry_match = 'registration' 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 n_number = 'N713UW' AND registry_match = 'registration' 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 AALA202212297918Lockpin · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT WING, OFF WING ESCAPE SLIDE THREE BALL LOCK PINS ARE CORRODED. MAINTENANCE REPLACED SLIDE ASSEMBLY PER TASK CARD 26C19053012.SDR AALA202212142579Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT PYLON LOWER SPIGOT FITTING BASE PLATE. MAINTENANCE REPAIRED SPIGOT FITTING BASE PLATE PER SRM 54-51-12-283-001.SDR AALA202212148249Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT PYLON LOWER SPIGOT FITTING BASE PLATE. MAINTENANCE REPAIRED SPIGOT FITTING BASE PLATE PER SRM 54-51-12-283-001.SDR AALA202301139700Fitting · wornAIRCRAFT IN BASE MAINTENANCE: WEAR / SCRATCH ON WEB FITTING BETWEEN FR 20 AND FR 21 AT S23R. MAINTENANCE REPLACED WEB/ FITTING PER SRM 51-42-11.SDR AALA202211304339Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING SLAT TRACK #1 MIDDLE AFT BOLT. MAINTENANCE REPLACED BOLT PER TASK CARD 26C61057005.SDR AALA202211309767Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING SLAT #3, SLAT TRACK #8 LOWER FORWARD BOLT. MAINTENANCE REPLACED BOLT PER AMM 27-84-65-400-002-A.SDR AALA202211157002Support Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SUPPORT FRAME WEB AT FR 70 AND S23L. MAINTENANCE REPLACED WEB SRM 51-42-11.SDR AALA202211227043Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND WING SLAT 3 BOLT OF TRACK 7. REPLACED BOLT PER AMM 27-84-65-400-002-A.SDR AALA202211154050Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING LEADING EDGE SLAT TRACK #6 LOWER MID BOLT. MAINTENANCE REPLACED BOLT PER AMM 27-84-64.SDR AALA202211151302Blucket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING AILERON #1 HINGE BOLT. MAINTENANCE REPLACED HINGE BOLT PER AMM 27-14-41.SDR AALA202302078194Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING BOTTOM SKIN PANEL #1, LOWER FLANGE OF STINGER 2 BETWEEN RIB 5 AND 6. MAINTENANCE REPAIRED STRINGER PER EA 340803.SDR AALA202302130315Frame · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT PASSENGER / CREW DOOR CUT OUT UPPER AFT CORNER CRACK INDICATION ON FRAME AT FR 68 BETWEEN S8L AND S9L, MAINTENANCE REPAIRED FRAME PER EA 340667.SDR AALA202302072357Frame · crackedAIRCRAFT IN BASE MAINTENANCE: AFT RIGHT PASSENGER / CREW DOOR CUT OUT UPPER AFT CORNER FRAME CRACKED AT FR 68 AT S8R. MAINTENANCE REPAIRED FRAME PER EA 340717.SDR AALA202211169137Hinge Pin · corrodedAIRCRAFT IN BASE MAINTENANCE CORROSION ON LEFT WING AILERON #1 HINGE PIN AT WS 12277 AND RIB 23 ON THE REAR SPAR AREA. MAINTENANCE REPLACED HINGE PIN PER AMM 27-14-41.SDR AALA202211221380Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY AREA LOWER SILL LOCATED AT FR 68 AND S23L. REPLACED SILL PER SRM 53-41-14-300-001.SDR AALA202302155527Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. MAINTENANCE REPLACED SHEAR PLATE PER SRM 21-42-11.SDR AALA202302035022Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FRAME AFT FACE WEB ON THE LOWER HORIZONTAL FLANGE RADIUS AT FR 68 AND S22L. MAINTENANCE REPAIRED FRAME PER EA 340323 AND SRM 53-41-12-300-011.SDR AALA202301251961Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S22L. MAINTENANCE REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202212207749Structure · crackedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 834 LEFT HAND SEGMENT CRACKED BETWEEN FR 40 AND FR 41, BETWEEN BEAM 1 AND 3. MAINTENANCE REPLACED SEGMENT PER SRM 51-42-11.SDR AALA202212025231Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL AT FR 66 AND S23L. MAINTENANCE REPAIRED LOWER SILL PER SRM 53-41-14-300-001 REPAIR PROCEDURE 2.A PRINCIPLE 11.SDR AALA202211117289Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SEAT TRACK BETWEEN FR 64 AND FR 66 AT +Y765. MAINTENANCE REPLACED SEAT TRACK PER SRM 51-42-11.SDR AALA202212076873Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR WEB AT FR 20 AND S23L. MAINTENANCE REPLACED WEB PER SRM 51-72-11.SDR AALA202212028612Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR SEAT TRACK AT FR 20 AND -Y1292. MAINTENANCE REPLACED SEAT TRACK PER SRM 51-72-11.SDR AALA202212027927Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR SEAT TRACK AT FR 20 AND -Y765. MAINTENANCE REPLACED SEAT TRACK PER SRM 51-72-11.SDR AALA202212014322Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOORBEAM AT FR 16 AND +Y1292. MAINTENANCE REPALCED FLOORBEAM PER SRM 51-72-11.SDR AALA202211304513Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FORWARD CABIN FLOOR WEB AT FR 16 AND S23L. MAINTENANCE REPLACED WEB PER SRM 51-72-11.SDR AALA202211232060Dummy Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD GALLEY AREA FLOOR DUMMY RAIL LOCATED BETWEEN FR 12 AND FR 16 AT Y503.2. REPLACED DUMMY RAIL PER SRM 51-72-11-911-002, SRM 51-42-11-801, DWG D53110984 AND DWG D53112825.SDR AALA202302164855Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TRAILING EDGE TOP SKIN PANEL 2 LOWER SURFACE BETWEEN RIBS 14 AND 16. MAINTENANCE REPAIRED SKIN PANEL PER EA 340283.SDR AALA202301138109Skin · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT WING LEADING EDGE SLAT #2 LOWER SKIN HAS WEAR AT SLAT TRACK 6. MAINTENANCE REPAIRED SLAT LOWER SKIN PER EA 341000.SDR AALA202212286447Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE. FLIGHT DECK WINDSHIELD FRAMING LEFT CENTER, CRACKED AT FRM 2, Y0. MAINTENANCE REPAIRED THE WINDSHIELD FRAME IAW EA 340202.SDR AALA202212287480Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE. FLIGHT DECK WINDSHIELD RT FRAME CENTER WAS CRACKED AT FRM 2, Y0. MAINTENANCE REPAIRED THE WINDSHIELD FRAME IAW EA 340202.SDR AALA202302217808Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING UPPER SURFACE TRAILING EDGE TOP SKIN PANEL#2 BETWEEN WX 4010.2 AND WX 4490.52, BETWEEN RIB 8 AND RIB 9. MAINTENANCE REPAIRED SKIN PANEL PER EA 340282.SDR AALA202302173869Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TRAILING EDGE TOP SKIN PANEL 2 UPPER SURFACE BETWEEN WS 6699 AND WS 7316, BETWEEN RIBS 13 AND 13. MAINTENANCE REPAIRED THE SKIN PANEL PER EA 340283.SDR AALA202302162694Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TRAILING EDGE TOP SKIN PANEL 2 UPPER SURFACE BETWEEN RIBS 16 AND 18. MAINTENANCE REPAIRED SKIN PANEL PER EA 340283.SDR AALA202302232557Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING REAR SPAR TRAILING EDGE TOP SKIN PANEL #2 LOWER SURFACE AT WX 3622 BETWEEN RIBS 7 AND 8. MAINTENANCE REPAIRED SKIN PANEL PER EA 340283.SDR AALA202302211333Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING TRAILING EDGE REAR SPAR TOP SKIN PANEL #2 LOWER SURFACE BETWEEN WX4349 AND WX4490, BETWEEN RIB 7 AND RIB 8. MAINTENANCE REPAIRED SKIN PANEL PER EA 340282.SDR AALA202302089454Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK LEFT HAND LATERL WINDOW FRAME UPPER STIFFENER CRACKED. MAINTENANCE REPAIRED WINDOW FRAME PER EA 340329.SDR AALA202206229908Battery · missingAIRCRAFT WAS NOT GROUNDED: CABIN MEGAPHONE INOPERATIVE. INSTALLED MISSING BATTERY ON MEGAPHONE PER AMM 25-65-51.SDR AALA202203179624Fire Bottle · fault messageAIRCRAFT WAS NOT GROUNDED: DISCHARGE LIGHT FOR APU FIRE BOTTLE ON. **SUPPLEMENTAL REPORT FOR AALA202203169624: REPLACED APU FIRE EXTINGUISHER BOTTLE 11WF AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 26-22-41.** (CLOSED)SDR AALA202203169624None · noneAIRCRAFT WAS NOT GROUNDED: DISCHARGE LIGHT FOR APU FIRE BOTTLE ON. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202203073796Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT LED DOES NOT FLASH AT THE 2R DOOR. REPLACED FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-65-00.SDR AALA202203018377Battery · defectiveAIRCRAFT WAS NOT GROUNDED: L1 EMERGENCY POWER SUPPLY UNIT BATTERY FAILED OPERATIONAL CHECK. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202202231469Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT PER AMM 25-65-00.SDR AALA202108269657Windshield · delaminatedAIRCRAFT WAS GROUNDED: LEFT HAND CAPTAINS WINDSHIELD DELAMINATED / BUBBLED ON TOP SIDE OF WINDSHIELD. **SUPPLEMENTAL REPORT FOR AALA202108259657: REPLACED WINDSHIELD PER TASK CARD 26L21056001.** (CLOSED)SDR AALA202108259657Windshield · delaminatedAIRCRAFT WAS GROUNDED: LEFT HAND CAPTAINS WINDSHIELD DELAMINATED / BUBBLED ON TOP SIDE OF WINDSHIELD. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202001109006Cover · detachedAIRCRAFT WAS GROUNDED: 2L DOOR SLIDE BUSSEL/ COVER IS DETACHED FROM DOOR. INSPECTED A/C, FOUND IN SAFE CONDITION FOR FERRY FLIGHT TO CLT. REPLACED MISSING DUAL LOCK RECLOSABLE FASTNER STRIP ON L2 SLIDE COVER IAW AMM 25-62-50. NO FURTHER DEFECTS NOTED.SDR AALA2019121219015Pump · leakingAIRCRAFT IN BAST VISIT: MAINTENANCE REPORTS WHILE PERFORMING CONFIDENCE CHECK OF #1 ENGINE FIRE LOOPS WITH ENGINE RUNNING, OBSERVED CONTINUOUS FUEL LEAK COMING FROM DRAIN MAST WHEN ENGINE WAS TAKEN TO POWER, DID NOT LEAK AT IDLE. MAINTENANCEREMOVED AND REPLACESDR AALA201904269010Hinge · wornAIRCRAFT WAS GROUNDED: LEFT MAIN LANDING GEAR DOOR FORWARD HINGE HAS EXCESSIVE PLAY / WORN. REPLACED HINGE PER CMM 52-81-18.SDR AALA2019022209002Holder · detachedEMERGENCY EXIT LIGHT ADJACENT TO SEAT 11C DETACHED. REMOVED AND REPLACED EMERGENCY EXIT LIGHT COVER AND LENS ASSY FOR PAX SEAT 11C. OPS CHECKED GOOD.SDR AALA201811209020Bustle · damagedSLIDE BUSTLE DAMAGED. MAINTENANCE SECURED THE SLIDE BUSTLE AND PERFORMED SATISFACTORY OPERATIONAL CHECK.
Back to N713UW