# Service difficulty reports: N823NK, cancelled Jan 18, 2005

A list on [N823NK, cancelled Jan 18, 2005](https://openairdocs.org/deregistered/N823NK-2005-01-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 · 83 reports

- [SDR GTIA040843](https://openairdocs.org/sdr/GTIA040843.md): Door Frame · corroded · Nov 29, 2004 · N823NK · Doug DC983 · Fuselage Main, Structure
  > AFT LOWER CARGO COMPARTMENT LOWER OB JAMB BEAM HAS CORROSION, STA 1155 TO STA 1211. REMOVED RIVNUTS TO CLEAN CORROSION ON JAMB BEAM, REMOVED FWD AND AFT SCUFF PLATES, REMOVED DOOR STOPS AT STA 1174 AND 1193, DOR JAMB BEAM WAS FOUND TO BE OUT OF LIMITS. FABRI
- [SDR GTIA040842](https://openairdocs.org/sdr/GTIA040842.md): Skin · damaged · Nov 12, 2004 · N823NK · Doug DC982 · Trailing Edge Flaps
  > DENT ON LT OB FLAP LOWER SIDE, 19 INCH FROM T/E AND 8 INCHES FROM IB END OF T/E WEDGE, DEPTH 0.095 INCH, DIAM 2.0 INCH. REMOVED DAMAGED SKIN, FABRICATED SKIN AND DOUBLER TREATED AND PRIMED, INSTALLED SKIN AND DOUBLER, BONDED SKINS AND PAINTED.
- [SDR GTIA040837](https://openairdocs.org/sdr/GTIA040837.md): Intercostal · cracked · Nov 10, 2004 · N823NK · Doug DC982 · Fuselage Miscellaneous Structure
  > AFT PIT OVERHEAD FLOORBEAM INTERCOSTAL CRACKED AT (4 EA) PLACES ALONG FASTENER HOLES, FS 1287-1309. REMOVED FLOORBEAM INTERCOSTAL AT FS 1287-1309, FABRICATED NEW INTERCOSTAL SRM 51-10-2 FROM 7075-T6-.063. HEAT TREATED NEW INTERCOSTAL, LOCATED AND DRILLED HOL
- [SDR GTIA040834](https://openairdocs.org/sdr/GTIA040834.md): Intercostal · corroded · Oct 5, 2004 · N823NK · Doug DC982 · Fuselage Miscellaneous Structure
  > AFT PIT - CORRODED INTERCOSTAL AND FRAME AT FS 1326, LONG 28L - 27L. REMOVED CORROSION ON FRAME, REMOVED CARGO TRACK FROM STA 1320-1271 (FOM), REMOVED AND REPLACED INTERCOSTAL IAW SRM 51-30-5, 51-30-2.
- [SDR GTIA040841](https://openairdocs.org/sdr/GTIA040841.md): Seat Track · corroded · Oct 4, 2004 · N823NK · Doug DC982 · Fuselage, Seat/Cargo Attach Fittings
  > PASSENGER SEAT TRACK EXFOLIATED AT FS 1058, LT OB AND 1250 LT IB. CUT AND REMOVED DAMAGED SEAT TRACK, FABBED NEW SEAT TRACK AND SPLICE, TREAT, PRIME AND TOPCOAT SEAT TRACK AND INSTALLED.
- [SDR GTIA040832](https://openairdocs.org/sdr/GTIA040832.md): Splice · corroded · Sep 30, 2004 · N823NK · Doug DC982 · Fuselage, Seat/Cargo Attach Fittings
  > SAS B00176-18-00074; AFT PIT CORROSION UNDERSIDE L/T CARGO TRACK SPLICE AT FS 1231-1250. REMOVED CORROSION IAW SRM 51-10-3, REMOVED DAMAGED CARGO TRACK, DRILLED AND LOCATED HOLES IN NEW CARGO TRACK SPLICE AT FS 1231-1250. REMOVED CORROSION IAW SRM 51-10-3,
- [SDR GTIA040835](https://openairdocs.org/sdr/GTIA040835.md): Skin · damaged · Sep 30, 2004 · N823NK · Doug DC982 · Vertical Stabilizer, Plate/Skin
  > SAS B0017605R00118; VERTICAL STABILIZER UPPER (VOR) L/E LOWER MOUNT HOLES, COUNTERSINKS BEYOND SKIN, OFF CENTER HOLES ELONGATED, INTERIOR SURFACE CHAFED. INSTALLED REPAIR DOUBLER IAW SRM 51-30-5, TOPCOATED IAW SRM 51-10-3, BLENDED OUT CHAFED AREA IAW SRM 55-
- [SDR GTIA040836](https://openairdocs.org/sdr/GTIA040836.md): Skin · deformed · Sep 30, 2004 · N823NK · Doug DC982 · Fuselage Main, Plate/Skin
  > WAVY SKIN 27 INCHES FROM LOWER EDGE OF AFT AIRSTAIRS RT SIDE, FABRICATED REPAIR PARTS (FILLER AND DOUBLER) FROM 2024T3-.032, OK TO TREAT AND PRIME FABBED FILLER AND DOUBLER, INSTALLED IAW SRM 52-01.
- [SDR GTIA040839](https://openairdocs.org/sdr/GTIA040839.md): Skin · damaged · Sep 30, 2004 · N823NK · Doug DC982 · Fuselage Main, Plate/Skin
  > EXTERNAL REPAIR AT STA 1165, LONGERON 18L TO 20L REQUIRES REPLACEMENT. REMOVED EXTERNAL REPAIR DOUBLER, STRIPPED SURROUNDING SKIN IAW SRM 51-10-3, FABRICATED EXTERNAL REPAIR DOUBLER FROM 2024-T3-0.025. OK TO TREAT AND PRIME REPAIR PARTS AND AREA, INSTALLED R
- [SDR GTIA040833](https://openairdocs.org/sdr/GTIA040833.md): Channel · corroded · Sep 29, 2004 · N823NK · Doug DC982 · Wing Miscellaneous Structure
  > LT WING L/E STA XRS 240 AFT L/E FLANGE ACCESS PANEL ATTACHED HAS CORROSION AT GANG CHANNEL. REMOVED CORRODED GANG CHANNEL, INSTALLED NEW GANG CHANNEL IAW SRM 51-30-2.
- [SDR GTIA040838](https://openairdocs.org/sdr/GTIA040838.md): Skin · chafed · Sep 29, 2004 · N823NK · Doug DC982 · Wing, Plate/Skin
  > LT WING L/E CHAFED ON EXTERNAL SURFACE AT STA XRS 240, XRS 164, XRS 137. BLENDED OUT CHAFED AREAS IAW SRM 57-01, FIG 1, MATERIAL LOSS AT XRS 137 AND 240 OUT OF LIMITS, FABRICATED 2EA REPAIR DOUBLERS FROM 7075-T6-.063, LOCATED DRILLED REPAIR DOUBLERS, TREATED,
- [SDR GTIA040808](https://openairdocs.org/sdr/GTIA040808.md): Retainer · corroded · Sep 27, 2004 · N823NK · Doug DC982 · Service Doors
  > FWD SERVICE GALLEY DOOR LOWER PRESSURE SEAL RETAINER HAS CORROSION. REMOVED CORROSION, FABRICATED NEW RETAINER, INSTALLED NEW RETAINER.
- [SDR GTIA040769](https://openairdocs.org/sdr/GTIA040769.md): Handle · loose · Sep 3, 2004 · N823NK · Doug DC982 · Passenger/Crew Doors
  > FLL - FOUND L1 DOOR HANDLE LOOSE. TIGHTENED L1 DOOR HANDLE ASSEMBLY. (M)
- [SDR GTIA040776](https://openairdocs.org/sdr/GTIA040776.md): Isolator · out of adjust · Aug 31, 2004 · N823NK · Doug DC982 · Engine Mount Section
  > NR 2 ENGINE PYLON FORWARD LOWER ISOLATOR, ALIGNMENT MARKS ARE OUT OF LIMITS. REMOVED AND REPLACED LOWER FORWARD ISOLATOR. (M)
- [SDR GTIA040762](https://openairdocs.org/sdr/GTIA040762.md): Unknown · fumes · Aug 29, 2004 · N823NK · Doug DC982 · Air Distribution System
  > FLL - FLT 380 - AFTER TAKEOFF FUMES FILLED A/C AND CAUSED AIR RETURN. PERFORMED A/C AIR CONDITION SYSTEM CHECK WITH ENGINES AT HIGH POWER SETTINGS. OPS CHECK NORMAL. (M) GTIA
- [SDR GTIA040749](https://openairdocs.org/sdr/GTIA040749.md): Lanyard · disconnected · Aug 25, 2004 · N823NK · Doug DC982 · Escape Slide
  > FOUND L1 DOOR LANYARD IS OFF. REINSTALLED L1 DOOR LANYARD. GTIA (M)
- [SDR GTIA040730](https://openairdocs.org/sdr/GTIA040730.md): Controller · malfunctioned · Aug 14, 2004 · N823NK · Doug DC982 · Cabin Pressure Controller
  > LGA - FLT 779 - LEVEL AT FL280, FLOW LT ILLUMINATED AND CABIN ALT STARTED CLIMBING. PRESSURIZATION CONFIRMED FULL FORWARD. DESCENDED INITIATED AND CABIN PRESSURIZATED AT 17000 FLOW LIGHT OUT COMPLIED WITH QRH PROC. REMOVED AND REPLACED 7 CONTROLLER/SELECTOR
- [SDR GTIA040716](https://openairdocs.org/sdr/GTIA040716.md): Slide · dislodged · Aug 5, 2004 · N823NK · Doug DC982 · Escape Slide
  > FLL - FOUND L2 DOOR EVAC SLIDE FELL DOWN. REMOVED AND REPLACED L2 DOOR EVAC SLIDE. (M)
- [SDR GTIA040668](https://openairdocs.org/sdr/GTIA040668.md): Handle · loose · Jul 15, 2004 · N823NK · Doug DC982 · Passenger/Crew Doors
  > FLL - FOUNF L1 DOOR HANDLE LOOSE. TIGHTENED L1 DOOR HANDLE ASSEMBLY, OPS CHECK GOOD. (M)
- [SDR GTIA040640](https://openairdocs.org/sdr/GTIA040640.md): Clip · disconnected · Jul 4, 2004 · N823NK · Doug DC982 · Escape Slide
  > RSW - FLT 689 - L2 DOOR PAX ESCAPE SLIDE 'CLIP' DISCONNECTED. RECONNECTED 'CLIP' ON SLIDE. (M)
- [SDR GTIA040578](https://openairdocs.org/sdr/GTIA040578.md): Connector · shorted · Jun 21, 2004 · N823NK · Doug DC982 · Fire Detection
  > ORD - FLT 1103 - RIGHT ENGINE LOOP B AND FIRE DETECTOR LOOP CAUTION LIGHTS CAME ON WITH NO OTHER ABNORMALITIES. LOOP A SELECTED AND LOOP A TESTED GOOD. FOUND CONNECTOR P1-863 SHORTED REMOVED AND REPLACED CONNECTOR P1-863 ON RIGHT ENGINE FIRE LOOP 'B'. SYSTE
- [SDR GTIA040574](https://openairdocs.org/sdr/GTIA040574.md): Connector · dirty · Jun 17, 2004 · N823NK · Doug DC982 · Fire Detection
  > RIGHT LOOP B LIGHT CAME ON DURING FLIGHT. PERFORMED QRH PROCEURE, LOOP A OK. T/S CLEANED CONNECTORS ON B LOOP ENGINE CONNECTORS UNABLE TO FIND CONCLUSIVE FAULT, OPS CHECK OK. (M)
- [SDR GTIA040572](https://openairdocs.org/sdr/GTIA040572.md): Slide · discharged · Jun 17, 2004 · N823NK · Doug DC982 · Escape Slide
  > LGA - FOUND SLIDE FROM R1 HAS LOW PRESSURE. REMOVED AND REPLACED R1 SLIDE. (M)
- [SDR GTIA040050](https://openairdocs.org/sdr/GTIA040050.md): Lanyard · disconnected · Feb 6, 2004 · N823NK · Doug DC982 · Escape Slide
  > RSW - FOUND R1 DOOR LANYARD OFF. RECONNECTED R1 DOOR SLIDE LANYARD. NO DEFECTS NOTED. (M)
- [SDR GTIA030959](https://openairdocs.org/sdr/GTIA030959.md): Slide · dislodged · Nov 28, 2003 · N823NK · Doug DC982 · Escape Slide
  > ACY - DURING MAINTENANCE THE CLEANERS OPENED L2 DOOR AND DROPPED SLIDE PACK ON RAMP. REMOVED AND REPLACED L-2 SLIDE. (M)
- [SDR GTIA030896](https://openairdocs.org/sdr/GTIA030896.md): Girt Bar · dirty · Nov 7, 2003 · N823NK · Doug DC982 · Escape Slide
  > ORD - FLT 1525A - L1 SLIDE PACK SLIPS OUT OF PLACE WHEN SLIDE IS DISARMED. DETERMINED GIRT BAR FALLING OUT OF LOCKS. CLEANED AND LUBED GIRT BAR LOCKS, OPS CHECK NORMAL. ALSO, ADJ GIRT BAR DISENGAGE HOLDER. (M)
- [SDR GTIA030994](https://openairdocs.org/sdr/GTIA030994.md): Frame · damaged · Oct 31, 2003 · N823NK · Doug DC982 · Fuselage Main, Frame
  > FTW - FOUND NOSE GEAR RIGHT SIDE AFT DOOR JAMB HAS DENTED/DAMAGED STATION 110. REMOVED DAMAGED FRAME. INSTALLED FRAME. (M)
- [SDR GTIA030732](https://openairdocs.org/sdr/GTIA030732.md): Warning Light · illuminated · Aug 23, 2003 · N823NK · Doug DC982 · Central Warning
  > A/C 823 HAS AUTO SLAT FAIL LIGHT ON TAXI OUT. UNSCHEDULED CHANGE A/C EN ROUTE. (M)
- [SDR GTIA030731](https://openairdocs.org/sdr/GTIA030731.md): Warning Light · illuminated · Aug 21, 2003 · N823NK · Doug DC982 · Central Warning
  > ON STABILZED APPROACH WITH FLAPS UP THE STALL INDICATION FAILURE LIGHT ILLUMINATED FOR ONE MINUTE THEN LIGHT REMAINED ON FOR REST OF THE APPROACH, ALSO HEADING LIGHT ON BOTH FMA'S WAS ILLUMINATED, HEADINGS WERE SPLIT 6-7 DEGREES BOTH LIGTHS ON STEADY. UNSCHED
- [SDR GTIA030485](https://openairdocs.org/sdr/GTIA030485.md): Generator · failed · Jun 20, 2003 · N823NK · Doug DC982 · AC Generation System
  > SELECTED EMERGENCY POWER AFTER LEFT GEN FAIL. CAPTAINS ATTITUDE FLAGS IN VIEW AND UNPOWERED EMER AC AND EMG DC ANNUNCIATOR LIGHTS REMAINED OUT AND ALL INDICATIONS WERE BUSSES POURED FOR EMERGENCY AC AND DC. PERFORMED OPS CHECKS ON EMERGENCY POWER SYSTEM, NO
- [SDR GTIA030452](https://openairdocs.org/sdr/GTIA030452.md): Bulb · burned out · Jun 12, 2003 · N823NK · Doug DC982 · Landing Gear Position and Warning
  > NOSE WHEEL NLG INDICATOR NOT OUT WHEN GEAR DOWN. LANDING GEAR NOSE LIGHT OUT. LUBRICATED NOSE GEAR VISUAL IND LEVER INDICATOR PRITRUDES.375 INCHES ABOVE TOP SURFACE OF PEDESTAL COVER PLACT WITH HYDRAULIC PRESSURE APPLIED. RELAMPED NOSE GEAR GREEN DOWN AND
- [SDR GTIA030326](https://openairdocs.org/sdr/GTIA030326.md): Wire · unsecure · May 6, 2003 · N823NK · Doug DC982 · Light System Wiring
  > L1 DOOR EXIT IDENTIFIER, INOPERATIVE. T/S AND FOUND POWER WIRE NOT SECURED. SECURED POWER WIRE.
- [SDR GTIA030338](https://openairdocs.org/sdr/GTIA030338.md): Frame · corroded · May 1, 2003 · N823NK · Doug DC982 · Fuselage Main, Frame
  > FOUND CORRODED FRAME IN AFT LEFT LAVATORY AT FS 1338 LEFT SIDE APPROX 6 INCHES ABOVE CUSP LINE. FABRICATED 3 ANGLE AND 5 SPLICE ANGLE. INSTALLED 3 ANGLE AND 5 SPLICE REPAIR. (M)
- [SDR GTIA030314](https://openairdocs.org/sdr/GTIA030314.md): Floor Panel · delaminated · Apr 29, 2003 · N823NK · Doug DC982 · Fuselage Floor Panel
  > FORWARD LAV ENTRY STA 256 FLOOR PANEL DELAMINATED. REMOVED FLOOR PANEL. FABBED FLOOR PANEL. INSTALLED NEW FLOOR PANEL.
- [SDR GTIA030315](https://openairdocs.org/sdr/GTIA030315.md): Floorboard · delaminated · Apr 29, 2003 · N823NK · Doug DC982 · Fuselage Floor Panel
  > FORWARD ENTRY STA 200 FLOOR PANEL DELAMINATED. REMOVED FLOOR PANEL. FABRICATED NEW FLOORBOARD. INSTALLED NEW FLOORBOARD.
- [SDR GTIA030327](https://openairdocs.org/sdr/GTIA030327.md): Floorboard · cracked · Apr 29, 2003 · N823NK · Doug DC982 · Fuselage Floor Panel
  > FLOORBOARD MAIN CABIN STA 826-927 LT, CRACKED. STOP DRILLED CRACK. FABBED REPAIR DOUBLER. INSTALLED REPAIR PARTS.
- [SDR GTIA030309](https://openairdocs.org/sdr/GTIA030309.md): Floor Support · corroded · Apr 21, 2003 · N823NK · Doug DC982 · Fuselage Miscellaneous Structure
  > CABIN STA 203, RBL 5, LBL 19 FLOOR SUPPORT CORRODED. REMOVED FLOOR SUPPORT, FABRICATED NEW FLOOR SUPPORT AND INSTALLED FLOOR SUPPORT.
- [SDR GTIA030308](https://openairdocs.org/sdr/GTIA030308.md): Structure · corroded · Apr 21, 2003 · N823NK · Doug DC982 · Fuselage Main, Structure
  > CABIN STA 218, LBL 43, SUBFLOOR CORRODED. CUT OUT DAMAGE. DRILL AND LOCATE DOUBLER. INSTALLED DOUBLER.
- [SDR GTIA030307](https://openairdocs.org/sdr/GTIA030307.md): Floorboard · cracked · Apr 20, 2003 · N823NK · Doug DC982 · Fuselage Floor Panel
  > PAX CABIN FLOORBOARD CRACKED/BROKEN AT FS 218-294 LEFT BETWEEN SEAT TRACKS 1 AND 2. REMOVED FLOORBOARD, DRILL AND LOCATE AND INSTALLED FLOORBOARD.
- [SDR GTIA030316](https://openairdocs.org/sdr/GTIA030316.md): Skin · damaged · Apr 17, 2003 · N823NK · Doug DC982 · Fuselage Main, Plate/Skin
  > FORWARD ENTRY DOOR HOLD OPEN PIN CUTOUT SKIN DAMAGED, REPAIRS. UPON FURTHER INSPECTION THE PAN COMMON TO THE ENTRY DOOR HOLD PIN ASSY WAS FOUND TO BE CRACKED. FABBED -13, -11 DOUBLERS, -3 PLATE. LOCATED AND DRILLED NEW PAN. INSTALLED FORWARD ENTRY DOOR HOL
- [SDR GTIA030312](https://openairdocs.org/sdr/GTIA030312.md): Floor Panel · broken · Apr 17, 2003 · N823NK · Doug DC982 · Fuselage Floor Panel
  > CABIN FLOOR PANEL AT FS 200-237 CENTER IS BROKEN IN CENTER. FABRICATED NEW FLOOR PANEL.
- [SDR GTIA030322](https://openairdocs.org/sdr/GTIA030322.md): Fire Seal · cracked · Apr 16, 2003 · N823NK · Doug DC982 · Nacelle/Pylon, Bulkhead/Firewall
  > NR ENGINE APRON UPPER 6TH FROM FORWARD FIRE SEAL CRACKED. REMOVED CRACKED FIRE SEAL. FABRICATED NEW FIRE SEAL. INSTALL NEW FIRE SEAL.
- [SDR GTIA030304](https://openairdocs.org/sdr/GTIA030304.md): Fireseal · cracked · Apr 16, 2003 · N823NK · Doug DC982 · Nacelle/Pylon, Bulkhead/Firewall
  > NR 2 ENGINE APRON UPPER 4TH FROM FORWARD FIRESEAL CRACKED. REMOVED CRACKED FIRESEAL. FABRICATED NEW FIRESEAL. INSTALLED NEW FIRESEAL.
- [SDR GTIA030306](https://openairdocs.org/sdr/GTIA030306.md): Skin · corroded · Apr 15, 2003 · N823NK · Doug DC982 · Fuselage Main, Plate/Skin
  > FOUND AFT PIT STATION 1174 CORRODED AT SKIN WITH INNER/OUTER DOUBLER, LOWER DOOR JAMB. INNER SKIN FOUND TO BE OUT OF LIMITS. FABRICATED REPAIR DOUBLERS. INSTALLED 2 DOUBLERS. (M)
- [SDR GTIA030336](https://openairdocs.org/sdr/GTIA030336.md): Frame · corroded · Apr 15, 2003 · N823NK · Doug DC982 · Fuselage Main, Frame
  > AFT PIT CORRODED AT FRAME, STATION 1079 - 1309. REMOVED CORROSION ON FRAME STATION 1231-1271 AND 1309. FOUND OUT OF LIMITS. CUTOUT DAMAGE IF FRAME FROM STATION 1231. INSTALLED NEW SECTION OF FRAME. SPLICE REPAIR STATION 1231. CUTOUT DAMAGE AREA OF FRAME
- [SDR GTIA030317](https://openairdocs.org/sdr/GTIA030317.md): Fitting · cracked · Apr 15, 2003 · N823NK · Doug DC982 · Fuselage Miscellaneous Structure
  > AFT PIT STA 1007 1 FITTING SUPPORT END CARGO TRACK ATTACH TO INTERCOASTAL RIGHT SIDE IS CRACKED. REMOVED CRACKED FITTING. HOLES LOCATED AND DRILLED ON NEW FITTING. INSTALLED NEW FITTING.
- [SDR GTIA030318](https://openairdocs.org/sdr/GTIA030318.md): Door Frame · corroded · Apr 15, 2003 · N823NK · Doug DC982 · Fuselage Main, Structure
  > AFT PIT STA 1155 FORWARD DOOR FRAME CORRODED. REMOVED DAMAGED AREA. FORMED REPAIR. INSTALLED 2 REPAIR PIECES.
- [SDR GTIA030319](https://openairdocs.org/sdr/GTIA030319.md): Fitting · corroded · Apr 15, 2003 · N823NK · Doug DC982 · Fuselage Main, Attach Fittings
  > AFT PIT LT FITTING SUPPORT LOWER DOOR JAMB, 2 EA CORRODED STA 1155, STA 1211. REMOVED 2EA LT FITTINGS. LOCATED AND DRILLED NEW FITTINGS. INSTALLED NEW FITTING.
- [SDR GTIA030329](https://openairdocs.org/sdr/GTIA030329.md): Bracket · corroded · Apr 15, 2003 · N823NK · Doug DC982 · Fuselage Miscellaneous Structure
  > AFT PIT STA 1155 TO STA 1117. 4 EA BRACKETS SUPPORT RIGHT CARGO TRACK CORRODED (ATTACH TO THE BEAM). FABRICATED 4 EA ANGLES.
- [SDR GTIA030337](https://openairdocs.org/sdr/GTIA030337.md): Skin · corroded · Apr 14, 2003 · N823NK · Doug DC982 · Fuselage Main, Plate/Skin
  > FOUND MID CARGO FS 690 STATION STRINGER 30-29L SKIN CORRODED. AFTER FURTHER EVALUATION, MORE DAMAGE FOUND ON EXTERNAL SKIN. FABRICATED EXT DOUBLER. FABRICATED INT DOUBLER. INSTALLED REPAIR DOUBLERS. (M)

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

This list as a web page: https://openairdocs.org/deregistered/N823NK-2005-01-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.
