# Service difficulty reports: N624US, cancelled Jan 2, 2018

A list on [N624US, cancelled Jan 2, 2018](https://openairdocs.org/deregistered/N624US-2018-01-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 2 · 75 reports

- [SDR NWAA093056624](https://openairdocs.org/sdr/NWAA093056624.md): Power Supply · defective · Aug 29, 2009 · N624US · Boeing 747251B · Emergency Lighting
  > DURING A MAINTENANCE VISIT, THE EMERGENCY EXIT SIGN JUST AFT OF DOOR 2R WAS FOUND TO BE INOPERATIVE. MAINTENANCE FOUND THE POWER SUPPLY TO BE DEFECTIVE AND REPLACED IT. SYSTEM OPERATION WAS NORMAL AFTER THE POWER SUPPLY WAS REPLACED.
- [SDR NWAA092976624](https://openairdocs.org/sdr/NWAA092976624.md): Battery Pack · inoperative · Aug 16, 2009 · N624US · Boeing 747251B · Emergency Lighting
  > DURING AN OVERNIGHT LINE CHECK THE EMERGENCY LIGHT AT DOOR THREE RIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE FOUND THE ASSOCIATED BATTERY PACK TO BE THE PROBLEM AND REPLACED IT. SYSTEM OPERATION WAS NORMAL AFTER THE BATTERY PACK WAS REPLACED.
- [SDR NWAA2926624](https://openairdocs.org/sdr/NWAA2926624.md): Battery Pack · discharged · Aug 13, 2009 · N624US · Boeing 747251B · Emergency Lighting
  > DURING A LINE CHECK THE EMERGENCY EXIT SIGN ABOVE DOOR TWO LEFT WAS FOUND TO BE INOPERATIVE. MAINTENANCE FOUND THE BATTERY PACK TO BE DEFECTIVE AND REPLACED IT. SYSTEM OPERATION WAS NORMAL AFTER THE BATTERY PACK WAS REPLACED.
- [SDR NWAA092666624](https://openairdocs.org/sdr/NWAA092666624.md): Power Supply · inoperative · Jul 28, 2009 · N624US · Boeing 747251B · Emergency Lighting
  > DURING A MX VISIT THE EMERGENCY EXIT SIGN ABOVE DOOR 3 RT WAS FOUND TO BE INOPERATIVE. MX FOUND THE ASSOCIATED POWER SUPPLY TO BE DEFECTIVE AND REPLACED IT. SYS OPS WAS NORMAL AFTER POWER SUPPLY WAS REPLACED.
- [SDR NWAA092516624](https://openairdocs.org/sdr/NWAA092516624.md): Battery Pack · inoperative · Jul 14, 2009 · N624US · Boeing 747251B · Emergency Lighting
  > DURING AN OVERNIGHT LINE CHECK THE EMERGENCY EXIT SIGN FOR DOOR 2L WAS FOUND TO BE INOPERATIVE. MAINTENANCE FOUND THE ASSOCIATED BATTERY PACK TO BE DEFECTIVE AND REPLACED IT. SYSTEM OPERATION WAS NORMAL AFTER THE BATTERY PACK WAS REPLACED.
- [SDR NWAA092426624](https://openairdocs.org/sdr/NWAA092426624.md): Battery Pack · defective · Jul 1, 2009 · N624US · Boeing 747251B · Emergency Lighting
  > DURING A MAINTENANCE VISIT THE EMERGENCY ESCAPE PATH LIGHTING IN THE AFT GALLEY WAS FOUND TO BE INOPERATIVE. MAINTENANCE FOUND THE ASSOCIATED BATTERY PACK TO BE DEFECTIVE AND REPLACED IT. THE SYSTEM OPERATED NORMALLY AFTER THE BATTERY PACK WAS REPLACED.
- [SDR NWAA091796624](https://openairdocs.org/sdr/NWAA091796624.md): Battery Pack · inoperative · May 22, 2009 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT CHECK FOUND EMERGENCY FLOOR LIGHTS IN UPPER DECK INOP. MAINTENANCE REMOVED AND REPLACED BATTERY. OPERATIONAL CHECKED GOOD AND AIRCRAFT WAS RETURNED TO SERVICE.
- [SDR NWAA 091736624](https://openairdocs.org/sdr/NWAA%20091736624.md): Power Supply · inoperative · May 18, 2009 · N624US · Boeing 747251B · Emergency Lighting
  > PILOT REPORTED EMERGENCY LIGHTS IN GALLEY 2 ARE INOP. MAINTENANCE REMOVED AND REPLACED POWER SUPPLY MODULE. OPERATIONAL CHECKED GOOD, AND AIRCRAFT WAS RETURNED TO SERVICE.
- [SDR NWAA091156624](https://openairdocs.org/sdr/NWAA091156624.md): Power Supply · inoperative · Apr 7, 2009 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT CHECK FOUND DOOR 1 RT FWD OVERHEAD CROSS AISLE EMERGENCY SIGN INOPERATIVE. MX REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK. OPS CHECKED GOOD, AND ACFT WAS RETURNED TO SERVICE. (K)
- [SDR NWAA091146624](https://openairdocs.org/sdr/NWAA091146624.md): Power Supply · inoperative · Apr 7, 2009 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT CHECK FOUND, DOOR 1 RT EMERGENCY SIGN OVER DOOR INOPERATIVE. MX REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK. OPS CHECKED GOOD, AND ACFT WAS RETURNED TO SERVICE. (K)
- [SDR NWAA091136624](https://openairdocs.org/sdr/NWAA091136624.md): Power Supply · inoperative · Apr 7, 2009 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT CHECK, FOUND DOOR 1 RT AFT OVERHEAD CROSS AISLE EMERGENCY EXIT SIGN INOPERATIVE. MX REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK. OPS CHECKED GOOD AND ACFT WAS RETURNED TO SERVICE. (K)
- [SDR NWAA085446624](https://openairdocs.org/sdr/NWAA085446624.md): Battery Pack · inoperative · Dec 8, 2008 · N624US · Boeing 747251B · Emergency Lighting
  > DURING AN OVERNIGHT LINE CHECK THE EMERGENCY EXIT SIGNAGE WOULD NOT ILLUMINATE WHEN TESTED. MX FOUND THE ASSOCIATED BATTERY PACK DEFECTIVE AND REPLACED IT. SYSTEM OPS WAS NORMAL AFTER THE BATTERY PACK WAS REPLACED.
- [SDR NWAA084996624](https://openairdocs.org/sdr/NWAA084996624.md): Battery Pack · inoperative · Nov 7, 2008 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT FOUND EMERGENCY EXIT SIGNS AT DOOR 2 RT INOP. MX R&R BATTERY PACK. OPS CHECKED GOOD AND ACFT WAS RETURNED TO SERVICE.
- [SDR NWAA084536624](https://openairdocs.org/sdr/NWAA084536624.md): Battery Pack · discharged · Oct 9, 2008 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT CHECK, FOUND EMERGENCY LIGHT EXIT SIGN AT 45C, 51C AND ABOVE 4L DOOR INOP. MX R&R BATTERY PACK. OPS CHECKED GOOD AND ACFT WAS RETURNED TO SERVICE.
- [SDR NWAA083416624](https://openairdocs.org/sdr/NWAA083416624.md): Battery Pack · inoperative · Jul 26, 2008 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT CHECK, FOUND ZONE-E FLOOR EMERGENCY LIGHTS LEFT SIDE INOP. MAINTENANCE REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK. OPERATIONAL CHECKED GOOD, AND AIRCRAFT WAS RETURNED TO SERVICE. (A)
- [SDR NWAA082356623](https://openairdocs.org/sdr/NWAA082356623.md): Shear Tie · cracked · May 23, 2008 · N624US · Boeing 747251B · Fuselage Internal Mounting Structure
  > DURING M-CHECK FOUND CRACKS IN FLOOR TO SKIN SHEAR TIE BETWEEN BS 340-360 LT SIDE. REPAIRED PER EA 66-212930.
- [SDR NWAA082286624](https://openairdocs.org/sdr/NWAA082286624.md): Power Supply · inoperative · May 19, 2008 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT CHECK, FOUND MAIN DECK DOOR 2 LEFT EXIT SIGN ABOVE DOOR INOP. MAINTENANCE REMOVED AND REPLACED POWER SUPPLY. OPERATIONAL CHECKED GOOD AND AIRCRAFT WAS RETURNED TO SERVICE.
- [SDR NWAA082276624](https://openairdocs.org/sdr/NWAA082276624.md): Power Supply · inoperative · May 19, 2008 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT CHECK, FOUND MAIN DECK GALLEY EMERGENCY EXIT SIGN WITH ARROWS INOP. MAINTENANCE REMOVED AND REPLACED POWER SUPPLY. OPERATIONAL CHECKED GOOD AND AIRCRAFT WAS RETURNED TO SERVICE.
- [SDR NWAA081986624](https://openairdocs.org/sdr/NWAA081986624.md): Battery Pack · inoperative · May 4, 2008 · N624US · Boeing 747251B · Emergency Lighting
  > DURING THE DOD (DEPARTMENT OF DEFENSE) PRE-FLIGHT, FOUND CABIN EMERGENCY LIGHTS AT 3L DOOR INOP. MAINTENANCE REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECKED GOOD AND AIRCRAFT WAS RETURNED TO SERVICE.
- [SDR NWAA073786624](https://openairdocs.org/sdr/NWAA073786624.md): Light · inoperative · Nov 17, 2007 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT CHECK, EMERGENCY LIGHTS INOP AT DOOR 1L AND 1R. MAINTENANCE REMOVED AND REPLACED BATTERY SUPPLY, LIGHT ASSEMBLY, AND REPAIRED BROKEN WIRES. OPERATIONAL CHECKED GOOD AND AIRCRAFT WAS RETURNED TO SERVICE.
- [SDR NWAA073796624](https://openairdocs.org/sdr/NWAA073796624.md): Battery Pack · discharged · Nov 16, 2007 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT CHECK, FOUND EMERGENCY LIGHTS MAIN DECK RIGHT SIDE AISLE EXIT SIGNS IN AISLE JUST FORWARD AND AFT OF DOOR 2R INOP. MAINTENANCE REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECKED GOOD AND AIRCRAFT WAS RETURNED TO SERVICE.
- [SDR NWAA073766624](https://openairdocs.org/sdr/NWAA073766624.md): Battery Pack · discharged · Nov 16, 2007 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT CHECK, FOUND 2 EMERGENCY LIGHTS OUTSIDE OF AIRCRAFT ON LEFT SIDE WING ROOT FAIRING INOP. MAINTENANCE REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECKED GOOD AND AIRCRAFT WAS RETURNED TO SERVICE.
- [SDR NWAA072926624](https://openairdocs.org/sdr/NWAA072926624.md): Powerpack · inoperative · Aug 28, 2007 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT CHECK, "A" ZONE EMERGENCY PATH LIGHTS DO NOT ILLUMINATE AT TEST. MAINTENANCE REMOVED AND REPLACED POWER PACK. OPERATIONAL CHECKED GOOD AND AIRCRAFT RETURNED TO SERVICE.
- [SDR 0602646624](https://openairdocs.org/sdr/0602646624.md): Battery · inoperative · Dec 11, 2006 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT MAINTENANCE, UPPER DECK FLOOR PATH LIGHT WILL NOT TURN ON DURING NIGHT CHECK. MAINTENANCE REMOVED AND REPLACED BATTERY. OPERATIONAL CHECKED GOOD, AIRCRAFT RETURNED TO SERVICE.
- [SDR 0602686624](https://openairdocs.org/sdr/0602686624.md): Battery · inoperative · Dec 11, 2006 · N624US · Boeing 747251B · Emergency Lighting
  > DURING OVERNIGHT MAINTENANCE, B ZONE FLOOR PATH LIGHT WILL NOT RUN ON DURING NIGHT CHECK. MAINTENANCE REMOVED AND REPLACED BATTERY, AND POWER SUPPLY. OPERATIONAL CHECKED GOOD, AIRCRAFT RETURNED TO SERVICE.
- [SDR 0602696624](https://openairdocs.org/sdr/0602696624.md): Beam · corroded · Dec 1, 2006 · N624US · Boeing 747251B · Wing Main, Frame Structure
  > DURING "L" CHECK FOUND CORROSION ON THE LEFT WING TRAILING EDGE BEAM LOWER CHORD AT WBL 320. ACCOMPLISHED TEMPORARY REPAIR PER SECTION I OF EA 66-207130. PERMANENT REPAIR TO BE ACCOMPLISHED BY REPLACING LOWER CHORD PER SECTION II OF EA 66-207130 DURING NEXT
- [SDR 0602636624](https://openairdocs.org/sdr/0602636624.md): Skin · corroded · Nov 21, 2006 · N624US · Boeing 747251B · Fuselage Main, Plate/Skin
  > DURING "L" CHECK, FOUND CORROSION ON SKIN PANEL 48 AT THE JACKSCREW COMPARTMENT DOOR CUTOUT BS 2412 S47R. REPAIRED PER EA 66-208404.
- [SDR 0601396624](https://openairdocs.org/sdr/0601396624.md): Battery Pack · discharged · Jun 24, 2006 · N624US · Boeing 747251B · Emergency Lighting
  > EMERGENCY PATH LIGHT IN D-ZONE INOP. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECKED GOOD, AIRCRAFT RETURNED TO SERVICE.
- [SDR 0601386624](https://openairdocs.org/sdr/0601386624.md): Battery Pack · discharged · Jun 24, 2006 · N624US · Boeing 747251B · Emergency Lighting
  > EMERGENCY PATH LIGHT IN D-ZONE INOP. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECKED GOOD, AIRCRAFT RETURNED TO SERVICE.
- [SDR 0600376624](https://openairdocs.org/sdr/0600376624.md): Power Supply · discharged · Feb 8, 2006 · N624US · Boeing 747251B · Emergency Lighting
  > DURING LINE CHECK, FOUND ZONE A FLOOR PATH EMERGENCY LIGHTS INOP. REPLACED POWER SUPPLY AND BATTERIES. OPERATIONAL CHECK GOOD. A/C RETURNED TO SERVICE.
- [SDR 0600346624](https://openairdocs.org/sdr/0600346624.md): Web · cracked · Jan 27, 2006 · N624US · Boeing 747251B · Fuselage Miscellaneous Structure
  > DURING LINE CHECK FOUND CRACKS IN AFT CARGO ROTARY ACTUATOR SUPPORT WEB AT BS 1900 RBL 110. REPAIRED PER EA 66-204586.
- [SDR 0502006624](https://openairdocs.org/sdr/0502006624.md): Skin · cracked · Oct 28, 2005 · N624US · Boeing 747251B · Fuselage Main, Plate/Skin
  > DURING M-CHECK FOUND CRACK IN SKIN AND BEAR STRAP AT LOWER FORWARD CORNER OF NR 3 RT ENTRY DOOR CUTOUT AREA. REPAIRED PER EA 66-205513.
- [SDR 0501996624](https://openairdocs.org/sdr/0501996624.md): Skin · cracked · Oct 25, 2005 · N624US · Boeing 747251B · Fuselage Main, Plate/Skin
  > DURING M-CHECK FOUND CRACK IN SKIN AND BEAR STRAP AT UPPER AFT CORNER OF NR 3 RT DOOR CUTOUT. REPAIRED PER EA 66-205514.
- [SDR 0501966624](https://openairdocs.org/sdr/0501966624.md): Frame · cracked · Oct 20, 2005 · N624US · Boeing 747251B · Fuselage Main, Frame
  > DURING "M" CHECK, FOUND CRACK ON FRAME AT BS 520 BETWEEN S10 AND S11. REPAIRED PER EA 66-205523.
- [SDR 0501956624](https://openairdocs.org/sdr/0501956624.md): Frame · cracked · Oct 20, 2005 · N624US · Boeing 747251B · Fuselage Main, Frame
  > DURING "M" CHECK, FOUND CRACKS ON FRAME AT BS 520 BETWEEN S9 AND S11. REPAIRED PER EA 66-205522.
- [SDR 0501936624](https://openairdocs.org/sdr/0501936624.md): Bulkhead · cracked · Oct 19, 2005 · N624US · Boeing 747251B · Fuselage Main, Bulkhead
  > DURING "M" CHECK FOUND CRACK IN CANTED BULKHEAD WEB AT BS 260 ST 26L. REPAIRED PER EA 66-205518.
- [SDR 0501986624](https://openairdocs.org/sdr/0501986624.md): Frame · cracked · Oct 18, 2005 · N624US · Boeing 747251B · Fuselage Main, Frame
  > DURING M-CHECK FOUND CRACK IN FRAME AT BS 240 BETWEEN S13L AND S14L. REPAIRED PER EA 66-205837.
- [SDR 0501926624](https://openairdocs.org/sdr/0501926624.md): Intercostal · cracked · Oct 18, 2005 · N624US · Boeing 747251B · Fuselage Miscellaneous Structure
  > DURING M-CHECK FOUND CRACKS IN INTERCOSTAL ATTACHED SUPPORT CLIP AT BS 340 STR 26L. REPAIRED PER EA 66-205519.
- [SDR 0501922005](https://openairdocs.org/sdr/0501922005.md): Clip · cracked · Oct 18, 2005 · N624US · Boeing 747251B · Fuselage Miscellaneous Structure
  > DURING "M" CHECK, FOUND CRACKS IN INTERCOSTAL ATTACHED SUPPORT CLIP AT BS 340 STR 26L. REPAIRED PER EA 66-205519.
- [SDR 0501916624](https://openairdocs.org/sdr/0501916624.md): Stiffener · cracked · Oct 16, 2005 · N624US · Boeing 747251B · Nacelle/Pylon Miscellaneous Structure
  > DURING "M" CHECK, FOUND CRACK IN INBOARD STIFFENER OF NR 4 PYLON AT NAC STA 217. REPAIRED PER EA 66-205836.
- [SDR 0501946624](https://openairdocs.org/sdr/0501946624.md): Frame · cracked · Oct 16, 2005 · N624US · Boeing 747251B · Fuselage Main, Frame
  > DURING "M" CHECK, FOUND CRACK IN FRAME AT BS 2231 S26L. REPAIRED PER EA 66-205517.
- [SDR 0500036624](https://openairdocs.org/sdr/0500036624.md): Engine · bird ingestion · Jan 12, 2005 · N624US · Boeing 747251B · Turbine Engine Compressor Section
  > THE CREW ABORTED TAKEOFF AT APPROXIMATELY 100 KTS AFTER SUFFERING A BIRD STRIKE ON THE NR 1 ENGINE. MAINTENANCE INSPECTED THE ENGINE AND FOUND AN UNCONTAINED FAILURE OF A FAN BLADE HAD OCCURRED. THE ENGINE WAS REPLACED. OPERATIONAL CHECK GOOD.
- [SDR 0402026624](https://openairdocs.org/sdr/0402026624.md): Battery · inoperative · Nov 14, 2004 · N624US · Boeing 747251B · Emergency Lighting
  > DURING LINE CHECK, FOUND ZONE 'D' AND 'E' FLOOR PATH EMERGENCY LIGHTS INOPERATIVE. REPLACED POWER SUPPLY AND BATTERIES. OPERATIONAL CHECK GOOD.
- [SDR 0401846624](https://openairdocs.org/sdr/0401846624.md): Battery Pack · inoperative · Oct 4, 2004 · N624US · Boeing 747251B · Emergency Lighting
  > DURING LINE CHECK, FOUND E-ZONE FLOOR PATH EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AND POWER SUPPLY. OPERATIONAL CHECK GOOD.
- [SDR 0401456624](https://openairdocs.org/sdr/0401456624.md): Electrical Box · odor · Aug 28, 2004 · N624US · Boeing 747251B · Entertainment System
  > BURNING SMELL NOTICED IN AREA BY DOOR 3. SMELL WAS MOST PRONOUNCED IN ROWS 35-39D-G. SEB'S AT THE BOTTOM OF SEATS -E- AND -F- FELT HOT TO TOUCH. TURNED OFF ENTERTAINMENT SYSTEM POWER. FLIGHT CONTINUED AND LANDED WITHOUT INCIDENT. REPLACED SEAT 36FG SEB, N
- [SDR 0401096624](https://openairdocs.org/sdr/0401096624.md): Battery Pack · inoperative · Jun 18, 2004 · N624US · Boeing 747251B · Emergency Lighting
  > DURING LINE CHECK, FOUND D-ZONE FLOOR PATH EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK, OPERATIONAL CHECK GOOD.
- [SDR 0400756624](https://openairdocs.org/sdr/0400756624.md): Connector · loose · May 12, 2004 · N624US · Boeing 747251B · Light System Wiring
  > DURING LINE CHECK, FOUND ZONE E-FLOOR PATH EMERGENCY LIGHTS INOPERATIVE. RESEATED EMERGENCY LIGHT POWER SUPPLY CONNECTOR. OPERATIONAL CHECK GOOD.
- [SDR 0301446624](https://openairdocs.org/sdr/0301446624.md): Floorbeam · cracked · Aug 6, 2003 · N624US · Boeing 747251B · Fuselage Main, Floor Beam
  > DURING "L" CHECK FOUND CRACKS IN THE FLOORBEAM WEB, UPPER SECTION AND FRAME WEB AT BS 340 LT. THERE WERE CRACKS IN THE FLOORBEAM UPPER SECTION AT BS 340 RT. ALSO CRACKS WERE FOUND IN THE FLOORBEAM WEB, UPPER SECTION AND THE FRAME WEB AT BS 360 RT. REPAIRED I
- [SDR 0300386624](https://openairdocs.org/sdr/0300386624.md): Wire · shorted · Mar 1, 2003 · N624US · Boeing 747251B · Fire Protection System Wiring
  > During takeoff the left wing leading edge overheat light illuminated. Aircraft aborted takeoff at 110 knots resulting in 7 blown tires. Passengers were bussed from aircraft to terminal. Repaired shorted and chaffed wires and replaced switch S896. Replaced 7 wh
- [SDR 0203566624](https://openairdocs.org/sdr/0203566624.md): Service difficulty · Oct 25, 2002 · N624US · Boeing 747251B · Trailing Edge Flap Control System
  > DURING APPROACH, THE OUTBOARD TRAILING EDGE FLAPS WOULD NOT EXTEND WITH EITHER PRIMARY OR ALTERNATE SYSTEMS. DECLARED A YELLOW EMERGENCY AND FOLLOWED THE COM PROCEDURE FOR A SPLIT FLAP LANDING. AIRCRAFT LANDED WITHOUT INCIDENT. REPLACED THE OUTBOARD TRAILIN

Next page: https://openairdocs.org/deregistered/N624US-2018-01-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 = 'N624US' AND deregistration_id = 'N624US-2018-01-02'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N624US-2018-01-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.
