N123UW
Service difficulty reports · 292
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 = 'N123UW' 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 = 'N123UW' 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 AALA2018062099028Seat Track · corrodedCORROSION FOUND ON THE SEAT TRACK, FRAMES 64 TO 66+5 INCHES. REPLACED THE SEAT TRACK IAW SRM 51-72-11, DRAWING D53472015, AND D5347200.SDR AALA201806199029Floor Panel · delaminatedDELAMINATION FOUND ON FLOOR PANEL 261BG IN THE AFT GALLEY. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011, 112M 9701 REVISION H.SDR AALA201806199011Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATED FLOOR PANEL 262BG BETWEEN FR 64 TO FR 66, LBL Y1732 TO RBL Y-254, AFT GALLEY AREA IN PASSENGER CABIN. REPLACED FLOOR PANEL 262BG PER SRM 53-02-00-300-013.SDR AALA201806199010Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATED FLOOR PANEL 261AG BETWEEN FR 64 TO FR 66, LBL Y254 TO RBL -Y254 AFT GALLEY AREA IN PASSENGER CABIN. REPLACED FLOOR PANEL 261AG PER SRM 53-02-00-300-011 AND IRM 9707, REVISION H.SDR AALA2018072099017Skin · damagedTRAPPED WATER INDICATION ON THE RT ELEVATOR UPPER SKIN HONEYCOMB CORE CELLS, OUTBOARD FROM RIB 1 AND 8.8 INCHES FROM TRAILING EDGE. REPAIRED THE ELEVATOR SKIN IAW SRM 55-21-11-300-005.SDR AALA201807189002Skin · damagedTRAPPED WATER INDICATION IN THE RT ELEVATOR UPPER SKIN, APPROXIMATELY 5 INCHES OUTBOARD FROM RIB 3 AND 11.5 INCHES FROM TRAILING EDGE. REPAIRED THE RT ELEVATOR SKIN IAW SRM 55-21-11-300-005.SDR AALA201807189038Skin · damagedTRAPPED WATER INDICATION ON RT ELEVATOR UPPER SKIN PANEL. 16 INCHES INBOARD FROM RIB 10 AND 3 INCHES FROM TRAILING EDGE. REPAIRED THE SKIN IAW SRM 55-21-11-300-005.SDR AALA201807189001Skin · damagedTRAPPED WATER INDICATION IN THE RT ELEVATOR UPPER SKIN, APPROXIMATELY 10.75 INCHES INBOARD FROM RIB 10 AND 6.5 INCHES FROM TRAILING EDGE. REPAIRED THE RT ELEVATOR SKIN IAW SRM 55-21-11-300-005.SDR AALA2018071769012Skin · damagedTRAPPED WATER INDICATION ON THE LT ELEVATOR UPPER SKIN PANEL HONEYCOMB CORE CELLS. INBOARD FROM RIB 4 AND 11 INCHES FROM TRAILING EDGE. REPAIRED THE LT ELEVATOR SKIN IAW SRM 55-21-11-300-005.SDR AALA2018071769011Skin · saturatedAIRCRAFT WAS IN BASE MAINTENANCE. TRAPPED WATER INDICATION ON THE LT ELEVATOR UPPER SKIN PANEL HONEYCOMB CORE CELLS. 25.5 INCHES INBOARD FROM RIB 10, AND 3.3 INCHES FROM TRAILING EDGE. REPAIRED THE LT ELEVATOR SKIN IAW SRM 55-21-11-300-004.SDR AALA2018071769010Skin · damagedTRAPPED WATER INDICATION ON THE LT ELEVATOR UPPER SKIN PANEL HONEYCOMB CORE CELLS. 22.6 INCHES OTBD FROM RIB 1, AND 23 INCHES FROM TRAILING EDGE. REPAIRED THE LT ELEVATOR SKIN IAW SRM 55-21-11-300-005.SDR AALA2018071769009Skin · damagedTRAPPED WATER INDICATION IN THE LT ELEVATOR UPPER SKIN PANEL, HONEYCOMB CORE CELLS, 17.8 INCHES OTBD FROM RIB 1 AND 28.2 INCHES FROM TRAILING EDGE. REPAIRED THE LT ELEVATOR IAW SRM 55-21-11-300-005.SDR AALA201807169008Skin · saturatedTRAPPED WATER INDICATION IN THE LEFT ELEVATOR UPPER SURFACE SKIN, BETWEEN RIBS 2 AND 3, 4.12 INCHES FROM RIB 3 AND 25 INCHES FROM TRAILING EDGE. REPAIRED THE LEFT ELEVATOR SKIN IAW SRM 55-21-11-300-005.SDR AALA201807169007Skin · damagedTRAPPED WATER INDICATION IN THE RIGHT ELEVATOR UPPER SURFACE SKIN BETWEEN RIBS 2 AND 3, 3.25 INCHES FROM RIB 3 AND 16 INCHES FROM TRAILING EDGE. REPAIRED THE RT ELEVATOR SKIN IAW SRM 55-21-11-300-004, PARAGRAPH 2A.SDR AALA201807169006Skin · damagedTRAPPED WATER INDICATION IN THE RT ELEVATOR UPPER SURFACE SKIN, BETWEEN RIBS 2 AND 3, 3.25 INCHES FROM RIB 2 AND 14 INCHES FROM TRAILING EDGE. REPAIRED THE RT ELEVATOR SKIN IAW SRM 55-21-11-300-005, PARAGRAPH 2A.SDR AALA201807169015Skin · damagedTRAPPED WATER INDICATION IN THE LT ELEVATOR UPPER SKIN PANEL, HONEYCOMB, CORE CELLS. RIB 4 AND 11 INCHES FROM TRAILING EDGE. REPAIRED THE LT ELEVATOR UPPER SKIN IAW SRM 55-21-11-300-004.SDR AALA201807169014Skin · damagedTRAPPED WATER INDICATION IN THE ELEVATOR UPPER SKIN PANEL, HONEYCOMB CORE CELLS. 15 INCHES OTBD FROM RIB 1, AND 19.5 INCHES FROM TRAILING EDGE. REPAIRED THE LT ELEVATOR UPPER SKIN IAW SRM 55-21-11-300-005.SDR AALA201807169013Skin · damagedTRAPPED WATER INDICATION ON THE LT ELEVATOR UPPER SKIN PANEL HONEYCOMB CORE CELLS. 25.7 INCHES OTBD FROM RIB 1 AND 17.5 INCHES FROM TRAILING EDGE. REPAIRED THE LT ELEVATOR UPPER SKIN PANEL IAW SRM 55-21-11-300-004.SDR AALA201807109029Stop Fitting · crackedTHE AIRCRAFT IS IN BASE MAINTENANCE. CRACK INDICATION FOUND ON LOWER INBOARD HOLE NR 7 DOOR STOP FITTING, AT FRAME 16 RIGHT HAND SIDE. REPLACED NR 7 DOOR STOP FITTING PER SRM 51-72-11 AND DRAWING D53112300.SDR AALA2018071099006Fitting · crackedA CRACK INDICATION ON THE FITTING OF FRAME 16. REPLACED THE FITTING IAW SRM 51-72-11, AND DRAWING D53112300.SDR AALA201807059027Stop Fitting · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACK INDICATED ON FR 16 LT SIDE OF DOOR STOP NR 7 OF THE FORWARD GALLEY AREA. REPLACED FITTING PER SRM 51-72-11 AND DRAWING 53112300.SDR AALA201807239011Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LATERAL WINDSHIELD FRAME AT FR 4, RBL -Y511. REPAIRED LATERAL WINDSHIELD FRAME PER EA 281404.SDR AALA201807249008Window Frame · crackedCRACK INDICATION ON THE LEFT LATERAL WINDOW FRAME 4 SIDE POST IN THE COCKPIT. REPAIRED WINDSHIELD POST IAW EA 281402.SDR AALA201807189007Shear Tie · corrodedCORROSION WAS FOUND ON THE SHEAR TIE, FRAME 32, STRINGERS 42R - 43R. REPLACED THE SHEAR TIE IAW SRM 51-72-11, AND DRAWING 53231712.SDR AALA2018071099022Shear Tie · corrodedCORROSION FOUND ON THE SHEAR TIE AT FRAME 32, BETWEEN STRINGERS 42 - 43R. REPLACED THE SHEAR TIE IAW SRM 51-72-11, AND DRAWING 53231712.SDR AALA2018071099021Shear Tie · corrodedCORROSION FOUND ON THE SHEAR TIE AT FRAME 28, BETWEEN STRINGERS 43L AND 44L. REPLACED THE SHEAR TIE IAW SRM 51-72-11, AND DWG 53233523.SDR AALA2018071099020Shear Tie · corrodedCORROSION FOUND ON THE SHEAR TIE AT FRAME 33, BETWEEN STRINGERS 42R - 43R. REPLACED THE SHEAR TIE IAW SRM 51-72-11, AND DWG 53231712.SDR AALA2018071099019Shear Tie · corrodedCORROSION FOUND ON THE SHEAR TIE AT FRAME 31 BETWEEN STRINGERS 42R - 43R. REPLACED THE SHEAR TIE IAW SRM 51-72-11, AND DWG 53231712.SDR AALA201807039037Stringer · corrodedCORROSION FOUND ON STRINGER 43L BETWEEN FRAMES 56 - 57, AFT CARGO BAY. REPLACED THE STRINGER IAW SRM 51-72-11, AND DRAWING D92491619.SDR AALA201807249009Fitting · crackedDURING A MAINTENANCE CHECK, A CRACK INDICATION WAS FOUND ON THE FUSELAGE WINSDSHILED FRAME CONTINUITY FITTING. REPAIRED THE FITTING IAW EA 281400.SDR AALA201807249006Fitting · crackedA CRACK INDICATION WAS FOUND ON WINDSHIELD CONTINUITY FITTING, LEFT SIDE. REPAIRED THE LT CONTINUITY FITTING IAW EA 281400.SDR AALA201806269013Fitting · excess playAIRCRAFT IN BASE MAINTENANCE. EXCESSIVE PLAY ON FITTING ASSEMBLY FORK END HINGE ARM NR 7 AT STA 5605. REPLACED FITTING ASSEMBLY PER SRM 51-72-11 AND DRAWING D55371042.SDR AALA201805199001Cover · fadedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVERS FADED ON BOTH AFT DOORS, CANNOT READ SLIDE ARMED. INSPECTED BOTH AFT DOORS SLIDE ARMED INDICATORS, NO FAULTS FOUND.SDR AALA2018051659013Seal · dislodgedL1 DOOR ARMING HANDLE REPORTED DIFFICULT TO ARM , DUE TO THE SEAL. OPERATED DOOR AND ARMING MECHANISM SEVERAL TIMES. OPERATIONS CHECKS NORMAL.SDR AALA201803069013Mechanism · lack of lubeL1 DOOR WOULD NOT SHOW ARMED, HANDLE WOULD NOT FLUSH WITH DOOR CLOSED AND LOCKED. MAINTENANCE CLEANED THE GIRT BAR LATCHES, LUBED MECHANISMS AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 25-62-00. AIRCRAFT WAS GROUNDED.SDR AALA201801129006Lens · looseEMERGENCY LIGHT LENS NEAR SEAT 1C IS LOOSE. SECURED THE LENS. OPS CHECKED OK.SDR AALA201801089031Tachometer · faultedBRAKES AUTO BRK FAULT AND BRAKE RELEASED ECAM MESSAGES DISPLAYED AFTER TAKE OFF. BRAKE TEMPS AT GATE ARRIVAL NR 1, 465, NR 2, 40, NR 3, 270, AND NR 4, 240 DEGREES. REPLACED THE NR 2 TACHOMETER IAW 32-42-57. OPS CHECKED GOOD. OKAY FOR SERVICE. AIRCRAFT WAS GRSDR AALA201712209012Condenser · leakingDURING CRUISE, CABIN PRESSURE ECAM MESSAGE ILLUMINATED AT 22000 FEET, CABIN PRESSURE STARTED TO CLIMB, REQUESTED A DESCENT TO 16000 FEET. CABIN CONTINUED TO CLIMB TO ALMOST 11000, DECLARED EMERGENCY DECSCENT TO 10000 FEET. CABIN CAME DOWN TO 3500 FEET AND FLISDR AALA201712209011Sense Line · crackedDURING CRUISE, CABIN PRESSURE ECAM MESSAGE ILLUMINATED AT 22000 FEET, CABIN PRESSURE STARTED TO CLIMB, REQUESTED A DESCENT TO 16000 FEET. CABIN CONTINUED TO CLIMB TO ALMOST 11000, DECLARED EMERGENCY DECSCENT TO 10000 FEET. CABIN CAME DOWN TO 3500 FEET AND FLISDR AALA201712209010Sense Line · leakingDURING CRUISE, CABIN PRESSURE ECAM MESSAGE ILLUMINATED AT 22000 FEET, CABIN PRESSURE STARTED TO CLIMB, REQUESTED A DESCENT TO 16000 FEET. CABIN CONTINUED TO CLIMB TO ALMOST 11000, DECLARED EMERGENCY DECSCENT TO 10000 FEET. CABIN CAME DOWN TO 3500 FEET AND FLISDR AALA201712189061Duct · blownDURING CRUISE, CABIN PRESSURE ECAM MESSAGE ILLUMINATED AT 22000 FEET, CABIN PRESSURE STARTED TO CLIMB, REQUESTED A DESCENT TO 16000 FEET. CABIN CONTINUED TO CLIMB TO ALMOST 11000, DECLARED EMERGENCY DECSCENT TO 10000 FEET. CABIN CAME DOWN TO 3500 FEET AND SDR AALA201712049038Cover · crackedAIRCRAFT WAS NOT GROUNDED. CRACK ON 4L DOOR SLIDE COVER. REPLACED 4L DOOR SLIDE DOOR COVER PER AMM 25-62-00-001.SDR AALA201711289007Cover · looseR2 DOOR EMERGENCY EVACUATION SLIDE COVER IS LOOSE. SECURED THE SLIDE COVER. OPS CHECKED GOOD.SDR AALA201709069013Lanyard · missingAIRCRAFT WAS NOT GROUNDED. RAFT SURVIVAL KIT LANYARD MISSING. MAINTENANCE INSTALLED SERVICEABLE RAFT SURVIVAL KIT.SDR AALA201707069011Lens · brokenEMERGENCY LIGHT COVER AT THE R2 DOOR FELL OFF. REPLACED BROKEN LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201706229004Cover · missingOVERWING SLIDE ARMED COVER MISSING, LEFT SIDE. REPLACED THE SLIDE COVER.SDR AALA201706199039Indicator · erraticLEFT OVERWING SLIDE ARMED INDICATION EXTINGUISHED ON TAXI IN. INDICATES ARMED AFTER PARKING AT GATE. PERFORMED OPS TEST OF WARNING SYSTEM. OF EMERGENCY. EXITS IAW AMM 52-73-00-710-002-A. NO 30 DAY HISTORY.SDR AALA201706199036Control Cable · seizedLEFT OVERWING SLIDE ARM INDICATOR WENT OUT AFTER PUSH BACK. RETURNED TO GATE. SLIDE ARM REAPPEARED AFTER PARKING AT GATE. RESET THE LT FWD AND AFT OVERWING SLIDE ARMING PLUNGER IAW 25-62-42. CHECKED OK.SDR AALA201706089012Buckle · missingR1 DOOR SLIDE BEZEL STRAP MISSING MALE BUCKLE. INSTALLED AND SECURED THE MALE STRAP BUCKLE ON THE R1 DOOR SLIDE COVER.SDR AALA201704109027Lens · missingEXIT ROW 11 EMERGENCY LIGHT LENS COVER MISSING. REPLACED EMERGENCY COVER LENS.
Back to N123UW