# Service difficulty reports: N808US, cancelled Jul 20, 2007

A list on [N808US, cancelled Jul 20, 2007](https://openairdocs.org/deregistered/N808US-2007-07-20.md).

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

- [SDR USAAD01169](https://openairdocs.org/sdr/USAAD01169.md): Generator · failed · Oct 11, 2001 · N808US · Doug DC981 · AC Generator-Alternator
  > BOS-CLT - FLT 323 - DURING CRUISE, THE RIGHT ENGINE DRIVEN GENERATOR BECAME INOPERATIVE. AS THE LEFT ENGINE GENERATOR WAS ALREADY INOPERATIVE AND RELEASED PER MEL PROCEDURES, THE AIRCRAFT DIVERTED AND LANDED AT RIC WITHOUT INCIDENT. MAINTENANCE REPLACED THE R
- [SDR USAA010951](https://openairdocs.org/sdr/USAA010951.md): Doubler · cracked · Jul 28, 2001 · N808US · Doug DC981 · Doors
  > PIT - FOUND DOUBLER/ANGLE CRACKED.75 INCH, AFT PSG CABIN DOOR JAMB, LEFT UPPER FRAME. REMOVED DOUBLER, INSTALLED DOUBLER ANGLE PER SRM 53-05 FIG 30A. (M)
- [SDR USAAD01130](https://openairdocs.org/sdr/USAAD01130.md): Module · failed · Jun 25, 2001 · N808US · Doug DC981 · Emergency Lighting
  > BOS-BWI - FLT 247 - THE LAST THREE ROWS OF LOW LEVEL EMERGENCY LIGHTS ILLUMINATED DURING FLIGHT. MAINTENANCE REPLACED THE AFT LOW LEVEL EMERGENCY LIGHT CONTROL MODULE. (M)
- [SDR USA2001F00002](https://openairdocs.org/sdr/USA2001F00002.md): Light · inoperative · May 12, 2001 · N808US · Doug DC981 · Emergency Lighting
  > IND - THE LOW LEVEL EMERGENCY LIGHTS DID NOT TEST. MAINTENANCE REPLACED THE CONTROL MODULE BATTERIES, THE LOW LEVEL LIGHT BATTERIES, AND THE OVERWING EXIT IDENTIFIER LIGHT ASSEMBLY. REF USAAD01102. (M)
- [SDR USA2001F00001](https://openairdocs.org/sdr/USA2001F00001.md): Battery · discharged · May 12, 2001 · N808US · Doug DC981 · Emergency Lighting
  > IND - THE LOW LEVEL EMERGENCY LIGHTS DID NOT TEST. MAINTENANCE REPLACED THE CONTROL MODULE BATTERIES, THE LOW LEVEL LIGHT BATTERIES, AND THE OVERWING EXIT IDENTIFIER LIGHT ASSEMBLY. REF USAAD01102. (M)
- [SDR USAAD01102](https://openairdocs.org/sdr/USAAD01102.md): Battery · discharged · May 12, 2001 · N808US · Doug DC981 · Emergency Lighting
  > IND - THE LOW LEVEL EMERGENCY LIGHTS DID NOT TEST. MAINTENANCE REPLACED THE CONTROL MODULE BATTERIES, THE LOW LEVEL LIGHT BATTERIES, AND THE OVERWING EXIT IDENTIFIER LIGHT ASSEMBLY. (M)
- [SDR USAAD01054](https://openairdocs.org/sdr/USAAD01054.md): Strut · low · Mar 17, 2001 · N808US · Doug DC981 · Nose/Tail Landing Gear Strut/Axle
  > EWR-PIT - FLT 557 - AFTER TAKEOFF, THE NOSE LANDING GEAR RED INDICATION LIGHT REMAINED ON AND THE NOSE LANDING GEAR RETRACTED INDICATION PIN WAS NOT VISIBLE. THE LANDING GEAR WAS EXTENDED AND THE AIRCRAFT DIVERTED TO LGA AND LANDED WITHOUT INCIDENT. MAINTENA
- [SDR USAAD01048](https://openairdocs.org/sdr/USAAD01048.md): Piston · defective · Mar 13, 2001 · N808US · Doug DC981 · Nose/Tail Landing Gear Strut/Axle
  > BOS-CLT - FLT 1045 - AFTER TAKEOFF, AS THE LANDING GEAR WAS BEING RAISED, A VIBRATION BEGAN AND THE INTENSITY INCREASED WITH AIRSPEED. THE LANDING GEAR WAS LOWERED, BUT THE NOSE GEAR UNSAFE LIGHT ILLUMINATED AND THE MECHANICAL INDICATOR SHOWED UNSAFE. QRH PR
- [SDR USAAD01044](https://openairdocs.org/sdr/USAAD01044.md): Proximity Sensor · failed · Mar 8, 2001 · N808US · Doug DC981 · Landing Gear Position and Warning
  > MSY-CLT - FLT 1278 - AFTER LANDING GEAR RETRACTION, THE RED NOSE GEAR INDICATION LIGHT REMAINED LIT. THE LANDING GEAR WAS CYCLED AND THE LIGHT WENT OUT BUT CAME BACK ON 5 MINUTES LATER. THE AIRCRAFT CONTINUED TO THE NEXT STATION AND LANDED WITHOUT INCIDENT.
- [SDR USAAD00178](https://openairdocs.org/sdr/USAAD00178.md): Slide · deflated · Nov 17, 2000 · N808US · Doug DC981 · Escape Slide
  > RSW - THE TAILCONE EMERGENCY EVACUATION SLIDE FAILED TO INFLATE WHEN DEPLOYED. MAINTENANCE REPLACED THE TAILCONE EVACUATION SLIDE ASSEMBLY. (M)
- [SDR USAAD00143](https://openairdocs.org/sdr/USAAD00143.md): Strap · broken · Sep 6, 2000 · N808US · Doug DC981 · Escape Slide
  > PIT - ONE TAILCONE EVACUATION SLIDE COVER HOLD DOWN STRAP WAS FOUND BROKEN. MAINTENANCE REPLACED THE STRAP. (M)
- [SDR USAAD00137](https://openairdocs.org/sdr/USAAD00137.md): Light · failed · Aug 19, 2000 · N808US · Doug DC981 · Emergency Lighting
  > PIT - FOUND EMERGENCY LIGHTS TO BE INOPERATIVE IN FIRST CLASS, THE VENTRAL STAIR AREA, AND THE EMERGENCY ESCAPE RAMP. MAINTENANCE REPLACED THE BATTERY PACK ASSEMBLIES IN THE FORWARD AND AFT POSITIONS, AND REPLACED THE INOPERATIVE LIGHT ASSEMBLY FOR THE EMERGE
- [SDR 20001129AP003](https://openairdocs.org/sdr/20001129AP003.md): Light · failed · Aug 15, 2000 · N808US · Doug DC981 · Emergency Lighting
  > PIT - THE FORWARD SECTION OF THE PASSENGER CABIN OVERHEAD EMERGENCY LIGHTS AND THE VENTRAL STAIR EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE REPLACED THE FORWARD PASSENGER CABIN OVERHEAD EMERGENCY LIGHT BATTERIES AND THE VENTRAL STAIR EMERGENCY LIGHT ASSEM
- [SDR USAAD00132](https://openairdocs.org/sdr/USAAD00132.md): Battery · discharged · Aug 15, 2000 · N808US · Doug DC981 · Emergency Lighting
  > PIT - THE FORWARD SECTION OF THE PASSENGER CABIN OVERHEAD EMERGENCY LIGHTS AND THE VENTRAL STAIR EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE REPLACED THE FORWARD PASSENGER CABIN OVERHEAD EMERGENCY LIGHT BATTERIES AND THE VENTRAL STAIR EMERGENCY LIGHT ASSEM
- [SDR USAAD00077](https://openairdocs.org/sdr/USAAD00077.md): Battery · discharged · May 19, 2000 · N808US · Doug DC981 · Emergency Lighting
  > PIT - FOUND EMERGENCY LIGHTS WON''T TEST. MAINTENANCE REPLACED BATTERY PACKS. OPS CHECKED GOOD. (M)
- [SDR USAAD00043](https://openairdocs.org/sdr/USAAD00043.md): Light · failed · Mar 20, 2000 · N808US · Doug DC981 · Emergency Lighting
  > TPA - THE FORWARD ENTRY DOOR EMERGENCY EXIT IDENTIFIER LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE FORWARD ENTRY DOOR EMERGENCY EXIT IDENTIFIER LIGHT ASSEMBLY. (M)
- [SDR USAA990944](https://openairdocs.org/sdr/USAA990944.md): Skin · cracked · Aug 29, 1999 · N808US · Doug DC981 · Wing, Plate/Skin
  > PIT - DURING RON, FOUND 6 INCH CRACK AT LEFT WING, STATION XRS-214, OUTBOARD OF NR 7 SLAT TRACK AT L/E SKIN. INSTALLED DOUBLER PER SRM 57-068 FIG 4. (M)
- [SDR USAAD98143](https://openairdocs.org/sdr/USAAD98143.md): Sensor · dirty · Aug 14, 1998 · N808US · Doug DC981 · Landing Gear Position and Warning
  > PHL - FLT 1622 - NOSE GEAR LIGHT WAS RED ON GEAR UP. CYCLED GEAR AND THE INDICATION WAS NORMAL. MAINTENANCE RESET PROX BOX AND PERFORMED BITE TEST, ALL NORMAL. CLEANED SENSORS A PRECAUTION. (M)
- [SDR USAAD98081](https://openairdocs.org/sdr/USAAD98081.md): Battery · discharged · May 6, 1998 · N808US · Doug DC981 · Emergency Lighting
  > ROC - THE CEILING EMERGENCY EVACUATION LIGHTS FOR THE CENTER SECTION OF THE CABIN WERE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERIES. (X)
- [SDR USAAD97167](https://openairdocs.org/sdr/USAAD97167.md): Controller · failed · Sep 26, 1997 · N808US · Doug DC981 · Cabin Pressure Controller
  > PIT - FL 2200 - AFTER TAKEOFF, CREW WAS NOT ABLE TO MAINTAIN PRESSURIZATION. THE FLOW LIGHT WAS ILLUMINATED. FLIGHT RETURNED TO PIT AND LANDED WITH NO FURTHER INCIDENT. MAINTENANCE REPAIRED A LEAKING DUCT. SUBSEQUENTLY, THE PRESSURE SELECTOR ASSEMBLY WAS R
- [SDR USAAD97149](https://openairdocs.org/sdr/USAAD97149.md): Battery · discharged · Sep 4, 1997 · N808US · Doug DC981 · Emergency Lighting
  > IND - FOUND FOUR CEILING EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY. (X)
- [SDR USAAD97089](https://openairdocs.org/sdr/USAAD97089.md): Retract Mech · lack of lube · May 19, 1997 · N808US · Doug DC981 · Landing Gear Retraction/Extension System
  > FLT 2301 - BUF-DCA - ON APPROACH, DID NOT GET NOSE GEAR DOWN AND LOCKED LIGHT OR VISUAL INDICATION. SLOWED TO 160 KTS, CYCLED GEAR, GOT 3 GREENS. JACKED NOSE GEAR, INSPECTED. FOUND NEW GEAR NOT LUBED. LUBRICATED GEAR, CYCLED 20 TIMES, CHECKS GOOD. (M)
- [SDR USAAD97014](https://openairdocs.org/sdr/USAAD97014.md): Windshield · cracked · Jan 14, 1997 · N808US · Doug DC981 · Flight Compartment Windows
  > FLT 1706 - PIT-PWM - DURING CRUISE AT FL 370, OUTER PANE OF CAPTAINS WINDSHIELD SHATTERED. DIVERTED TO PHL. REPLACED CAPTAINS WINDSHIELD. (M)
- [SDR USAAD96049](https://openairdocs.org/sdr/USAAD96049.md): Fuel Contl Unit · failed · May 3, 1996 · N808US · Doug DC981 · Fuel Control/Turbine Engines
  > BOS - FL 478 - AT TOP OF CLIMB, FL 230, LEFT ENGINE WOULD NOT RESPOND TO THROTTLE MOVEMENT. OIL TEMPERATURE OF LEFT ENGINE WAS THIRTY TO THIRTY-FIVE DEGREES HIGHER THAN THE RIGHT ENGINE TEMPERATURE. FLIGHT RETURNED TO BOS AND SHUT DOWN ENGINE ON FINAL APPROA
- [SDR USAA950830](https://openairdocs.org/sdr/USAA950830.md): Belt Frame · cracked · Jul 12, 1995 · N808US · Doug DC981 · Fuselage Main, Frame
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND 2 CRACKS.25 INCH LONG IN BELTFRAME AT STATION 1322 AT LONGERON 17R. REPLACED SECTION OF FRAME AND INSTALLED DOUBLERS PER SRM 53-03 FIG 31. (M)
- [SDR USAA950835](https://openairdocs.org/sdr/USAA950835.md): Frame · corroded · Jul 11, 1995 · N808US · Doug DC981 · Fuselage Main, Frame
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND LEVEL 1 CORROSION PREVIOUSLY REWORKED ON BELTFRAME 1287 BETWEEN LONGERON 22L AND 23L (CORROSION TASK RED C57-53301). ACCOMPLISHED REPAIR TO BELTFRAME PER SRM 53-03 FIG 30. (M)
- [SDR USAA950829](https://openairdocs.org/sdr/USAA950829.md): Longeron · cracked · Jul 11, 1995 · N808US · Doug DC981 · Fuselage Main, Longeron/Stringer
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND A.25 INCH CRACK AT LONGERON ATTACH POINTS TO FRAME STATION 160 LONG 3L. ACCOMPLISHED SPLICE TYPE REPAIR PER SRM 53-02 FIG 2. (M)
- [SDR USAA950828](https://openairdocs.org/sdr/USAA950828.md): Longeron · cracked · Jul 11, 1995 · N808US · Doug DC981 · Fuselage Main, Longeron/Stringer
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND CRACK.25 INCH LONG AT BOTH ATTACH POINTS STATION 160 LONG 4L. SPLICED IN NEW SECTION OF LONGERON PER SRM 53-02 FIG 2. (M)
- [SDR USAA950827](https://openairdocs.org/sdr/USAA950827.md): Intercostal · cracked · Jul 11, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND.375 INCH CRACK IN FITTING AT STATION 988 INSIDE HEEL ABOVE AFT END OF DOOR HINGE. INSTALLED DOUBLER REPAIR PER SRM 53-01. (M)
- [SDR USAA950826](https://openairdocs.org/sdr/USAA950826.md): Cusp Membrane · cracked · Jul 11, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND CUSP MEMBRANE CRACKED 1 INCH LONG STATION 1250 RIGHT SIDE. MFG CUSP MEMBRANE PER SRM 53-05 FIG 79. (M)
- [SDR USAA950825](https://openairdocs.org/sdr/USAA950825.md): Cusp Membrane · cracked · Jul 11, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND CUSP MEMBRANE CRACKED IN 2 PLACES BOTH 1 INCH LONG AT STATION 1287 LEFT. MFG NEW CUSP MEMBRANE PER SRM 53-05 FIG 79. (M)
- [SDR USAA950820](https://openairdocs.org/sdr/USAA950820.md): Clip · cracked · Jul 11, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND CRACK AT SKIN CLIP.375 INCH LONG AT STATION 1459 BETWEEN LONGERON 2L AND 3L. MFG NEW SKIN CLIP AND INSTALLED PER SRM 53-03 FIG 28. (M)
- [SDR USAA950819](https://openairdocs.org/sdr/USAA950819.md): Clip · cracked · Jul 11, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND.5 INCH CRACK IN SKIN CLIP STATION 1459 BETWEEN LONGERON 2R AND 3R. MFG NEW SKIN CLIP AND INSTALLED PER SRM 53-03 FIG 28. (M)
- [SDR USAA950821](https://openairdocs.org/sdr/USAA950821.md): Seat Track · corroded · Jul 10, 1995 · N808US · Doug DC981 · Fuselage, Seat/Cargo Attach Fittings
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND LEVEL 1 CORROSION AT RIGHT INBOARD SEAT TRACK AT BOTTOM INBOARD FLOOR ATTACH ANGLE AT STATION FS-205 (PREVIOUSLY REWORKED) CORROSION TASK REF C46-53305. REMOVED CORROSION AND SPLICED IN NEW SECTION OF SEAT TRACK P
- [SDR USAA950824](https://openairdocs.org/sdr/USAA950824.md): Fitting · corroded · Jul 6, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND 3 INCH BY 4 INCH AREA OF CORROSION (LEVEL 1) AT FITTING AT AFT LOWER CORNER OF AIR STAIR DOOR STATION 200 LONGERON 21L (PREVIOUSLY REWORKED). CORROSION TASK NR REF C45-53301. INSTALLED NEW FITTING P/N 109-7172.
- [SDR USAA950823](https://openairdocs.org/sdr/USAA950823.md): Angle · cracked · Jul 6, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND.5 INCH CRACK IN SUPPORT ANGLE LEFT OF CENTER UNDER RADAR SUPPORT SHELF STATION 37 BULKHEAD HORIZONTAL ANGLE. INSTALLED DOUBLER REPAIR PER SRM 53-01. (M)
- [SDR USAA950822](https://openairdocs.org/sdr/USAA950822.md): Skin · cracked · Jul 6, 1995 · N808US · Doug DC981 · Wing, Plate/Skin
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND.25 INCH CRACK IN TEMPORARY REPAIR ON WING LE AT INBOARD AND OUTBOARD EDGE OF FUEL SERVICE PANEL IN SKIN. REMOVED TEMP REPAIR AND STOP DRILLED CRACKS. INSTALLED DOUBLER REPAIR PER SRM 57-06B. (M)
- [SDR USAA950818](https://openairdocs.org/sdr/USAA950818.md): Cusp Web · cracked · Jul 6, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND 1 INCH CRACK IN STATION 825 TO 845 LONGERON 18R CUSP WEB. REPLACED SECTION OF CUSP WEB PER SRM 53-05 FIG 27. (M)
- [SDR USAA950817](https://openairdocs.org/sdr/USAA950817.md): Longeron · cracked · Jul 6, 1995 · N808US · Doug DC981 · Fuselage Main, Longeron/Stringer
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND.125 INCH CRACK IN LONGERON 3L AT STATION 160. SPLICED IN NEW SECTION OF LONGERON PER SRM 53-02 FIG 2. (M)
- [SDR USAA950816](https://openairdocs.org/sdr/USAA950816.md): Skin · damaged · Jul 6, 1995 · N808US · Doug DC981 · Fuselage Main, Plate/Skin
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND A LIGHTNING STRIKE LEAVING A.020 INCH PIT AT FUSELAGE SKIN STATION 636 BETWEEN LONGERON 9R AND 10R. REMOVED DAMAGE AND INSTALLED FILLER AND INTERNAL DOUBLER REPAIR PER SRM 53-04 FIG 38. (M)
- [SDR USAA950815](https://openairdocs.org/sdr/USAA950815.md): Angle · cracked · Jul 6, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND A 1 INCH CRACK IN TOP KEEL BEAM 'T' ANGLE ON HORIZONTAL LEG AT STATION 985. SPLICED IN NEW SECTION OF ANGLE AND DOUBLER PER USAIR EA 30834. (M)
- [SDR USAA950814](https://openairdocs.org/sdr/USAA950814.md): Jamb · corroded · Jul 6, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND CORROSION IN MED STATION 200 BOTTOM LEFT AFT DOOR JAMB. CUT OUT CORRODED SECTION OF JAMB AND INSTALLED DOUBLER REPAIR PER USAIR EA 308 AND SRM 53-05 FIG 55. (M)
- [SDR USAA950834](https://openairdocs.org/sdr/USAA950834.md): Window Pan · cracked · Jun 30, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND.25 INCH CRACK STATION 888 LEFT WINDOW PAN. INSTALLED DOUBLER REPAIR PER USAIR TYPICAL REPAIR 53-50-06. (M)
- [SDR USAA950833](https://openairdocs.org/sdr/USAA950833.md): Window Pan · cracked · Jun 30, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND.25 INCH CRACK STATION 929 LEFT SIDE WINDOW PAN. INSTALLED DOUBLER REPAIR PER USAIR TYPICAL REPAIR 53-50-06. (M)
- [SDR USAA950832](https://openairdocs.org/sdr/USAA950832.md): Window Pan · cracked · Jun 30, 1995 · N808US · Doug DC981 · Fuselage Miscellaneous Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND.25 INCH CRACK STATION 948 LEFT SIDE WINDOW PAN. INSTALLED DOUBLER TYPE REPAIR PER USAIR TYPICAL REPAIR 53-50-06. (M)
- [SDR USAA950831](https://openairdocs.org/sdr/USAA950831.md): Le Web · cracked · Jun 30, 1995 · N808US · Doug DC981 · Horizontal Stabilizer Structure
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND A.25 INCH CRACK RIGHT INBOARD WEB LEADING EDGE TO HORIZONTAL STABILIZER FROM SPAR. INSTALLED DOUBLER REPAIR IAW SRM 55-01 FIG 5. (M)
- [SDR USAA950813](https://openairdocs.org/sdr/USAA950813.md): Frame · cracked · Jun 30, 1995 · N808US · Doug DC981 · Fuselage Main, Frame
  > PIT - DURING Q-4/CX-6 CHECK INSPECTION, FOUND 2 CRACKS ONE.0625 INCH AND ONE.1875 INCH IN FRAME STATION 1463 LEFT SIDE DORSAL FIN ATTACH ANGLE. INSTALLED DOUBLER REPAIR PER SRM 53-05 FIG 23B. (M)

## 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 = 'N808US' AND deregistration_id = 'N808US-2007-07-20'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N808US-2007-07-20/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.
