# Service difficulty reports: N781CA, cancelled Jul 30, 2023

A list on [N781CA, cancelled Jul 30, 2023](https://openairdocs.org/deregistered/N781CA-2023-07-30.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 4 · 162 reports

- [SDR ASOA201901145012](https://openairdocs.org/sdr/ASOA201901145012.md): Connector · contaminated · Jan 14, 2019 · N781CA · Cndair CL6002B19 · Air Conditioning System Wiring
  > IN CRUISE AT FL350 RT PACK HI TEMP CAUTION MESSAGE DISPLAYED FOLLOWED BY LOSS OF CABIN PRESSURE. STARTED DESCENT TO 10000FT PASSENGER O2 MASKS DEPLOYED AS CABIN CLIMBED TO 15000 AUTO PRESS 1 AND 2 FAIL MESSAGES DISPLAYED. SUPPLEMENTAL INFORMATION UPON FURTHER
- [SDR ASOA201811025309](https://openairdocs.org/sdr/ASOA201811025309.md): Skin · corroded · Nov 2, 2018 · N781CA · Cndair CL6002B19 · Wing, Plate/Skin
  > LOWER WING PLANK SKIN CUTOUT RH BOOST PUMP HAS MULTIPLE INDICATIONS NOTED AROUND ENTIRE CIRCUMFERENCE ON HORIZ LANDING FOR PNL AND VERTICAL SURFACES 50% FSH FAILED NDT INSP. C/W CARD REO 601R-57-21-2884 BLENDED CORROSION.
- [SDR ASOA2018110625308](https://openairdocs.org/sdr/ASOA2018110625308.md): Bushing · failed · Nov 2, 2018 · N781CA · Cndair CL6002B19 · Elevator Structure
  > REF:CO# 7312618 JOB#7731265A OP#9 L/H ELEVATOR FAILED BEARING BACKLASH SYSTEM NO.1 AT.230 AND SYSTEM NO.3 AT.232, MAX LIMIT IS.210. C/A REPAIRED L/H ELEVATOR IAW EXPRESSJET EC/TC RIL#0183 AND BOMBARDIER RIL# 0183 REV B, DATED 01/24/2014. REPLACED BUSHINGS A
- [SDR ASOA201810315307](https://openairdocs.org/sdr/ASOA201810315307.md): Floorbeam · corroded · Oct 31, 2018 · N781CA · Cndair CL6002B19 · Fuselage Main, Floor Beam
  > AFT CABIN FLOORBEAM HAS CORROSION ON UPPER SURFACE FS 559.00 RBL 9.0. COMPLIED WITH EC/TC REO 601R-53-41-2379 AND GENERIC REO 601R-53-41-2379 DATED: 10/29/2018.
- [SDR ASOA201810305306](https://openairdocs.org/sdr/ASOA201810305306.md): Floorbeam · corroded · Oct 30, 2018 · N781CA · Cndair CL6002B19 · Fuselage Main, Floor Beam
  > LBL 27 UPPER FLOORBEAM CAP FROM FS 574 TO FS 621 IS CORRODED. REPAIRED UPPER FLOORBEAM CAP IAW REO 601R-53-61-6743 REV -, ECTC REO 601R-53-61-6743 REV 0, REO 601R-53-61-3778, AND ECTC REO 601R-53-61-3778 REV C.
- [SDR ASOA201810305305](https://openairdocs.org/sdr/ASOA201810305305.md): Skin · dented · Oct 30, 2018 · N781CA · Cndair CL6002B19 · Fuselage Main, Plate/Skin
  > DENT AT FS 582 STR 22L APPROX L 1.7" W 1.0" D.015". REPAIRED DENT AT FS 582 STR 22L IAW EA 32-2018-225 AND ECTC EA 32-2018-225 REV 0.
- [SDR ASOA201810305304](https://openairdocs.org/sdr/ASOA201810305304.md): Skin · dented · Oct 30, 2018 · N781CA · Cndair CL6002B19 · Fuselage Main, Plate/Skin
  > DENT FOUND AT FS 409+16 ON STR 16L APPROX L=2", W=1.5, D=.012". REPAIRED DENT AT FS 409+16 AT STR 16L IAW EA 30-2018-231 AND ECTC EA 30-2018-231 REV 0.
- [SDR ASOA2018110295301](https://openairdocs.org/sdr/ASOA2018110295301.md): Sidewall Support · corroded · Oct 29, 2018 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > LEFT CARGO SIDEWALL SUPPORT HAD CORROSION BS 559+83, LBL 36. REPAIRED THE SIDEWALL SUPPORT IAW SNIEO 601R31133-S04, AND SNIEO CC601R31133 S04.
- [SDR ASOA2018110295300](https://openairdocs.org/sdr/ASOA2018110295300.md): Floor Support · corroded · Oct 29, 2018 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CABIN LEFT SIDE FLOOR SUPPORT HAD SIGNS OF CORROSION, BS 409 - 409+16 AND 409+110. REPAIRED THE FLOOR SUPPORT IAW REO 601R-53-00-530, REV A, EC/TC 601R-53-00-530, REV A, REO 601R-53-00-708 REV --, AND EC/TC REO 601R-53-00-708 REV --.
- [SDR ASOA201810295299](https://openairdocs.org/sdr/ASOA201810295299.md): Frame · corroded · Oct 29, 2018 · N781CA · Cndair CL6002B19 · Fuselage Main, Frame
  > AFT CARGO AREA HAS CORROSION BELOW FLOOR, FS 605.00, LBL 6.0 LOWER FRAME FLANGE. REMOVED AND REPLACED FRAME IAW SRM 51-40-11, 51-42-06, CC 601R36026 S01 AND EC/TC CC 601R36026 S01.
- [SDR ASOA201810295298](https://openairdocs.org/sdr/ASOA201810295298.md): Not Reported · worn · Oct 29, 2018 · N781CA · Cndair CL6002B19 · Elevator Miscellaneous Structure
  > RT ELEVATOR FAILED BEARING BACKLASH SYSTEM NR 3 AT.285. MAX LIMIT IS.210. REPAIRED RT ELEVATOR IAW EC/TC RIL 0183 AND RIL 0183 REV B, DATED 01/24/2014.
- [SDR ASOA201810295297](https://openairdocs.org/sdr/ASOA201810295297.md): Bulkhead · chafed · Oct 29, 2018 · N781CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > FS 621 BULKHEAD FWD FACE HAS DAMAGE AROUND FASTENER HOLE AT LBL44, 18" ABOVE FLOOR LEVEL. REPAIRED FS 621 BULKHEAD FWD FACE IAW REO 601R-53-61-2155 REV -A, DATED 2013-08-13 AND EC/TC REO 601R-53-61-2155.
- [SDR ASOA201810295296](https://openairdocs.org/sdr/ASOA201810295296.md): Bulkhead · gouged · Oct 29, 2018 · N781CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > FS 621 BULKHEAD FWD FACE HAS 1 LIGHT GOUGE AT LBL 14, 3" ABOVE FLOOR LEVEL AND APPROX..5" LONG. REPAIRED FS 621 BULKHEAD FWD FACE IAW REO 601R-53-61-2155 REV -A, DATED 2013-08-13 AND EC/TC REO 601R-53-61-2155.
- [SDR ASOA2018110185293](https://openairdocs.org/sdr/ASOA2018110185293.md): Skin · cracked · Oct 28, 2018 · N781CA · Cndair CL6002B19 · Wing, Plate/Skin
  > REF: CO# 7312618 JOB# 7731265 OP# 25: LOWER WING PLANK ACCESS HOLE HAS MULTIPLE INDICATIONS NOTED IN THE LANDING FOR PANEL 650D B AT FWD AND AFT AREA, BOTH AREAS ARE 4" LONG BY 0.250" WIDE BY 50% SCREEN HEIGHT. FAILS NDT.C/A: REPAIRED IAW BOMBARDIER REO 601R-
- [SDR ASOA2018110185292](https://openairdocs.org/sdr/ASOA2018110185292.md): Skin · cracked · Oct 28, 2018 · N781CA · Cndair CL6002B19 · Wing, Plate/Skin
  > REF: CO# 7312618 JOB# 7731265 OP# 26: LOWER WING PLANK ACCESS HOLE HAS MULTIPLE INDICATIONS NOTED IN THE LANDING FOR PANEL 640AB AT FWD AND AFT AREA, BOTH AREAS ARE 4" LONG BY 0.250" WIDE BY 50% SCREEN HEIGHT. FAILS NDT. C/A: REPAIRED IAW BOMBARDIER REO 601R-
- [SDR ASOA201810195279](https://openairdocs.org/sdr/ASOA201810195279.md): Hinge · worn · Oct 19, 2018 · N781CA · Cndair CL6002B19 · Rudder Structure
  > RUDDER BACKLASH FAILED. SYSTEM NR 1 PCU AT 0.312" AND SYSTEM NO.3 PCU AT 0.340". BEARING FAILED AT 0.170". REPAIRED RUDDER SYSTEM BACKLASH IAW RIL'S 0602, 0392 AND EC/TC 0602 AND 0392. RUDDER BACKLASH PERFORMED IAW AMM 27-21-00-220-810. BACKLASH CHECK PASSED.
- [SDR ASOA2018101965267](https://openairdocs.org/sdr/ASOA2018101965267.md): Door Sill · corroded · Oct 16, 2018 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > REF: CO 7312618 JOB 7731268 OP 30: LT AFT CARGO DOOR SILL CORRODED. C/A: REPAIRED LT AFT CARGO DOOR SILL IAW REO 601R-53-00-526 REV— DATED 22 MAY 2013 AND ECTC REO 601R-53-00-526.
- [SDR ASOA2018101955266](https://openairdocs.org/sdr/ASOA2018101955266.md): Skin · dented · Oct 15, 2018 · N781CA · Cndair CL6002B19 · Fuselage Main, Plate/Skin
  > REF: CO 7312618 JOB 7731265 OP 7022: FROM MX TRANS 17250131 DENT UNDER CARGO DOOR. COMPLIED WITH REO 601R-53-61-6255. COMPLY WITH LPI WITHIN 50FH, AND REINSPECT EVERY 300FH. PERMANENT REPAIR DUE IN 2800 FH BY TAT42138.8. ACCOMPLISH PERMANENT REPAIR PER REO 601
- [SDR ASOA2018101995262](https://openairdocs.org/sdr/ASOA2018101995262.md): Door Sill · corroded · Oct 9, 2018 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > REF: CO 7312618 JOB 7731268 OP 22: RT CARGO FLOOR SIDE SILL 559.00+80 TO FS 578.00, RBL 36.0 HAS CORROSION AROUND NUTPLATES. C/A: COMPLIED WITH EC/TC REO 601R-53-00-526 01 AND GENERIC REO 601R-53-00-526 REV. --, DATED: 05/22/2013 AS WRITTEN.
- [SDR ASOA2018101995261](https://openairdocs.org/sdr/ASOA2018101995261.md): Skin · chafed · Oct 9, 2018 · N781CA · Cndair CL6002B19 · Wing, Plate/Skin
  > REF: CO 7312618 JOB 7731261 OP 79: CENTER WING LOWER PLANK IS CHAFED AT LBL45 & RBL45 FROM CONTACT WITH BELLY FAIRING 193AB. C/A: COMPLIED WITH EC/TC REO 601R-57-21-880 IN ACCORDANCE WITH REO 601R-57-21-880 REV. D, DATED: 03/06/2017 AS WRITTEN.
- [SDR ASOA201810075257](https://openairdocs.org/sdr/ASOA201810075257.md): Intercostal · corroded · Oct 7, 2018 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > MAIN AVIONICS DOOR SURROUND STRUCTURE HAS CORROSION AT TWO FWD INTERCOSTALS LBL 2.0, RBL 2.0 AND ONE AFT INTERCOSTAL RBL 2.0 FS 364 - 394. FRAME STATION 280.00 FWD J ANGLE IS CORRODED. REMOVED AND REPLACED ONE AFT INTERCOSTAL RBL 2.0 FS 364 - 394 IAW SRM 51-42
- [SDR ASOA201810075256](https://openairdocs.org/sdr/ASOA201810075256.md): Cargo Track · corroded · Oct 7, 2018 · N781CA · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings
  > CARGO FLOOR TRACKS AT FS 559.00+112 HAVE CORROSION, LBL 9.00 AND RBL 9.00. REMOVED AND REPLACED TRACKS IAW EC/TC REO 601R-53-00-485 AND GENERIC REO 601R-53-00-485 REV D, DATED 01/29/2018.
- [SDR ASOA201810075255](https://openairdocs.org/sdr/ASOA201810075255.md): Cargo Track · corroded · Oct 7, 2018 · N781CA · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings
  > CARGO TRACKS CORRODED FS 559.00+90, LBL 9.0, RBL 9.0 AND RBL 27.00. REMOVED AND REPLACED TRACKS IAW EC/TC REO 601R-53-00-485 AND GENERIC REO 601R-53-00-00485 REV D, DATED 01/29/2018.
- [SDR ASOA201810045254](https://openairdocs.org/sdr/ASOA201810045254.md): Angle · corroded · Oct 4, 2018 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > FRAME STATION 280.00 FWD J ANGLE IS CORRODED. INSTALLED NEW SERVICEABLE FWD J ANGLE IAW SRM 51-42-21, 51-42-06, 51-44-06, 51-25-16.
- [SDR ASOA2018100595242](https://openairdocs.org/sdr/ASOA2018100595242.md): Bracket · corroded · Sep 29, 2018 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > REF: CO 7312618 JOB 7731268 OP 16: PAX DOOR BRACKET AND CLEAT CORRODED AT FS 343.00, LBL 33. C/A: REMOVED AND REPLACED BRACKET IAW SRM 51-42-06, 51-42-11 AND 51-42-10.
- [SDR ASOA201809235310](https://openairdocs.org/sdr/ASOA201809235310.md): Fitting · cracked · Sep 23, 2018 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > RT 484 FRAME O/B CLIP IS CRACKED. REPAIRED IAW REO 601R-53-41-2376 REV - DATE 2018-10-19.
- [SDR ASOA2018100535241](https://openairdocs.org/sdr/ASOA2018100535241.md): Strap · corroded · Sep 23, 2018 · N781CA · Cndair CL6002B19 · Fuselage Floor Panel
  > REF: CO 7312618 JOB 7731261 OP 158: CORROSION ON FLOOR PNL STRAP AT LT AFT EDGE OF PRESSURE BOX AT FS 559.0. C/A: FABBED AND REPLACED STRAP IAW SRM 53-41-43, 51-40-11, 51-25-01 AND 51-42-06.
- [SDR ASOA2018100535240](https://openairdocs.org/sdr/ASOA2018100535240.md): Seat Track · corroded · Sep 23, 2018 · N781CA · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings
  > REF: CO 7312618 JOB 7731261 OP 205: WALL SEAT TRACK ON RT SIDE FROM FS 500 TO FS 545 CORRODED. C/A: REMOVE, FABBED AND REPLACED SEAT TRACK IAW REO 601R-53-00-485.
- [SDR ASOA2018100535239](https://openairdocs.org/sdr/ASOA2018100535239.md): Seat Track · corroded · Sep 23, 2018 · N781CA · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings
  > REF: CO 7312618 JOB 7731261 OP 204: WALL SEAT TRACK ON RT SIDE FROM FS 449 TO FS 500 CORRODED. C/A: REMOVE, FABBED AND REPLACED SEAT TRACK IAW REO 601R-53-00-485.
- [SDR SWIA201642343](https://openairdocs.org/sdr/SWIA201642343.md): Floor Support · corroded · Jul 1, 2016 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > LEFT CABIN FLOOR SUPPORT AND ANGLE BETWEEN BS 518 AND 527. REPAIRED THE FLOOR SUPPORT AND ANGLE IAW REO.
- [SDR SWIA201642341](https://openairdocs.org/sdr/SWIA201642341.md): Structure · bent · Jul 1, 2016 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > FWD AND AFT LANDS FOR THE GROUND AIR CONDITIONING DOOR BENT. REPAIRED FWD AND AFT LANDS FOR THE GROUND AIR CONDITIONING DOOR IAW EA.
- [SDR SWIA201642338](https://openairdocs.org/sdr/SWIA201642338.md): Floorbeam · corroded · Jun 28, 2016 · N781CA · Cndair CL6002B19 · Fuselage Main, Floor Beam
  > FLOORBEAM AT BS 349 BETWEEN RBL 27 AND 38 HAS CORROSION BEYOND LIMITS. REPAIRED THE FLOORBEAM IAW EA.
- [SDR SWIA201642339](https://openairdocs.org/sdr/SWIA201642339.md): Angle · corroded · Jun 21, 2016 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CARGO DOOR AFT LOWER ANGLE BEHIND COMBING IS CORRODED. THE ANGLE WAS REMOVED AND NEW ANGLE P/N: 600-35011-45 INSTALLED IAW SRM.
- [SDR SWIA201642337](https://openairdocs.org/sdr/SWIA201642337.md): Bracket · corroded · Jun 20, 2016 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CORROSION ON LOWER FRAME BRACKET AT BS 319 STRINGER 17R. REMOVED AND REPLACED LOWER FRAME BRACKET IAW SRM.
- [SDR SWIA201642336](https://openairdocs.org/sdr/SWIA201642336.md): Vane · chafed · Jun 19, 2016 · N781CA · Cndair CL6002B19 · Trailing Edge Flaps
  > RT INBOARD FLAP CENTER VANE CAP CHAFED. REMOVED AND REPLACED THE VANE CAP IAW SRM.
- [SDR SWIA201642333](https://openairdocs.org/sdr/SWIA201642333.md): Vane · chafed · Jun 19, 2016 · N781CA · Cndair CL6002B19 · Trailing Edge Flaps
  > L/H INBOARD FLAP CENTER VANE CAP CHAFED. REMOVED AND REPLACED THE VANE CAP IAW SRM.
- [SDR SWIA201642344](https://openairdocs.org/sdr/SWIA201642344.md): Floor Support · corroded · Jun 17, 2016 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > RIGHT SIDE FUSELAGE INTERIOR FLOOR SUPPORT AT BS 349 HAS CORROSION. REPAIRED THE FLOOR SUPPORT IAW EA.
- [SDR SWIA201642335](https://openairdocs.org/sdr/SWIA201642335.md): Vane · chafed · Jun 17, 2016 · N781CA · Cndair CL6002B19 · Trailing Edge Flaps
  > RIGHT INBOARD FLAP OUTBOARD VANE CAP IS CHAFED. VANE CAP WAS REMOVED AND REPLACED IAW SRM.
- [SDR SWIA201642342](https://openairdocs.org/sdr/SWIA201642342.md): Angle · corroded · Jun 16, 2016 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > GALLEY SERVICE DOOR THRESHOLD AT BS 319, ANGLE HAS CORROSION. REMOVED AND REPLACED THE ANGLE IAW SRM.
- [SDR SWIA201642340](https://openairdocs.org/sdr/SWIA201642340.md): Threshold · corroded · Jun 16, 2016 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > PAX DOOR ENTRY THRESHOLD HAS CORROSION AT FWD AND AFT CUPS. INSTALLED FWD AND AFT PAX DOOR ENTRY THRESHOLD CUP IAW SRM.
- [SDR SWIA201642334](https://openairdocs.org/sdr/SWIA201642334.md): Floor Support · corroded · Jun 16, 2016 · N781CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > LEFT SIDE INSIDE FUSELAGE AT BS 349, CORROSION ON FLOOR SUPPORT. REPAIRED THE FLOOR SUPPORT IAW EA.
- [SDR SWIA201642332](https://openairdocs.org/sdr/SWIA201642332.md): Panel · failed · Jun 14, 2016 · N781CA · Cndair CL6002B19 · Horizontal Stabilizer Structure
  > HORIZONTAL STABILIZER VISOR PANEL 326AR FAILED GAP CHECK. REMOVED AND REPLACED IAW SRM.
- [SDR SWIA201642331](https://openairdocs.org/sdr/SWIA201642331.md): Housing · gouged · Jun 13, 2016 · N781CA · Cndair CL6002B19 · Cargo/Baggage Doors
  > EXTERNAL CARGO DOOR HANDLE HOUSING IS GOUGED. A NEW EXTERNAL CARGO DOOR HANDLE INSTALLED IAW AMM AND SRM. OPERATIONAL TESTS GOOD.
- [SDR SWIA201642330](https://openairdocs.org/sdr/SWIA201642330.md): Skin · dented · Jun 12, 2016 · N781CA · Cndair CL6002B19 · Landing Gear Doors
  > TWO DENTS ON THE RT LANDING GEAR DOOR. DRESSED THE DENTS IAW STS EA.
- [SDR SWIA201641756](https://openairdocs.org/sdr/SWIA201641756.md): Warning Light · illuminated · Jan 12, 2016 · N781CA · Cndair CL6002B19 · Landing Gear Retraction/Extension System
  > GEAR DISAGREE ON GEAR RETRACTION. OPEN
- [SDR SWIA201540569](https://openairdocs.org/sdr/SWIA201540569.md): Structure · cracked · Jan 5, 2015 · N781CA · Cndair CL6002B19 · Fuselage Main, Structure
  > FOUND CRACKED AT BS 640, S9R CUT-OUT. REPAIRED IAW REO.
- [SDR SWIA201439814](https://openairdocs.org/sdr/SWIA201439814.md): Loop · failed · Nov 5, 2014 · N781CA · Cndair CL6002B19 · Airfoil Anti/De-ice System
  > RETURNED TO THE FIELD WITH AN ANTI-ICE DUCT WARNING MESSAGE. CHANGED THE RT WHEEL BIN LOOP. OPS CHECKED GOOD.
- [SDR SWIA201438819](https://openairdocs.org/sdr/SWIA201438819.md): Connector · loose · Jul 18, 2014 · N781CA · Cndair CL6002B19 · Landing Gear System Wiring
  > NOSE DOOR NOT OPERATING PROPERLY, DID NOT OPEN WITH HYDRAULIC 3A ON. DID OPEN WHEN HYDRAULIC 3A WAS OFF AND PRESSURE DECREASED IN SYSTEM 3. SECURED LOOSE CONNECTOR ON NLG DOOR SELECTOR VALVE. OPS CHECK OF NLG GEAR DOORS GOOD AT THIS TIME IAW AMM.
- [SDR SWIA2014062338269](https://openairdocs.org/sdr/SWIA2014062338269.md): Skin · damaged · Jun 13, 2014 · N781CA · Cndair CL6002B19 · Passenger/Crew Doors
  > PAX DOOR LOWER INNER SKIN DAMAGED. REPAIRED PAX DOOR INNER SKIN IAW EA.
- [SDR SWIA2014062338270](https://openairdocs.org/sdr/SWIA2014062338270.md): Hinge · gouged · Jun 12, 2014 · N781CA · Cndair CL6002B19 · Fuselage, Door Hinge
  > PAX DOOR HINGE, ACFT SIDE, AFT LUG LAND IS GOUGED. REPAIRED PAX DOOR HINGE IAW EA.

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

This list as a web page: https://openairdocs.org/deregistered/N781CA-2023-07-30/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.