N723UW
Service difficulty reports · 364
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 = 'N723UW' 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 = 'N723UW' 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 AALA201707129041Floor Panel · delaminatedDELAMINATED ON FORWARD GALLEY FLOOR PANEL 232EF. REPLACED FLOOR PANEL IAW SRM 53-12-00, AND IRM 9701 REVISION G.SDR AALA201707129039Floor Panel · corrodedCORROSION FOUND ON THE FORWARD GALLEY FLOOR PANEL 221DF INSERT. REPLACED FLOOR PANEL IAW SRM 53-12-00-300-006, FIGURE 20106 AND IRM 9701 REVISION G.SDR AALA201707139026Floor Panel · delaminatedDELAMINATION ON FORWARD GALLEY FLOOR PANEL 222CF. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006, AND IRM 9701 REVISION G.SDR AALA201707139024Floor Panel · delaminatedDELAMINATION ON FORWARD GALLEY FLOOR PANEL 231CF. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006, AND IRM 9701 REVISION G.SDR AALA201707139022Floor Panel · delaminatedDELAMINATION ON FORWARD GALLEY FLOOR PANEL 231FF. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006, AND IRM 9701 REVISION G.SDR AALA201708029018Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. AFT GALLEY FLOOR PANEL 261DF HAS DELAMINATION. REPLACED FLOOR PANEL 261DF PER AMM 53-42-12-400-002-A.SDR AALA201707139025Floor Panel · delaminatedDELAMINATION ON AFT GALLEY FLOOR PANEL 261PF. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011, AND IRM 9701 REVISION G.SDR AALA201708029023Fitting · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK INDICATION ON FRAME 4 CONTINUITY FITTING CENTER POST AREA ON THE LEFT HAND WINDSHIELD. REPLACED CONTINUITY FITTINGS PER EA 271323.SDR AALA201707259011Floor Panel · delaminatedDELAMINATION ON PASSENGER CABIN FLOOR PANEL 251UF. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011, AND IRM 9701 REVISION G.SDR AALA201707149028Floor Panel · delaminatedDELAMINATION FOUND ON PASSENGER CABIN FLOOR PANEL 232AH BETWEEN FRAMES 28 TO 35. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006, AND IRM 9701 REVISION G.SDR AALA201707139023Floor Panel · delaminatedDELAMINATION ON BULK CARGO COMPARTMENT FLOOR PANEL 161NF. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011, AND IRM 9701 REVISION G.SDR AALA201708029027Floor Panel · crackedAIRCRAFT IN BASE MAINTENANCE. AFT AVIONIC COMPARTMENT FLOOR PANEL 127CF CRACKED. REPLACED FLOOR PANEL 127CF PER AMM 53-12-13 AND EA 271837.SDR AALA201707319028Hinge Fitting · wornEXCESSIVE PLAY ON VERTICAL STABILIZER RUDDER HINGE ARM NR 7 BEARING AT VERTICAL STABILIZER, RUDDER STATION 561 AND RIB 11. REMOVED AND REPLACED HINGE ARM FITTING ASSEMBLY IAW SRM 51-72-11 AND AMM 55-36-41.SDR AALA201707319027Hinge Fitting · wornEXCESSIVE PLAY ON VERTICAL STABILIZER RUDDER HINGE ARM NR 5 BEARING VERTICAL STABILIZER, RUDDER STATION 299 AND RIB 7. REMOVED AND REPLACED HINGE ARM FITTING ASSEMBLY IAW SRM 51-72-11 AND AMM 55-36-41.SDR AALA201707319026Hinge Fitting · wornEXCESSIVE PLAY ON VERTICAL STABILIZER RUDDER HINGE ARM NR 3 BEARING, RUDDER STATION 228 AND RIB 5. REMOVED AND REPLACED HINGE ARM FITTING ASSEMBLY IAW SRM 51-72-11 AND AMM 55-36-41.SDR AALA201707319025Hinge Fitting · wornEXCESSIVE PLAY ON VERTICAL STABILIZER RUDDER HINGE ARM NR 1 BEARING. VSS 780 AND RIB 2 . REMOVED AND REPLACED HINGE ARM FITTING ASSEMBLY IAW SRM 51-72-11 AND AMM 55-36-41.SDR AALA201707319023Hinge Fitting · wornEXCESSIVE PLAY ON VERTICAL STABILIZER RUDDER HINGE ARM NR 4 BEARING. REMOVED AND REPLACED HINGE ARM FITTING ASSEMBLY IAW SRM 51-72-11, AND AMM 55-36-41.SDR AALA201707139018Floor Panel · delaminatedDELAMINATION ON AFT CARGO COMPARTMENT FLOOR PANEL 151DE. REPLACED FLOOR PANEL IAW SRM 53-02-00-300-011, AND IRM 9701 REVISION G.SDR AALA201707129044Floor Panel · delaminatedDELAMINATION ON AFT CARGO COMPARTMENT FLOOR PANEL 151ZG. REPLACED FLOOR PANEL IAW SRM 53-02-00-300-011, AND IRM 9701 REVISION G.SDR AALA201707129043Floor Panel · delaminatedDELAMINATION ON BULK CARGO COMPARTMENT FLOOR PANEL 161PF. REPLACED FLOOR PANEL IAW SRM 53-02-00-300-011, AND IRM 9701 REVISION G.SDR AALA201707129040Floor Panel · delaminatedDELAMINATION ON FORWARD CARGO COMPARTMENT FLOOR PANEL 131CG. REPLACED FLOOR PANEL IAW SRM 53-02-00-300-011, AND IRM 9701 REVISION G.SDR AALA201707129038Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON AFT CARGO BAY FLOOR PANEL 151CE. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011, FIGURE 20109, AND IRM 9701 REVISION G.SDR AALA201707129037Floor Panel · delaminatedDELAMINATION ON BULK CARGO BAY FLOOR PANEL 161CF. REPLACED FLOOR PANEL IAW SRM 53-02-00-300-011, FIGURE 20109, AND IRM 9701 REVSION G.SDR AALA201707129036Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON AFT CARGO COMPARTMENT FLOOR PANEL 151AE. REPLACED FLOOR PANEL IAW SRM 53-02-00-300-011, AND IRM 9701 REVISION G.SDR AALA201707139041Floor Panel · delaminatedDELAMINATION ON AFT CARGO BAY FLOOR PANEL 152UG. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011, AND IRM 9701 REVISION G.SDR AALA201707139021Floor Panel · delaminatedDELAMINATION ON AFT CARGO COMPARTMENT FLOOR PANEL 152WG. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011, AND IRM 9701 REVISION G.SDR AALA201707139020Floor Panel · delaminatedDELAMINATION ON FORWARD CARGO BAY FLOOR PANEL 131AF. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011, AND IRM 9701, REVISION G.SDR AALA201708029022Plate · crackedAIRCRAFT IN BASE MAINTENANCE. DOOR 832 EXTERNAL SKIN UPPER PLATE CRACKED AT BEAM 7 AND XP 70 TO XP 290.6. REPLACED EXTERNAL SKIN UPPER PLATE PER SRM 51-72-11 AND DRAWING D52111475.SDR AALA201703139024Not Reported · unknownAIRCRAFT WAS GROUNDED. AT CRUISE ALTITUDE FL 280 WE NOTICED THE PLANE WAS FLYING WITH RIGHT WING DOWN. THOUGHT IT MIGHT BE CONTROL PROBLEM, TURNED OUT TO BE FUEL IMBALANCE. RAN QUICK REFERENCE HANDBOOK, DECLARED EMERGENCY, DIVERTED TO JFK. LANDED WITH 5000 LBSSDR AALA201701099001Light · unsecureAIRCRAFT WAS NOT GROUNDED. SEAT 12C EMERGENCY FLOOR LIGHT HANGING LOOSE. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-50-00.SDR AALA201612139010Apu · overservicedAIRCRAFT WAS GROUNDED. ONCE WE STARTED BLEEDING APU ON ARRIVAL WE GOT A STRONG ACIDIC SMELL AND SLIGHT SMOKE HAZE IN CABIN. SEEMED TO DISSIPATE WHEN APU BLEED WAS TURNED OFF. HEAVY RAIN ON GATE ARRIVAL MAINTENANCE SERVICED APU PER JOB CARDS 26L00021002 AND 26LSDR AALA201611259008Unknown · odorFUMES IN COCKPIT AND CABIN ON DESCENT. THE FLIGHT DECLARED AN EMERGENCY AND LANDED WITHOUT FURTHER INCIDENT. ACCOMPLISHED JOB CARD 26L00021001. NO ODORS NOTED. THE AIRCRAFT WAS GROUNDED.SDR AALA201605029013Seal · leakingAIRCRAFT WAS GNDED. FLIGHT ATTENDANTS REPORT FOUL SMELL THROUGHOUT CABIN. ACCOMPLISHED TASK CARDS 26L00021001. TROUBLE SHOT CABIN AIR QUALITY, 26L00021002, APU SMELL IN CABIN & 26L0002004, DECONTAMINATION OF ECS, & DETERMINED THAT THERE WAS AN OIL LEAK COMISDR AALA201511309012Butterfly Valve · defectiveAVIONICS SMOKE ANNUNCIATED, NO SMOKE PRESENT. REPLACED CONDITIONED AIR INLET VLV 21HQ & SKIN EXHANGER ISOLATION VLV 24HQ. ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 21-26-54 & 21-26-55. SEE AALA201511309011 FOR ADDITIONAL PART INFORMATION.SDR AALA201511309011Butterfly Valve · defectiveAVIONICS SMOKE ANNUNCIATED, NO SMOKE PRESENT. REPLACED CONDITIONED AIR INLET VLV, 21HQ & SKIN EXHANGER ISOLATION VLV 24HQ, ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 21-26-54 & 21-26-55. SEE AALA 201511309012 FOR ADDITIONAL PART INFORMATION.SDR AALA201509099013Limiter · trippedFLIGHT CONTROL FLAPS FAULT IN FLIGHT, SLATS 3 FLAPS 0. CREW DECLARED AN EMER AS A PRECAUTIONARY MEASURE & THE ACFT LANDED WITH NO INCIDENTS. AFTER LANDING THE CREW CYCLED THE FLAPS & NO ISSUES WERE NOTED. RESET RT FLAP TRACK NR 1 TORQUE LIMITER IAW AMM 27-5SDR USAA2015011600002Power Supply · inoperativeEMERGENCY LT EPSU MSG DISPLAYED DURING EMER LIGHT TEST. R & R 11WL EPSU IAW MM 33-51-38.SDR USAA2015010800004Battery · dischargedCABIN MEGA PHONE INOPERATIVE. REPLACED BATTERY OF FWD CABIN MEGA PHONE IAW AMM 25-60-00.SDR USAA2014111000005Lens · missingSEAT ROW 20ABC EMER LIGHT LENS MISSING. REPLACED SEAT MOUNTED EMER LIGHT IAW AMM 33-51-18 PB 401. OPERATIONS CHECKED GOOD.SDR USAA2014100800007Skin · saturatedC11 CHECK WATER INGRESS ON RT ELEVATOR AT APPROX 85 INCHES FROM INBD EDGE & 6 INCHES FROM TE. REPAIRED RT ELEVATOR IAW SRM 55-21-11 PAR 5 K FIGURE 211.SDR USAA2014100600022Slide Raft · defectiveC11 CHECK. R1 DOOR SLIDE RAFT HITTING FUSELAGE WHEN DOOR IS FULL OPEN. R & R SLIDE RAFT IAW JOB CARD 26L000250011.SDR USAA2014100600023Torque Link · wornC11 CHECK. LT MLG UPPER TORQUE LINK APEX BUSHING WORN BEYOND LIMITS IAW JC 26C74032002. INSTALLED NEW TORQUE LINK IAW JC 26C74032002.SDR USAA2014100600021Torque Link · wornC11 CHECK. RT MLG UPPER TORQUE LINK APEX BUSHING WORN BEYOND LIMITS IAW JC 26C74032002. INSTALLED NEW TORQUE LINK IAW JC 26C74032002.SDR USAA2014100300009Access Panel · corrodedC11 CHECK RT WING FUEL ACCESS PANEL 640PB HAS CORROSION AT 6 FASTENERS COUNTERSINK LOCATIONS. R & R PANEL.SDR USAA2014100600018Access Panel · corrodedC11 CHECK RT WING FUEL ACCESS PANEL 640NB CORRODED AT 8 COUNTERSINKS. R & R PANEL IAW SRM 51-72-11.SDR USAA2014100300007Slide · defectiveC11 CHECK. L2 SLIDE CONTACTING FUSELAGE WHEN FULLY OPEN. R & R SLIDE IAW JOB CARD 26L00025011.SDR USAA2014092200001Chiller · unserviceableFLIGHT ATTENDANT SWITCHED AFT GALLEY CHILLER OFF DUE TO A MOMENTARY MILD SMELL OF BURNING RUBBER. SMELL DISAPPEARED UPON SWITCHING COOLER OFF. R & R AFT GALLEY CHILLER IAW AMM 25-34-51-000-002-A. CHECKED OK.SDR USAA2014090500009Power Supply · inoperativeDURING WEEKLY CHECK, FOUND LT EPSU UNIT INOPERATIVE. R & R LT EPSU IAW AMM 33-51-38-000-001-A. OPERATIONS CHECKED GOOD.SDR USAA2014090200007Cover · brokenTHE LIGHT COVER FOR EXIT PATH EMER LIGHT AT 22C BROKEN. INSTALLED NEW LENS COVER. OK FOR SERVICE.SDR USAA2014082500003Cylinder · low pressureR2 DOOR EMER OPERATION CYLINDER PRESS LOW. R2 DOOR CYLINDER SERVICED IAW AMM 52-10-00-614-001A TO 1850 PSI. LEAK CHECKED GOOD.
Back to N723UW