N604AL
Service difficulty reports not matched to an aircraft · 332
They name N604AL, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. Newest first.
Query with SQL
duckdb -csv -c "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 = 'N604AL' AND registry_match IS NULL ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 = 'N604AL' AND registry_match IS NULL ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR DHL2003604535Splice Plate · brokenLT OUTER WING OTBD L/E FORMER SPLICE PLATE BROKEN AT XFS 710.000. REMOVED SPLICE PLATE IAW SRM 51-1-21 PG 1. FABRICATE NEW SPLICE PLATE IAW SRM 57-1-0 PG 2, SRM 57-3-0 FIG 20. CLEANED, TREATED AND PRIMED AREA AND NEW SPLICE PLATE IAW SRM 51-1-8B. INSTALLEDSDR DHL2003604544Frame · crackedRT WING CENTER L/E FORMER CRACKED 1.000, AT XFS 416.500 (UPPER PART). STOP DRILLED CRACK AT XFS 416.500 AND FABRICATED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED AREA AND ANGLE DOUBLER IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM SDR DHL2003604552Skin · canningLT ELEVATOR L/E UPPER EXTERNAL SKIN DEFLECTED AT XE.55.06 (OIL CANNING). PERFORMED MAJOR REPAIR IAW SRM 55-1-0 PG 1, SRM 55-4-1 FIG 1. REMOVED DEFLECTED SKIN IAW SRM 51-1-21 PG 1. FABRICATED NEW SKIN IAW SRM 55-1-0 PG 1, SRM 55-4-1 FIG 1. CLEANED, TREATED SDR DHL2003604547Doubler · crackedRT OUTER WING INBD L/E INNER LOWER DOUBLER CRACKED 2.500 AT XFS 598.500. REMOVED CRACKED INNER LOWER DOUBLER IAW SRM 51-1-21 PG 1. FABRICATED NEW INNER LOWER DOUBLER IAW SRM 57-1-0 PG 1, SRM 57-3-3 PG 26. CLEANED, TREATED AND PRIMED AREA AND NEW INNER LOWERSDR DHL2003604543Skin · damagedLT WING OUTBD L/E UPPER PLATING SHOWS ELONGATED HOLE AT XFS.710.000 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 57-2-1 FIG.38. REMOVED FASTENERS IAW SRM 51-1-21 PG.1, SRM 51-1-20D PG.21. CUT OUT DAMAGED AREA IAW SRM 57-2-1 FIG.38. FABRICATED FILLER (7075-T6SDR DHL2003604542Frame · crackedRT OUTER WING OB L/E FRAME CRACKED (0.500) STA. XFS.753.000. STOP DRILLED CRACK AT XFS.753.000 AND FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG.9-10. CLEANED,TREATED AND PRIMED AREA AND ANGLE DOUBLER IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SSDR DHL2003604528Doubler · crackedRT OUTER WING INDB L/E INTERNAL DOUBLER CRACKED .500, STA XFS.572.500. PERFORMED MAJOR REPAIR IAW SRM 57-1-0 PG 1 & SRM 57-3-3 FIG 6. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. REMOVED DAMAGED INTERNAL DOUBLER IAW SRM 57-3-3 FIG 6. FABRICATED NEW INTERNAL DOUBLERSDR DHL2003604526Gusset · crackedMAIN CARGO COMPT - GUSSET CRACKED 0.250 AT STA 1347.000, L-7R. REMOVED CRACKED GUSSET IAW SRM 51-1-21 PG 2. FABRICATED NEW GUSSET (7075-T6 AL0.071) IAW SRM 53-2-0 PG 2. CLEANED, TREATED AND PRIMED AREA AND NEW GUSSET IAW SRM 51-1-8B. INSTALLED NEW GUSSET ISDR DHL2003604527Frame · crackedLT WING - OUTBOARD STUB WING FORMER CRACKED 0.500 AT XS 539.000. STOP DRILLED CRACK AT XS 539.000 AND FABRICATED DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED ANGLE DOUBLER AND AREA IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SDR DHL2003604794Cargo Track · deterioratedMAIN CARGO COMPT NR 1 TRACK WITH LUGS (02 EA) DETERIORATED, STA 116.000 - STA 118.000. REMOVED DAMAGED NR 1 TRACK PLUG IAW SRM 51-3-0 PG 1. FABRICATED NEW TRACK PLUG IAW SRM 53-2-3 PG 17-19. INSTALLED NEW PLUG ON NR 1 TRACK IAW SRM 53-2-3 PG 17-19, SRM 51-3SDR DHL2003604792Seat Track · wornMAIN CARGO COMPT NR 4 TRACK LUGS WORN AT SEVERAL SPOTS STA 950.000-610.000. REMOVED NR 4 TRACK DAMAGED SEGMENT IAW SRM 53-2-3 PG 49-50. FABRICATED SPLICES IAW SRM 53-2-3 PG 49-50. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED NEW TRACK SEGMENT ANDSDR DHL2003604537Frame · crackedRT OUTER WING INBD L/E FORMER CRACKED 0.250) STA XFS 566.250. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B AND INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51-1-20D PG 9, SRM 51-1-SDR DHL2003604538Frame · crackedRT OUTER WING INBD L/E FORMER CRACKED 0.250 STA XFS 691.250. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 51-1-20D PG 9-10, SRM 51-1-20D, SRM 51-1-21 PG SDR DHL2003604533Doubler · crackedRT WING- CTR L/E INNER PART DOUBLER CRACKED, XFS 322.750. REMOVED CRACKED DOUBLER IAW SRM 51-1-21 PG 1, IAW SRM 51-1-20D PG 21. FABRICATED NEW DOUBLER IAW SRM 57-1-0 PG 1, SRM 57-3-3 PG 14. CLEANED, TREATED AND PRIMED DOUBLER IAW SRM 51-1-8B. INSTALLED DOUSDR DHL2003604532Frame · crackedRT OUTER WING OTBD L/E FORMER CRACKED 0.250 STA XFS 59.500. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, 51-2-20D PG 9, SRM 51-1-21 PG 1.SDR DHL2003604534Frame · crackedRT OUTER WING OUTBOARD L/E FORMER CRACKED (0.250) STA XFS 747.500. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51-1-20D PG 9, SRM 51SDR DHL2003604536Frame · crackedRT OUTER WING INBOARD L/E FORMER CRACKED (0.250) STA XFS 703.750. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51-1-20D PG 9, SRM 51-SDR DHL2003604541Frame · crackedRT WING OUTBD. L/E FORMER 0.250 CRACKED AT STA. XFS.797.000. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG.9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG.9-10, SRM 51-1-20D PG.SDR DHL2003604529Skin · dentedLT HORZ STAB L/E OUTER PLATING DENTED, STA XFS 241.250 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 55-2-1 FIG 4. CUT OUT DAMAGED AREA OF LT HORZ STAB L/E OUTER PLATING IAW SRM 55-2-1 FIG 4. FABRICATED FILLER AND DOUBLER IAW SRM 55-2-1 FIG 4. CLEANED, TRSDR DHL2003604524Frame · crackedLT WING INBOARD L/E FORMER AT STA XFS 591.250 WITH 0.500 INCH CRACK. STOP DRILLED CRACK AT STA XFS 591.250 AND FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED AREA AND ANGLE DOUBLER IAW SRM 51-1-8B. INSTALLED ANGSDR DHL2003604521Frame · crackedLT OUTER WING INBOARD L/E FORMER CRACKED (0.500 INCH) STA XFS 628.750. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 5SDR DHL2003604525Frame · crackedLT WING INBOARD L/E FORMER AT STA XFS 691.250 CRACKED 0.500 INCH. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51-1-2SDR DHL2003604519Frame · crackedLT OUTER WING INBOARD L/E FORMER CRACKED 0.500 INCH, STA XFS 635.00. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51-1SDR DHL2003604522Frame · crackedLT WING INBOARD L/E FORMER AT STA XFS 672.500 CRACKED 0.500 INCH. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51-1-2SDR DHL2003604517Frame · crackedLT WING INBOARD L/E FORMER WITH 0.500 INCH CRACK STA XFS 610.000. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER (2024-T3 0.040) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51-1-2SDR DHL2003604523Frame · crackedLT OUTER WING INBOARD L/E FORMER CRACKED (0.500 INCH), STA 653.750. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51-1SDR DHL2003604520Frame · crackedLT OUTER WING INBOARD L/E FORMER CRACKED 0.500 INCH, STA XFS 641.250. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51SDR DHL2003604509Frame · crackedLT WING INBOARD L/E FORMER AT STA XFS 585.000 WITH 0.500 INCH CRACK. STOP DRILLED CRACK AT STA XFS.585.000, FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED AREA AND DOUBLER IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLESDR DHL2003604514Frame · crackedLT WING OUTBOARD L/E FORMER AT STA XFS 741.250 CRACKED 0.500 INCH. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER (2024-T3 AL0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51-SDR DHL2003604508Frame · crackedLT OUTER WING INBOARD L/E FORMER CRACKED 0.500 INCH, STA XFS 622.500. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51SDR DHL2003604507Frame · crackedLT WING INBOARD L/E FORMER WITH 0.500 INCH CRACK STA XFS 578.750. STOP DRILLED CRACK AT STA XFS 578.750 AND FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED AREA AND ANGLE DOUBLER IAW SRM 51-1-8B. INSTALLED ANGLE SDR DHL2003604510Frame · crackedLT WING INBOARD L/E FORMER AT STA XFS 597.000 WITH 0.500 INCH CRACK. STOP DRILLED CRACK AND FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51-SDR DHL2003604540Skin · damagedLT OUTER WING OUTBOARD L/E UPPER SKIN SHOWS INTERIM REPAIR, XFS 766.250 - XFS 778.750 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 57-2-1 FIG 38. REMOVED INTERIM REPAIR IAW SRM 51-1-21 PG 1. FABRICATED DOUBLER IAW SRM 57-2-1 FIG 38. CLEANED, TREATED AND SDR DHL2003604511Frame · crackedLT WING CTR L/E FORMER WITH 0.500 INCH CRACK IN IT, STA XS 461.372. STOP DRILLED CRACK AND FABRICATED DOUBLER ANGLE (2024-T3 AL0.040) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED AREA AND DOUBLER ANGLE IAW SRM 51-1-8B. INSTALLED DOUBLER ANGLE ON LT WSDR DHL2003604505Frame · crackedRT WING - CTR L/E INNER PART FORMER CRACKED 1.000, XFS 502.500 (UPPER PART). STOP DRILLED CRACK AND FABRICATED DOUBLER ANGLE (2024-T3 AL0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED AREA AND DOUBLER ANGLE IAW SRM 51-1-8B. INSTALLED DOUBLER ANGLSDR DHL2003604513Frame · crackedLT WING CTR L/E FORMER WITH 0.500 INCH CRACK STA XS 478.897. STOP DRILLED CRACK AND FABRICATED DOUBLER ANGLE (2024-T3 AL0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED AREA AND DOUBLER ANGLE IAW SRM 51-1-8B. INSTALLED DOUBLER ANGLE AT XS 478.897 SDR DHL2003604506Frame · crackedRT WING CTR L/E INNER PART FORMER CRACKED 1.000 INCH, XFS 316.500. STOP DRILLED CRACK AND FABRICATED DOUBLER ANGLE (2024-T3 AL0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED AREA AND DOUBLER ANGLE IAW SRM 51-1-8B. INSTALLED DOUBLER ANGLE ON RT WISDR DHL2003604504Frame · crackedLT WING CTR L/E FORMER WITH 0.500 INCH CRACK STA XS 491.193. STOP DRILLED AND FABRICATED DOUBLER ANGLE (2024-T3 0.040) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED AREA AND DOUBLER ANGLE IAW SRM 51-1-8B. INSTALLED DOUBLER ANGLE ON LT WING CTR L/E FORSDR DHL2003604503Frame · crackedLT WING OUTBOARD L/E FORMER AT STA XFS 835.000 CRACKED 0.500 INCH. STOP DRILLED CRACK AND FABRICATED DOUBLER ANGLE (2024-T3 AL0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED AREA AND DOUBLER ANGLE IAW SRM 51-1-8B. INSTALLED DOUBLER ANGLE AT XFS 8SDR DHL2003604518Frame · crackedLT WING OUTBOARD L/E FORMER AT STA XFS 722.500 CRACKED 0.500 INCH. STOP DRILLED CRACK AND FABRICATED DOUBLER ANGLE (2024-T3 AL0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED AREA AND DOUBLER ANGLE IAW SRM 51-1-8B. INSTALLED DOUBLER ANGLE AT XFS 7SDR DHL2003604516Frame · crackedLT WING OUTBOARD L/E FORMER AT STA XFS 735.000 CRACKED 0.500 INCH. STOP DRILLED CRACK AND FABRICATED ANGLE-DOUBLER (2024-T3 AL0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51-SDR DHL2003604515Frame · crackedLT WING OUTBOARD L/E FORMER AT STA XFS 866.250 CRACKED 0.500 INCH. STOP DRILLED CRACK AT XFS 866.250. FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-SDR DHL2003604512Frame · crackedLT WING OUTBOARD L/E FORMER AT STA XFS 797.500 CRACKED 0.500 INCH. STOP DRILLED CRACK AND FABRICATED ANGLED DOUBLER (2024-T3 0.032) IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10, SRM 51-1SDR DHL2003604707Skin · corrodedLT INNER WING CENTER EXTENDED L/E UPPER SKIN CORRODED AROUND STA. XFS.341.500 TO XOLDI 6.2246. REMOVED FASTNERS. REMOVED CORROSION FOUND OUT OF LIMITS. TRIMMED OUT CORRODED AREA. PERFORMED NDT INSPECTION IAW DC8 NDT SPM PART 06-10-01-001. CLEANED, TREATED ANDSDR DHL2003604750Skin · damagedLT WING CTR. L/E VANE SLOT HOLES ELONGATED AT XOLDI 6.224 PERFORMED MAJOR REPAIR IAW EODHL-030544, ED-3301. REMOVED FASTENERS IAW SRM 51-1-21 PG.1, SRM 51-1-20D PG.21. TRIMMED OUT ELONGATED HOLES SKIN AREA IAW EODHL-030544, ED-3301. PERFORMED EDDY CURRENT INSPSDR RRXA010014Accumulator · lowON TAKEOFF ROLL AIRPLANE YAWED TO THE LEFT UNCONTROLLABLE, ALL ENGINE PARAMETERS WERE EQUAL AND THROTTLES ALIGNED MAX SPEED WAS 70 KNOTS F/O HAD FULL RIGHT RUDDER APPLIED. INSPECTED NOSE GEAR FOUND FWD ACCUMALTOR LOW NOSE STEERING SERVICED FWD NOSE STEERING SDR RRXA001074Skin · damagedTHERE''S A HALF DOLLAR HOLE AT BOTTOM OF DOOR LEVEL APPROXIMATELY TWO FEET AFT. APPEARS TO HAVE BEEN MADE BY ENTRANCE STAIRS IN DAYTON, DOES NOT MATCH STAIR HEIGHT AT MCO. REMOVED DAMAGE AND INSTALLED DOUBLER IAW MM 53-2-1 FIG 7 PG 115.SDR RRXA000190Relay · failedON T/O DURING ROTATION, STICK SHAKER WENT OFF AT 5-8 DEG OF ROTATION. ON APPROACH AND LANDING STICK SHAKER WENT OFF CONTINUOUSLY BELOW 180 KIAS AND STOPPED RINGING/SHAKING AT GROUND SHIFT. REMOVED AND REPLACED STALL WARN MODE TRANSFER RELAY R2-351, OPS CKS GSDR RRXA000189Transducer · malfunctionedON T/O DURING ROTATION, STICK SHAKER WENT OFF AT 5 DEG - 8 DEG OF ROTATION. ON LANDING AND APPROACH STICK SHAKER WENT OFF CONTINUOUSLY BELOW 160 KIAS. REMOVED AND REPLACED LIFT TRANSDUCER AND STALL WARNING COMPUTER. SYSTEM OPS CHECK NORMAL IAW DC-8 MM CHAPTSDR RRXA991478Fitting · crackedDURING A POST-FLIGHT, FOUND RIGHT WING INBOARD AILERON HINGE FITTING CRACKED BEYOND LIMITS. REMOVED CRACKED FITTING, RECEIVED NEW FITTING AND INSTALLED IAW DC-8 MM CHAPTER 57. OPERATIONS CHECKS GOOD.
Back to N604AL