# Service difficulty reports: N417US, cancelled Sep 22, 2015

A list on [N417US, cancelled Sep 22, 2015](https://openairdocs.org/deregistered/N417US-2015-09-22.md).

Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.

Page 1 of 5 · 224 reports

- [SDR USAA2012010600025](https://openairdocs.org/sdr/USAA2012010600025.md): Seal · out of position · Jan 5, 2012 · N417US · Boeing 737401 · Emergency Exits
  > CREW REPORTED THE RIGHT EMERGENCY EXIT WINDOW IS PARTALLY BLOCKED BY INSULATION. MAINTENANCE REPOSITIONED DUST SEAL AND RE-INSTALLED RIGHT EMERGENCY EXIT DOOR PER AMM 52-21-00-404-003.
- [SDR USAA2012010400015](https://openairdocs.org/sdr/USAA2012010400015.md): Engine · vibration · Jan 2, 2012 · N417US · Boeing 737401 · Engine (Turbine/Turboprop)
  > ON TAKEOFF THROUGH CLIMBOUT, CREW NOTICED A STRANGE SOUND. OUT OF APPROXIMATELY 10,000 MCL, VIBRATION INDICATOR ON NR 1 ENGINE CLIMBED STEADILY THROUGH 4.0 TO 5.0 AND EGT CLIMBED TO APPROXIMATELY 910 DEGREE C. BEFORE PULLING BACK ENGINE NR 1. ACCOMPLISHED Q
- [SDR USAA2011121200002](https://openairdocs.org/sdr/USAA2011121200002.md): Lens · missing · Dec 11, 2011 · N417US · Boeing 737401 · Emergency Lighting
  > CREW REPORTED THE EMERGENCY EXIT LENS MISSING AT AIRCRAFT LEFT, ROWS 11-12. MAINTENANCE REPLACED LEFT OVERWING EXIT DOOR EMERGENCY LIGHT LENS COVER. CHECKS OK PER AMM 33-51-41-201.
- [SDR USAA2011103100003](https://openairdocs.org/sdr/USAA2011103100003.md): Lens · unsecure · Oct 30, 2011 · N417US · Boeing 737401 · Emergency Lighting
  > CREW REPORTED THE OVERWING EXIT SIGN, AIRCRAFT LEFT, IS MISSING. MAINTENANCE SECURED THE LEFT OVERWING EXIT LENS. OK FOR SERVICE.
- [SDR USAA2011102100013](https://openairdocs.org/sdr/USAA2011102100013.md): Sign · detached · Oct 21, 2011 · N417US · Boeing 737401 · Emergency Lighting
  > CREW REPORTED THE EXIT SIGN AT OVERWING EXIT NEEDS RE-ATTACHED. MAINTENANCE RE-ATTACHED EXIT SIGN AT OVERWING EXIT AS REQUIRED.
- [SDR USAA2011101400017](https://openairdocs.org/sdr/USAA2011101400017.md): Seat Track · lack of lube · Oct 13, 2011 · N417US · Boeing 737401 · Fuselage, Seat/Cargo Attach Fittings
  > CAPTAIN'S SEAT IS DIFFICULT TO ADJUST FORE AND AFT. MAINTENANCE LUBED THE SEAT TRACKS. OPS CHECKS GOOD.
- [SDR USAA2011101000029](https://openairdocs.org/sdr/USAA2011101000029.md): Mechanism · lack of lube · Oct 9, 2011 · N417US · Boeing 737401 · Flight Compartment Equipment
  > CAPTAIN'S SEAT WILL NOT STAY IN POSITION, SLIDES DURING TAKEOFF AND LANDING. MAINTENANCE LUBRICATED THE LOCKING MECHANISM. OPS CHECK GOOD.
- [SDR USAA2011091500001](https://openairdocs.org/sdr/USAA2011091500001.md): Sign · detached · Sep 14, 2011 · N417US · Boeing 737401 · Emergency Lighting
  > CREW REPORTED THE EMERGENCY EXIT SIGN AT ROW 11/12, LEFT SIDE, KEEPS FALLING DOWN. MAINTENANCE REPAIRED EMERGENCY EXIT SIGN AS NEEDED. OPS CHECKS GOOD.
- [SDR USAA2011082900021](https://openairdocs.org/sdr/USAA2011082900021.md): Strap · corroded · Aug 20, 2011 · N417US · Boeing 737401 · Fuselage Miscellaneous Structure
  > Q3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON STRAP AT BS 795, S27R. REPAIRED STRAP AT BS 795, S27R IAW EA 103233.
- [SDR USAA2011082900007](https://openairdocs.org/sdr/USAA2011082900007.md): Floorbeam · corroded · Aug 20, 2011 · N417US · Boeing 737401 · Fuselage Main, Floor Beam
  > Q3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON AFT CARGO FLOORBEAM AT BS 773, LBL 3. REPLACED AFT CARGO FLOORBEAM AT BS 773, LBL 3 IAW EA 103286.
- [SDR USAA2011082900006](https://openairdocs.org/sdr/USAA2011082900006.md): Floorbeam · corroded · Aug 20, 2011 · N417US · Boeing 737401 · Fuselage Main, Floor Beam
  > Q3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON AFT CARGO FLOORBEAM AT BS 773, LBL 8. REPAIRED AFT CARGO FLOORBEAM AT BS 773, LBL 8 IAW EA 103286.
- [SDR USAA2011082900005](https://openairdocs.org/sdr/USAA2011082900005.md): Floorbeam · corroded · Aug 20, 2011 · N417US · Boeing 737401 · Fuselage Main, Floor Beam
  > Q3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON AFT CARGO FLOORBEAM AT BS 773, RBL 3. REPAIRED AFT CARGO FLOORBEAM AT BS 773, RBL 3 IAW EA 103286.
- [SDR USAA2011082600019](https://openairdocs.org/sdr/USAA2011082600019.md): Frame · corroded · Aug 20, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME AT BS 747, LBL 8. REPAIRED FUSELAGE FRAME AT BS 747, LBL 8 IAW B737 SRM 53-00-07, REPAIR 4.
- [SDR USAA2011082600018](https://openairdocs.org/sdr/USAA2011082600018.md): Frame · corroded · Aug 20, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME AT BS 747 BETWEEN S26L TO S27L. REPAIRED FUSELAGE FRAME AT BS 747 BETWEEN S26L TO S27L IAW B737 SRM 53-00-07, REPAIR 4.
- [SDR USAA2011082600024](https://openairdocs.org/sdr/USAA2011082600024.md): Failsafe · gouged · Aug 19, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - 4 WEAR MARKS ON FAIL SAFE CHORDS ON FUSELAGE FRAME AT BS 727A BETWEEN S20L TO S24L. REPAIRED FAIL SAFE CHORDS ON FUSELAGE FRAME AT BS 727A BETWEEN S20L TO S24L IAW EA 103253.
- [SDR USAA2011082600023](https://openairdocs.org/sdr/USAA2011082600023.md): Failsafe · gouged · Aug 18, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - 4 WEAR MARKS ON FAIL SAFE CHORDS ON FUSELAGE FRAME AT BS 727B AT S20L, S21L, S23L & S24L. REPAIRED FAIL SAFE CHORDS ON FUSELAGE FRAME AT BS 727B AT S20L, S21L, S23L & S24L IAW EA 103254.
- [SDR USAA2011082600022](https://openairdocs.org/sdr/USAA2011082600022.md): Frame · corroded · Aug 18, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME LOWER LEG AT BS 767 BETWEEN LBL 2 TO LBL 12. REPAIRED FUSELAGE FRAME LOWER LEG AT BS 767 BETWEEN LBL 2 TO LBL 12 IAW B737 SRM 53-00-07, REPAIR 3.
- [SDR USAA2011082900012](https://openairdocs.org/sdr/USAA2011082900012.md): Skin · damaged · Aug 17, 2011 · N417US · Boeing 737401 · Rudder, Plate/Skin
  > Q3 CHECK - MISSING PLYS LOCATED AT RUDDER STATION 7.0, 1.5" X 2.5"; MISSING PLYS AT RUDDER STA 133.0, 1.5" X 0.75". REPLACED RUDDER IAW JOB CARD 03C70827007.
- [SDR USAA2011082600025](https://openairdocs.org/sdr/USAA2011082600025.md): Frame · corroded · Aug 16, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE STUB FRAME AT BS 807 BETWEEN LBL 4 TO LBL 10. REPAIRED FUSELAGE STUB FRAME AT BS 807 BETWEEN LBL 4 TO LBL 10 IAW B737 SRM 53-00-07.
- [SDR USAA2011081900027](https://openairdocs.org/sdr/USAA2011081900027.md): Frame · cracked · Aug 13, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R IAW B737 SRM 53-00-07, REPAIR 13.
- [SDR USAA2011081900021](https://openairdocs.org/sdr/USAA2011081900021.md): Frame · corroded · Aug 12, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME AT BS 787, LBL 8. REPAIRED FUSELAGE FRAME AT BS 787, LBL 8 IAW B737 SRM 53-00-07, REPAIR 3.
- [SDR USAA2011082900022](https://openairdocs.org/sdr/USAA2011082900022.md): Angle · corroded · Aug 11, 2011 · N417US · Boeing 737401 · Fuselage Miscellaneous Structure
  > Q3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON TRANSITION ANGLE BETWEEN BS 767 TO BS 790, RBL 20. REPLACED TRANSITION ANGLE BETWEEN BS 767 TO BS 790, RBL 20 IAW B737 SRM 53-60-53 BOEING DRAWING 65-47957.
- [SDR USAA2011082900020](https://openairdocs.org/sdr/USAA2011082900020.md): Skin · delaminated · Aug 11, 2011 · N417US · Boeing 737401 · Elevator, Tab Structure
  > Q3 CHECK - DELAMINATION ON LEFT ELEVATOR TAB LOWER SKIN SURFACE AT NR 2 HINGE CUTOUT. REPLACED LEFT ELEVATOR TAB IAW JOB CARD 03C71127007.
- [SDR USAA2011082900013](https://openairdocs.org/sdr/USAA2011082900013.md): Skin · delaminated · Aug 11, 2011 · N417US · Boeing 737401 · Elevator, Tab Structure
  > Q3 CHECK - DELAMINATION ON RIGHT ELEVATOR TAB LOWER SKIN AT 2 HINGE CUTOUT. REPLACED RIGHT ELEVATOR TAB IAW JOB CARD 03C71227004.
- [SDR USAA2011082900008](https://openairdocs.org/sdr/USAA2011082900008.md): Attach Angle · cracked · Aug 11, 2011 · N417US · Boeing 737401 · Fuselage Main, Floor Beam
  > Q3 CHECK - CRACK ON FLOORBEAM VERTICAL ATTACH ANGLE AT BS 328, RBL 32. REPLACED FLOORBEAM VERTICAL ATTACH ANGLE AT BS 328, RBL 32 IAW EA 103286.
- [SDR USAA2011081900034](https://openairdocs.org/sdr/USAA2011081900034.md): Doubler · cracked · Aug 11, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME WEB DOUBLER AT BS 303.9, S16L. REPAIRED FUSELAGE FRAME WEB DOUBLER AT BS 303.9, S16L IAW BOEING DRAWING 65-17684.
- [SDR USAA2011082600020](https://openairdocs.org/sdr/USAA2011082600020.md): Beltframe · cracked · Aug 10, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500D BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500D BETWEEN S20R TO S21R IAW B737 SRM 53-00-07 REPAIR 13.
- [SDR USAA2011082900030](https://openairdocs.org/sdr/USAA2011082900030.md): Bulkhead · canning · Aug 5, 2011 · N417US · Boeing 737401 · Fuselage Main, Bulkhead
  > Q3 CHECK - OIL CANNING WAS FOUND AFTER REMOVING PREVIOUS REPAIR ON AFT PRESSURE BULKHEAD AT BS 1016 BETWEEN S9R TO S11R. REPAIRED AFT PRESSURE BULKHEAD WEB IAW EA 103226.
- [SDR USAA2011082900023](https://openairdocs.org/sdr/USAA2011082900023.md): Web · corroded · Aug 4, 2011 · N417US · Boeing 737401 · Fuselage Miscellaneous Structure
  > Q3 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON WEB BETWEEN BS767 TO BS787, S25R. REPLACED WEB BETWEEN BS 767 TO BS 787, S25R IAW B737 SRM 51-10-02.
- [SDR USAA2011082900010](https://openairdocs.org/sdr/USAA2011082900010.md): Keelbeam · corroded · Aug 4, 2011 · N417US · Boeing 737401 · Fuselage Main, Keel
  > Q3 CHECK - CORROSION ON AFT FUSELAGE RIGHT KEEL BEAM CHORD BETWEEN BS727C + 11 INCHES TO BS 816, S27R. REPLACED AFT FUSELAGE RIGHT KEEL BEAM BETWEEN BS 727C + 11 INCHES TO BS 816, S27R IAW EA 103215.
- [SDR USAA2011081900028](https://openairdocs.org/sdr/USAA2011081900028.md): Frame · cracked · Aug 3, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500F BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R IAW B737 SRM 53-00-07, REPAIR 13.
- [SDR USAA2011081900022](https://openairdocs.org/sdr/USAA2011081900022.md): Frame · cracked · Aug 3, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500G, S13L. REPAIRED FUSELAGE FRAME AT BS500G, S13L IAW EA 103214.
- [SDR USAA2011082900017](https://openairdocs.org/sdr/USAA2011082900017.md): Attach Angle · cracked · Aug 2, 2011 · N417US · Boeing 737401 · Fuselage Miscellaneous Structure
  > Q3 CHECK - CRACK ON AFT END OF ATTACH ANGLE BETWEEN BS 303.9 & BS 294.5, S10L. REPLACED ATTACH ANGLE BETWEEN BS 303.9 & BS 294.5, S10L IAW B737 SRM 51-40-03.
- [SDR USAA2011082900024](https://openairdocs.org/sdr/USAA2011082900024.md): Web · cracked · Aug 1, 2011 · N417US · Boeing 737401 · Galley Doors
  > Q3 CHECK - CRACK IN FORWARD GALLEY DOOR LOWER WEB. REPLACED FORWARD GALLEY DOOR LOWER WEB IAW B737 SRM 51-40-02.
- [SDR USAA2011082900029](https://openairdocs.org/sdr/USAA2011082900029.md): Pan · corroded · Jul 31, 2011 · N417US · Boeing 737401 · Fuselage Miscellaneous Structure
  > Q3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON AFT GALLEY FLOOR PAN BETWEEN BS 1016 +10 INCHES TO BS 1016 +16 INCHES & BETWEEN LBL 2 TO RBL 2. REPAIRED AFT GALLEY FLOOR PAN IAW B737 SRM 51-70-13 & BOEING DRAWING 65C32677.
- [SDR USAA2011081900029](https://openairdocs.org/sdr/USAA2011081900029.md): Frame · cracked · Jul 31, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500F JUST BELOW S13R. REPAIRED FUSELAGE FRAME AT BS 500F JUST BELOW S13R IAW TYPICAL REPAIR 737-5310-10-0327.
- [SDR USAA2011082900018](https://openairdocs.org/sdr/USAA2011082900018.md): Attach Angle · cracked · Jul 30, 2011 · N417US · Boeing 737401 · Fuselage Miscellaneous Structure
  > Q3 CHECK - CRACK ON AFT END OF ATTACH ANGLE BETWEEN BS 303.9 & BS 294.5, S13L. REPLACED ATTACH ANGLE BETWEEN BS 303.9 & BS 294.5, S13L IAW B737 SRM 51-40-02.
- [SDR USAA2011081900030](https://openairdocs.org/sdr/USAA2011081900030.md): Frame · cracked · Jul 30, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME AT BS 520, 1 INCH BELOW S13R. REPAIRED FUSELAGE FRAME AT BS 520, 1 INCH BELOW S13R IAW TYPICAL REPAIR 737-5310-10-0327, TABLE 1, FIG 8.
- [SDR USAA2011081900025](https://openairdocs.org/sdr/USAA2011081900025.md): Frame · cracked · Jul 30, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500C BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S20L TO S21L IAW B737 SRM 53-00-07, REPAIR 13.
- [SDR USAA2011081900024](https://openairdocs.org/sdr/USAA2011081900024.md): Frame · cracked · Jul 30, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500E BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500E BETWEEN S20L TO S21L IAW B737 SRM 53-00-07, REP 13.
- [SDR USAA2011081900023](https://openairdocs.org/sdr/USAA2011081900023.md): Frame · cracked · Jul 30, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500B BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500B BETWEEN S20R TO S21R IAW B737 SRM 53-00-07, REP 13.
- [SDR USAA2011082200025](https://openairdocs.org/sdr/USAA2011082200025.md): Frame · cracked · Jul 29, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500B BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME IAW B737 SRM 53-00-07, REPAIR 13.
- [SDR USAA2011081900033](https://openairdocs.org/sdr/USAA2011081900033.md): Angle · cracked · Jul 29, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME REINFORCEMENT ANGLE AT BS 500B BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME REINFORCEMENT ANGLE IAW B737 SRM 53-00-07, REPAIR 13.
- [SDR USAA2011081900031](https://openairdocs.org/sdr/USAA2011081900031.md): Frame · cracked · Jul 29, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500E, S13R. REPAIRED FUSELAGE FRAME AT BS 500E, S13R IAW TYPICAL REPAIR 737-5310-10-0327.
- [SDR USAA2011082900025](https://openairdocs.org/sdr/USAA2011082900025.md): Web · cracked · Jul 27, 2011 · N417US · Boeing 737401 · Fuselage Miscellaneous Structure
  > Q3 CHECK - CRACK IN INTERCOSTAL WEB AT BS 294.5, S12R. REPLACED INTERCOSTAL WEB AT BS 294.5, S12R IAW B737 SRM 51-40-02.
- [SDR USAA2011081900032](https://openairdocs.org/sdr/USAA2011081900032.md): Skin · cracked · Jul 27, 2011 · N417US · Boeing 737401 · Nacelle/Pylon, Plate/Skin
  > Q3 CHECK - CRACK ON RIGHT PYLON UPPER SKIN PANEL CUTOUT 5827R BETWEEN NAC STA210 TO NAC STA220. REPAIRED RIGHT PYLON UPPER SKIN PANEL CUTOUT 5827R IAW TYPICAL REPAIR 737-5430-10-0054.
- [SDR USAA2011081900026](https://openairdocs.org/sdr/USAA2011081900026.md): Frame · cracked · Jul 27, 2011 · N417US · Boeing 737401 · Fuselage Main, Frame
  > Q3 CHECK - CRACK ON FUSELAGE FRAME AT BS 480 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 480 BETWEEN S8R TO S9R IAW EA 103207.
- [SDR USAA2011082900026](https://openairdocs.org/sdr/USAA2011082900026.md): Angle · corroded · Jul 25, 2011 · N417US · Boeing 737401 · Fuselage Miscellaneous Structure
  > Q3 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON Z-ANGLE BETWEEN B887 TO BS1016, S17L. REPLACED Z-ANGLE BETWEEN BS 887 TO BS 1016, S17L IAW B737 SRM 51-40-02, 51-40-02, 51-40-03, 51-40-04 & 51-40-05.
- [SDR USAA2011081900035](https://openairdocs.org/sdr/USAA2011081900035.md): Skin · cracked · Jul 23, 2011 · N417US · Boeing 737401 · Fuselage Main, Plate/Skin
  > Q3 CHECK - CRACKS ON FUSELAGE SKIN AT MAIN ENTRY DOOR UPPER HINGE CUTOUTS AT BS303.9 BETWEEN S10L TO S13L. REPAIRED FUSELAGE FUSELAGE SKIN AT MAIN ENTRY DOOR UPPER HINGE CUTOUTS IAW B737 SRM 53-10-01, REPAIR 14.
- [SDR USAA2011082900027](https://openairdocs.org/sdr/USAA2011082900027.md): Strap · cracked · Jul 20, 2011 · N417US · Boeing 737401 · Fuselage Miscellaneous Structure
  > Q3 CHECK - CRACK ON H-STRAP AT BS 303.9, S13L. REPLACED H-STRAP AT BS303.9, S13L IAW B737 SRM 53-10-15 & BOEING DRAWING 65-17684 FRAME NR 1.

Next page: https://openairdocs.org/deregistered/N417US-2015-09-22/reports.md?page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 'N417US' AND deregistration_id = 'N417US-2015-09-22'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N417US-2015-09-22/reports

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.