# Service difficulty reports: N12167

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

- [SDR JJBA20260629020](https://openairdocs.org/sdr/JJBA20260629020.md): Battery · inoperative · Jun 27, 2026 · N12167 · Emb EMB145XR · Emergency Lighting
  > ALL FWD EMERGENCY LIGHTS MOMENTARILY COME ON THEN DIM OFF. REMOVED AND REPLACED NR 1 EMERGENCY LIGHT BATTERY. OPS CHECK SAT.
- [SDR JJBA20260629019](https://openairdocs.org/sdr/JJBA20260629019.md): Battery Pack · inoperative · Jun 26, 2026 · N12167 · Emb EMB145XR · Emergency Lighting
  > AFT EXIT LOCATING SIGN INOPERATIVE. EXIT MARKING SIGNS ON LT AND RT EXIT ROW INOPERATIVE. FOUND ADDITIONAL EMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT TO AND REMOVED AND REPLACED NR 3 EMERGENCY LIGHT BATTERY AND REMOVED AND REPLACED AISLE CEILING NR 3 EMERGENCY
- [SDR JJBA20250217028](https://openairdocs.org/sdr/JJBA20250217028.md): Latch · stuck · Feb 13, 2025 · N12167 · Emb EMB145XR · Landing Gear System
  > LG FREE FALL SELECTOR DOOR WON'T OPEN. OPENED FREE FALL SELECTOR DOOR. OPS CHECK SAT. UNABLE TO OPEN FREE FALL PANEL 222EF BY NORMAL MEANS. CLOSURE LATCH BUTTON APPEARS TO BE STUCK. REMOVED AND REPLACED LATCH. OPS CHECK SAT"
- [SDR JJBA20250127020](https://openairdocs.org/sdr/JJBA20250127020.md): Charger · inoperative · Jan 23, 2025 · N12167 · Emb EMB145XR · Emergency Lighting
  > ENTRYWAY EMERGENCY LIGHTS OUT. DUE TO EXCESSIVE HISTORY OF EXACT EMERGENCY LIGHTS BEING WRITTEN UP, REMOVED AND REPLACED #1 BATTERY POWER SUPPLY AND BATTERY PACK. OPS CHECK SAT.
- [SDR JJBA20250123019](https://openairdocs.org/sdr/JJBA20250123019.md): Battery · inoperative · Jan 22, 2025 · N12167 · Emb EMB145XR · Emergency Lighting
  > FWD LH EXT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT LAMP. OPS CHECK FAILED. FOUND #1 BATTERY PACK TO BE FAULT. REMOVED AND REPLACED BATTERY PACK #1. OPS CHECK SAT.
- [SDR JJBA20250123018](https://openairdocs.org/sdr/JJBA20250123018.md): Battery · inoperative · Jan 22, 2025 · N12167 · Emb EMB145XR · Emergency Lighting
  > MCD, FLOOR AND FIRST OVERHEAD EMERGENCY LIGHTS OUT. REMOVED AND REPLACED #1 BATTERY PACK. OPS CHECK SAT.
- [SDR JJBA2025010023060](https://openairdocs.org/sdr/JJBA2025010023060.md): Battery · inoperative · Dec 29, 2024 · N12167 · Emb EMB145XR · Emergency Lighting
  > LH EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LH EMERGENCY LIGHT BULB AND REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY POWER SUPPLY. OPS CHECK SAT.
- [SDR JJBA20241209005](https://openairdocs.org/sdr/JJBA20241209005.md): Battery · inoperative · Dec 9, 2024 · N12167 · Emb EMB145XR · Emergency Lighting
  > EMERGENCY EXIT SIGNS BY COCKPIT DOOR INOPERATIVE. REMOVED AND REPLACED BPS #1. OPS CHECK SAT.
- [SDR JJBA20241025014](https://openairdocs.org/sdr/JJBA20241025014.md): Battery Pack · inoperative · Oct 25, 2024 · N12167 · Emb EMB145XR · Emergency Lighting
  > MULITPLE EMERGENCY LIGHTS INOPERATIVE. AISLE CEILING LIGHT AT SEAT 3A/ EMERGENCY EXIT LOCATING SIGN AT FA SEAT / BELOW COCKPIT DOOR / AT SEAT 1A AND EXTERIOR LH FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY 1. OPS CHECK SAT.
- [SDR JJBA20241014009](https://openairdocs.org/sdr/JJBA20241014009.md): Pump · faulted · Oct 13, 2024 · N12167 · Emb EMB145XR · Hydraulic Pump (Electric/Engine), Main
  > E2 HYD PUMP IN FLIGHT. INSPECTED HYDRAULIC RESERVOR FOR LEAKS, NONE FOUND. HYD FUSES NOT POPPED, OPS CHECKED EMDP. OPS CHECK SAT. INSPECTED BRAKES, NO LEAKS NOTED, PERFORMED FIM, FOUND E2 EDP TO BE FAULTY. REMOVED AND REPLACED ENGINE-DRIVEN PUMP. DURING REMOVA
- [SDR JJBA20241007003](https://openairdocs.org/sdr/JJBA20241007003.md): Battery Pack · inoperative · Oct 3, 2024 · N12167 · Emb EMB145XR · Emergency Lighting
  > LH EXTERIOR FWD EMERGENCY LIGHT OUT. REMOVED AND REPLACED LH FORWARD EXTERIOR LIGHT. OPS CHECK FAILED. SLAVED IN NEW INVERTER. OPS CHECK FAILED. REINSTALLED ORIGINAL INVERTER. REMOVED AND REPLACED #1 BATTERY POWER SUPPLY. OPS CHECK SAT.
- [SDR JJBA20240930019](https://openairdocs.org/sdr/JJBA20240930019.md): Battery · inoperative · Sep 25, 2024 · N12167 · Emb EMB145XR · Emergency Lighting
  > ALL LIGHTS CONNECTED TO THE EMERGENCY BATTERY #1 ARE OUT. REMOVED AND REPLACED BPS 1. OPS CHECK SAT
- [SDR JJBA20240612034](https://openairdocs.org/sdr/JJBA20240612034.md): Skin · damaged · Jun 11, 2024 · N12167 · Emb EMB145XR · Cargo/Baggage Doors
  > EXTERNAL BAGGAGE DOOR SKIN, DENT FOUND 7.500 INCHES FROM LOWER EDGE AND 3.000 INCHES FROM FWD EDGE. EXTERNAL BAGGAGE DOOR SKIN REPAIRED.
- [SDR JJBA20240612032](https://openairdocs.org/sdr/JJBA20240612032.md): Skin · corroded · Jun 5, 2024 · N12167 · Emb EMB145XR · Fuselage Main, Plate/Skin
  > REAR FUSELAGE 1, FRAME 61 BTW STR 19L-18L, CORROSION SUSPECTED ON INNER SKIN SURFACE. CORROSION DAMAGE ON INNER SKIN SURFACE AT FR61 BTW STR 19L-18L REPAIRED.
- [SDR JJBA20240611030](https://openairdocs.org/sdr/JJBA20240611030.md): Frame · cracked · Jun 5, 2024 · N12167 · Emb EMB145XR · Fuselage Main, Frame
  > LH OVERHEAD COCKPIT FRAME FOUND CRACKED. LH OVERHEAD COCKPIT FRAME SPLICE REPAIRED
- [SDR JJBA20240611028](https://openairdocs.org/sdr/JJBA20240611028.md): Skin · damaged · Jun 5, 2024 · N12167 · Emb EMB145XR · Fuselage Main, Plate/Skin
  > CENTER FUSELAGE 2, EXTERNAL SKIN, SEVERAL LIGHTNING STRIKE FOUND BTW FRAME 25-31 AND STR 21L-19L. PERFORMED REPAIRS ON CENTER FUSELAGE 2, EXTERNAL SKIN BTW FR 25 - FR 31 AND STR 21L-19L
- [SDR JJBA20240607003](https://openairdocs.org/sdr/JJBA20240607003.md): Gusset · corroded · Jun 5, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > LH GUSSET BTW FR 59-61 FOUND CORRODED. LH GUSSET BTW FR59-61 BLENDED AND FOUND OUT OF LIMIT. LH GUSSET BTW FR 59-61 REMOVED AND REPLACED
- [SDR JJBA20240611031](https://openairdocs.org/sdr/JJBA20240611031.md): Floor Support · corroded · Jun 4, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > RF1, UNDERFLOOR, CENTER OMEGA BEAM FOUND CORRODED BTW FR 59-60 AND 60-61 AROUND ANCHOR NUT. REAR FUSELAGE I FLOOR STRUCTURE, CTR OMEGA BEAM REPAIRED BTW FR 59-60 AND FR 60-61
- [SDR JJBA20240611029](https://openairdocs.org/sdr/JJBA20240611029.md): Skin · dented · Jun 4, 2024 · N12167 · Emb EMB145XR · Fuselage Main, Plate/Skin
  > FWD FUSELAGE, DENT FOUND 4.000 INCHES FWD FRAME 7 AND 14.000 INCHES STR 15L. REPAIR DOUBLER PERFORMED ON FWD FUSELAGE BTW FR 6-7 AND BELOW GPU ACCESS PANEL
- [SDR JJBA20240610015](https://openairdocs.org/sdr/JJBA20240610015.md): Shear Tie · cracked · Jun 4, 2024 · N12167 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > RF1, ABOVE FLOOR, SHEAR CLIP AT FR66 AND BTW STR 6L-7L FOUND CRACKED. SHEAR CLIP AT FR66 BTW STR 6L-7L LOCALLY FABRICATED. MADE REPAIR PART INSTALLED
- [SDR JJBA20240610014](https://openairdocs.org/sdr/JJBA20240610014.md): Floor Support · corroded · Jun 4, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > RF1, UNDERFLOOR, LH OMEGA BEAM FOUND CORRODED BTW FR 59-60 AND 60-61 AROUND ANCHOR NUT. REPAIR PERFORMED ON CENTER FUSELAGE IV, LH OMEGA BEAM HAT UPPER SURFACE
- [SDR JJBA20240607007](https://openairdocs.org/sdr/JJBA20240607007.md): Floor Support · cracked · Jun 4, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > CF1, LH OMEGA BEAM AT FR22 VERTICAL FLANGE INBD CRACKED FOUND ON RIVET. CF1, LH OMEGA BEAM CRACK AT FR22 REPAIRED
- [SDR JJBA20240607005](https://openairdocs.org/sdr/JJBA20240607005.md): Floor Support · cracked · Jun 4, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > LH OMEGA BEAM #4 CORROSION FOUND AND CRACK SUSPECTED AT FR36. LH OMEGA BEAM #4 BLENDED WITHIN LIMITS AND REPROTECTED. LH OMEGA BEAM #4 CRACK AT FR36 REPAIRED. CORROSION LEVEL 1.
- [SDR JJBA20240606002](https://openairdocs.org/sdr/JJBA20240606002.md): Floor Support · cracked · Jun 4, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > LH OMEGA BEAM #6 FOUND CORRODED AND CRACK SUSPECTED AT FR51. CORROSION BLENDED AND WITHIN LIMITS. LH OMEGA BEAM #6 CRACK REPAIRED. CORROSION LEVEL 1
- [SDR JJBA20240606001](https://openairdocs.org/sdr/JJBA20240606001.md): Floor Support · corroded · Jun 4, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > LH OMEGA BEAM #2 FOUND CORRODED AND 2 CRACK SUSPECTED AT FR 24 AND 25. LH OMEGA BEAM #2 BLENDED WITHIN LIMITS AND RE-PROTECTED. LH OMEGA BEAM #2, CRACK AT FR 24 AND 25 REMOVED AND REPAIRED.
- [SDR JJBA20240612033](https://openairdocs.org/sdr/JJBA20240612033.md): Support · cracked · May 31, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > RF1, ABOVE FLOOR, BAGGAGE DOOR MECHANISM LOWER SUPPORT BTW FR68-69 AND ON STR 5R FOUND CRACKED. RF1, BTW FR 68-69 AT STR 5R BAGGAGE DOOR MECHANISM SUPPORT REMOVED AND REPLACED
- [SDR JJBA20240611017](https://openairdocs.org/sdr/JJBA20240611017.md): Floor Support · cracked · May 29, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > LH OMEGA BEAM #5 FOUND CRACKED AT FR 39. LH OMEGA BEAM #5 CRACK AT FR39 REPAIRED
- [SDR JJBA20240610016](https://openairdocs.org/sdr/JJBA20240610016.md): Support Plate · corroded · May 29, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > RF1, ABOVE FLOOR, LH SUPPORT PLATE AT FR61 FOUND CORRODED AT FLOOR LEVEL. AT RF1, ABOVE FLOOR LH SUPPORT PLATE AT FR61 BLENDED AND FOUND OUT OF LIMIT AND REMOVED FOR REPLACEMENT. AT RF1, ABOVE FLOOR, LH SUPPORT PLATE AT FR61 REPLACED
- [SDR JJBA20240610011](https://openairdocs.org/sdr/JJBA20240610011.md): Bracket · cracked · May 29, 2024 · N12167 · Emb EMB145XR · Nacelle/Pylon Miscellaneous Structure
  > RH ENG PYLON PRECOOLER, FWD STRUCTURE BRACKET IS CRACKED. RH ENG PYLON PRECOOLER, FWD STRUCTURE BRACKET REMOVED FOR REPLACEMENT. RH ENG PYLON PRECOOLER FWD STRUCTURE BRACKET REPLACED
- [SDR JJBA20240603064](https://openairdocs.org/sdr/JJBA20240603064.md): Support Plate · corroded · May 29, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > RF1, ABOVE FLOOR, RH SUPPORT PLATE AT FR61 FOUND CORRODED AT FLOOR LEVEL. AT RF1, ABOVE FLOOR AT RH FR61, SUPPORT PLATE BLENDED AND FOUND OUT OF LIMIT AND REMOVED FOR REPLACEMENT. AT RF1, ABOVE FLOOR AT RH FR61, SUPPORT PLATE REPLACED.
- [SDR JJBA20240607009](https://openairdocs.org/sdr/JJBA20240607009.md): Support · corroded · May 28, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > RF1, UNDERFLOOR, RH SILL BTW FR 61-65 FOUND CORRODED. RH SILL BTW FR 61-65 BLENDED AND FOUND OUT OF LIMIT. RH SILL BTW FR 61-65 REMOVED AND INSTALLED.
- [SDR JJBA20240603065](https://openairdocs.org/sdr/JJBA20240603065.md): Support · corroded · May 28, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > RH SILL BTW FR 59-61 FOUND CORRODED. RH SILL BTW FR 59-61 FOUND CORRODED OUT OF LIMIT. RH SILL BTW FR 59-61 REMOVED AND REPLACED.
- [SDR JJBA20240603063](https://openairdocs.org/sdr/JJBA20240603063.md): Support · corroded · May 28, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > LH SILL BTW FR 59-61 FOUND CORRODED. LH SILL BTW FR 59-61 BLENDED OUT OF LIMITS AND REMOVED FOR REPLACEMENT. LH SILL BTW FR 59-61 REPLACED
- [SDR JJBA20240611027](https://openairdocs.org/sdr/JJBA20240611027.md): Yoke · cracked · May 27, 2024 · N12167 · Emb EMB145XR · Nacelle/Pylon, Main Frame
  > RH PYLON SPAR II YOKE AFT RIVET HOLE CRACKED. CRACKED HOLE ON RH PYLON SPAR II YOKE AFT RIVET HOLE REPAIRED
- [SDR JJBA20240528062](https://openairdocs.org/sdr/JJBA20240528062.md): Shear Tie · cracked · May 24, 2024 · N12167 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > CF4, LH SHEAR CLIP ON FR58 BTW STR 15L-16L FOUND CRACKED. CF4 LH SHEAR CLIP ON FR58 BTW STR 15L-16L REPLACED.
- [SDR JJBA20240611024](https://openairdocs.org/sdr/JJBA20240611024.md): Shroud · cracked · May 22, 2024 · N12167 · Emb EMB145XR · Trailing Edge Flaps
  > RH OUTBD FLAP SHROUD OUTBD HINGE FOUND CRACKED. RH OUTBD FLAP SHROUD OUTBD HINGE REPLACED
- [SDR JJBA20240611022](https://openairdocs.org/sdr/JJBA20240611022.md): Attach Angle · cracked · May 22, 2024 · N12167 · Emb EMB145XR · Fuselage Main, Attach Fittings
  > LH OMEGA BEAM WING BOX ATTACH ANGLE, OUTBD FOUND CRACKED AT FR47 AND INBD FOUND CORRODED AT FR49. LH OMEGA BEAM WING BOX ATTACH ANGLE, OUTBD BTW FR 47 TO 50 REMOVED AND REPLACED
- [SDR JJBA20240611021](https://openairdocs.org/sdr/JJBA20240611021.md): Attach Angle · cracked · May 22, 2024 · N12167 · Emb EMB145XR · Fuselage Main, Attach Fittings
  > RH OMEGA BEAM WING BOX ATTACH ANGLE, INBD AND OUTBD ANGLES AT FR 47 FOUND CRACKED. INBD AND OUTBD ANGLES BTW FR 47 TO FR50 ON RH OMEGA BEAM REMOVED AND REPLACED
- [SDR JJBA20240611019](https://openairdocs.org/sdr/JJBA20240611019.md): Angle · cracked · May 22, 2024 · N12167 · Emb EMB145XR · Aerodynamic Fairings
  > CENTER FUSELAGE 3, LH UPPER SURFACE OF WING TO FUSELAGE FAIRING STRUCTURE, ANGLE 1, 2, 3 FROM FWD FOUND CRACKED. ANGLE 2 FROM FWD END REMOVED AND REPLACED
- [SDR JJBA20240611018](https://openairdocs.org/sdr/JJBA20240611018.md): Angle · cracked · May 22, 2024 · N12167 · Emb EMB145XR · Aerodynamic Fairings
  > CENTER FUSELAGE 3, RH UPPER SURFACE OF WING TO FUSELAGE FAIRING STRUCTURE, ANGLE 2, 4, 7 FROM FWD FOUND CRACKED. ANGLE 4 FROM FWD END REMOVED AND REPLACED
- [SDR JJBA20240607006](https://openairdocs.org/sdr/JJBA20240607006.md): Threshold · corroded · May 22, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > ON CF1, RH FUSE THRESHOLD SERVICE DOOR BTW FR20-22 CORRODED. ON CF1, BTW FR20-22 RH FUSE THRESHOLD SERVICE DOOR CORROSION BLENDED OUT OF LIMITS. ON CF1, RH FUSE THRESHOLD SERVICE DOOR BTW FR20-22 REMOVED AND REPLACED
- [SDR JJBA20240603072](https://openairdocs.org/sdr/JJBA20240603072.md): Bracket · cracked · May 22, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > RH SIDE AT FR 46 CLOSING ANGLE BRACKET FOUND CRACKED JUST UNDER FLOOR LEVEL. RH SIDE AT FRAME 46 CLOSING ANGLE BRACKET REPLACED
- [SDR JJBA20240611026](https://openairdocs.org/sdr/JJBA20240611026.md): Rib · cracked · May 21, 2024 · N12167 · Emb EMB145XR · Fuselage Main, Structure
  > LEFT EXTENDED RIB FOUND CRACKED FROM BOTTOM HOLES ON CENTER FUSELAGE UNDER SPAR III. ON LH EXTENDED RIB FROM BOTTOM HOLES ON CENTER FUSELAGE UNDER SPAR III REMOVED AND REPLACED
- [SDR JJBA20240603067](https://openairdocs.org/sdr/JJBA20240603067.md): Rib · cracked · May 21, 2024 · N12167 · Emb EMB145XR · Fuselage Main, Structure
  > EXTENDED RIB FOUND CRACKED FROM BOTTOM HOLES ON CENTER FUSELAGE UNDER SPAR III. REMOVED AND REPLACED EXTENDED RIB ON RH CENTER FUSE UNDER SPAR III
- [SDR JJBA20240603066](https://openairdocs.org/sdr/JJBA20240603066.md): Bracket · corroded · May 20, 2024 · N12167 · Emb EMB145XR · Wing, Attach Fittings
  > L-SHAPE BRACKET FOUND HEAVY CORROSION ON RH WING UNDER INBD FLAP SHROUD. RH WING UNDER INBD FLAP SHROUD L-SHAPE BRACKET BLENDED OUT OF LIMITS. RH WING INBD FLAP L-SHAPE BRACKET REMOVED AND REPLACED
- [SDR JJBA20240610012](https://openairdocs.org/sdr/JJBA20240610012.md): Floor Support · cracked · May 16, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > LH OMEGA BEAM AT FR21 VERTICAL FLANGE INBD CRACKED ON RIVET. LH OMEGA BEAM AT FR21 CRACK REPAIRED
- [SDR JJBA20240610013](https://openairdocs.org/sdr/JJBA20240610013.md): Floor Support · corroded · May 14, 2024 · N12167 · Emb EMB145XR · Fuselage Miscellaneous Structure
  > RF1, UNDERFLOOR, RH OMEGA BEAM FOUND CORRODED BTW FR 59-60 AND 60-62 AROUND ANCHOR NUT. RH OMEGA BEAM BTW FR 60-62 BLENDED, FOUND WITHIN LIMITS. REPAIR DOUBLER PERFORMED ON CTR FUSELAGE IV, RH OMEGA BEAM UPPER SURFACE BTW FR 59-60
- [SDR JJBA20240522052](https://openairdocs.org/sdr/JJBA20240522052.md): Shear Tie · cracked · May 14, 2024 · N12167 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > RF1, ABOVE FLOOR, RH SHEAR CLIP AT FR 73 AND BTW STR 8R-10R FOUND CRACKED. SHEAR CLIP REMOVED AND REPLACED
- [SDR JJBA20240520034](https://openairdocs.org/sdr/JJBA20240520034.md): Shear Tie · cracked · May 13, 2024 · N12167 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > SHEAR CLIP FOUND CRACKED AT FR15 BTW STR 15R-16R. SHEAR CLIP AT FR15, BTW STR 15R-16R REMOVED AND REPLACED WITH NEW PART.
- [SDR JJBA20240520033](https://openairdocs.org/sdr/JJBA20240520033.md): Shear Tie · cracked · May 13, 2024 · N12167 · Emb EMB145XR · Fuselage Internal Mounting Structure
  > SHEAR CLIP FOUND CRACKED AT FR16 BTW STR 15R-16R. SHEAR CLIP AT FR16 BTW STR 15R-16R REMOVED AND REPLACED WITH NEW PART

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

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