N748UW
Service difficulty reports · 215
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 = 'N748UW' 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 = 'N748UW' 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 USAA2012110600006Cleat · corroded2S CHECK - CORROSION ON CLEAT IN FORWARD CARGO COMPARTMENT AT FR28 BETWEEN S43R TO S44R. REPLACED FORWARD CARGO COMPARTMENT CLEAT AT FR28 BETWEEN S43R TO S44R IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53233523.SDR USAA2012112600034Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR24 TO FR35, -Y1292. REPLACED SEAT TRACK BETWEEN FR24 TO FR35, -Y1292 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53110920.SDR USAA2012112600033Splice · damaged2S CHECK - ELONGATED HOLE IN SEAT TRACK SPLICE AT FR24, -Y1292. REPLACED SEAT TRACK SPLICE AT FR24, -Y1292 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53110920.SDR USAA2012112300021Skin · worn2S CHECK - WEAR ON LEFT WING NR 1 SLAT INTERNAL SKIN LOWER SURFACE AT SLAT TRACK NR 2 AT SLAT STATION WFX1244. REPAIRED LEFT WING NR 1 SLAT INTERNAL SKIN LOWER SURFACE AT SLAT TRACK NR 2 AT SLAT STATION WFX1244 IAW EA 503347.SDR USAA2012112300020Skin · worn2S CHECK - WEAR ON LEFT WING NR 1 SLAT INTERNAL SKIN LOWER SURFACE AT SLAT TRACK NR 1. REPAIRED LEFT WING NR 1 SLAT INTERNAL SKIN LOWER SURFACE AT SLAT TRACK NR 1 IAW EA 503347.SDR USAA2012111200014Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR36 TO FR41, -Y765. REPLACED SEAT TRACK BETWEEN FR36 TO FR41, -Y765 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D57130300.SDR USAA2012111200013Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR36 TO FR41, Y765. REPLACED SEAT TRACK BETWEEN FR36 TO FR41, Y765 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53370500.SDR USAA2012111200012Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FR36 TO FR40 -Y1292. REPLACED SEAT TRACK BETWEEN FR36 TO FR40 -Y1292 IAW A319 SRM 51-72-11, AIRBUS DRAWING D57130300 & D53370500.SDR USAA2012110900006Seat Track · corroded2S CHECK - SEAT TRACK CORRODED BETWEEN FR 36 AND FR 41 AT Y 1292. REMOVED AND REPAIRED SEAT TRACK IAW A319 SRM 51-72-11 AND AIRBUS DRAWING D57130300.SDR USAA2012110900004Seat Track · corroded2S CHECK. SEAT TRACK CORRODED BETWEEN FR 41 & FR 47/51 AT Y 1292. REMOVED AND REPLACED SEAT TRACK IAW A319 SRM 51-72-11 AND AIRBUS DRAWING D53370500.SDR USAA2012112300019Skin · worn2S CHECK - WEAR ON LEFT WING 2 SLAT INTERNAL SKIN LOWER SURFACE AT SLAT TRACK 6. REPAIRED LEFT WING 2 SLAT INTERNAL SKIN LOWER SURFACE AT SLAT TRACK 6 IAW EA 503348.SDR USAA2012110600010Floor Panel · delaminated2S CHECK - DELAMINATION ON FLOOR PANEL 221EF BETWEEN FR16 TO FR20 & BETWEEN Y1292 TO Y254. REPLACED FLOOR PANEL 221EF IAW A319 SRM 53-12-00 FIG 206 & IRM 9701 REV G.SDR USAA2012110600009Floor Panel · delaminated2S CHECK - DELAMINATION ON FLOOR PANEL 252NF BETWEEN FR54 TO FR58 & BETWEEN -Y765 TO -Y1292. REPLACED FLOOR PANEL 252NF IAW A319 SRM 53-02-00 FIG 209 & IRM 9701 REV G.SDR USAA2012110600008Floor Panel · delaminated2S CHECK - DELAMINATION ON FLOOR PANEL 252SF BETWEEN FR58 TO FR62 & BETWEEN -Y254 TO -Y765. REPLACED FLOOR PANEL 252SF IAW A319 SRM 53-02-00 FIG 209 & IRM 9701 REV G.SDR USAA2012110600007Floor Panel · delaminated2S CHECK - DELAMINATION FLOOR PANEL 252GF BETWEEN FR51 TO FR54 & BETWEEN -Y254 TO -Y765. REPLACED FLOOR PANEL 252GF IAW A319 SRM 53-02-00 FIG 209 & IRM 9701 REV G.SDR USAA2012113000004Hinge Fitting · excess play2S CHECK - EXCESSIVE PLAY ON RUDDER HINGE ARM END FITTING NR 1. REPLACED NR 1 RUDDER HINGE ARM END FITTING IAW A319 SRM 51-42-11 & AMM 55-36-41.SDR USAA2012113000001Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT RAIL BEAM BETWEEN FR64 TO FR66+5 INCHES, Y765. REPLACED SEAT RAIL BEAM BETWEEN FR64 TO FR66+5 INCHES, Y765 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53472815.SDR USAA2012111900018Floor Panel · delaminated2S CHECK - DELAMINATION ON FLOOR PANEL 151VG BETWEEN FR53 TO FR55 & BETWEEN S38R TO S38L. REPLACED FLOOR PANEL 151VG IAW A319 SRM 53-02-00 & IRM 9701 REV G.SDR USAA2012112300018Sill · corroded2S CHECK - CORROSION ON LEFT LOWER DOOR SILL BETWEEN FR66 TO FR68, S23L. REPLACED LEFT LOWER DOOR SILL BETWEEN FR66 TO FR68, S23L IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53480505.SDR USAA2012021000007Lug · missingC11 CHECK - SAFETY LUG MISSING FROM LEFT ELEVATOR NR 5 HINGE FITTING AT FORWARD SPAR. REPAIRED LEFT ELEVATOR NR 5 HINGE FITTING IAW EA 201802.SDR USAA2012021000006Shear Plate · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOOR SUPPORT SHEAR PLATE BETWEEN FR69 TO FR70, S23R, Z-500. REPLACED FLOOR SUPPORT SHEAR PLATE BETWEEN FR69 TO FR70, S23R, Z-500 IAW A319 SRM 51-72-11 & AIRBUS DRAWING # D53474180.SDR USAA2012020800009Floor Panel · delaminatedC11 CHECK - DELAMINATION ON FLOOR PANEL 232DF BETWEEN FR20 TO FR24, Z-500, -Y500. REPLACED FLOOR PANEL 232DF IAW IRM 9701 REV G.SDR USAA2012020800008Floor Panel · delaminatedC11 CHECK - DELAMINATION ON FLOOR PANEL 221AF BETWEEN FR13 TO FR16, Z-500, Y=0. REPLACED FLOOR PANEL 221AF IAW IRM 9701 REV G.SDR USAA2012020800007Floor Panel · delaminatedC11 CHECK - DELAMINATION ON FLOOR PANEL 221EF BETWEEN FR18 TO FR20, Z-500, Y765. REPLACED FLOOR PANEL 221EF IAW IRM 9701 REV G.SDR USAA2012020800006Floor Panel · delaminatedC11 CHECK - DELAMINATION ON FLOOR PANEL 261DF BETWEEN FR66 TO FR68, Z-500, Y=0. REPLACED FLOOR PANEL 261DF IAW IRM 9701 REV G.SDR USAA2012020600037Floor Support · corrodedC11 CHECK - LEVEL 2 FILIFORM CORROSION ON FLOOR SUPPORT BETWEEN FR68 TO FR69, Y1162.5. REPLACED FLOOR SUPPORT BETWEEN FR68 TO FR69, Y1162.5 IAW A319 SRM 51-72-11.SDR USAA2012020600036Floor Support · corrodedC11 CHECK - LEVEL 2 FILIFORM CORROSION ON FLOOR SUPPORT BETWEEN FR64 TO FR66, Y1292. REPLACED FLOOR SUPPORT BETWEEN FR64 TO FR66, Y1292 IAW A319 SRM 51-72-11.SDR USAA2012020600035Floor Support · corrodedC11 CHECK - LEVEL 2 FILIFORM CORROSION ON FLOOR SUPPORT AT FR66, Y1292. REPLACED FLOOR SUPPORT AT FR66, Y1292 IAW A319 SRM 51-72-11.SDR USAA2012021000008Sill · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON SILL PLATE AT FR66, Z-500, -Y1292. REPAIRED SILL PLATE AT FR66, Z-500, -Y1292 IAW EA # 201755.SDR USAA2012020600031Floorbeam · corrodedC11 CHECK - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR66, Z-500, -Y464.8. REPLACED FLOORBEAM AT FR66, Z-500, -Y464.8 IAW A319 SRM 52-71-11, 51-25-13 & TYPICAL REPAIR # TR320-2528-10-0011C.SDR USAA2012020300013Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR67 TO FR68, Z-500, Y765. REPLACED FLOORBEAM BETWEEN FR67 TO FR68, Z-500, Y765 IAW A319 SRM 51-42-11.SDR USAA2012020300012Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR64, Z-500, Y1292. REPLACED FLOORBEAM AT FR64, Z-500, Y1292 IAW A319 SRM 52-41-11.SDR USAA2012020300011Skin · saturatedC11 CHECK - AREA OF WATER EGRESS ON LEFT ELEVATOR UPPER SURFACE APPROX 156 INCHES FROM INBOARD EDGE & 6 INCHES FROM TRAILING EDGE. REPAIRED LEFT ELEVATOR UPPER SURFACE IAW A319 SRM 55-21-11.SDR USAA2012020300010Skin · saturatedC11 CHECK - AREA OF WATER EGRESS ON LEFT ELEVATOR UPPER SURFACE APPROX 143 INCHES FROM INBOARD EDGE & 5.5 INCHES FROM TRAILING EDGE. REPAIRED LEFT ELEVATOR UPPER SURFACE IAW A319 SRM 55-22-11.SDR USAA2012020300009Skin · saturatedC11 CHECK - AREA OF WATER EGRESS ON LEFT ELEVATOR UPPER SURFACE APPROX 127 INCHES FROM INBOARD EDGE & 3.5 INCHES FROM TRAILING EDGE. REPAIRED LEFT ELEVATOR UPPER SURFACE IAW A319 SRM 55-21-11.SDR USAA2012020300008Skin · saturatedC11 CHECK - AREA OF WATER EGRESS ON LEFT ELEVATOR UPPER SURFACE APPROX 94 INCHES FROM INBOARD EDGE & 14 INCHES FROM TRAILING EDGE. REPAIRED LEFT ELEVATOR UPPER SURFACE IAW A319 SRM 55-21-11.SDR USAA2012020300018Shear Plate · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON SHEAR PLATE BETWEEN FR69 TO FR70, Z-500, Y1162.5. REPLACED SHEAR PLATE BETWEEN FR69 TO FR70, Z-500, Y1162.5 IAW A319 SRM 51-72-11 & TYPICAL REPAIR TR320-2528-10-0011C.SDR USAA2012020100007Shear Plate · crackedC11 CHECK - CRACK ON SHEAR PLATE AT FR68, S23L, Z-500, Y1163. REPLACED SHEAR PLATE AT FR68, S23L, Z-500, Y1163 IAW AIRBUS DRAWING # 18D53480019.SDR USAA2012020600032Floorbeam · corrodedC11 CHECK - LEVEL 2 CORROSION ON FLOORBEAM BETWEEN FR68 TO FR69, Z-500, -Y1162.5. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, Z-500, -Y1162.5 IAW A319 SRM 51-72-11 & AIRBUS DRAWING # D53472780.SDR USAA2012020600030Beam · corrodedC11 CHECK - LEVEL 2 GALVANIC CORROSION ON Z-BEAM BETWEEN FR67 TO FR68, Z-500, -Y1292. REPLACED Z-BEAM BETWEEN FR67 TO FR68, Z-500, -Y1292 IAW A319 SRM 52-71-11.SDR USAA2012020600038Floor Support · corrodedC11 CHECK - LEVEL 2 GALVANIC CORROSION ON FLOOR SUPPORT BETWEEN FR64 TO FR70, -Y765. REPLACED FLOOR SUPPORT BETWEEN FR64 TO FR70, -Y765 IAW A319 SRM 51-72-11.SDR USAA2012020600034Floor Support · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOOR SUPPORT BETWEEN FR14 TO FR16, Z-500, Y81. REPLACED FLOOR SUPPORT BETWEEN FR14 TO FR16, Z-500, Y81 IAW A319 SRM 51-72-11.SDR USAA2012020600033Floor Support · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOOR SUPPORT BETWEEN FR12 TO FR24, Y254. REPLACED FLOOR SUPPORT BETWEEN FR12 TO FR24, Y254 IAW A319 SRM 51-72-11.SDR USAA2012020700001Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR63, -Z500, Y1589. REPLACED FLOORBEAM AT FR63, -Z500, Y1589 IAW AIRBUS DRAWINGS D53472750 AND D53474250.SDR USAA2012020600016Floor Support · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOOR SUPPORT BETWEEN FR12 TO FR24, Z-500, -Y254. REPLACED FLOOR SUPPORT BETWEEN FR12 TO FR24, Z-500, -Y254 IAW A319 SRM 51-72-11.SDR USAA2012020300019Sill · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON DOOR CENTER SHAPE SILL BETWEEN FR66 TO FR68, Z-500, Y1589. REPLACED DOOR CENTER SHAPE SILL BETWEEN FR66 TO FR68, Z-500, Y1589 IAW A319 SRM 51-40-00.SDR USAA2012020300017Floor Support · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOOR SUPPORT BETWEEN FR12 TO FR24, Y1292. REPLACED FLOOR SUPPORT BETWEEN FR12 TO FR24, Y1292 IAW A319 SRM 51-72-11.SDR USAA2012020300015Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR20 TO FR24, -Y1292. REPLACED FLOORBEAM BETWEEN FR20 TO FR24, -Y1292 IAW A319 SRM 53-11-14.SDR USAA2012020300014Floorbeam · corrodedC11 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR16 TO FR24, -Y1292. REPLACED FLOORBEAM BETWEEN FR16 TO FR24, -Y1292 IAW A319 SRM 53-11-14.SDR USAA2012020200005Floor Support · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOOR SUPPORT BETWEEN FR208 TO FR24, -Y765. REPLACED FLOOR SUPPORT BETWEEN FR208 TO FR24, -Y765 IAW A319 SRM 51-72-11.
Back to N748UW