# Service difficulty reports: N604UA, cancelled Feb 22, 2007

A list on [N604UA, cancelled Feb 22, 2007](https://openairdocs.org/deregistered/N604UA-2007-02-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 3 · 134 reports

- [SDR 2004UALA00732](https://openairdocs.org/sdr/2004UALA00732.md): Compressor · stalled · Aug 7, 2004 · N604UA · Boeing 767222 · Turbine Engine Compressor Section
  > RT ENG COMPRESSOR EXPERIENCED A COMPRESSOR STALL. STALL STOPPED WHEN RT THROTTLE RETARDED. RESET BLEED ALL INDICATIONS NORMAL. ALL POST-COMPRESSOR STALL TROUBLESHOOTING ACCOMPLISHED IMMEDIATELY AFTER EVENT, NO DEFECTS FOUND. DECIDED TO WATCH ENG FOR ANY RE
- [SDR 2004UALA00522](https://openairdocs.org/sdr/2004UALA00522.md): Warning Light · illuminated · Jun 1, 2004 · N604UA · Boeing 767222 · Trailing Edge Flap Control System
  > LANDED LAX UNDER AMBER ALERT DUE TO FLAP DISAGREE INDICATION. ACCOMPLISHED FLAP POSITION TRANSMITTER SYNCHRONIZATION CHECK ON 3, 4, AND 5 FLAP POSITION TRANSMITTERS. FOUND NR 4 OUT OF LIMITS. ADJUSTED TRANSMITTER.
- [SDR 2003UALA00480](https://openairdocs.org/sdr/2003UALA00480.md): Shear Tie · corroded · Jun 5, 2003 · N604UA · Boeing 767222 · Fuselage Main, Structure
  > BS 1335, BETWEEN STRINGERS 33R AND 34R, SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.
- [SDR 2003UALA00479](https://openairdocs.org/sdr/2003UALA00479.md): Stringer · damaged · Jun 5, 2003 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > BS 1361-1379 STRINGER SECTION REQUIRES REPLACEMENT IN ORDER TO MAINTAIN 20 INCH MINIMUM SPACING BETWEEN STRINGER SPLICE AT STATION 1337, STRINGER 34R. MAJOR REPAIR ACCOMPLISHED. REPLACED STRINGER SECTION AND SPLICE.
- [SDR 2003UALA00478](https://openairdocs.org/sdr/2003UALA00478.md): Skin · punctured · Jun 5, 2003 · N604UA · Boeing 767222 · Aerodynamic Fairings
  > FUSELAGE TAILCONE SKIN AT STA 1848, LBL 24 PUNCTURED. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED REPAIR DOUBLER.
- [SDR 2003UALA00477](https://openairdocs.org/sdr/2003UALA00477.md): Stringer · corroded · Jun 5, 2003 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > AFT CARGO STRINGER 34R AT STA 1337 HAS HEAVY CORROSION ON SIDE. MAJOR REPAIRED ACCOMPLISHED. INSTALLED SPLICE REPAIR.
- [SDR 2003UALA00476](https://openairdocs.org/sdr/2003UALA00476.md): Web · corroded · Jun 5, 2003 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > AFT CARGO PIT AT BS 1329-1351, LOWER DOOR SILL LOWER WEB IS CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED REPAIR DOUBLER. INSTALLED WEB AND SPLICE REPAIR.
- [SDR 2003UALA00470](https://openairdocs.org/sdr/2003UALA00470.md): Clip · damaged · Jun 4, 2003 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > BS 1346, STR 34R, FRAME ATTACH CLIP REQUIRES REPLACEMENT FOR STRINGER REPAIR. MAJOR REPAIR ACCOMPLISHED. REPLACED CLIP.
- [SDR 2003UALA00465](https://openairdocs.org/sdr/2003UALA00465.md): Stringer · misrepaired · Jun 4, 2003 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > STATION 1361 TO 1379, STRINGER 34R, STRINGER SECTION AND SPLICE DO NOT HAVE REQUIRED EDGE DISTANCE BETWEEN REPAIR SPLICES. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER & SPLICE REPAIRS.
- [SDR 2003UALA00464](https://openairdocs.org/sdr/2003UALA00464.md): Stringer · corroded · Jun 4, 2003 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > AFT CARGO STRINGER 34R AT STATION 1337 HAS HEAVY CORROSION ON SIDE. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW SECTION AND DOUBLER REPAIR.
- [SDR 2003UALA00458](https://openairdocs.org/sdr/2003UALA00458.md): Stringer · corroded · Jun 2, 2003 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > AFT CARGO PIT AT BS 1081-1087, STRINGER 37L IS CORRODED AT END FITTING. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER SECTION AND SPLICE.
- [SDR 2002UALA00924](https://openairdocs.org/sdr/2002UALA00924.md): Skin · corroded · May 28, 2002 · N604UA · Boeing 767222 · Fuselage Main, Plate/Skin
  > AFT EXTERNAL FUSELAGE, AFT WATER DRAIN MAST, CORROSION AROUND BASE, BODY STATION 1417, STRINGER 35R. MAJOR REPAIR ACCOMPLISHED. REPAIRED SKIN WITH EXTERNAL DOUBLER.
- [SDR 2002UALA00929](https://openairdocs.org/sdr/2002UALA00929.md): Fitting · cracked · May 27, 2002 · N604UA · Boeing 767222 · Wing, Control Surfaces
  > RIGHT HAND WING FRONT SPAR OUTBOARD PITCHLOAD FITTING CRACKED AT THE FORWARD UPPER RADIUS ABOVE FITTING LUG, CRACK FOUND AND CONFIRMED. MAJOR REPAIR ACCOMPLISHED. REPLACED OUTBOARD PITCHLOAD FITTING.
- [SDR 2001UALA00932](https://openairdocs.org/sdr/2001UALA00932.md): Charger · defective · May 30, 2001 · N604UA · Boeing 767222 · Emergency Lighting
  > EMERGENCY LIGHTS ILLUMINATED ON LEFT SIDE FROM DOOR 1 LEFT TO OVERWING EXIT BOTH UPPER LIGHTING AND EEL. *S/D* REPLACED BATTERY CHARGER AND BATTERY M735 AND EEL POWER SUPPLY. TEST OK.
- [SDR 2001UALA00933](https://openairdocs.org/sdr/2001UALA00933.md): Power Supply · malfunctioned · May 29, 2001 · N604UA · Boeing 767222 · Emergency Lighting
  > EMERGENCY PATH LIGHTING SECTION LEFT FWD OF COACH SECTION INTERMITTENTLY ON-OFF THROUGHOUT FLIGHT. ALSO BUSINESS CLASS SECTION. *S/D* POWER SUPPLY AT STATION 425 LT. ALL LIGHTS OPS NORMAL.
- [SDR 2001UALA00838](https://openairdocs.org/sdr/2001UALA00838.md): Skin · damaged · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Main, Plate/Skin
  > LOWER FUSELAGE SKIN HAS HOLE AT STA 380, BL 0. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. INSTALLED SKIN REPAIR PER SRM 53-00-01, FIG 214, AND SRM 51-40-2.
- [SDR 2001UALA00837](https://openairdocs.org/sdr/2001UALA00837.md): Splice · damaged · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > STRINGER 38R SPLICE AT STATION 434 HAS AN ELONGATED HOLE FOR STRINGER CLIP. *S/D* MAJOR REPAIR ACCOMPLISHED. REPLACED SPLICE PER SRM 53-30-03 AND 51-40-2.
- [SDR 2001UALA00836](https://openairdocs.org/sdr/2001UALA00836.md): Web · corroded · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > AFT CARGO PIT BS 1329-1351, LBL 26 TO BL 0, SHEAR PANEL CORRODED ON UPPER SURFACE OF PANEL.UPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED.REPLACED WEB PER 146T5000-3 AND SRM 51-40-2.
- [SDR 2001UALA00835](https://openairdocs.org/sdr/2001UALA00835.md): Stringer Clip · broken · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > FORWARD PIT, STRINGER CLIP AT STATION 434 STRINGER 38R BROKEN. *S/D* MAJOR REPAIR IS ACCOMPLISHED. REPLACED CLIP PER BAC DRAWING 140T2101-573 AND SRM 51-40-2.
- [SDR 2001UALA00833](https://openairdocs.org/sdr/2001UALA00833.md): Stringer Clip · broken · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > FORWARD PIT, STRINGER CLIP AT STATION 434, STRINGER 37L BROKEN. *S/D* MAJOR REPAIR IS ACCOMPLISHED. REPLACED CLIP PER BAC DRAWING 140T2101-573 AND SRM 51-40-2.
- [SDR 2001UALA00830](https://openairdocs.org/sdr/2001UALA00830.md): Stringer Clip · corroded · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > FORWARD PIT STATION 412 AND STRINGER 37L, CLIP IS CORRODED. *S/D* MAJOR REPAIR IS ACCOMPLISHED. REPLACED STRINGER CLIP PER SRM 51-40-2 AND BAC DRAWING 141T1225.
- [SDR 2001UALA00829](https://openairdocs.org/sdr/2001UALA00829.md): Clip · cracked · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > AFT PIT STATION 1351, STRINGER 34L, STRINGER CLIP IS CRACKED. *S/D* MAJOR REPAIR ACCOMPLISHED. REPLACED CLIP PER BAC DRAWING 140T2101 AND SRM 51-30-2.
- [SDR 2001UALA00828](https://openairdocs.org/sdr/2001UALA00828.md): Splice · cracked · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > FORWARD PIT STRINGER 34R BS 434 HAS A CRACK. *S/D* MAJOR REPAIR ACCOMPLISHED. REPLACED SPLICE PER SRM 53-00-03 AND BAC DRAWING 140T0115-4.
- [SDR 2001UALA00826](https://openairdocs.org/sdr/2001UALA00826.md): Clip · cracked · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > FORWARD PIT, STRINGER CLIP CRACKED STATION 434 STRINGER 39L. *S/D* MAJOR REPAIR ACCOMPLISHED. REPLACED CLIP PER BAC DRAWING 141T1225 AND SRM 51-40-2.
- [SDR 2001UALA00825](https://openairdocs.org/sdr/2001UALA00825.md): Clip · cracked · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > STRINGER CLIP CRACKED AT STATION 434, STRINGER 38L. *S/D* MAJOR REPAIR ACCOMPLISHED. REPLACED CLIP AS PER BAC DRAWING 141T1225 AND SRM 51-40-2.
- [SDR 2001UALA00824](https://openairdocs.org/sdr/2001UALA00824.md): Stringer · corroded · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > AFT PIT STRINGER 34L BS 1329 - 1362 CORRODED.SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPAIRED STRINGER PER SRM 53-00-03 AND 51-20-2.
- [SDR 2001UALA00822](https://openairdocs.org/sdr/2001UALA00822.md): Clip · misaligned · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > STRINGER 39R FORWARD END CLIP DOES NOT ALIGN WITH PRE-DRILLED STRINGER STATION 325. *S/D* MAJOR REPAIR ACCOMPLISHED. REPLACED CLIP PER BAC DRAWING 141T1220-45 AND SRM 51-40-2.
- [SDR 2001UALA00819](https://openairdocs.org/sdr/2001UALA00819.md): Shear Tie · corroded · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Main, Structure
  > AFT PIT APPROX BS 1279 SHEAR TIE BETWEEN 33R AND 34R CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE PER BAC DRAWING 146T8561 AND SRM 51-40-2.
- [SDR 2001UALA00797](https://openairdocs.org/sdr/2001UALA00797.md): Splice · corroded · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > SPLICE 146T1033-60 CORRODED BEYOND LIMITS STATION 1439, BETWEEN STRINGERS 25R AND 26R. *S/D* MAJOR REPAIR ACCOMPLISHED. REPLACED SPLICE PER BAC DRAWING 146T1033 AND SRM 51-40-2.
- [SDR 2001UALA00796](https://openairdocs.org/sdr/2001UALA00796.md): Clip · cracked · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > FORWARD PIT STATION 370 FRAME CLIP CRACKED BETWEEN STRINGERS 39R AND 39L. *S/D* MAJOR REPAIR ACCOMPLISHED. REPLACED FRAME CLIP PER SRM 51-40-2 AND BAC DRAWING 141T3220.
- [SDR 2001UALA00795](https://openairdocs.org/sdr/2001UALA00795.md): Skin · grooved · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Main, Plate/Skin
  > LEFT SIDE OF EMPENNAGE SKIN HAS LONG WEAR GROOVE FS 1809, WL 226.10. *S/D* MAJOR REPAIR ACCOMPLISHED. REPAIRED SKIN AS PER SRM 53-80-01.
- [SDR 2001UALA00794](https://openairdocs.org/sdr/2001UALA00794.md): Skin · cracked · May 21, 2001 · N604UA · Boeing 767222 · Nacelle/Pylon, Plate/Skin
  > NR 1 ENG PYLON LT OUTBOARD SIDE, PANEL 436BL CUTOUT IS CRACKED AT FWD UPPER FASTENER HOLE. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPAIRED SKIN PER SRM 54-53-97.
- [SDR 2001UALA00793](https://openairdocs.org/sdr/2001UALA00793.md): Floorbeam · corroded · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Main, Floor Beam
  > MAIN CABIN UNDER FLOOR T-CAP CORRODED BS 873, RBL 12. *S/D* MAJOR REPAIR ACCOMPLISHED. REPAIRED T-CAP PER SRM 53-00-51.
- [SDR 2001UALA00792](https://openairdocs.org/sdr/2001UALA00792.md): Stringer · corroded · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > CORROSION ON STRINGER 34R FROM STATION 412 - 434, FORWARD PIT. *S/D* MAJOR REPAIR ACCOMPLISHED. REPAIRED STRINGER AS PER SRM 53-00-03 AND 51-40-2.
- [SDR 2001UALA00791](https://openairdocs.org/sdr/2001UALA00791.md): Stringer · corroded · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > CORROSION ON STRINGER 34R FROM STATION 412-434 FORWARD PIT. *S/D* MAJOR REPAIR ACCOMPLISHED. REPAIRED STRINGER PER SRM 53-00-03 AND 51-40-2.
- [SDR 2001UALA00790](https://openairdocs.org/sdr/2001UALA00790.md): Stringer · corroded · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > CORROSION INSIDE STRINGER 33R BETWEEN FRAME STA 478-500 RT. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED.REPAIRED STRINGER AS PER SRM 53-00-03 AND 51-40-2.
- [SDR 2001UALA00789](https://openairdocs.org/sdr/2001UALA00789.md): Stringer · cracked · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > STRINGER 38R CRACKED AT THE END UNDER FRAME STA 456 RT. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPAIRED STRINGER PER SRM 53-00-03 AND 51-40-2.
- [SDR 2001UALA00787](https://openairdocs.org/sdr/2001UALA00787.md): Angle · corroded · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > AFT CARGO PIT BS 1087 AT STR 36R FRAME TO STRINGER ATTACH ANGLE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. REPLACED FRAME ATTACH ANGLE PER BAC DRAWING 146T1070-5 AND SRM 51-40-2.
- [SDR 2001UALA00785](https://openairdocs.org/sdr/2001UALA00785.md): Attach Angle · corroded · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > AFT CARGO PIT BS 1087 AT STR 39L, STRINGER TO FRAME ATTACH ANGLE CORRODED.
- [SDR 2001UALA00780](https://openairdocs.org/sdr/2001UALA00780.md): Clip · misaligned · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > STRINGER 39L FORWARD END CLIP DOES NOT ALIGN WITH PREDRILLED STRINGER STATION 325. MAJOR REPAIR ACCOMPLISHED. REPLACED CLIP PER BAC DRAWING 141T3001 AND T-ANGLE PER BAC DRAWING 141T1220 AND SRM 51-40-02.
- [SDR 2001UALA00779](https://openairdocs.org/sdr/2001UALA00779.md): Stringer · cracked · May 21, 2001 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > STRINGER 38R CRACKED AT THE END UNDER FRAME STATION 456 RT. MAJOR REPAIR ACCOMPLISHED. REPAIRED STRINGER PER SRM 53-00-03 AND 51-40-02.
- [SDR 2001UALA00784](https://openairdocs.org/sdr/2001UALA00784.md): Attach Angle · cracked · May 19, 2001 · N604UA · Boeing 767222 · Electrical/Electronic Compartment Doors
  > FORWARD EQUIPMENT BAY DOOR HAS A CRACK ON ATTACH ANGLE IN HANDLE BAY, CENTER OF DOOR.SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED REMOVED INNER DOOR SKIN, FABRICATED NEW ATTACH ANGLE PER BAC DRAWING 141T6422 AND INSTALLED PER SRM 51-40-02, REINSTALLED SK
- [SDR 2001UALA00735](https://openairdocs.org/sdr/2001UALA00735.md): Stringer · damaged · May 15, 2001 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > BS 434 STRINGER 38R DAMAGED. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW STRINGER IN ACCORDANCE WITH SRM 51-40-02.
- [SDR 2001UALA00734](https://openairdocs.org/sdr/2001UALA00734.md): Splice · cracked · May 15, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > BS 434 - 456 STRINGER 38R - 37 STRINGER SPLICE CRACKED AND CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWING 140T0115 AND SRM 53-00-03 FIGURE 202.
- [SDR 2001UALA00733](https://openairdocs.org/sdr/2001UALA00733.md): Stringer · cracked · May 15, 2001 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > BS 434 STRINGER 35R CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWING 140T1228 AND SRM 51-40-02.
- [SDR 2001UALA00732](https://openairdocs.org/sdr/2001UALA00732.md): Skin · corroded · May 14, 2001 · N604UA · Boeing 767222 · Fuselage Main, Plate/Skin
  > BELLY SKIN BS 287 - 434 STRINGER 37L TO 37R HAS HEAVY CORROSION. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW IN ACCORDANCE WITH SRM 51-40-02.
- [SDR 2001UALA00731](https://openairdocs.org/sdr/2001UALA00731.md): Stringer Clip · broken · May 14, 2001 · N604UA · Boeing 767222 · Fuselage Miscellaneous Structure
  > BS 434 STRINGER 34R CLIP BROKEN. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWING 143T1225 AND SRM 51-40-02.
- [SDR 2001UALA00725](https://openairdocs.org/sdr/2001UALA00725.md): Stringer · damaged · May 14, 2001 · N604UA · Boeing 767222 · Fuselage Main, Longeron/Stringer
  > BS 434 - 325 STRINGER 39R REQUIRES REPLACEMENT WITH BELLY SKIN. *S/D* MAJOR REPAIR ACCOMPLISHED. INSTALLED STRINGER 39R IN ACCORDANCE WITH SRM 51-40-02.
- [SDR 2001UALA00852](https://openairdocs.org/sdr/2001UALA00852.md): Shear Tie · corroded · May 11, 2001 · N604UA · Boeing 767222 · Fuselage Main, Structure
  > BS 456 STR 39L-38L SHEAR TIE CORRODED.SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWING 140T2102-307.
- [SDR 2001UALA00851](https://openairdocs.org/sdr/2001UALA00851.md): Shear Tie · corroded · May 11, 2001 · N604UA · Boeing 767222 · Fuselage Main, Structure
  > BS 1153 STR 37R-38R SHEAR TIE CORRODED.SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWING 140T2103-446 AND SRM51-40-02.

Next page: https://openairdocs.org/deregistered/N604UA-2007-02-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 = 'N604UA' AND deregistration_id = 'N604UA-2007-02-22'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N604UA-2007-02-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, except the copies of manufacturers’ service documents, which belong to their rights holders.
