# Service difficulty reports: N239NN

A list on [N239NN](https://openairdocs.org/aircraft/N239NN.md).

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

- [SDR SIMA20250505004](https://openairdocs.org/sdr/SIMA20250505004.md): Floorbeam · corroded · May 5, 2025 · N239NN · Emb ERJ170200LR · Fuselage Main, Floor Beam
  > CROSSBEAM AT FR 17 CORRODED JUST INBD OF CENTER FLOOR BEAM UNDER FLOORBOARD 225ALF. (LEVEL 2 CORROSION) (MAJOR REPAIR) PERMANENTLY REPAIRED IAW ERS-EJ-53MR-4564 PTB.
- [SDR SIMA20250422010](https://openairdocs.org/sdr/SIMA20250422010.md): Shear Tie · corroded · Apr 22, 2025 · N239NN · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 75 BETWEEN STR 28L AND 28R IS CORRODED. (LEVEL 2 CORROSION) COMPLETE: REMOVED AND REPLACE SHEAR CLIP IAW SRM 51-40-08
- [SDR SIMA20250422011](https://openairdocs.org/sdr/SIMA20250422011.md): Shear Tie · corroded · Apr 22, 2025 · N239NN · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 76 BETWEEN STR 28L AND 28R IS CORRODED. (LEVEL 2 CORROSION) COMPLETE: EVALUATED AND REPAIRED IAW SRM 51-75-16
- [SDR SIMA20250422003](https://openairdocs.org/sdr/SIMA20250422003.md): Shear Tie · corroded · Apr 22, 2025 · N239NN · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 83 BETWEEN STGRS 27R AND 28R IS CORRODED. (LEVEL 2 CORROSION) COMPLETE: RAR SHEAR CLIP IAW EMB-175 SRM CH. 51-40-08.
- [SDR SIMA20250422009](https://openairdocs.org/sdr/SIMA20250422009.md): Shear Tie · corroded · Apr 22, 2025 · N239NN · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 81 BETWEEN STRS 27R AND 28R IS CORRODED. (LEVEL 2 CORROSION) COMPLETE: REMOVED AND REPLACED SHEAR CLIP IAW SRM 51-40-08
- [SDR SIMA20250422002](https://openairdocs.org/sdr/SIMA20250422002.md): Shear Tie · corroded · Apr 22, 2025 · N239NN · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 82 BETWEEN STGRS 27R AND 28R IS CORRODED. (LEVEL 2 CORROSION) COMPLETE: INSTALLED NEW SHEAR CLIP IAW EMB-175 SRM CH. 51-40-08.
- [SDR SIMA20250422004](https://openairdocs.org/sdr/SIMA20250422004.md): Shear Tie · corroded · Apr 22, 2025 · N239NN · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 76 BETWEEN STR 27R AND 28R IS CORRODED. (LEVEL 2 CORROSION) COMPLETE: REMOVED AND REPLACED CLIP IAW SRM 51-40-08
- [SDR SIMA20250422008](https://openairdocs.org/sdr/SIMA20250422008.md): Shear Tie · corroded · Apr 22, 2025 · N239NN · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 81 BETWEEN STRS 26R AND 27R IS CORRODED. (LEVEL 2 CORROSION) COMPLETE: REMOVED AND REPLACED SHEAR CLIP IAW SRM 51-40-08
- [SDR SIMA20250422005](https://openairdocs.org/sdr/SIMA20250422005.md): Shear Tie · corroded · Apr 22, 2025 · N239NN · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 83 BETWEEN STR 26R AND 27R IS CORRODED. (LEVEL 2 CORROSION) COMPLETE: RAR SHEAR CLIP IAW EMB-175 SRM CH. 51-40-08.
- [SDR SIMA20250422006](https://openairdocs.org/sdr/SIMA20250422006.md): Shear Tie · corroded · Apr 22, 2025 · N239NN · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 86 BETWEEN STRS 27R AND 28R IS CORRODED. (LEVEL 2 CORROSION) COMPLETE: INSTALLED SHEAR CLIP IAW ERS-EJ-5300-5188-R2 AND SRM 51-40-08
- [SDR SIMA20250422007](https://openairdocs.org/sdr/SIMA20250422007.md): Shear Tie · corroded · Apr 22, 2025 · N239NN · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 87 BETWEEN STR 26R AND 27R IS CORRODED. (LEVEL 2 CORROSION) COMPLETE: RAR SHEAR CLIP IAW EMB-175 SRM CH. 51-40-08.
- [SDR SIMA20250422012](https://openairdocs.org/sdr/SIMA20250422012.md): Shear Tie · corroded · Apr 22, 2025 · N239NN · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 86 BETWEEN STR 26R AND 27R IS CORRODED. (LEVEL 2 CORROSION) COMPLETE: RAR SHEAR CLIP IAW EMB-175 SRM CH. 51-40-08.
- [SDR SIMA20250422001](https://openairdocs.org/sdr/SIMA20250422001.md): Light · faded · Apr 22, 2025 · N239NN · Emb ERJ170200LR · Emergency Lighting
  > LH #1 EMERGENCY PHOTOLUMINESCENT STRIP HAS FADED ELEMENT. COMPLETE: REPLACED LH #1 EMERGENCY PHOTOLUMINESCENT STRIP IAW AMM 33-50-21.
- [SDR SIMA20241028001](https://openairdocs.org/sdr/SIMA20241028001.md): Light · inoperative · Oct 28, 2024 · N239NN · Emb ERJ170200LR · Emergency Lighting
  > FOUND FWD RH EMERGENCY PHOTOLUMINESCENT STRIP INDICATOR INOP. RAR FWD RH EMERGENCY PHOTOLUMINESCENT STRP INDICATOR NEXT TO CLOSET IAW AMM-33-50-21
- [SDR SIMA20230919002](https://openairdocs.org/sdr/SIMA20230919002.md): Battery · inoperative · Sep 19, 2023 · N239NN · Emb ERJ170200LR · Emergency Lighting
  > FOUND MAIN PASSENGER DOOR EMERGENCY LIGHT INOP-C/A-T/S IAW FIM TASK 33-50-00-810-816. RAR ELPU 2 IAW ERJ AMM 33-50-01. OPC GOOD.
- [SDR SIMA20230102001](https://openairdocs.org/sdr/SIMA20230102001.md): Warning Message · false activation · Jan 2, 2023 · N239NN · Emb ERJ170200LR · Drag Control System
  > SPOILER FAULT SHORT FINAL DESCENT. FLT DECLARED EMERGENCY, FLT LANDED MTX INSP. FAULT CODE 27030319FCS FCP SWITCH FAULT. PERFORMED FIM TASK 27-00-00-810-802-A00 DETERMINED TO BE TRANSIENT FAULT AND PERFORMED SPOILER OPS TEST IAW AMM CH 27-60-00.
- [SDR SIMA20221229002](https://openairdocs.org/sdr/SIMA20221229002.md): Engine · vibration · Dec 29, 2022 · N239NN · Emb ERJ170200LR · Engine Vibration Analyzer
  > ENGINE 2 LP VIBE AMBER ABIVE 4.0 AT FLIGHT IDLE. DECLARED EMERGENCY. PER AMM 05-50-27 SINK RATES WAS LESS THAN 360 FPM. NO INSPECTION ARE NECESSARY.
- [SDR SIMA20221205001](https://openairdocs.org/sdr/SIMA20221205001.md): I/O Module · faulted · Dec 5, 2022 · N239NN · Emb ERJ170200LR · Engine Bleed Air System Wiring
  > BLEED 1 FAIL DURING CLIMB THRU 17000 LOSS BLEED 1 AND 2 DECLARED EMERGENCY. C/W FIM 36-10-00-810-018-A FOUND TO BE TRANSITORY CONDITION OF GENERIC I/O MODULE 1 OK FOR SERVICE
- [SDR SIMA20221008001](https://openairdocs.org/sdr/SIMA20221008001.md): None · damaged · Oct 8, 2022 · N239NN · Emb EMB110* · Integrated Flight System
  > DECLARED AN EMERGNECY DUE TO AN STANDBY ATTITUDE INDICATION PROBLEM-C/A-RAR IES IAW ERJ-175 AMM 34-11-01.OPS CHECK GOOD.T/S PER FIM 34-11-00, FOUND TO BE TRANSITORY CONDITION OF EISS. AC OKAY FOR SERVICE.
- [SDR SIMA20220624001](https://openairdocs.org/sdr/SIMA20220624001.md): Floor Splice · corroded · Jun 24, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-23-005 AFT GALLEY RH CENTER FLOOR SPLICE CORRODED AT FR 90.(LEVEL 2 CORROSION)-C/A-RAR AFT GALLEY RH CENTER FLOOR SPLICE AT FR 90 IAW ERB 175 SRM 51-40-08.
- [SDR SIMA20220623002](https://openairdocs.org/sdr/SIMA20220623002.md): Track · corroded · Jun 23, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-23-005 CENTER SEAT TRACK GOUGED WITH POSSIBLE CORROSION AT FR 80. (LEVEL 2 CORROSION)-C/A-PERFORMED SPLICE DEVICE PERMANENT REPAIR ON CENTER SEAT TRACK GOUGE WITH CORROSION AT FR 80 IAW EMB 175 SRM 53-00-10 REPAIR 02P, SRM 51-23-02 AND SRM 51-23-06.
- [SDR SIMA20220623001](https://openairdocs.org/sdr/SIMA20220623001.md): Seat Track · corroded · Jun 23, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-23-005 RH CENTER SEAT TRACK GOUGED WITH POSSIBLE CORROSION AT FR 83 - FR 84. (MAJOR REPAIR) (LEVEL 2 CORROSION)-C/A-RAR RH CENTER SEAT TRACK BETWEEN FR 73 ? FR 85 IAW ERJ 175 SRM 51-40-08.
- [SDR SIMA20220622014](https://openairdocs.org/sdr/SIMA20220622014.md): Seat Track · corroded · Jun 22, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-22-012 CENTER SEAT TRACK GOUGED WITH POSSIBLE CORROSION AT FR 52. (LEVEL 2 CORROSION)-C/A-PERFORMED SPLICE DEVICE PERMANENT REPAIR TO CENTER SEAT TRACK GOUGE WITH CORROSION AT FR 52 IAW EMB 175 SRM 51-10-03, SRM 53-00-10, SRM 53-22-10 AD 01 AND SRM 53-0
- [SDR SIMA20220622013](https://openairdocs.org/sdr/SIMA20220622013.md): Track · corroded · Jun 22, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-21-005 RH CABIN FLOOR BEAM SEAT TRACK CORRODED BETWEEN FR 25 ? FR 26. (MAJOR REPAIR) (LEVEL 2 CORROSION)-C/A-ACCOMPLISHED SPLICE DEVICE PERMANENT REPAIR TO RH CABIN FLOOR SEAT TRACK BEAM AT FR 25 AND FR 26 IAW ERS-EJ-53MR-4572
- [SDR SIMA20220622012](https://openairdocs.org/sdr/SIMA20220622012.md): Track · corroded · Jun 22, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-22-012 RH CENTER SEAT TRACK GOUGED WITH POSSIBLE CORROSION BETWEEN FR 45 ? FR 46. (MAJOR REPAIR) (LEVEL 2 CORROSION) -C/A-ACCOMPLISHED PERMANENT REPAIR TO RH CENTER SEAT TRACK GOUGE WITH CORROSION BETWEEN FR 45 AND FR 46 IAW ERS-EJ-53MR-4571 AND ERJ 175
- [SDR SIMA20220622011](https://openairdocs.org/sdr/SIMA20220622011.md): Nut Plate · corroded · Jun 22, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > AFT GALLEY RH FLOORBOARD NUTPLATE SUPPORT CORRODED AT FR 87. -C/A-RAR AFT GALLEY RH FLOORBOARD NUTPLATE SUPPORT AT FR 87 IAW EMB 175 SRM 51-40-08
- [SDR SIMA20220622010](https://openairdocs.org/sdr/SIMA20220622010.md): Floorbeam · corroded · Jun 22, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-23-005 AFT GALLEY RH LOWER BEAM CORRODED AT FR 87. (LEVEL 2 CORROSION)-C/A-RAR AFT GALLEY RH LOWER BEAM AT FR 87 IAW EMB 175 SRM 51-40-08 AND SRM 51-43-03.
- [SDR SIMA20220622009](https://openairdocs.org/sdr/SIMA20220622009.md): Skin Panel · corroded · Jun 22, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-23-005 AFT GALLEY RH FLOOR SLICE CORRODED AT FR 90. (LEVEL 2 CORROSION)-C/A-RAR RH AFT GALLEY FLOOR SPLICE AT FR 90 IAW EMB 175 SRM 51-40-08.
- [SDR SIMA20220622007](https://openairdocs.org/sdr/SIMA20220622007.md): Shear Panel · corroded · Jun 22, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-23-005 AFT GALLEY CENTER SHEAR PANEL BETWEEN FR 87 AND FR 88 CORRODED IN NUMEROUS AREAS. (LEVEL 2 CORROSION)-C/A-RAR AFT GALLEY CENTER SHEAR PANEL BETWEEN FR 87 AND FR 88 IAW EMB 175 SRM 51-40-08.
- [SDR SIMA20220622008](https://openairdocs.org/sdr/SIMA20220622008.md): Shear Panel · corroded · Jun 22, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-23-005 AFT GALLEY RH SHEAR PANEL BETWEEN FR 87 AND FR 88 CORRODED IN NUMEROUS AREAS. (LEVEL 2 CORROSION)-C/A-RAR AFT GALLEY RH SHEAR PANEL BETWEEN FR 87 AND FR 88 IAW EMB 175 SRM 51-40-08.
- [SDR SIMA20220622006](https://openairdocs.org/sdr/SIMA20220622006.md): Floor Support · corroded · Jun 22, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-23-005 AFT GALLEY RH FLOOR SUPPORT CORRODED AT FR 89. (LEVEL 2 CORROSION)-C/A-RAR AFT GALLEY RH FLOOR SUPPORT AT FR 89 IAW ERJ 175 SRM 51-40-08.
- [SDR SIMA20220622005](https://openairdocs.org/sdr/SIMA20220622005.md): Intercostal · corroded · Jun 22, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-23-005 AFT GALLEY RH LOWER INTERCOSTAL BEAM CORRODED BETWEEN FR 89 AND FR 90.(LEVEL 2 CORROSION)-C/A-RAR AFT GALLEY RH LOWER INTERCOSTAL BEAM BETWEEN FR 89 AND FR 90 IAW EMB 175 SRM 51-40-08 AND SRM 51-43-03.
- [SDR SIMA20220622004](https://openairdocs.org/sdr/SIMA20220622004.md): Intercostal · corroded · Jun 22, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-23-005 AFT GALLEY CENTER INTERCOSTAL BEAM CORRODED BETWEEN FR 90 AND FR 91. -C/A-RAR AFT GALLEY CENTER INTERCOSTAL BEAM BETWEEN FR 90 AND FR 91 IAW EMB 175 SRM 51-40-08.
- [SDR SIMA20220621003](https://openairdocs.org/sdr/SIMA20220621003.md): Floor Splice · corroded · Jun 21, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-10-027 RH GALLEY FLOOR SILL BETWEEN FR 12 AND FR 14 CORRODED IN MULTIPLE AREAS. (LEVEL 2 CORROSION)-C/A-RAR RH GALLEY FLOOR SILL BETWEEN FR 12 AND FR 14 IAW EMB 175 SRM 51-40-08.
- [SDR SIMA20220621002](https://openairdocs.org/sdr/SIMA20220621002.md): Floorbeam · corroded · Jun 21, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > SSI 53-10-027 RH FLOOR BEAM CORRODED BETWEEN FR 13-14 (MAJOR REPAIR) (LEVEL 2 CORROSION) -C/A-ACCOMPLISHED A PERMANENT REPAIR ON RH FLOOR BEAM BETWEEN FR 13-14 IAW ERS-EJ-53MR-4566.
- [SDR SIMA20220612004](https://openairdocs.org/sdr/SIMA20220612004.md): Light · damaged · Jun 12, 2022 · N239NN · Emb ERJ170200LR · Emergency Lighting
  > #2 RH EMERGENCY PHOTOLUMINESCENT INDICATOR STRIP LIGHT DAMAGED-C/A-COMPLETE:RAR #2 RH EMERGENCY PHOTOLUMINESCENT INDICATOR STRIP LIGHT IAW EMB 175 AMM 33-50-21
- [SDR SIMA20220612003](https://openairdocs.org/sdr/SIMA20220612003.md): Crossbeam · corroded · Jun 12, 2022 · N239NN · Emb ERJ170200LR · Fuselage Main, Structure
  > TRANSFERED FROM NRTC E923456, CROSSBEAM AT FR 17 CORRODED JUST INBD OF CENTER FLOOR BEAM UNDER FLOORBOARD 225ALF (MAJOR REPAIR) (LEVEL 2 CORROSION)-C/A- ERS-EJ-53MR-4564 PART B - PERMANENT REPAIR OF CROSSBEAM AT FR17 JUST INBD OF CENTER FLOOR BEAM DEFERED PER
- [SDR SIMA20220506004](https://openairdocs.org/sdr/SIMA20220506004.md): Spar · cracked · May 6, 2022 · N239NN · Emb ERJ170200LR · Wing, Plate/Skin
  > LH WING TIP IS CRACKED AT SPAR 1 BETWEEN MOUNTING BOLTS.-C/A-INSTALLED NEW SERVICEABLE LH WING TIP IAW AMM 57-30-00-400-801-A.
- [SDR SIMA20220506003](https://openairdocs.org/sdr/SIMA20220506003.md): Spar · cracked · May 6, 2022 · N239NN · Emb ERJ170200LR · Wing, Plate/Skin
  > RH WING TIP IS CRACKED AT SPAR 1 BETWEEN MOUNTING BOLTS.-C/A-INSTALLED NEW SERVICEABLE RH WING TIP IAW AMM 57-30-00-400-801-A.
- [SDR SIMA20210913001](https://openairdocs.org/sdr/SIMA20210913001.md): Transducer · faulted · Sep 13, 2021 · N239NN · Emb ERJ170200LR · Landing Gear Brake System
  > PARKING BRAKE NOT RELEASED CAUTION ON DESCENT. EMRG PARKING BRAKE STARTED FLICKERING. EMERGENCY DECLARED. -C/A-PERFORMED E175 FIM TASK 32-41-00-810-839-A AND FOUND FAULTY LH EMERGENCY/PARKING BRAKE ACCUMULATOR PRESSURE TRANSDUCER 1DEFERRED LH EMERGENCY/PARKING
- [SDR SIMA20210818002](https://openairdocs.org/sdr/SIMA20210818002.md): Heat Exchanger · dirty · Aug 18, 2021 · N239NN · Emb ERJ170200LR · Cabin Cooling System
  > REF MEL 21-44 AUTH# 080418D-C LGPG 4760551 ITEM 1. COFFEE SMELL FROM PACK #2 FOUND.-C/A-COFFEE SMELL FROM PACK #2 FOUND. PERFORMED HEAT EXCHANGER CLEANING IAW EO EJ-2100-006. OPC GOOD. NO FUTHER DEFECTS NOTED. MEL RESTORED.
- [SDR SIMA20190916002](https://openairdocs.org/sdr/SIMA20190916002.md): Unknown · odor · Sep 16, 2019 · N239NN · Emb ERJ170200LR · Air Distribution System
  > SMELL OF BURNT WIRE IN FORWARD LAV. CIRCUIT BREAKERS POP IN FORWARD GALLEY "TRANSFERRED TO NRWC 039-DFW-01158". C/A-PERFORMED A/C PWR UP, RESET ALL 3 GALLEY BREAKERS. PERFORMED LIGHT CHECKS IN GALLEY AND LAV REF AMM 33-21-00. PERFORMED GALLEY LIGHT INSP REF AM
- [SDR SIMA201904021004](https://openairdocs.org/sdr/SIMA201904021004.md): Heat Exchanger · dirty · Apr 1, 2019 · N239NN · Emb ERJ170200LR · Cabin Cooling System
  > LIGHT BURN SMELL AFTER TAKE OFF, MADE FA2 EYES WATERING AND DISSIPATED QUICKLY. SMELL CAME BACK ON GROUND AFTER WE STARTED THE APU.-C/A-DEFFERED PACK 2 DUE TO COKED ACM PER MEL 21-44 AUTH# 040005D-C. FOUND PACK 2 HEAT EXCHANGER COKED WITH COFFEE/SODA PERFORMED
- [SDR SIMA201810087004](https://openairdocs.org/sdr/SIMA201810087004.md): Light · inoperative · Oct 7, 2018 · N239NN · Emb ERJ170200LR · Emergency Lighting
  > FLOOR ILLUMINATION STRIP INOP 1A-C/A-REMOVED AND REPLACED FLOOR ILLUMINATION STRIP AT SEAT 1A IAW AMM 33-50-21.
- [SDR SIMA20180703003](https://openairdocs.org/sdr/SIMA20180703003.md): Relay · failed · Jul 2, 2018 · N239NN · Emb ERJ170200LR · Pneumatic Distribution System
  > BLEED 1 OVERPRESSURE ON TAKEOFF. RAN BLEED 1 OVERPRESS CHECKLIST AND BLEED 1 OVERPRESS CAUTION REMAIN ANNUNCIATED. RETURNED FOR LANDING BELOW MAX LANDING WEIGHT. REMOVED AND REPLACED LT BLEED OVERPRESSURE AUX RELAY IAW SWPM 20-32-01.
- [SDR SIMA20170516001](https://openairdocs.org/sdr/SIMA20170516001.md): Pin · unknown · May 16, 2017 · N239NN · Emb ERJ170200LR · Engine (Turbine/Turboprop)
  > 15000 FEET, 89 PERCENT N1, 4.0 VIBRATION NORMAL AT CRUISE, NR 1 ENGINE BELOW LANDING WT74300 MAX LANDING. REMOVED AND REPLACED FAN BLADE RETAINING PINS IAW ESM 72-00-00 SPECIAL PROCEDURES 096.

## 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 = 'N239NN' AND registry_match = 'registration'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/aircraft/N239NN/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.
