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 AALA201810319009Flashlight · inoperativeMID CABIN FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT INOPERATIVE. REPLACED THE FLASHLIGHT.SDR AALA201810299023Generator · leakingAIRCRAFT WAS GROUNDED. CABIN ODOR REPORTED ON DESCENT WHEN ENGINES AT IDLE, SEEMED TO DISSIPATE WHEN ENGINES WERE ABOVE IDLE. FLIGHT CREW REPORTED WHEN GETTING ON A/C IN RSW THE COCKPIT SMELT LIKE THE DIRTY SOCK SMELL. DURING FLIGHT, NO ISSUES BUT ON DESCENT ISDR AALA201810249014Computer · faultedAN EMERGENCY WAS DECLARED. ECAM FOR A FLIGHT CONTROL ELAC 2 PITCH FAULT. THE AIRCRAFT WAS GROUNDED. ACCOMPLISHED TSM 27-90-00-810-803-A. REPLACED ELAC IAW AMM 27-93-34. OPS CHECKED GOOD. ACCOMPLISHED SUCCESSFUL LAND CAT 3 CAPABILITY TEST IAW JOB CARD 26T0SDR AALA201807279015Access Panel · defectiveTHE AIRCRAFT IS IN BASE MAINTENANCE. CHECK R2 DOOR SLIDE, AFTER PARKING SHOWED DOOR OPEN AND SLIDE ARM FOR A MOMENT AT AFT GALLEY AREA. REPLACED ACCESS PANEL 842DZ PER AMM 25-23-46-400-002-A.SDR AALA201807259002Access Panel · corrodedCORROSION WAS FOUND ON THE RIGHT WING FUEL ACCESS PANEL 640DB. REPLACED THE ACCESS PANEL IAW AMM 57-27-11-400-001-A.SDR AALA201807259001Access Panel · corrodedCORROSION FOUND ON THE RIGHT WING FUEL ACCESS PANEL 640CB. REPLACED THE ACCESS PANEL IAW AMM 57-27-11-400-001-A.SDR AALA201807249012Power Supply · burnedBURNED EMERGENCY POWER SUPPLY. REPLACED THE POWER SUPPLY IAW AMM 33-51-38-400-001-A.SDR AALA201807209004Slide · looseTHE AIRCRAFT IS IN BASE MAINTENANCE. LOOSE DOOR OFFWING ESCAPE SLIDE NUT LEFT HAND SIDE ON LOWER FUSELAGE. REPLACED OFF WING ESCAPE SLIDE LEFT HAND SIDE PER AMM 25-62-42-400-001-A AND OPERATIONAL TEST OF THE EMERGENCY LIGHTS IS OK.SDR AALA2018072089014Slide · deformedDEFORMED SLIDE RAFT ON THE PASSENGER DOOR. REPLACED SLIDE IAW AMM 25-62-44-400-803.SDR AALA201807169003Hinge Fitting · wornWEAR FOUND ON THE NR 2 HINGE BEARING SUPPORT FITTING ON THE RIGHT HORIZONTAL STABILIZER. REPLACED THE HINGE BEARING FITTING IAW AMM 55-16-42-400-001-A.SDR AALA201807129022Damper · faultyAIRCRAFT IN BASE MAINTENANCE. DURING OPERATIONAL TEST OF PASSENGER CREW DOOR (841) HARD IMPACT BETWEEN THE BUFFER DOOR AND FUSELAGE AT FORWARD GALLEY AREA. REPLACED DOOR DAMPER ON PASSENGER CREW DOOR (841) PER AMM 52-11-14-400-001-A. LEAK TEST IS OK.SDR AALA2018071879002Skin · damagedTRAPPED WATER INDICATION ON THE RT ELEVATOR LOWER SKIN PANEL HONEYCOMB CORE CELLS. 13 INCHES INBD FROM RIB 10 AND 3.5 INCHES FROM TRALING EDGE. REPAIRED THE RT ELEVATOR SKIN IAW SRM 55-21-11-300-005 PAR 2A.SDR AALA201807179001Skin · saturatedAIRCRAFT IN BASE MAINTENANCE: TRAPPED WATER INDICATION ON RIGHT HAND ELEVATOR UPPER SKIN PANEL BETWEEN RIB 2 AND RIB 3, AT 7.5 INCHES FROM RIB 2 AND 10.5 INCHES FROM TRAILING EDGE. REPAIRED RIGHT HAND ELEVATOR UPPER SURFACE SKIN PER SRM 55-21-11-300-005, PARAGSDR AALA201807169016Skin · saturatedTRAPPED WATER INDICATION IN THE LT ELEVATOR UPPER SKIN PANEL, HONEYCOMB, CORE CELLS. 34.7 INCHES INBOARD FROM RIB 10, AND 11.7 INCHES FROM TRAILING EDGE. REPAIRED THE LT ELEVATOR UPPER SKIN PANEL IAW SRM 55-21-11-300-004.SDR AALA201807249007Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED WINDSHIELD FRAME AT FR 4. REPAIRED WINDSHIELD FRAME PER EA 281399.SDR AALA201806219015Seal · cutCUT ON DOOR LINING AND SEAL BETWEEN EMERGENCY CONTROL HANDLE AT FORWARD GALLEY AREA. REPLACED THE SEAL IAW AMM 25-23-46-400-001-A STEP 4.B.SDR AALA201806219011Seal · cutCUT ON DOOR LINING 831 AND THE SEAL BETWEEN EMERGENCY CONTROL HANDLE AT FORWARD GALLEY AREA. REPLACED SEAL IAW AMM 25-23-46-400-001-A STEP 4.B.SDR AALA201807029032Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON RIGHT WING NR 1 SLAT TRACK UPPER AFT ATTACHMENT BOLT. REPLACED RIGHT WING NR 1 SLAT TRACK UPPER AFT ATTACHMENT BOLT PER AMM 27-84-63-400-002-A.SDR AALA201807029028Bolt · corrodedFOUNDTHE BOLT CORRODED ON SLAT TRACK NR 1, RT WING. REPLACED THE BOLT IAW AMM 27-84-63-400-002-A.SDR AALA201806279003Hinge Fitting · wornEXCESSIVE PLAY ON HINGE ARM END FITTING ON THE RIGHT HORIZONTAL STABILIZER, BETWEEN HSS 1305 AND 1809, RIB 5. REPLACED HINGE ARM END FITTING IAW AMM 55-16-42-400-001-A.SDR AALA2018071319017Pivot · corrodedCORROSION FOUND ON THE PIVOT BOLT, TRACK 3 RT, BETWEEN WS 6699 AND 7316, RIBS 12 AND 13. REPLACED THE PIVOT BOLT TRACK IAW AMM 27-54-62.SDR AALA201807119005Bolt · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND ON PIVOT BOLT FLAP TRACK 2, STA 3059 OF RIGHT HAND WING. REPLACED BOLT PER AMM 27-54-61.SDR AALA201807119018Bolt · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION FOUND ON OUTBOARD FLAP PIVOT BOLT THAT ATTACHES AT CARRIAGE OF TRACK 4 ON RIGHT HAND WING. REPLACED NR 4 PIVOT BOLT TRACK PER AMM 27-54-62.SDR AALA201806289003Floor Panel · delaminatedDELAMINATION FOUND ON FLOOR PANEL 212EF IN THE COCKPIT. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006.SDR AALA201806279006Floor Panel · delaminatedDELAMINATED FLOOR PANEL 211EF, BETWEEN FRAMES 6 TO 9, Y254 TO Y765. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006.SDR AALA201806279004Floor Panel · delaminatedDELAMINATED FLOOR PANEL 221DF, BETWEEN FRAMES 16 TO 20, Y254 TO Y-254. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006.SDR AALA201806269012Floor Panel · delaminatedAIRCRAFT WAS IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 251WF LOCATED AT STA FR 62 TO FR 64 AND -Y765 TO Y765 IN THE PASSENGER CABIN. REPLACE FLOOR PANEL PER SRM 53-12-00-300-006 AND IRM 9701 REV H.SDR AALA201806269011Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATED FLOOR PANEL 221LF BETWEEN FR 12 TO FR 16, LBL Y0 TO LBL Y512.5 AT FORWARD GALLEY AREA. REPLACED FLOOR PANEL 221LF PER SRM 53-12-00-300-006 AND IRM 9701, REVISION H.SDR AALA2018071099004Hinge Fitting · wornTHE AFT HINGE FITTING OF THE LT AFT NLG DOOR WAS FOUND TO BE WORN. REPLACED THE HINGE FITTING IAW CMM 52-82-32, AND AMM 32-22-13.SDR AALA2018071099003Hinge Fitting · wornTHE AFT HINGE FITTING ON THE RIGHT AFT NLG DOOR WAS FOUND TO BE WORN. REPLACED THE AFT HINGE FITTING IAW CMM 52-82-32, AND AMM 32-22-13.SDR AALA2018071099002Hinge Fitting · wornTHE FORWARD HINGE FITTING OF THE LEFT NLG DOOR WAS FOUND TO BE WORN. REPLACED THE HINGE FITTING IAW CMM 52-82-32, AND AMM 32-22-13.SDR AALA2018071099001Hinge Fitting · wornTHE FORWARD HINGE FITTING ON THE RIGHT NLG DOOR AT FRAME 18 TO 20 WAS FOUND TO BE WORN. REPLACED THE HINGE FITTING IAW CMM 52-82-32, AND AMM 32-22-13.SDR AALA201807059003Floor Panel · delaminatedAIRCRAFT WAS IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 222CF LOCATED AT STA FR 12 THRU FR 16, STR 23. REPLACED FLOOR PANEL PER AMM 53-00-00-400-801-A.SDR AALA2018070539027Floor Panel · delaminatedDELAMINATION FOUND ON FLOOR PANEL 232DF, FRAME 20 - 24. REPLACED THE FLOOR PANEL IAW AMM 53-00-00-400-801-A.SDR AALA201807029021Floor Panel · delaminatedDELAMINATION FOUND ON FLOOR PANEL 221PF, FRAMES 12 TO 16, Y765 TO 1292. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006.SDR AALA201806279005Floor Panel · delaminatedDELAMINATION FOUND ON THE AFT FORWARD GALLEY FLOOR PANEL 221EF, FRAMES 16 TO 20, Y1292 TO Y254. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006.SDR AALA201806269016Floor Panel · delaminatedAIRCRAFT WAS IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 222EF LOCATED AT STA FR 13 TO FR 20 AND BL Y-1292 TO Y-254 OF THE FORWARD GALLEY AREA. REPLACED FLOOR PANEL PER SRM 53-12-00-300-006, IRM 9701 REV H.SDR AALA201806269014Floor Panel · delaminatedAIRCRAFT WAS IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 231CF LOCATED ON FR 20 TO FR 24 AND Y254 TO Y765 OF THE FORWARD GALLEY AREA. REPLACED FLOOR PANEL PER SRM 53-12-00-300-006, IRM 9701 REV H.SDR AALA201806269015Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATED FLOOR PANEL 232FF BETWEEN FR 20 TO FR 24, RBL Y-1732 TO RBL Y-1292 AT FORWARD GALLEY AREA. REPLACED FLOOR PANEL 232FF PER SRM 53-12-00-300-006 AND IRM 9701, REVISION H.SDR AALA201806209002Support · corrodedCORROSION FOUND ON THE LOWER SUPPORT AT FRAME 68, STRINGER 23L. REPAIRED THE SUPPORT IAW SRM 53-41-14-300-001.SDR AALA2018072309020Rib · elongatedLEFT WING LEADING EDGE, FIXED INBOARD MACHINED RIB HAS TWO ELONGATED HOLES AT WFX 365.514. REPAIRED THE RIB IAW EA 281787.SDR AALA201807129002Floor Panel · delaminatedTHE AIRCRAFT IS IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 261LG AFT GALLEY AREA IN PASSENGER CABIN. REPLACED FLOOR PANEL PER AMM 53-00-00-400-801-A.SDR AALA2018071099009Floor Panel · delaminatedDELAMINATION FOUND ON FLOOR PANEL 262LG. FRAMES 66 - 68. REPLACED THE FLOOR PANEL IAW AMM 53-00-00400-801-A.SDR AALA201807029023Floor Panel · delaminatedDELAMINATION FOUND ON FLOOR PANEL 261DF, FRAMES 66 TO 68, Y765 TO -Y765. REPLACED THE FLOOR PANEL IAW EA 281543, SRM 53-02-00-300-011.SDR AALA201806269010Seat Track · corrodedAIRCRAFT WAS IN BASE MAINTENANCE CORROSION FOUND ON SEAT TRACK IN THE FORWARD GALLEY AREA AT STA FR 12 TO FR 24 AND BL -Y1292. REPLACED SEAT TRACK PER SRM 51-72-11 AND DRAWING D53112812.SDR AALA201806269008Beam · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND ON THE BEAM AT AFT GALLEY AREA LOCATED AT STA FR 68 TO FR 69 AND BL -Y1162.5. REPLACED BEAM PER SRM 51-72-11 DRAWING D5347278.SDR AALA201806269006Beam · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND ON THE BEAM AT THE AFT GALLEY AREA AT STA FR 64 TO FR 66+5" AND BL -Y1292. REPLACED BEAM PER SRM 51-72-11 DRAWING 53472815SDR AALA201806269009Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION SEAT TRACK BETWEEN FR 12 TO FR 24, RBL -Y765 IN FORWARD GALLEY AREA. REPLACED SEAT TRACK PER SRM 51-72-11, DRAWINGS D53110984000 AND D53110920000.SDR AALA201806269007Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATED FLOOR PANEL 261PF BETWEEN FR 68 TO FR 70, LBL Y1292 TO RBL -Y1292 IN PASSENGER CABIN. REPLACED FLOOR PANEL 261PF PER SRM 53-02-00-300-011 AND IRM 9701, REVISION H.SDR AALA201806269005Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE. CORRODED FLOORBEAM BETWEEN FR 66 PLUS 5 INCHES TO FR 68, RBL -Y1225 AT AFT GALLEY AREA. REPLACED FLOORBEAM PER DRAWINGS D53472780, D53472815 AND SRM 51-72-11.
Back to N123UW