# Service difficulty reports: N397US, cancelled Jul 18, 2006

A list on [N397US, cancelled Jul 18, 2006](https://openairdocs.org/deregistered/N397US-2006-07-18.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 2 · 74 reports

- [SDR USAA051066](https://openairdocs.org/sdr/USAA051066.md): Skin · cracked · Sep 6, 2005 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > CRACK IN FUSELAGE SKIN BS 754, S25L. CUT OUT DAMAGE, FABRICATED AND INSTALLED DOUBLER PER SRM 53-00-01 FIG 249. DEFECT SIZE: 4.5 INCH CRACK IN FUSELAGE SKIN.
- [SDR USAA051067](https://openairdocs.org/sdr/USAA051067.md): Skin · cracked · Sep 6, 2005 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > 15.5 INCHES AFT OF BS 727D, S23L (2) 16.5 INCHES AFT OF BS 727D, S-22L, REMOVED DAMAGE, FAB AND INST DOUBLER, INC 2 CRACKS AND 2 PREEX REPAIRS TO 1 DOUBLER REP IAW 53-00-01 FIG 201. DEFECT SIZE: (1) 15.5 INCHES AFT OF BS 727D, S-23-L, (2) 16.5 INCHES AFT OF B
- [SDR SB05078](https://openairdocs.org/sdr/SB05078.md): Seal · leaking · Jul 2, 2005 · N397US · Boeing 7373B7 · Fuselage Main, Bulkhead
  > CREW REPORTED A LOSS OF CABIN PRESSURIZATION. CREW ACCOMPLISHED AN EMERGENCY DESCENT, DECLARED AN EMERGENCY AND DIVERTED TO RIC WHERE THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. NO OXYGEN MASKS WERE DEPLOYED. MAINTENANCE FOUND AND RESECURED LOOSE POTABLE WA
- [SDR USAA040352](https://openairdocs.org/sdr/USAA040352.md): Skin · cracked · Jul 20, 2004 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > FOUND SKIN CRACKED 2.5 INCHES, 5 INCHES FORWARD OF BS 500 RT AND 1 INCH ABOVE S-15R. (M)
- [SDR USA2004F00017](https://openairdocs.org/sdr/USA2004F00017.md): Turbocharger · overserviced · Mar 1, 2004 · N397US · Boeing 7373B7 · APU Oil System
  > ON DESCENT, CREW REPORTED STRONG EXHAUST FUMES IN THE AFT CABIN. NO SMOKE WAS NOTED. CREW TURNED RIGHT PACK TO HIGH AND RECIRCULATION FAN TO OFF WITH NO CHANGE. FLIGHT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE APU OIL OVERSERVICED. REMOVED OIL TO PRO
- [SDR USAA040014](https://openairdocs.org/sdr/USAA040014.md): Skin · cracked · Jan 13, 2004 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > CLT - FOUND SKIN CRACKED.008 INCH, FS 727E JUST BELOW S24L. INSTALLED DOUBLER PER SRM 53-00-01. (M)
- [SDR USAA040015](https://openairdocs.org/sdr/USAA040015.md): Skin · cracked · Jan 6, 2004 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > CLT - FOUND SKIN CRACKED 6.250 INCH, FS 500D PLUS 3 INCHES JUST BELOW S15R. INSTALLED DOUBLER PER SRM 53-00-01. (M)
- [SDR USAA030222](https://openairdocs.org/sdr/USAA030222.md): Stringer · corroded · Nov 4, 2003 · N397US · Boeing 7373B7 · Fuselage Main, Longeron/Stringer
  > FOUND STRINGER CORRODED 6 INCHES, STRINGER 27R BETWEEN STRINGER TIE BS 360 AND BS 366. CORROSION LEVEL 1, TASK NR C53-202-01. ACCOMPLISHED REPAIR IAW SRM 53-00-03 FIG 201, WITH MINOR DEVIATION GRANTED BY EA 77108. (M)
- [SDR USAA030233](https://openairdocs.org/sdr/USAA030233.md): Skin · cracked · Oct 26, 2003 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > FOUND SKIN CRACKED 1.4 INCH LONG, STATION 727D PLUS 2 INCHES BELOW S23R. INSTALLED DOUBLER PER EA 94836. (M)
- [SDR USAA030234](https://openairdocs.org/sdr/USAA030234.md): Skin · cracked · Oct 22, 2003 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > FOUND SKIN CRACKED 1.1 INCH, STATION 754 ABOVE S21R. INSTALLED DOUBLER PER SRM 53-00-01 FIG 202. (M)
- [SDR USAA030211](https://openairdocs.org/sdr/USAA030211.md): Skin · cracked · Oct 3, 2003 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > FOUND SKIN CRAKCED.375 INCH, LOWER HINGE CUT OUT AFT SERVICE DOOR. REMOVED DAMAGE, INSTALLED TRIPLERS PER SRM 53-60-01. (M)
- [SDR USAA030210](https://openairdocs.org/sdr/USAA030210.md): Skin · cracked · Sep 27, 2003 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > FOUND SKIN CRACKED 2 INCHES, LOWER AFT CORNER OF FORWARD SERVICE DOOR OPENING. ROUTED OUT DAMAGE, INSTALLED FILLER/DOUBLER/TRIPLER PER SRM 53-10-01. (M)
- [SDR USAA030209](https://openairdocs.org/sdr/USAA030209.md): Stringer · cracked · Sep 22, 2003 · N397US · Boeing 7373B7 · Fuselage Main, Longeron/Stringer
  > FOUND STRINGER CRACKED 3 INCHES, BS 520 STRINGER 12 RT. INSTALLED DOUBLER PER EA 77007. (M)
- [SDR USAA030145](https://openairdocs.org/sdr/USAA030145.md): Skin · cracked · Aug 6, 2003 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > PIT - FOND SKIN CRACKED 3 INCHES, RIGHT SIDE STATION 520 STRINGER 12 RT. INSTLALED EXTERNAL DOUBLER, TEMPORARY REPAIR PER EA 76766 PER SRM 53-00-01 FIG 201. (M)
- [SDR USAASB03126](https://openairdocs.org/sdr/USAASB03126.md): Outflow Valve · leaking · Aug 2, 2003 · N397US · Boeing 7373B7 · Pressure Regulator/Outflow Valve
  > DTW - FLT 390 - EN ROUTE FROM CLT TO DTW, AT FL350, A/C LOST PRESSURIZATION. CABIN CLIMBED TO 11,000 FT WITH CABIN ALTITUDE WARNING HORN SOUNDING. CREW ACCOM QRH PROCEDURES AND RAPID DESCENT TO 10,000 FEET. FLT CONTINUED TO DTW AND LANDED WITHOUT INCIDENT.
- [SDR USAASB03123](https://openairdocs.org/sdr/USAASB03123.md): Wire · chafed · Jul 27, 2003 · N397US · Boeing 7373B7 · Air Conditioning System Wiring
  > ORD - FLT 299 - EN ROUTE FROM PHL TO ORD, AT FL350, THE CABIN ALTITUDE WARNING HORN SOUNDED. CABIN ALTITUDE WAS AT 11,500 FEET. CREW DECLARED AN EMERGENCY AND DESCENDED TO 10,000 FEET. CREW REGAINED CONTROL OF CABIN IN STANBY MODE. HIGHEST CABIN RATE OF DE
- [SDR USAA030099](https://openairdocs.org/sdr/USAA030099.md): Skin · cracked · Jun 27, 2003 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > FOUND SKIN CRAKED.75 INCHES LONG, SKIN BS 360 S27L, S27R, LOWER CENTERLINE. INSTALLED DOUBLER FROM BS 360-380 ON BOTTOM C/L OF SKIN PER TYPICAL REPAIR 53-30-07. (M)
- [SDR USAA030023](https://openairdocs.org/sdr/USAA030023.md): Skin · cracked · Mar 4, 2003 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > CLT - FOUND SKIN CRACKED 3.25 INCH, STATION 520 AND STRINGER 16R. INSTALLED REPAIR DOUBLER PER SRM 53-00-01 FIG 202. (M)
- [SDR USAA030017](https://openairdocs.org/sdr/USAA030017.md): Skin · cracked · Feb 11, 2003 · N397US · Boeing 7373B7 · Fuselage Main, Plate/Skin
  > CLT - FOUND UNSCHEDULED MAINTENANCE, SKIN CRACKED 2 INCHES, STATION 764 ABOVE STRINGER 21R. INSTALLED DOUBLER PER SRM 53-00-01, FIG 202. (M)
- [SDR USAASB01257](https://openairdocs.org/sdr/USAASB01257.md): Battery Pack · discharged · Sep 16, 2001 · N397US · Boeing 7373B7 · Emergency Lighting
  > IAD - MAINTENANCE FOUND SIX SEAT MOUNTED EMERGENCY LIGHTS, IN THE AFT CABIN, WOULD NOT ILLUMINATE WHEN TESTED. MAINTENANCE REMOVED AND REPLACED THE AFT EMERGENCY LIGHT BATTERY PACK. OPERATIONAL CHECK GOOD. (M)
- [SDR USAASB01121](https://openairdocs.org/sdr/USAASB01121.md): Outflow Valve · malfunctioned · Apr 30, 2001 · N397US · Boeing 7373B7 · Pressure Regulator/Outflow Valve
  > PIT - FLT 1107 - EN ROUTE FROM YYZ TO CLT, AT FL350, THE CABIN ALTITUDE ALERT SOUNDED AS CABIN WAS AT 10,000 FEET AND CLIMBING AT APPROXIMATELY 600 FEET PER MINUTES. CREW INITIATED DESCENT TO FL115 AND COMPLIED WITH QUICK REFERENCE HANDBOOK PROCEDURES BUT OUT
- [SDR USAASB01024](https://openairdocs.org/sdr/USAASB01024.md): Battery Pack · discharged · Jan 27, 2001 · N397US · Boeing 7373B7 · Emergency Lighting
  > TPA - MAINTENANCE FOUND THE AFT AISLE EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFT LEFT BATTERY PACK IN OVERHEAD PANEL AT STATION 736. OPERATIONAL CHECK GOOD. (M)
- [SDR USAASB99216](https://openairdocs.org/sdr/USAASB99216.md): Computer · failed · Aug 31, 1999 · N397US · Boeing 7373B7 · Elevator Control System
  > CLT - FLT 8052 - AIRCRAFT WAS FERRYING TO ABE FOR SCHEDULED SERVICE WHEN THE CAPTAIN REPORTED THE ELEVATOR FEEL DIFFERENTIAL PRESSURE LIGHT ILLUMINATED. FLIGHT DIVERTED TO CLT AND LANDED WITHOUT FURTHER INCIDENT. NO EMERGENCY WAS DECLARED. MAINTENANCE REMOV
- [SDR USAA990909](https://openairdocs.org/sdr/USAA990909.md): Frame · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Frame
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A.1250 INCH CRACK STA 847 FRAME AT STR 9R OVERHEAD BIN ATTACH POINT. INSTALLED FILLER AND REPAIR ANGLE PER EA 65193 AND SRM 53-00-07 FIG 202. (X)
- [SDR USAA990908](https://openairdocs.org/sdr/USAA990908.md): Frame · worn · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Frame
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 1 INCH SLIT WORN INTO FUSELAGE FRAME. BLENDED OUT DAMAGE, INSTALLED REPAIR DOUBLER PER TR 53-80-02. (X)
- [SDR USAA990907](https://openairdocs.org/sdr/USAA990907.md): Angle · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Miscellaneous Structure
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 1 INCH CRACK LT RAM AIR INLET UPPER AFT ANGLE AT BS 520, STR21L. INSTALLED REPAIR FILLER AND DOUBLER PER TR 53-50-03. (X)
- [SDR USAA990906](https://openairdocs.org/sdr/USAA990906.md): Tie Clip · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Miscellaneous Structure
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A CRACK AT STRINGER TIE CLIP STA 616 AT STR 4L. REMOVED AND REPLACED PER SRM 53-00-03. (X)
- [SDR USAA990905](https://openairdocs.org/sdr/USAA990905.md): Frame · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Frame
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 1 INCH CRACK BS 726 STR 18A LT CHORD ANGLE. REMOVED AND REPLACED PER SRM 51-10-02. (X)
- [SDR USAA990904](https://openairdocs.org/sdr/USAA990904.md): Frame · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Frame
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 1 INCH CRACK BS 723 STR 18A, LT CHORD ANGLE. REMOVED AND REPLACED PER SRM 51-10-02. (X)
- [SDR USAA990903](https://openairdocs.org/sdr/USAA990903.md): Frame · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Frame
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A..125 INCH CRACK STATION 787 FRAME AT STRINGER 9L OVERHEAD BIN ATTACH POINT. INSTALLED DOUBLER AND REPAIR ANGLE PER EA 65193. (M)
- [SDR USAA990902](https://openairdocs.org/sdr/USAA990902.md): Frame · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Frame
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A..125 INCH CRACK STATION 380 BETWEEN STRINGER 8R AND 9R FRAME. INSTALLED DOUBLER PER SRM 53-30-07. (M)
- [SDR USAA990901](https://openairdocs.org/sdr/USAA990901.md): Splice · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Miscellaneous Structure
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A.25 INCH CRACK STA 907 + 1/2 AT STR 4R. INSTALLED NEW STRINGER SPLICE PER SRM 51-10-00. (X)
- [SDR USAA990900](https://openairdocs.org/sdr/USAA990900.md): Splice · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Miscellaneous Structure
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A..25 INCH CRACK STATION 907 PLUS 1/2 AT STRINGER 4L. INSTALLED NEW STRINGER SPLICE PER SRM 51-10-00. (M)
- [SDR USAA990899](https://openairdocs.org/sdr/USAA990899.md): Frame · chafed · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Frame
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A..25 INCH BY 2 INCH CHAFFED AREA AT STATION 1064, BL 0 FRAME. DAMAGED BLENDED AND INSTALLED REPAIR DOUBLER PER TR 53-80-02. (M)
- [SDR USAA990898](https://openairdocs.org/sdr/USAA990898.md): Strap · corroded · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Miscellaneous Structure
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND CORROSION IN VARIOUS LOCATIONS STATION 774-855, RBL 19 STRAP. CORROSION LEVEL 1. REMOVED AND REPLACED WITH NEW STRAP PER SRM 51-10-02. (M)
- [SDR USAA990897](https://openairdocs.org/sdr/USAA990897.md): Tie Clip · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Miscellaneous Structure
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A..5 INCH CRACK STRINGER TIE CLIP STATION 663.75, STRINGER 10R. REMOVED CRACKED TIE CLIP INSTALLED NEW TIE CLIP PER SRM 51-10-02. (M)
- [SDR USAA990896](https://openairdocs.org/sdr/USAA990896.md): Frame · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Frame
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A..125 INCH CRACK STATION 807 FRAME, STRINGER 9R OVERHEAD BIN ATTACH POINT. INSTALLED REPAIR ANGLE AND FILLER PER EA 65193 AND SRM 53-00-07 FIG 202. (M)
- [SDR USAA990895](https://openairdocs.org/sdr/USAA990895.md): Frame · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Frame
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FUOND.125 INCH CRACK STATION 787 FRAME, STRINGER OVERHEAD BIN ATTACH POINT. INSTALLED REPAIR ANGLE AND FILLER PER EA 65193 AND SRM 53-00-07 FIG 202. (M)
- [SDR USAA990879](https://openairdocs.org/sdr/USAA990879.md): Stringer · corroded · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Longeron/Stringer
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 1 INCH BY 3 INCH AREA OF CORROSION BS 1007, STRINGER 23R, CORROSION LEVEL 1. INSTALLED STRINGER SPLICE PER SRM 53-00-03. (M)
- [SDR USAA990878](https://openairdocs.org/sdr/USAA990878.md): Intercostal · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Miscellaneous Structure
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 2 INCH CRACK STATION 178, RBL 22, WL 196 INTERCOSTAL. INSTALLED DOUBLER PER TR 53-10-15 AND SRM 53-10-08. (M)
- [SDR USAA990871](https://openairdocs.org/sdr/USAA990871.md): Angle · corroded · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Miscellaneous Structure
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND CORROSION AT BS 312 TO 344 LBL 45 Z-ANGLE. CORROSION LEVEL 2. REPAIRED PER 53-10-15 AND 51-10-02. (M)
- [SDR USAA990854](https://openairdocs.org/sdr/USAA990854.md): Angle · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Vertical Stabilizer
  > CLT - DURING Q-2 CHECK VISUAL INSPECTINO, FOUND A..25 INCH CRACK AT DRAG ANGLE VERT FIN ATTACH FITTING. INSTALLED DOUBLER AND FILLERS PER EA 65234 AND 65234A. (M)
- [SDR USAA990853](https://openairdocs.org/sdr/USAA990853.md): Frame · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Frame
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A..1 INCH CRACK AT BS 726 STRINGER 18A RIGHT CHORD ANGLE. INSTALLED NEW PART PER EA 65273A. (M)
- [SDR USAA990852](https://openairdocs.org/sdr/USAA990852.md): Floorbeam · corroded · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Floor Beam
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND CORROSION 60 INCHES BY 2 INCHES AT STATION 344 FLOORBEAM LBL 45 - RBL 15. CORROSION LEVEL 1. CORROSION TASK NR C 53-107-01. INSTALLED NEW SECTION OF UPPER CHORD WITH REPAIR DOUBLER PER SRM 51-70-12 AND EA 6523
- [SDR USAA990845](https://openairdocs.org/sdr/USAA990845.md): Intercostal · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Miscellaneous Structure
  > CLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND A..75 INCH CRACK BS 278 STRINGER 14R IN RADIUS OF INTERCOSTAL. INSTALLED REPAIR DOUBLER PER SRM 51-70-11 FIG 1. (M)
- [SDR USAA990844](https://openairdocs.org/sdr/USAA990844.md): Floorbeam · corroded · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Floor Beam
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A AREA OF CORROSION BS 1016, BBL 0, LBL 12, WL 208 FLOORBEAM. CORROSION LEVEL 1. INSTALLED COMPLETE T-CAP PER SRM 53-10-05 AND EA 65232. (M)
- [SDR USAA990836](https://openairdocs.org/sdr/USAA990836.md): Bulkhead · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Bulkhead
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 1 INCH CRACK STATION 666, LBBL 32.5 PRESSURE DECK. INSTALLED DOUBLER PER EA 65231. (M)
- [SDR USAA990835](https://openairdocs.org/sdr/USAA990835.md): Bracket · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Miscellaneous Structure
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A..25 INCH CRACK IN ANGLE RIGHT BS 616 STRINGER 7 AND STRINGER 8 BRACKET. REPLACED BRACKET, FABRICATED NEW PART PER SRM 51-30-01 FIG 2 PG 14. (M)
- [SDR USAA990834](https://openairdocs.org/sdr/USAA990834.md): Frame · cracked · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Frame
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 2 INCH CRACK BS 305, STRINGER 4L FRAME. INSTALLED NEW PART PER SRM 51-10-02.. (M)
- [SDR USAA990833](https://openairdocs.org/sdr/USAA990833.md): Floorbeam · corroded · Aug 29, 1999 · N397US · Boeing 7373B7 · Fuselage Main, Floor Beam
  > CLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 2 INCH BY 2 INCH AREA OF CORROSION AT STATION 360, RBL 12 FLOORBEAM. CORROSION LEVEL 1. REPAIRED ANGLES PER SRM 53-00-51. (M)

Next page: https://openairdocs.org/deregistered/N397US-2006-07-18/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 = 'N397US' AND deregistration_id = 'N397US-2006-07-18'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N397US-2006-07-18/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.