# Service difficulty reports: N857AS, cancelled Mar 2, 2023 A list on [N857AS, cancelled Mar 2, 2023](https://openairdocs.org/deregistered/N857AS-2023-03-02.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 5 · 237 reports - [SDR SWIA2019091246295](https://openairdocs.org/sdr/SWIA2019091246295.md): Unknown · malfunctioned · Sep 11, 2019 · N857AS · Cndair CL6002B19 · Landing Gear Retraction/Extension System > RECEIVED GEAR DISAGREE DURING GEAR EXTENSION, THEN FELT A LOUD CLUNK AS GEAR FINALLY ALL LOCKED. RIGHT MAIN GEAR LOCKED FIRST, LEFT MAIN REMAINED INDICATING UP FOR LONGER THAN USUAL. NOSE EXTENSION NORMAL. MESSAGE CLEARED BEFORE WE COULD PERFORM QRH. (FLT#5583 - [SDR ASOA201901145020](https://openairdocs.org/sdr/ASOA201901145020.md): Skin · damaged · Jan 14, 2019 · N857AS · Cndair CL6002B19 · Fuselage Main, Plate/Skin > REF: CO# 7411918 JOB# 7741191 OP# 128: UPON REMOVAL OF PAX DOOR (FUSE SIDE) HINGE FOUND SEVERAL FASTENER HOLES COMMON TO FUSELAGE SKIN TO BE ELONGATED.C/A: REPAIRED DAMAGE IAW REO 601R-53-21-3059 REV.--, DATED 2019-01-12 AND EC/TC REO 601R-53-21-3059 REV.0, DA - [SDR ASOA201901145019](https://openairdocs.org/sdr/ASOA201901145019.md): Hinge · gouged · Jan 14, 2019 · N857AS · Cndair CL6002B19 · Fuselage, Door Hinge > REF: CO# 7411918 JOB# 7741191 OP# 73: PAX DOOR HINGE (FUSE SIDE) HAS A GOUGED LUG FROM ONTACT WITH HINGE PIN, ROLL PIN. C/A: REPAIRED DAMAGE IAW REO 601R-53-21-656 REV.A, DATED 2017-03-06 AND EC/TC REO 601R-53-21-656 REV.0, DATED 2019-01-14. - [SDR ASOA201901125018](https://openairdocs.org/sdr/ASOA201901125018.md): Skin · dented · Jan 12, 2019 · N857AS · Cndair CL6002B19 · Fuselage Main, Plate/Skin > REF: CO# 7411918 JOB# 7741191 OP# 80: 1 DENT EXTERNAL SKIN FS 605-621 STRGRS 23L-22L.C/A: REPAIRED SKIN BY DRESSING BACK AREA MARKED WITH DEFECT#899269 IAW EC/TC EA 48-2018-100 REVA, 1/8/2019. - [SDR ASOA201901075008](https://openairdocs.org/sdr/ASOA201901075008.md): Frame · corroded · Jan 7, 2019 · N857AS · Cndair CL6002B19 · Fuselage Main, Frame > REF: CO# 7411918 JOB# 7741198 OP# 5: FRAME 319.00 IS CORRODED BETWEEN STRINGER 27 AND 25R. C/A:REPAIRED DAMAGE IAW ENGINEERING EA# 43-2018-168 REV.--, DATED 12/31/2018 AND EC/TC EA 43-2018-168 REV.0, DATED 2019/01/03. - [SDR ASOA201901075007](https://openairdocs.org/sdr/ASOA201901075007.md): Skin · dented · Jan 7, 2019 · N857AS · Cndair CL6002B19 · Passenger/Crew Doors > REF: CO# 7411918 JOB# 7741191 OP# 59: PAX DOOR EXTERIOR SKIN HAS A DENT BETWEEN FS 320.10 AND FS 329.50, 23" FROM LOWER EDGE OF DOOR, 12" AFT OF FORWARD EDGE OF DOOR. (DOOR IN OPEN POSITION) C/A: REPAIRED DAMAGE IAW ENGINEERING EA# 48-2018-098 REV.--, DATED 01 - [SDR ASOA201901075006](https://openairdocs.org/sdr/ASOA201901075006.md): Buttstrap · corroded · Jan 7, 2019 · N857AS · Cndair CL6002B19 · Fuselage Miscellaneous Structure > REF: CO# 7411918 JOB# 7741198 OP# 14: CORROSION ON BUTT STRAP AT FS 333.00 AND BETWEEN STR 26L AND STR 27. C/A:REPAIRED DAMAGE IAW ENGINEERING EA# 30-2018-350 REV.--, DATED 12/31/2018 AND EC/TC EA 30-2018-350 REV.0, DATED 2019-01-02. - [SDR ASOA201901075005](https://openairdocs.org/sdr/ASOA201901075005.md): Skin · dented · Jan 7, 2019 · N857AS · Cndair CL6002B19 · Fuselage Main, Plate/Skin > REF: CO# 7411918 JOB# 7741191 OP# 44: (1EA) DENT BETWEEN F.S. 589 AND F.S. 605, BETWEEN STR 24R AND STR 25R. C/A: REPAIRED DAMAGE IAW EA# 30-2018-342 REV.--, DATED 12/31/2018 AND EC/TC EA 30-2018-342 REV.0, DATED 2019-01-02 - [SDR ASOA201901075004](https://openairdocs.org/sdr/ASOA201901075004.md): Strap · corroded · Jan 7, 2019 · N857AS · Cndair CL6002B19 · Fuselage Main, Plate/Skin > REF: CO# 7411918 JOB# 7741198 OP# 6: SKIN JOINT STRAP AT F.S. 333.00 BETWEEN STR 25R AND STR 26R IS CORRODED. C/A:REPAIRED DAMAGE IAW EA# 32-2018-271 REV.--, DATED 12/20/2018 AND EC/TC EA 32-2018-271 REV.0, DATED 2018-12-24. - [SDR SWIA2018022144314](https://openairdocs.org/sdr/SWIA2018022144314.md): Skin · dented · Feb 3, 2018 · N857AS · Cndair CL6002B19 · Fuselage Main, Plate/Skin > FUSELAGE SKIN HAS A DENT JUST FWD OF BS 250 BETWEEN STRINGERS 23 AND 24L. REPAIRED IAW REO. - [SDR SWIA2018022144313](https://openairdocs.org/sdr/SWIA2018022144313.md): Skin · damaged · Jan 28, 2018 · N857AS · Cndair CL6002B19 · Landing Gear Doors > AFT NLG DOOR HAS A LARGE CREASE RUNNING ACROSS ENTIRE LENGTH OF OUTER SKIN. REPAIRED THE NLG DOOR IAW SRM. - [SDR SWIA2018022144326](https://openairdocs.org/sdr/SWIA2018022144326.md): Bulkhead · cracked · Jan 11, 2018 · N857AS · Cndair CL6002B19 · Fuselage Main, Bulkhead > REAR PRESSURE BULKHEAD WEB CRACKED. REPAIRED IAW REO. - [SDR SWIA2018022144322](https://openairdocs.org/sdr/SWIA2018022144322.md): Floor Support · corroded · Jan 9, 2018 · N857AS · Cndair CL6002B19 · Fuselage Miscellaneous Structure > RIGHT FLOOR SUPPORT CORRODED, RBL 9, BS 439 TO 499. REPAIRED IAW REO. - [SDR SWIA2018022144319](https://openairdocs.org/sdr/SWIA2018022144319.md): Floor Support · corroded · Jan 9, 2018 · N857AS · Cndair CL6002B19 · Fuselage Miscellaneous Structure > FLOOR SUPPORT IS CORRODED, LBL 9, BS 461 TO 473.15. REPAIRED THE FLOOR SUPPORT IAW REO. - [SDR SWIA2018022144316](https://openairdocs.org/sdr/SWIA2018022144316.md): Frame · corroded · Jan 8, 2018 · N857AS · Cndair CL6002B19 · Fuselage Main, Frame > BS 349 FRAME FWD SIDE IS CORRODED BETWEEN STRINGERS 26 AND 27L. BLENDED IAW SRM. - [SDR SWIA2018022144325](https://openairdocs.org/sdr/SWIA2018022144325.md): Skin · dented · Jan 5, 2018 · N857AS · Cndair CL6002B19 · Fuselage Main, Plate/Skin > FUSELAGE SKIN DENTED BETWEEN BS 654.5 AND 672.2, STRINGERS 20L AND 21L. REPAIRED IAW REO. - [SDR SWIA2018022144323](https://openairdocs.org/sdr/SWIA2018022144323.md): Skin · dented · Jan 5, 2018 · N857AS · Cndair CL6002B19 · Fuselage Main, Plate/Skin > FUSELAGE SKIN HAD ONE PROTRUDING DENT BETWEEN BS 682 AND 700, STRINGER 23L AND 22L. REPAIRED IAW REO. - [SDR SWIA2018022144317](https://openairdocs.org/sdr/SWIA2018022144317.md): Skin · dented · Jan 5, 2018 · N857AS · Cndair CL6002B19 · Fuselage Main, Plate/Skin > FUSELAGE SKIN HAS TWO DENTS BETWEEN BS 605 AND 621, STRINGERS 19L AND 20L. REPAIRED THE SKIN IAW REO. - [SDR SWIA201844327](https://openairdocs.org/sdr/SWIA201844327.md): Skin · chafed · Jan 4, 2018 · N857AS · Cndair CL6002B19 · Fuselage Main, Plate/Skin > FUSELAGE SKIN AT BS 310 IS CHAFED AT STRINGER 16L. REPAIRED IAW REO. - [SDR SWIA201844324](https://openairdocs.org/sdr/SWIA201844324.md): Floor Support · corroded · Jan 4, 2018 · N857AS · Cndair CL6002B19 · Fuselage Miscellaneous Structure > FLOOR SUPPORT CORRODED. REMOVED AND REPLACED THE FLOOR SUPPORT, BS 409+5 TO 409+118 IAW REO. - [SDR SWIA2018022144321](https://openairdocs.org/sdr/SWIA2018022144321.md): Skin · dented · Jan 4, 2018 · N857AS · Cndair CL6002B19 · Trailing Edge Flaps > RIGHT FLAP LOWER SKIN DENTED. REPAIRED IAW REO. - [SDR SWIA2018022144320](https://openairdocs.org/sdr/SWIA2018022144320.md): Skin · dented · Jan 4, 2018 · N857AS · Cndair CL6002B19 · Trailing Edge Flaps > RIGHT FLAP LOWER SKIN DENTED. REPAIRED IAW SRM. - [SDR SWIA201844318](https://openairdocs.org/sdr/SWIA201844318.md): Flap · damaged · Jan 4, 2018 · N857AS · Cndair CL6002B19 · Trailing Edge Flaps > DAMAGE ON THE LT OTBD FLAP AT. REPAIR IAW REO. - [SDR SWIA201844315](https://openairdocs.org/sdr/SWIA201844315.md): Skin · chafed · Jan 4, 2018 · N857AS · Cndair CL6002B19 · Fuselage Main, Plate/Skin > FUSELAGE SKIN, PREVIOUS REPAIR AT BS 349 IS CHAFED AT STRINGER 16L. REPAIRED THE SKIN IAW REO. - [SDR ASOA2016080115152](https://openairdocs.org/sdr/ASOA2016080115152.md): Skin · burned · Jul 28, 2016 · N857AS · Cndair CL6002B19 · Electrical/Electronic Compartment Doors > MULTIPLE BURN MARKS ON AFT EQUIPMENT BAY DOOR AT FWD EDGE LT SIDE. FOUND TO BE OUT OF LIMITS IAW EC/TC REO 601R-53-00-115 REV H. COMPLIED WITH DISPOSITION EA 25-2016-199, SECTION 1 PERMANENT REPAIR, ITEMS 5-9. - [SDR ASOA2016080115151](https://openairdocs.org/sdr/ASOA2016080115151.md): Skin · burned · Jul 28, 2016 · N857AS · Cndair CL6002B19 · Fuselage Main, Plate/Skin > ONE BURN BETWEEN BS 333 AND 349 BETWEEN STRINGERS 25 - 26L. DRILLED THROUGH SKIN BAY TO REMOVE LIGHTNING BURN IAW EC/TC REO 601R-53-00-115 REV H. FABRICATED INTERNAL REPAIR WASHER. CONTROLLED COUNTERSINK AND INSTALLED NAS1097AD5 SOLID RIVET AND RESTORED FIN - [SDR ASOA2016040114682](https://openairdocs.org/sdr/ASOA2016040114682.md): Wire · broken · Apr 1, 2016 · N857AS · Cndair CL6002B19 · Light System Wiring > FLOOD LIGHT ON AFT SIDE OF WARDROBE INOPERATIVE, VARIOUS EMERGENCY EXIT LIGHTS ARE INOPERATIVE, AND VARIOUS CEILING PANELS ARE INOPERATIVE. REPAIRED BROKEN WIRE SPLICE CONNECTORS 3 EA ON WARDROBE FLOOD LIGHT EXIT LIGHTS AND CEILING EXIT LIGHTS IAW ESPM 20-17- - [SDR ASOA2016031514663](https://openairdocs.org/sdr/ASOA2016031514663.md): Bracket · cracked · Mar 15, 2016 · N857AS · Cndair CL6002B19 · Fuselage Miscellaneous Structure > CRACKED FOUND ON BOTH INBD, OTBD BRACKET ON CABLE INTRCOSTAL AT FS 484.00 AND BETWEEN LBL 27 AND 36. R & R ANGLE ON INBD CABLE INTERCOSTAL IAW SRM 51-40-11 AND 51-42-20. RECEIVED AND COMPLIED WITH REO 601R-53-41-2011 AND ECTC REO 601R-53-41-2011. COMPLIED W - [SDR ASOA2016031514662](https://openairdocs.org/sdr/ASOA2016031514662.md): Bracket · cracked · Mar 15, 2016 · N857AS · Cndair CL6002B19 · Fuselage Miscellaneous Structure > CRACK FOUND ON OTBD BRACKET ON CABLE INTERCOSTAL AT FS 484.00 + LBL27. R & R THE BRACKET IAW SRM 51-40-11 AND 51-42-20. - [SDR ASOA2016031414681](https://openairdocs.org/sdr/ASOA2016031414681.md): Fitting · cracked · Mar 14, 2016 · N857AS · Cndair CL6002B19 · Flight Compartment Windows > LT AND RT WINDSHIELD CENTER POST LOWER FITTINGS CRACKED. R & R LT AND RT WINDSHIELD CENTER POST LOWER FITTINGS IAW SRM TASK 51-40-11 AND 51-42-21. - [SDR ASOA2016031414680](https://openairdocs.org/sdr/ASOA2016031414680.md): Frame · cracked · Mar 14, 2016 · N857AS · Cndair CL6002B19 · Fuselage Main, Frame > CRACK ON FRAME AT FS 333 BETWEEN STR 0 - STR 1R. R & R FRAME AT BS 333 BETWEEN STRINGER 5R IAW SRM 51-42-06 AND DWG 601R 32004-5. - [SDR ASOA2016031414661](https://openairdocs.org/sdr/ASOA2016031414661.md): Floor Support · corroded · Mar 14, 2016 · N857AS · Cndair CL6002B19 · Fuselage Miscellaneous Structure > CORROSION AROUND NUTPLATE HOLE ON RBL 9 BS 409+48 AND +64. REPAIRED FLOOR SUPPORT IAW SRM 53-00-43. - [SDR ASOA2016031414660](https://openairdocs.org/sdr/ASOA2016031414660.md): Floorbeam · corroded · Mar 14, 2016 · N857AS · Cndair CL6002B19 · Fuselage Main, Floor Beam > CORROSION FOUND ON FS 621 FLOORBEAM BETWEEN RBL 40-27. REMOVED CORROSION DAMAGE IAW SRM 51-21-06 ON PREVIOUS REPAIR FOUND DAMAGE TO BE OUT OF LIMITS IAW SRM 53-00-00. - [SDR ASOA2016030914659](https://openairdocs.org/sdr/ASOA2016030914659.md): Seat Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > RT SIDE SEAT TRACK AT BS 409+112 AND +128 HAS CORROSION. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-01-11-400-802. - [SDR ASOA2016030914658](https://openairdocs.org/sdr/ASOA2016030914658.md): Seat Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > RT SIDE SEAT TRACK AT BS 409+16, AND +112 HAS CORROSION. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-14-11-000-802, AMM 53-00-49-400-801, AND REO 601R-53-00-485. - [SDR ASOA2016030914657](https://openairdocs.org/sdr/ASOA2016030914657.md): Seat Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > RIGHT SIDE SEAT TRACK AT BS 364 - 409+16 HAS CORROSION. FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-01-11-04, AMM 53-01-11-400-802, AND REO 601R-53-00-055 REV B. - [SDR ASOA2016030914656](https://openairdocs.org/sdr/ASOA2016030914656.md): Seat Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > LEFT SIDE SEAT TRACK AT BS 409+112, AND +128 HAS CORROSION. FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-01-11-000-802, AMM 53-01-11-400-802, AND REO 601R-53-00-055, REV B. - [SDR ASOA2016030914655](https://openairdocs.org/sdr/ASOA2016030914655.md): Seat Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > LEFT SIDE SEAT TRACK AT BS 409+16, AND +112 HAS CORROSION. FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-01-11-000-802, AMM 53-01-11-400-802, REO 601R-53-00-055 AND REO 601R-53-00-055, REV B. - [SDR ASOA2016030914654](https://openairdocs.org/sdr/ASOA2016030914654.md): Seat Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > LT SIDE SEAT TRACK BS 364 - 409+16 HAS CORROSION. FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-01-11-000-802, AMM 53-01-11-400-802, REO 601R-53-00-055 AND REO 601R-53-00-055. REV B. - [SDR ASOA2016030914653](https://openairdocs.org/sdr/ASOA2016030914653.md): Seat Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > RT SEAT TRACK AT BS 364 - 409 HAS CORROSION RBL 9. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-01-11-000-802 AND AMM 53-00-49-400-801. - [SDR ASOA2016030914652](https://openairdocs.org/sdr/ASOA2016030914652.md): Seat Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > SEAT TRACK LBL 9 F/S 409+128 - 559+16 HAS CORROSION. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-01-11-000-802, AMM 53-01-11-400-802, AND REO 601R-53-00-485. - [SDR ASOA2016030914651](https://openairdocs.org/sdr/ASOA2016030914651.md): Seat Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > SEAT TRACK RBL 9 BS 409+128 - 559+16 FOUND CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-01-11-000-802, AND, 53-01-11-400-802, AND GREO 601R-53-00-485, REV A. - [SDR ASOA2016030914650](https://openairdocs.org/sdr/ASOA2016030914650.md): Floorbeam · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage Main, Floor Beam > CORROSION FOUND ON FLOORBEAM AROUND SCREW HOLE. BLENDED AND REMOVED CORROISON IAW SRM 51-21-06-00. BLENDED AREA IS OUT OF ALLOWABLE LIMITS IAW REO 601R-5-53-00-005. - [SDR ASOA2016030914632](https://openairdocs.org/sdr/ASOA2016030914632.md): Seat Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > LEFT SEAT TRACK AT BS 364-409, LBL 9, HAS CORROSION. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-1-11-00, AMM 53-01-11-400-802, AND REO 601R-53-00-485. - [SDR ASOA2016030914631](https://openairdocs.org/sdr/ASOA2016030914631.md): Floor Support · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage Miscellaneous Structure > CORROSION AROUND NUTPLATE HOLES ON FLOOR SUPPORT RBL9, F/S 409.80+32-409.00+48. REMOVED THE CORROSION IAW SRM 51-21-06 AND FOUND TO BE OUT OF LIMITS IAW SRM 53-00-00. REPAIRED THE FLOOR SUPPORT IAW SRM 53-00-43. - [SDR ASOA2016030914630](https://openairdocs.org/sdr/ASOA2016030914630.md): Cargo Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > CARGO TRACK CORRODED AT BS 559 - 559+96, LBL 9. REMOVED AND REPLACED THE CARGO TRACK IAW AMM 53-00-49-000-801, AMM 53-00-49-400-801, AND REO 601R-53-00-485. - [SDR ASOA2016030914629](https://openairdocs.org/sdr/ASOA2016030914629.md): Seat Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > SEAT TRACK CORRODED AT BS 559 - 559+80 LBL 9. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-01-11-000-802, AMM 53-01-11-400-802, AND REO 601R-53-00-485. - [SDR ASOA2016030914628](https://openairdocs.org/sdr/ASOA2016030914628.md): Cargo Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > CARGO TRACK CORRODED AT BS 559+69 LBL 27. REMOVED AND REPLACED THE CARGO TRACK IAW AMM 53-00-49-000-802, AMM 53-00-49-400-802, AND REO 601R-53-00-485. - [SDR ASOA2016030914627](https://openairdocs.org/sdr/ASOA2016030914627.md): Cargo Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > CARGO TRACK CORRODED AT BS 559+96-87. REMOVED AND REPLACED THE CARGO TRACK IAW AMM 53-01-11-000-802, AMM 53-00-49-400-801, AND REO 601R-53-00-485. - [SDR ASOA2016030914626](https://openairdocs.org/sdr/ASOA2016030914626.md): Seat Track · corroded · Mar 9, 2016 · N857AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings > SEAT TRACK CORRODED AT BS 559 -559+80, RBL 9. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-01-11-000-802, AMM 53-01-11-400-802, AND REO 601R-53-00-485. Next page: https://openairdocs.org/deregistered/N857AS-2023-03-02/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 = 'N857AS' AND deregistration_id = 'N857AS-2023-03-02' ORDER BY difficulty_date DESC ``` This list as a web page: https://openairdocs.org/deregistered/N857AS-2023-03-02/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.