# Service difficulty reports: N21197

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

- [SDR JJBA20261023007](https://openairdocs.org/sdr/JJBA20261023007.md): Control Panel · inoperative · Oct 22, 2026 · N21197 · Emb EMB145XR · Emergency Lighting
  > MCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EXTERNAL EMERGENCY LIGHT ASSEMBLY. OPS CHECK SAT.
- [SDR JJBA20260901022](https://openairdocs.org/sdr/JJBA20260901022.md): Elec Connector · loose · Aug 28, 2026 · N21197 · Emb EMB145XR · Landing Gear System Wiring
  > LG AIR GROUND FAIL, LEVER STUCK DOWN ON CLIMB OUT. FOUND LOOSE ELECTRICAL CONNECTOR ON NLG WOW PROXIMITY SWITCH. CLEANED & RESECURED NLG WOW PROX SWITCH ELEC CONNECTOR. PERFORMED GEAR SWINGS. OPS CHECKED SAT. NO FURTHER DEFECTS NOTED.
- [SDR JJBA20260327013](https://openairdocs.org/sdr/JJBA20260327013.md): Lamp · inoperative · Mar 25, 2026 · N21197 · Emb EMB145XR · Emergency Lighting
  > MCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EMERGENCY LIGHT HOUSING AND BULB. OPS CHECK SAT.
- [SDR JJBA20260327012](https://openairdocs.org/sdr/JJBA20260327012.md): Sign · detached · Mar 24, 2026 · N21197 · Emb EMB145XR · Emergency Lighting
  > BOTH EMERGENCY EXIT LIGHT SIGNS ARE COMING OFF CEILING BY EMERGENCY EXIT. REMOVED AND REPLACED BOTH EMERGENCY EXIT LIGHT SIGNS. OPS CHECK SAT.
- [SDR JJBA20250109008](https://openairdocs.org/sdr/JJBA20250109008.md): Battery Pack · inoperative · Jan 7, 2025 · N21197 · Emb EMB145XR · Emergency Lighting
  > MULTIPLE INTERIOR EMERGENCY LIGHTS INOPERATIVE (ROW 18). REMOVED AND REPLACED #3 BATTERY PACK. OPS CHECK SAT
- [SDR JJBA20241227054](https://openairdocs.org/sdr/JJBA20241227054.md): Battery Pack · inoperative · Dec 24, 2024 · N21197 · Emb EMB145XR · Emergency Lighting
  > EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY #4. OPS CHECK SAT, EMERGENCY LIGHTS BACK TO NORMAL OPERATION
- [SDR JJBA20240930020](https://openairdocs.org/sdr/JJBA20240930020.md): Inverter · inoperative · Sep 26, 2024 · N21197 · Emb EMB145XR · Emergency Lighting
  > FWD CEILING EMERGENCY SIGN AT ROW 18 INOPERATIVE. REMOVED AND REPLACED FWD CEILING EMERGENCY EXIT SIGN INVERTER #6. OPS CHECK SAT.
- [SDR JJBA20240916013](https://openairdocs.org/sdr/JJBA20240916013.md): Sign · inoperative · Sep 14, 2024 · N21197 · Emb EMB145XR · Emergency Lighting
  > FWD OVERHEAD EXIT SIGN AT EMERGENCY EXIT ROW INOPERATIVE. REMOVED AND REPLACED EXIT LOCATING SIGN. OPS CHECK SAT.
- [SDR JJBA20240522051](https://openairdocs.org/sdr/JJBA20240522051.md): Skin · cracked · May 21, 2024 · N21197 · Emb EMB145XR · Fuselage Main, Plate/Skin
  > RH EXTERNAL FUSELAGE, BTW FRAME 77-80 AND BTW STR 3R-9R, CRACKS (6X) FOUND AROUND FASTENERS. 4 BUSHINGS REPAIRS AND A REPAIR DOUBLER ON RH REAR FUSELAGE II SKIN, BTW FR 77 & 79 AND BTW STR 3R-7R
- [SDR JJBA20240522050](https://openairdocs.org/sdr/JJBA20240522050.md): Floor Support · cracked · May 21, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CF2, UNDERFLOOR, LH OMEGA BEAM NO 2, 2 CRACKS SUSPECTED AT FR24,25. 2 REPAIR DOUBLERS ON LH CENTER FUSELAGE 1 OMEGA BEAM, ON INBD VERTICAL FLANGE AT FR24 & 25
- [SDR JJBA20240522048](https://openairdocs.org/sdr/JJBA20240522048.md): Floor Support · cracked · May 21, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CF1, UNDERFLOOR, LH OMEGA BEAM NO 1 INBD SIDE, CRACK SUSPECTED AT FR21, 22, AND 23. CF1, LH OMEGA BEAM NO 1 INBD SIDE, CUTOUT PERFORED AT FR 21, 22, 23. LH OMEGA NO 2 INBD SIDE, FR21, 22, 23 REPAIRED
- [SDR JJBA20240522049](https://openairdocs.org/sdr/JJBA20240522049.md): Skin · scratched · May 7, 2024 · N21197 · Emb EMB145XR · Fuselage Main, Plate/Skin
  > LH EXTERNAL FWD FUSELAGE, SCRATCH FOUND LOWER GPU POWER CONNECTOR AT REPAIR DOUBLER. ON LH EXTERNAL FWD FUSELAGE, LOWER GPU POWER CONNECT AT REPAIR DOUBLER SCRATCH BLEND OUT OF LIMITS. EXISTING DOUBLER REMOVED FOR REPLACEMENT. REPAIR DOUBLER FABRICATED. REPAI
- [SDR JJBA20240520032](https://openairdocs.org/sdr/JJBA20240520032.md): Support Angle · cracked · May 7, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > RF1, CARGO DOOR LIFTING AND LOWERING MECHANISM AT RH SIDE, UPPER HORIZONTAL SUPPORT ANGLE BTW FR 67-68 AND AT STR 4R FOUND CRACKED. RF1, CARGO DOOR LIFTING AND LOWERING MECHANISM AT RH SIDE UPPER HORIZONTAL SUPPORT ANGLE BTW FR 67-68 AT STR 4R REPLACED.
- [SDR JJBA20240520031](https://openairdocs.org/sdr/JJBA20240520031.md): Gusset · corroded · May 3, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CF2, UNDERFLOOR, LH GUSSET NO 2 BTW FR 24-30 FOUND CORRODED. CF2, UNDER FLOOR, LH GUSSET #2 BTW FR 24-30 CORROSION BLENDED AND FOUND OUT OF LIMIT. CF2, UNDER FLOOR, LH GUSSET NO 2 BTW FR 14-30 IS REMOVED. CF2, UNDER FLOOR LH GUSSET NO 2 BTW FR 24-FR 30 INSTALL
- [SDR JJBA20240522045](https://openairdocs.org/sdr/JJBA20240522045.md): Window Frame · cracked · May 2, 2024 · N21197 · Emb EMB145XR · Fuselage Main, Structure
  > COCKPIT WINDSHIELD OVERHEAD PANEL FR PN 123-07751-005 FOUND CRACKED. LH COCKPIT OVERHEAD PANEL FR PN 123-07751-005 REPAIR PERFORMED.
- [SDR JJBA20240522044](https://openairdocs.org/sdr/JJBA20240522044.md): Window Frame · cracked · May 2, 2024 · N21197 · Emb EMB145XR · Fuselage Main, Structure
  > COCKPIT ABOVE RH WINDSHIELD, HORIZONTAL RIB-OVERHEAD PANEL FOUND CRACKED. IN COCKPIT ABOVE RH WINDSHIELF HORIZONTAL RIB-OVERHEAD PANEL REPAIRED AND INSTALLED
- [SDR JJBA20240522043](https://openairdocs.org/sdr/JJBA20240522043.md): Shear Tie · cracked · May 2, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > RF1, LH SHEAR CLIP AT FR68 BTW STR 8L-7L FOUND CRACKED. RF1, LH SHEAR CLIP AT FR68 BTW STR 8L-7L REMOVED AND REPLACED
- [SDR JJBA20240520030](https://openairdocs.org/sdr/JJBA20240520030.md): Latch · broken · May 2, 2024 · N21197 · Emb EMB145XR · Aerodynamic Fairings
  > FWD FUSELAGE 1, FR 1A LH & RH UPPER RADOME LATCHE FAIRING BROKEN. LH AND RH UPPER RADOME LATCHE REMOVED AND REPLACED
- [SDR JJBA20240520028](https://openairdocs.org/sdr/JJBA20240520028.md): Floor Support · cracked · May 2, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CENTER FUSE 3, UNDER FLOOR STRUCTURE, BRACKET RH OMEGA BEAM AT FRAME 41 FOUND CRACKED. IN CF3, UNDER FLOOR STRUCTURE, ON RH OMEGA BEAM AT FR41, SUPPORT BRACKET REPLACED
- [SDR JJBA20240522046](https://openairdocs.org/sdr/JJBA20240522046.md): Floor Support · corroded · May 1, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CENTER FUSELAGE IV, UNDERFLOOR, RH GUSSET BTW FRAME 59-61 FOUND CORRODED. CF4 RH GUSSET BTW FR 59-61 REMOVED AND REPLACED
- [SDR JJBA20240523055](https://openairdocs.org/sdr/JJBA20240523055.md): Skin · cracked · Apr 30, 2024 · N21197 · Emb EMB145XR · Fuselage Main, Plate/Skin
  > LH EXTERNAL FUSELAGE, BTW FRAME 77-80 AND STR 3L-9L, CRACKS (X5) FOUND AROUND FASTENERS. LH EXTERNAL FUSE, PAINT REMOVED BTW FR 77-80 AND BTW STR 3L-9L. LH EXTERNAL FUSELAGE, BTW FRAME 77-80 AND STR 3L-9L. LH EXTERNAL FUSELAGE BTW FR 77-80 STR 3L-9L FOUR REPAI
- [SDR JJBA20240522047](https://openairdocs.org/sdr/JJBA20240522047.md): Floor Support · corroded · Apr 30, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CENTER FUSELAGE IV, UNDERFLOOR, CENTER OMEGA BEAM AT FRAME 59, CORROSION FOUND UNDER NUT PLATE. CENTER OMEGA BEAM REPAIRED AT FR59 AND FR60
- [SDR JJBA20240520029](https://openairdocs.org/sdr/JJBA20240520029.md): Floor Support · corroded · Apr 30, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CENTER FUSE 3, UNDER FLOOR STRUCTURE, LH SILL 5 FOUND CORRODED. CENTER FUSE 3, UNDER FLOOR STRUCTURE LH SILL 4 BLEND OUT OF LIMITS. AT CENTER FUSE 3, LH SILL 5 REPLACED
- [SDR JJBA20240430066](https://openairdocs.org/sdr/JJBA20240430066.md): Support · corroded · Apr 25, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CENTER FUSELAGE 4, RH SILL 6 CORRODED. ON CENTER FUSELAGE 4, RH SILL BLEND OUT CORROSION OUT OF LIMITS. CENTER FUSELAGE 4, RH SILL 6 REMOVED. ON CENTER FUSELAGE 4, RH SILL, 6 INSTALLED
- [SDR JJBA20240513018](https://openairdocs.org/sdr/JJBA20240513018.md): Gusset · corroded · Apr 19, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CF4, UNDER FLOOR, CENTER GUSSET BTW FRAME 59-61 FOUND CORRODED. CTR GUSSET BTW FR59-61 REPLACED.
- [SDR JJBA20240508010](https://openairdocs.org/sdr/JJBA20240508010.md): Shear Tie · cracked · Apr 19, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > CENTER FUSELAGE IV, SHEAR CLIP CRACKED AT FRAME 61 BTW 7R-6R CENTER FUSELAGE IV SHEAR CLIP AT FR 61 BTW STR 7R-6R REPLACED (MADE REPAIR PART), INSTALLED WITH SOLID RIVETS.
- [SDR JJBA20240425062](https://openairdocs.org/sdr/JJBA20240425062.md): Shear Tie · cracked · Apr 19, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > RF1, RH SHEAR CLIP AT FR 73 BTW STR 7R-10R FOUND CRACKED. RF1, RH SHEAR CLIP AT FR73 BTW STR 7R-10R REMOVED, REPLACED WITH NEW PART
- [SDR JJBA20240513016](https://openairdocs.org/sdr/JJBA20240513016.md): Angle · cracked · Apr 18, 2024 · N21197 · Emb EMB145XR · Aerodynamic Fairings
  > L/H WING TO BODY FAIRING UPPER ANGLE #1 AND #3 FOUND CRACKED. ON L/H WING TO BODY FAIRING UPPER ANGLE #1 AND #3 REPAIRED.
- [SDR JJBA20240516025](https://openairdocs.org/sdr/JJBA20240516025.md): Shear Tie · cracked · Apr 17, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > RF1, L/H SHEAR CLIP AT FR66 BTW STR 6L-7L FOUND CRACKED RF1, L/H SHEAR CLIP AT FR66 BTW STR 6L-7L REMOVED AND REPLACED.
- [SDR JJBA20240513023](https://openairdocs.org/sdr/JJBA20240513023.md): Shear Tie · cracked · Apr 17, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > RF1, L/H SHEAR CLIP AT FR73 BTW STR 15L-16L FOUND CRACKED. L/H SHEAR CLIP AT FR73 BTW STR 15L-16L REPLACED.
- [SDR JJBA20240513021](https://openairdocs.org/sdr/JJBA20240513021.md): Support · cracked · Apr 17, 2024 · N21197 · Emb EMB145XR · Cargo/Baggage Doors
  > CARGO DOOR LIFTING AND LOWERING MECHANISI, FWD BOX SUPPORT CRACKED BTW FR 61-62 AND BTW STR 3R-4R CORGO DOOR LIFTING AND LOWERING MECHANISM FWD BOX SUPPORT REPLACED
- [SDR JJBA20240513020](https://openairdocs.org/sdr/JJBA20240513020.md): Angle · cracked · Apr 17, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > VERTICAL U-SHAPE ANGLE BTW FR 67-68 AND BTW STR 3-4R CRACKED. VERTICAL U-SHAPE ANGLE BTW FR 67-68 AND BTW 3R-4R REPLACED.
- [SDR JJBA20240513019](https://openairdocs.org/sdr/JJBA20240513019.md): Shear Tie · cracked · Apr 17, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > SHEAR CLIP CRACKED BTW STR 15L-16L AT FR 56 SHARE CLIP AT FR56 BTW STR 15L-16L REPLACED
- [SDR JJBA20240513013](https://openairdocs.org/sdr/JJBA20240513013.md): Shear Tie · cracked · Apr 17, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > REAR FUSELAGE 1, UNDR FLOOR, SHEAR CLIP CRACKED AT FRAME 65 BTWN STR 19L-18L SHEAR CLIP AT FR 65 STR 19L-18L REPLACED
- [SDR JJBA20240508009](https://openairdocs.org/sdr/JJBA20240508009.md): Shear Tie · cracked · Apr 17, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > REAR FUSELAGE, UNDER FLOOR, SHEAR CLIP CRACKED AT FRAME 72 BTW STR 18L-17L. REAR FUEDLAGE, UNDER FLOOR, SHEAR CLIP AT FRAME 72 BTW STR 18L-17L REPLACED WITH NEW PART.
- [SDR JJBA20240508008](https://openairdocs.org/sdr/JJBA20240508008.md): Shear Tie · cracked · Apr 17, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > REAR FUSELAGE 1, UNDER FLOOR, SHEAR CLIP CRACKED AT FRAME 71 BTWN STR 18L-17L SHEAR CLIP AT FR71 BTW STR17L-18L REPLACED.
- [SDR JJBA20240513022](https://openairdocs.org/sdr/JJBA20240513022.md): Shear Tie · cracked · Apr 16, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > CF2 UNDERFLOOR, L/H SHEAR CLIP AT FR24 BTW STR 15L-16L FOUND CRACKED.CF2, UNDERFLOOR, L/H SHEAR CLIP AT FR 24 BTW STR 15L-16L REMOVE AND REPLACE WITH NEW PART.
- [SDR JJBA20240508012](https://openairdocs.org/sdr/JJBA20240508012.md): Shear Tie · cracked · Apr 16, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > CF2, UNDERFLOOR, R/H SHEAR CLIP AT FR27 BTW STR 15R-16R FOUND CRACKED AT FR27 BTW STR 15R-16R, NEW SHEAR CLIP INSTALLED.
- [SDR JJBA20240508011](https://openairdocs.org/sdr/JJBA20240508011.md): Shear Tie · cracked · Apr 16, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > CF2, UNDERFLOOR, R/H SHEAR CLIP AT FR25 BTW STR 15R-16R FOUND CRACKED NEW SHEAR CLIP AT FR 25 BTW STR 15R-16R INSTALLED
- [SDR JJBA20240508007](https://openairdocs.org/sdr/JJBA20240508007.md): Shear Tie · cracked · Apr 16, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > L/H SHEAR CLIP CRACKED AT FR27 BTW STR 15L-16L L/H SHEAR CLOP MADE REPAIRED PART AT FR27 BTW STR 15L16L REPLACES.
- [SDR JJBA20240506005](https://openairdocs.org/sdr/JJBA20240506005.md): Shear Tie · cracked · Apr 16, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > CF2, UNDERFLOOR, L/H SHEAR CLIP AT FR26 BTW STR 15L-16L FOUND CRACKED REMOVED AND REPLACED L/H SHEAR CLIP AT FR26 BTW STR 15L-16L
- [SDR JJBA20240506004](https://openairdocs.org/sdr/JJBA20240506004.md): Shear Tie · cracked · Apr 16, 2024 · N21197 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > CF2, UNDERFLOOR, R/H SHEAR CLIP AT FR 26 BTW STR 15R-16R FOUND CRACKED. R/H CHEAR CLIP AT FR26 BTW STR 15R-16R REMOVED AND REPLACED.
- [SDR JJBA20240430067](https://openairdocs.org/sdr/JJBA20240430067.md): Angle · corroded · Apr 16, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CF1, UNDERFLOOR, PASSENGER DOOR, BOTH LOWER U SHAPE ANGLE FOUND CORRODED. CF1, UNDERFLOOR, PASSENGER DOOR, BOTH LOWER U SHAPE ANGLE BLENDED OUT OF LIMITS. ON CF1, UNDER FLOOR PASSENGER DOOR BOTH LOWER U SHAPE ANGLE REMOVED. CF1 UNDER FLOOR, PASSENGER DOOR, BOT
- [SDR JJBA20240516026](https://openairdocs.org/sdr/JJBA20240516026.md): Floor Support · corroded · Apr 15, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CENTER FUSE 3, UNDER FLOOR STRUCTURE, RH SILL 3 FOUND CORRODED R/H SILL #3 REMOVED FOR REPLACEMENT. ON CENTER FUDE 3, RH SILL 3 REPLACED.
- [SDR JJBA20240513017](https://openairdocs.org/sdr/JJBA20240513017.md): Floor Support · corroded · Apr 15, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CF1, UNDERFLOOR, L/H SILL NO.1 BTW FR 19-23 FOUND CORRODED ON CF1. UNDERFLOOR, L/H SILL NO1 BTW FR 19-23 CORROSION REMOVED. AT FR19, L/H CROSS BEAM AND T ABGLE REMOVED FOR ACCESS. L/H SILL BTWEEM 18-23 REMOVED FOR REPLACEMENT.CF1. UNDERFLOOR, L/H SILL NO1 BTW
- [SDR JJBA20240513015](https://openairdocs.org/sdr/JJBA20240513015.md): Floor Support · corroded · Apr 15, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CF3, UNDER FLOOR STRUCTURE, LH SILL 4 FOUND CORRODED. CF3, UNDER FLOOR L/H SILL, #4 BLENDED OUT OUT LIMIT. CF3 L/H SILL #4 REMOVED FOR REPLACEMENT. AT CF3, UNDER FLOOR STRUCTURE, LH SILL 4 REPLACED.
- [SDR JJBA20240513014](https://openairdocs.org/sdr/JJBA20240513014.md): Door Sill · corroded · Apr 15, 2024 · N21197 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CF1, UNDERFLOOR, SERVICE DOOR AFT SILL FOUND CORRODED. CF1 UNDERFLOOR SERCIVE DOOR AFT SILL CORROSION AREA CUT OUT, CF1 UNDERFLOOR SRVICE DOOR AFT SILL REPAIRED.
- [SDR JJBA20230925041](https://openairdocs.org/sdr/JJBA20230925041.md): Unknown · unknown · Sep 20, 2023 · N21197 · Emb EMB145XR · Cabin Cooling System
  > BURNING SMELL IN CABIN ON APPROACH BETWEEN ROWS 5-18. INSPECTED ACM, NO DEFECTS NOTED. PERFORMED GROUND HIGH POWER ENGINE RUNS AND PERFORMED FIM. NO DEFECTS NOTED
- [SDR JJBA20230208003](https://openairdocs.org/sdr/JJBA20230208003.md): Not Reported · not reported · Feb 5, 2023 · N21197 · Emb EMB145XR · Passenger/Crew Doors
  > SUPPLEMENTAL (NEW) INFORMATION: REMOVED AND REPLACED MAIN DOOR SEAL FOUND ORIGINAL SEAL TO BE UNEVENLY PLACED AT SEAL TRACK UPTO PRESS LEAK CHECK. OPS/LEAK CHECK GOOD.
- [SDR JJBA20221024016](https://openairdocs.org/sdr/JJBA20221024016.md): Lamp · inoperative · Oct 21, 2022 · N21197 · Emb EMB145XR · Emergency Lighting
  > FWD AISLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED FWD AISLE EMERGENCY LIGHT BULB. OPS CHECK SAT.

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

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