N701UW
Service difficulty reports · 286
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 = 'N701UW' 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 = 'N701UW' 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 AALA201506179004Hinge Fitting · excess play3S CHECK, RT ELEVATOR NR 1 HINGE FITTING HAS EXCESSIVE PLAY. REPLACED THE RT ELEVATOR NR 1 HINGE FITTING IAW AMM 55-16-42-400-001-A.SDR AALA201506299001Seat Track · corroded3S CHECK, CORROSION ON SEAT TRACK BETWEEN FRAME 47 & 64 AT -Y1292. REPLACED SEAT TRACK IAW SRM 51-72-11-001 & DWG D53476917.SDR AALA201506269001Door Frame · cracked3S CHECK, CRACK INDICATION FOUND ON DOOR FRAME AT FRAME 68 & STRINGER 8R. REPAIRED IAW EA 251767.SDR AALA201506229016Floor Panel · delaminated3S CHECK, CABIN FLOOR PANEL 251WF DELAMINATED. REPLACED FLOOR PANEL IAW SRM 53-02-00-201.SDR AALA201506179009Floor Panel · cracked3S CHECK, BULK CARGO COMPARTMENT FLOOR PANEL 161NF CRACKED. REPLACED BULK CARGO COMPARTMENT FLOOR PANEL 161NF IAW IRM 9701 REV G.SDR AALA201506129013Cover · corrodedSAL S3 & SY6 CHECK. GALVANIC CORROSION ON JOINT COVER BETWEEN FRAME 12 TO 16 AT -Y81. REPLACED JOINT COVER IAW SRM A319 51-72-11, DWG D53112829.SDR AALA201506299009Door Frame · cracked3S CHECK, R1 DOOR CUT OUT FRAME CRACKED AT FRAME 16 & ABOVE DOOR STOP NR 7. REPAIRED IAW EA 251687.SDR AALA201506299007Plate · cracked3S CHECK, PRESS PLATE AT FRAME 43 & -Y1650 CRACKED. REPLACED PRESS PLATE IAW SRM 51-72-11 & DWG D53370500.SDR AALA201506299006Crossbeam · cracked3S CHECK, CABIN CROSSBEAM AT FRAME 16 & Y1379 TO Y1405 CRACKED. REPAIRED CROSSBEAM IAW EA 251595.SDR AALA201506299005Crossbeam · cracked3S CHECK, CABIN CROSSBEAM AT FRAME 16 BETWEEN -Y1379 TO -Y1405 CRACKED. REPAIRED IAW EA 251595.SDR AALA201506259001Beam · cracked3S CHECK, PAX CABIN LT SIDE BOX BEAM CRACKED AT A FASTENER HOLE ON THE UPPER FLANGE AT FRAME 43 & + Y 1650. REPAIRED BEAM IAW EA 251677 & EO 5315Y066.SDR AALA201506239003Hinge Fitting · excess play3S CHECK, EXCESSIVE PLAY ON NR 2 RUDDER HINGE FITTING ON VERTICAL STABILIZER. REPLACED NR 2 RUDDER HINGE FITTING ON VERTICAL STABILIZER IAW SRMA 319 51-42-11 & AMM 55-36-41-0401.SDR AALA201506199007Hinge Fitting · excess play3S CHECK, NR 3 RUDDER HINGE FITTING HAS EXCESSIVE PLAY. REPLACED NR 3 RUDDER HINGE FITTING IAW AMM 55-36-41-400-001-A.SDR AALA201506199008Hinge Fitting · excess play3S CHECK, NR 7 RUDDER HINGE FITTING HAS EXCESSIVE PLAY. REPLACED NR 7 RUDDER HINGE FITTING IAW AMM 55-36-41-400-001-A.SDR AALA201506129015Floor Panel · delaminatedS3 & SY6 CHECK. DELAMINATED FLOOR PANEL 261 BETWEEN FRAME 64 TO 66 & BETWEEN Y765 TO Y1732. REPLACED FLOOR PANEL 261B IAW SRM 53-02-00 PAR 8H FIG 209 & IRM 9701 REV G.SDR AALA201506259007Pressure Deck · cracked3S CHECK, FWD CARGO COMPARTMENT PRESS DECK MEMBRANE HAS A CRACKED FASTENER HOLE AT FRAME 36 BETWEEN + Y 1523 - + Y 1292. REPAIRED PRESS DECK MEMBRANE IAW EA 251563. ENER PN ENG115K3AX & NOT PN ASNA2536-3A IAW SRM A319 51-42-11 & EA 251563.SDR AALA201506199005Plate · cracked3S CHECK, CRACK ON R1 DOOR EXTERNAL SKIN RT UPPER PLATE. REPLACED R1 DOOR EXTERNAL SKIN RT UPPER PLATE IAW SRM 51-72-11-001 & DWG D52110475.SDR AALA201506199006Floor Panel · delaminated3S CHECK: AFT CARGO COMPARTMENT FLOOR PANEL 151ZG HAS DELAMINATION. REPLACED FLOOR PANEL IAW IRM 9701 REV G.SDR AALA201504279007Lens · damagedEMERGENCY LIGHT LENS DAMAGED. REPLACED THE LENS AT SEAT 1C.SDR AALA201504279001Cover · missingEXIT LIGHT 10D COVER MISSING. REPLACED MISSING EMERGENCY LIGHT COVER AT SEAT 10D.SDR AALA201504219010Lens · missingEXIT LENS COVER MISSING FROM LIGHT FIXTURE AT DOOR 2R. INSTALLED COVER AT DOOR 2R.SDR USAA2015031900010Smoke Detector · faultyDURING CRUISE, CAPTAIN NOTIFIED CREW THAT SMOKE DETECTORS WERE INOPERATIVE. FLIGHT ATTENDANTS LATER SMELLED ODOR IN AFT GALLEY & SAW FOG AT ROW 20. CAPTAIN ELECTED TO RETURNED DUE TO AFT CARGO COMPARTMENT SMOKE DETECTOR FAULT, FUMES & FOG. R & R AFT CARGO CSDR USAA2015020900009Lens · looseEMERGENCY EXIT LIGHT AT ROW 1L IS LOOSE. REPLACED EMER EXIT LENS AT ROW 1L.SDR USAA2014112400007Connector · defectiveOVERHEAD EMER LIGHT AT ROW 2 INOPERATIVE. REPLACED THE CONNECTOR IAW ELEC SPM 20-44-10. OPERATIONS CHECKED GOOD.SDR USAA2014111100001Lens · missingTWO MISSING EXIT LIGHT COVERS. REPLACED EXIT LIGHT COVERS AS REQUIRED.SDR USAA2014070900007Door Sill · corrodedC11 CHECK LEVEL 2 EXFOLIATION CORROSION ON L2 DOOR SILL BETWEEN FRAME 66 TO 68, Y1732. REPLACED L2 DOOR SILL BETWEEN FRAME 66 TO 68, Y1732 IAW SRM 53-41-14, FIG 101 & 51-42-11.SDR USAA2014070800011Door Sill · corrodedC11 CHECK LEVEL 2 GALVANIC CORROSION ON R2 DOOR SILL AT FRAME 66 TO 68, -Y1732. REPLACED R2 DOOR SILL AT FRAME 66 TO 68, -Y1732 IAW SRM 53-41-14, FIG 101, 51-44-11 & 51-42-11.SDR USAA2014070700036Floorbeam · corrodedC11 CHECK CABIN FLOORBEAM CORRODED AT FRAME 66 & Y 1292. R & R BEAM IAW SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2014070700035Floorbeam · corrodedC11 CHECK CABIN FLOORBEAM CORRODED BETWEEN FRAME 68 & 69 AT Y -1292. R & R BEAM IAW SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2014070700034Floorbeam · corrodedC11 CHECK CABIN FLOORBEAM CORRODED BETWEEN FRAME 66 & 68 AT Y -1292. BEAM IAW SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2014070700033Floor Panel · delaminatedC11 CHECK CABIN FLOOR PANEL 261PF DELAMINATED. FABRICATED & INSTALLED REPLACEMENT PANEL IAW SRM 53-02-00 FIG 209.SDR USAA2014070700028Floorbeam · corrodedC11 CHECK CABIN FLOORBEAM CORRODED BETWEEN FRAME 68 & 69 AT Y 1292. R & R BEAM IAW SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2014070700027Floor Panel · delaminatedC11 CHECK CABIN FLOOR PANEL 261CG DELAMINATED. FABRICATED & INSTALLED REPLACEMENT PANEL IAW SRM 53-02-00 FIG 209.SDR USAA2014070700038Floorbeam · corrodedC11 CHECK CABIN FLOORBEAM CORRODED BETWEEN FRAME 64 & 66 AT Y -765. R & R BEAM IAW SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2014070700037Floor Panel · delaminatedC11 CHECK CABIN FLOOR PANEL 221DF DELAMINATED. FABRICATED & INSTALLED REPLACEMENT PANEL IAW SRM 53-02-00 FIG 209.SDR USAA2014070700032Floorbeam · corrodedC11 CHECK CABIN FLOORBEAM CORRODED BETWEEN FRAME 66 & 70 AT Y 765. R & R BEAM IAW SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2014070700031Floorbeam · corrodedC11 CHECK CABIN FLOORBEAM CORRODED BETWEEN FRAME 64 & 66 AT Y 765. R & R BEAM IAW SRM 53-41-15 FIG 101, 51-21-11, 51-75-12 & 51-42-11.SDR USAA2014070700029Floorbeam · corrodedC11 CHECK CABIN FLOORBEAM CORRODED BETWEEN FRAME 66 & 70 AT Y -465. R & R BEAM IAW SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2014070700026Floorbeam · corrodedC11 CHECK CABIN FLOORBEAM CORRODED BETWEEN FRAME 66 & 70 AT Y -765. R & R BEAM IAW SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2014070700025Floor Panel · delaminatedC11 CHECK CABIN FLOOR PANEL 222EF DELAMINATED. FABRICATED & INSTALLED REPLACEMENT PANEL IAW SRM 53-02-00 FIG 209.SDR USAA2014070700024Floor Panel · delaminatedC11 CHECK CABIN FLOOR PANEL 232FF DELAMINATED. FABRICATED & INSTALLED REPLACEMENT PANEL IAW SRM 53-02-00 FIG 209.SDR USAA2014070700023Floor Panel · delaminatedC11 CHECK CABIN FLOOR PANEL 231CF DELAMINATED. FABRICATED & INSTALLED REPLACEMENT PANEL IAW SRM 53-02-00 FIG 209.SDR USAA2014070100019Floor Support · corrodedC11 CHECK LEVEL 2 GALVANIC CORROSION ON FLOOR SUPPORT BETWEEN FRAME 64 TO 68, -Y465. REPLACED FLOOR SUPPORT BETWEEN FRAME 64 TO 68, -Y465 IAW SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2014070100018Floor Support · corrodedC11 CHECK LEVEL 2 GALVANIC CORROSION ON FLOOR SUPPORT BETWEEN FRAME 65 TO 67, -Y318. REPLACED FLOOR SUPPORT BETWEEN FRAME 65 TO 67, -Y318 IAW SRM 53-00-14 FIG 102 & 51-42-11.SDR USAA2014070100017Seat Track · corrodedC11 CHECK LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FRAME 12 TO 24, -Y1292. REPLACED SEAT TRACK BETWEEN FRAME 12 TO 24, -Y1292 IAW SRM 53-11-14 FIG 101 & 51-42-11.SDR USAA2014070100016Fitting · corrodedC11 CHECK LEVEL 2 EXFOLIATION CORROSION ON R2 DOOR AFT SILL CORNER FITTING AT FRAME 68, -Y1732. REPLACED R2 DOOR AFT SILL CORNER FITTING AT FRAME 68, -Y1732 IAW SRM 51-42-11.SDR USAA2014070100015Door Sill · corrodedC11 CHECK LEVEL 2 EXFOLIATION CORROSION ON R2 DOOR SILL MID SILL SHAPE AT FRAME 67, -Y1732. REPLACED R2 DOOR SILL MID SILL SHAPE AT FRAME 67, -Y1732 IAW SRM 51-42-11.SDR USAA2014063000024Seat Track · corrodedC11 CHECK LEVEL 2 GALVANIC CORROSION ON SEAT TRACK BETWEEN FRAME 20 TO 24, -Y765. REPLACED SEAT TRACK BETWEEN FRAME 20 TO 24, -Y765 IAW SRM 53-00-15, FIG 101 & 51-42-11.SDR USAA2014063000023Floor Panel · delaminatedC11 CHECK DELAMINATION ON FLOOR PANEL 232EF BETWEEN FRAME 20 TO 24 & BETWEEN -Y1292 TO -Y754. REPLACED FLOOR PANEL 232EF IAW SRM 53-02-00, FIG 209.SDR USAA2014063000022Floor Support · corrodedC11 CHECK LEVEL 2 GALVANIC CORROSION ON FLOOR SUPPORT AT FRAME 20, -Y1732. REPLACED FLOOR SUPPORT AT FRAME 20, -Y1732 IAW SRM 51-42-11.
Back to N701UW