# Service difficulty reports: N209JQ

A list on [N209JQ](https://openairdocs.org/aircraft/N209JQ.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 3 · 109 reports

- [SDR R61A2025022600117](https://openairdocs.org/sdr/R61A2025022600117.md): Seat Track · corroded · Feb 7, 2025 · N209JQ · Emb ERJ170200LR · Fuselage, Seat/Cargo Attach Fittings
  > CFIII, RH I/B SEAT TRACK BET FR74-FR84 FOUND CORRODED. CFIII, RH I/B SEAT TRACK BET FR74-FR84 REPLACED IAW SRM 51-41-08.
- [SDR R61A2025022600116](https://openairdocs.org/sdr/R61A2025022600116.md): Floor Support · corroded · Feb 7, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > CFIII, FLOOR PANEL SUPPORT AT FR87, LBL29 FOUND CORRODED. CFIII, FLOOR PANEL SUPPORT AT FR87, LBL29 WAS REPLACED IAW SRM 51-40-02 AND SRM 51-40-08.
- [SDR R61A2025022600115](https://openairdocs.org/sdr/R61A2025022600115.md): Shear Panel · corroded · Feb 7, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > CFIII, LH SHEAR PANEL, BETWEEN FR87-FR88, LBL12-LBL41 FOUND CORRODED. CORRODED SHEAR PANEL ON CFIII, LH BETWEEN FR87-FR88, LBL12-LBL41 REMOVED AND REPLACED IAW SRM 51-42-01.
- [SDR R61A2025022600114](https://openairdocs.org/sdr/R61A2025022600114.md): Plate · corroded · Feb 7, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > CFIII, GUSSET PLATE AT FR90, LBL11 FOUND CORRODED. CFIII, GUSSET PLATE AT FR90, LBL11 HAS BEEN REPLACED IAW SRM 51-41-02
- [SDR R61A2025022600113](https://openairdocs.org/sdr/R61A2025022600113.md): Plate · corroded · Feb 7, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > CFIII, GUSSET PLATE AT FR90, RBL25 FOUND CORRODED. CFIII, GUSSET PLATE AT FR90, RBL25 HAS BEEN REPLACED IAW SRM 51-41-02.
- [SDR R61A2025022600112](https://openairdocs.org/sdr/R61A2025022600112.md): Plate · corroded · Feb 7, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > CFIII, GUSSET PLATE AT FR90, RBL11 FOUND CORRODED. CFIII, GUSSET PLATE AT FR90, RBL11 HAS BEEN REPLACED IAW SRM 51-41-02
- [SDR R61A2025022600106](https://openairdocs.org/sdr/R61A2025022600106.md): Reinforcement · corroded · Feb 7, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > CFI, OXYGEN REINFORCEMENT WEB BET FR23-FR24, STR21R FOUND CORRODED. REMOVED AND REPLACED OXYGEN REINFOREMENT WEB ON CFI BETWEEN FR23-FR24, STR21R IAW EMBRAER SRM 51-41-01 AND 51-43-03.
- [SDR R61A2025022600111](https://openairdocs.org/sdr/R61A2025022600111.md): Beam · corroded · Feb 6, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Main, Structure
  > AFT PASSENGER DOOR (L2) CUTOUT, LOWER BEAM FOUND MULTIPLE SPOTS OF CORROSION. AFT PASSENGER DOOR (L2) CUTOUT, CORRODED LOWER BEAM REMOVED AND REPLACED IAW SRM 51-43-03 AND 51-43-04.
- [SDR R61A2025022600110](https://openairdocs.org/sdr/R61A2025022600110.md): Doubler · corroded · Feb 5, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > FWD FUSELAGE FR19-20 LBL10-36 FOUND TO HAVE CORRODED SHEAR PLATE. CORRODED SHEAR PLATE ON FWD FUSELAGE FR19-20 LBL10-36 REMOVED AND REPLACED IAW SRM 51-41-02 AND 51-43-02.
- [SDR R61A2025022600109](https://openairdocs.org/sdr/R61A2025022600109.md): Support · corroded · Feb 5, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > FWD FUSELAGE FR16 LBL47 FOUND CORRODED FLOOR SUPPORT FITTING. CORRODED FLOOR SUPPORT FITTING ON FWD FUSELAGE FR16 LBL47 REMOVED AND REPLACED IAW SRM 51-43-01
- [SDR R61A2025022600105](https://openairdocs.org/sdr/R61A2025022600105.md): Doubler · cracked · Feb 5, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Main, Plate/Skin
  > CORROSION FOUND ON ANTENNA INTERNAL DOUBLER AT FWD FUSELAGE FWD CARGO BETWEEN FR19-20,STR26L-27L. ANTENNA INTERNAL DOUBLER AT FUSELAGE FWD CARGO BETWEEN FR19-20, STR26L-27L, REMOVED AND REPLACED IAW SRM 51-41-02
- [SDR R61A2025022600108](https://openairdocs.org/sdr/R61A2025022600108.md): Support · corroded · Feb 4, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > CFIII, FR85-87, CORRODED LWR BEAM SUPPORT. CFIII, FR85-87, CORRODED LWR BEAM SUPPORT REMOVED AND REPLACED IAW SRM 51-41-01.
- [SDR R61A2025022600103](https://openairdocs.org/sdr/R61A2025022600103.md): Support Angle · cracked · Feb 4, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > WHEEL WELL AREA, CENTER TANK EXTERNAL LOWER SKIN L ANGLE SUPPORT FOR RIB FR52 IS CRACKED. WHEEL WELL AREA, CENTER TANK EXTERNAL LOWER SKIN L ANGLE SUPPORT FOR RIB FR52 WAS REPLACED IAW SRM 51-43-03
- [SDR R61A2025022600104](https://openairdocs.org/sdr/R61A2025022600104.md): Skin · cracked · Feb 3, 2025 · N209JQ · Emb ERJ170200LR · Leading Edge Devices
  > RH WING FIXED LEADING EDGE SKIN, SLAT #2, INBOARD TRACK CUT-OUT, UPPER SURFACE BET RIB 14 AND 15 THERE IS A CRACK. REPAIRED FLE SKIN AT RH WING, SLAT#2 INBD TRACK CUTOUT UPPER SURFACE BET RIB 14 & 15 IAW ETD2025-170-902076.
- [SDR R61A2025022600101](https://openairdocs.org/sdr/R61A2025022600101.md): Rib · cracked · Feb 3, 2025 · N209JQ · Emb ERJ170200LR · Wing, Rib/Bulkhead
  > LH GEARWELL FRAME 52 CRACKED. RIB ON FRAME 52 IN LH MLG WAS REPLACED IAW SRM 51-41-01.
- [SDR R61A2025022600102](https://openairdocs.org/sdr/R61A2025022600102.md): Support · cracked · Feb 2, 2025 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > CFI, VENT SUPPORT BET. FR31-FR32, STR24L-STR23L FOUND CRACKED (P/N:170-92988-401. CRACKED VENT SUPPORT ON CFI BET FR31-FR32, STR23L-STR24L REMOVED AND REPLACED IAW SRM 51-41-01. CRACK LENGTH:.480"
- [SDR R61A2024052300236](https://openairdocs.org/sdr/R61A2024052300236.md): Power Supply · no test · May 22, 2024 · N209JQ · Emb ERJ170200LR · Emergency Lighting
  > AFT RH EMERGENCY LIGHT BATTERY FAILED FUNCTIONAL CHECK. R&R AFT RH EMERGENCY LIGHT POWER UNIT.
- [SDR R61A2022110100679](https://openairdocs.org/sdr/R61A2022110100679.md): Shear Tie · corroded · Oct 29, 2022 · N209JQ · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 82 BTWN STR 29R - STR 28R CORRODED. R&R IAW SRM 51-41-01 AND 51-41-02.
- [SDR R61A2022110100678](https://openairdocs.org/sdr/R61A2022110100678.md): Floor Support · corroded · Oct 29, 2022 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > LH FLOOR SUPPORT BTWN FR 88 - 90 CORRODED. R&R IAW SRM 51-41-01, 51-43-01, 51-21-01 AND 51-23-05.
- [SDR R61A2022110100677](https://openairdocs.org/sdr/R61A2022110100677.md): Shear Tie · corroded · Oct 29, 2022 · N209JQ · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 87 BTWN STE 27R - 28R CORRODED. R&R IAW SRM 51-41-02 AND 51-43-03.
- [SDR R61A2022110100676](https://openairdocs.org/sdr/R61A2022110100676.md): Shear Tie · corroded · Oct 29, 2022 · N209JQ · Emb ERJ170200LR · Fuselage Internal Mounting Structure
  > SHEAR CLIP AT FR 88 BTWN STR 27R - 28R CORORODED. R&R IAW SRM 51-41-02 AND 51-43-03.
- [SDR R61A2022110100675](https://openairdocs.org/sdr/R61A2022110100675.md): Floor Support · corroded · Oct 29, 2022 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > RH FLOOR SUPPORT BTWN FR 83 - 84 CORRODED. R&R IAW SRM 51-41-02, 51-41-01 AND 51-43-02.
- [SDR R61A2022110100674](https://openairdocs.org/sdr/R61A2022110100674.md): Floor Support · corroded · Oct 29, 2022 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > LH FLOOR SUPPORT BTWN FR 83 - 84 CORRODED. R&R IAW SRM 51-41-01 AND 51-41-02.
- [SDR R61A2022110100673](https://openairdocs.org/sdr/R61A2022110100673.md): Seat Track · corroded · Oct 29, 2022 · N209JQ · Emb ERJ170200LR · Fuselage, Seat/Cargo Attach Fittings
  > RH I/B SEAT TRACK BTWN FR 12 - 20 CORRODED. R&R IAW SRM 51-41-01, 51-41-02 & 51-43-01.
- [SDR R61A2022110100672](https://openairdocs.org/sdr/R61A2022110100672.md): Shear Web · corroded · Oct 29, 2022 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > LH SHEAR WEB BTWN FR 13 - 16 CORRODED. R&R IAW SRM 51-41-02.
- [SDR R61A202211010671](https://openairdocs.org/sdr/R61A202211010671.md): Shear Web · corroded · Oct 29, 2022 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > LH SHEAR WEB BTWN FR 13 - 16 CORRODED. R&R IAW SRM 51-41-02.
- [SDR R61A2022110300683](https://openairdocs.org/sdr/R61A2022110300683.md): Skin · cracked · Oct 26, 2022 · N209JQ · Emb ERJ170200LR · Horizontal Stabilizer, Plate/Skin
  > "MAJOR REPAIR" LH H-STAB FOUND CRACK AT RIB 11 & 12 BTWN FRONT SPAR AND MID SPAR. R&R IAW 170EO-55-10-004-04_1. REF SB170-55-0014-IR.
- [SDR R61A2022110300682](https://openairdocs.org/sdr/R61A2022110300682.md): Reinforcement · corroded · Oct 26, 2022 · N209JQ · Emb ERJ170200LR · Aerodynamic Fairings
  > FWD WTF FAIRING AFT MOUNTING FRAME LWR RH REINF PAN CORRODED. R&R IAW SRM 51-41-01.
- [SDR R61A2020080500582](https://openairdocs.org/sdr/R61A2020080500582.md): Rib · cracked · Jul 19, 2020 · N209JQ · Emb ERJ170100SE · Horizontal Stabilizer, Spar/Rib
  > OUT OF SERVICE FOR HEAVY CHECK, RT HORIZONTAL STAB CRACKED AT RIB 10A BETWEEN MID AND FRONT SPAR. CRACK FOUND AND AT RIB 10A AND REPLACED ON CARD 170EO-55-10-0004.
- [SDR R61A2020080400578](https://openairdocs.org/sdr/R61A2020080400578.md): Skin · dented · Jul 17, 2020 · N209JQ · Emb ERJ170200LR · Wing, Plate/Skin
  > DURING HEAVY CHECK, RT WING FIXED LE OB NEAR RIB 41. WAS DENTED. RH WING FIXED LE NEAR RIB 41 WAS REPAIRED IAW ETD2020-170-023106.
- [SDR R61A2020080400577](https://openairdocs.org/sdr/R61A2020080400577.md): Bracket · cracked · Jul 16, 2020 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > WHILE A/C WAS IN FOR HEAVY MAINTENANCE. FOUND NLG BAY NOSE GEAR STEERING ACTUATOR MOUNTING BRACKET CRACKED. REPLACED IAW SRM 51-43-03. AIRCRAFT STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.
- [SDR R61A201812051193](https://openairdocs.org/sdr/R61A201812051193.md): Girt Bar · activated · Dec 5, 2018 · N209JQ · Emb ERJ170200LR · Escape Slide
  > UPON OPENING L1 DOOR, EMERGENCY SLIDE GIRT BAR REMAINED ATTACHED TO A/C, SLIDE OUT OF PACKING. R&R L1 EMERGENCY EVACUATION SLIDE ASSY IAW AMM 25-65-01-000-801-A, NO DEFECTS NOTED AT THIS TIME.
- [SDR R61A2018060010623](https://openairdocs.org/sdr/R61A2018060010623.md): Module · faulted · May 31, 2018 · N209JQ · Emb ERJ170200LR · Emergency Lighting
  > EMERGENCY LIGHT BATTERY FAULT. R & R DISCRETE I/O MODULE SPDA 1 SLOT 11 IAW AMM 24-61-05.
- [SDR R61A201803080298](https://openairdocs.org/sdr/R61A201803080298.md): Plate · corroded · Feb 23, 2018 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > CORROSION WAS DISCOVERED ON THE AFT CARGO DOOR CUTOUT FLOOR COVER PLATE. MAINTENANCE REMOVED AND REPLACED THE COVER PLATE IAW EO-53-18-0004.
- [SDR R61A201803080292](https://openairdocs.org/sdr/R61A201803080292.md): Fitting · corroded · Feb 20, 2018 · N209JQ · Emb ERJ170200LR · Fuselage Main, Structure
  > MAINTENANCE DISCOVERED CORROSION ON FLOOR SUPPORT FITTING AT FRAME 16 LBL 44. THE FITTING WAS REMOVED AND REPLACED IAW SRM 51-43-01.
- [SDR R61A201803080299](https://openairdocs.org/sdr/R61A201803080299.md): Floor Support · corroded · Feb 19, 2018 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > CORROSION WAS DISCOVERED ON AFT WET AREA FLOOR SUPPORT, FRAMES 85 - 88, RBL 12. MAINTENANCE REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-41-01, 51-42-01, AND 51-43-03.
- [SDR R61A201803080294](https://openairdocs.org/sdr/R61A201803080294.md): Shear Panel · corroded · Feb 19, 2018 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > WHILE AC WAS OUT OF SERVICE FOR HEAVY CHECK, LEVEL 2 CORROSION WAS DISCOVERED IN THE AFT WET AREA ON RT SHEAR PANEL. MAINTENANCE REMOVED AND REPLACED THE SHEAR PANEL IAW SRM 51-42-01. AC REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.
- [SDR R61A201803080293](https://openairdocs.org/sdr/R61A201803080293.md): Shear Panel · corroded · Feb 19, 2018 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > WHILE AC WAS OUT OF SERVICE FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND IN THE AFT WET AREA, CENTER SHEAR PANEL IN MULTIPLE AREAS. MAINTENANCE REMOVED AND REPLACED THE SHEAR PANEL IAW SRM 51-42-01. AC REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.
- [SDR R61A201802190287](https://openairdocs.org/sdr/R61A201802190287.md): Fitting · corroded · Feb 19, 2018 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, MAINTENANCE FOUND LEVEL 2 CORROSION SHEAR CLIP AT FR88 BETWEEN STRG27R JUST FWD OF WASTE BOX. THEY REMOVED AND REPLACED SHEAR CLIP IAW SRM 51-41-03. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.
- [SDR R61A201802190286](https://openairdocs.org/sdr/R61A201802190286.md): Splice · corroded · Feb 19, 2018 · N209JQ · Emb ERJ190200LR · Fuselage Miscellaneous Structure
  > WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, MAINTENANCE FOUND LEVEL 2 CORROSION AT AFT WET AREA LT OUTBD SPLICE PLATE AFT OF L2. THEY REMOVED AND REPLACED SPLICE IAW SRM 51-42-02. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.
- [SDR R61A201802190285](https://openairdocs.org/sdr/R61A201802190285.md): Doubler · corroded · Feb 19, 2018 · N209JQ · Emb ERJ170200LR · Fuselage Main, Floor Beam
  > WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, MAINTENANCE FOUND LEVEL 2 CORROSION AFT WET AREA FR 84-85 RBL12 FLOORBEAM DOUBLER. THEY REMOVED AND REPLACED DOUBLER IAW SRM 51-41-01. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.
- [SDR R61A201802190284](https://openairdocs.org/sdr/R61A201802190284.md): Gusset · corroded · Feb 19, 2018 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > WHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, MAINTENANCE FOUND LEVEL 2 CORROSION AFT WET AREA GUSSET PLATE AT FR90 RBL12. THEY REMOVED AND REPLACED GUSSET PLATE IAW SRM 51-41-02. AIRCRAFT REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.
- [SDR R61A201802190283](https://openairdocs.org/sdr/R61A201802190283.md): Gusset · corroded · Feb 19, 2018 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > WHILE A/C WAS OUT OF SERVICE FOR HVY CHECK, MAINTENANCE FOUND LEVEL 2 CORROSION AFT WET AREA GUSSET PLATE AT FR 90. THEY REMOVED AND REPLACED FLOOR GUSSET PLATE IAW SRM 51-41-02. AIRCRAFT REMAINS OUT OF SERVICE FOR HVY CHECK COMPLETION.
- [SDR R61A201802190282](https://openairdocs.org/sdr/R61A201802190282.md): Panel Support · corroded · Feb 19, 2018 · N209JQ · Emb ERJ170200LR · Fuselage Miscellaneous Structure
  > WHILE A/C WAS OUT OF SERVICE FOR HVY CHECK, MAINTENANCE FOUND LEVEL 2 CORROSION AFT WET AREA RT OB FLOOR PANEL SUPPORT AFT OF R2 DOOR FR 89. THEY REMOVED AND REPLACED FLOOR PANEL SUPPORT IAW SRM 51-42-01. AIRCRAFT REMAINS OUT OF SERVICE FOR HVY CHECK COMPLETIO
- [SDR R61A201803080300](https://openairdocs.org/sdr/R61A201803080300.md): Seat Track · corroded · Feb 18, 2018 · N209JQ · Emb ERJ170200LR · Fuselage, Seat/Cargo Attach Fittings
  > CORROSION WAS DISCOVERED ON THE RT INBD SEAT TRACK, BETWEEN FRAMES 26 AND 27. MAINTENANCE REMOVED CORROSION AND INSTALLED A REPAIR SPLICE IAW SRM 51-10-03, AND SRM 53-00-10, REPAIR 02.
- [SDR R61A201803080297](https://openairdocs.org/sdr/R61A201803080297.md): Seat Track · gouged · Feb 18, 2018 · N209JQ · Emb ERJ170200LR · Fuselage, Seat/Cargo Attach Fittings
  > MULTIPLE OUT OF LIMITS GOUGES WERE DISCOVERED ON THE RT OTBD SEAT TRACK, FRAMES 46 TO 55. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-42-01, AND 51-41-01.
- [SDR R61A201803080296](https://openairdocs.org/sdr/R61A201803080296.md): Seat Track · corroded · Feb 18, 2018 · N209JQ · Emb ERJ170200LR · Fuselage, Seat/Cargo Attach Fittings
  > CORROSION WAS DISCOVERED ON THE RT INBD SEAT TRACK. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-43-03.
- [SDR R61A201803080295](https://openairdocs.org/sdr/R61A201803080295.md): Seat Track · corroded · Feb 18, 2018 · N209JQ · Emb ERJ170200LR · Fuselage, Seat/Cargo Attach Fittings
  > CORROSION WAS DISCOVERED ON LT INBD SEAT TRACK, BETWEEN FRAMES 82 AND 83. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-43-03.
- [SDR R61A201803080302](https://openairdocs.org/sdr/R61A201803080302.md): Panel · cracked · Feb 17, 2018 · N209JQ · Emb ERJ170200LR · APU Cowling/Containment
  > A CRACK WAS DISCOVERED ON THE APU FIREWALL PANEL 351AZ. MAINTENANCE REMOVED AND REPLACED THE PANEL IAW AMM 53-31-21.
- [SDR R61A201803080301](https://openairdocs.org/sdr/R61A201803080301.md): Seat Track · corroded · Feb 17, 2018 · N209JQ · Emb ERJ170200LR · Fuselage, Seat/Cargo Attach Fittings
  > CORROSION WAS DISCOVERED ON THE LT INBD SEAT TRACK. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-41-01, AND 51-43-03.

Next page: https://openairdocs.org/aircraft/N209JQ/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 = 'N209JQ' AND registry_match = 'registration'
ORDER BY difficulty_date DESC
```

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