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 DHL2003604549Skin · damagedLT WING INBD FLAP UPPER PLATING SHOWS INTERIM REPAIR, XW 104.000 - XW 122.000 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 57-1-0 PG 1, SRM 57-7-1 FIG 1. REMOVED UPPER PLATING WITH INTERIM REPAIR IAW SRM 51-1-21 PG 1. FABRICATED NEW UPPER PLATING IAW SRM SDR DHL2003604568Angle · crackedLT HORIZ STAB INNER ANGLE CRACKED 1.000 AT XFS.30.500. REMOVED CRACKED ANGLE IAW SRM 51-1-21 PG 1. FABRICATED NEW ANGLE IAW SRM 55-1-0 PG 1. PERFORMED HEAT TREATMENT TO NEW ANGLE IAW SRM 51-1-1 PG 11,13. CLEANED, TREATED AND PRIMED AREA AND NEW ANGLE IAW SRM SDR DHL2003604718Skin · crackedLT OUTER WING INBD L/E LOWER PLATING CRACKED 1.000, AROUND STA XFS 597.500. PERFORMED MAJOR REPAIR IAW EODHL-030527, ED-3290. REMOVED FASTENERS, PERFORMED STOP HOLE ON CRACK END USING 0.250 DIA DRILL IAW EODHL-030527, ED-3290. PERFORMED NDT INSPECTION IAW DSDR DHL2003604601Skin · corrodedRT. WING OB L/E UPPER SKIN CORRODED STA. XFS.710.000 PERFORMED MAJOR REPAIR IAW EODHL-030517, ED-3306. REMOVED FASTENERS AND EXISTING DOUBLER AND FILLER IAW SRM 51-1-21 PG.1. REMOVED CORROSION IAW SRM. FOUND OUT OF LIMITS. TRIMMED OUT THE CORRODED SKIN AREA. SDR DHL2003604629Vane · elongatedLT WING CTR L/E VANE SLOT HOLES ELONGATED AT XOLDI 6.224. REMOVED FASTENERS IAW SRM 51-1-21 PG 1, SRM 51-1-20D PG 21. TRIMMED OUT THE ELONGATED HOLES SKIN AREA. CLEANED, TREATED AND PRIMED AREA. FABRICATED A REPAIR EXTERNAL DOUBLER (7075-T6 AL0.071), A FILSDR DHL2003604581Floor Panel · corrodedMAIN CARGO COMPT, CORROSION ON FLOOR PANEL SKIN STA 1160.000 TRACK NR 6. REMOVED CORROSION IAW SRM 51-1-8 PG 17,18 FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2P. FABRICATED DOUBLER IAW SRM 53-2-3 FIG 10. CLEANED, TREATED AND PRIMED AREA AND DOUBLER IAW SRM 51-1-8B.SDR DHL2003604731Frame · damagedMAIN CARGO COMPT FRAME SHOWS INTERIM REPAIR AT STA 1580.000, L-21R TO L-19R. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 2, TR 53-125, TR 53-110, SRM 51-1-1, DPS 7.00-01. TRIMMED OUT DAMAGED FRAME AND FABRICATED NEW FRAME SEGMENT AND SPLICE ANGLES 2 EA WITH IASDR DHL2003604779Frame · crackedMAIN CARGO COMPT FRAME FLANGE WITH 2.000 CRACK, STA 1580.000, L-21L - L-20L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 2, TR 53-125, TR 53-110, SRM 51-1-1. TRIMMED OUT DAMAGED FRAME AND FABRICATED NEW FRAME SEGMENT AND SPLICE ANGLES (02 EA) IASDR DHL2003604656Plate · corrodedRT OUTER WING OUTBD L/E UPPER PLATING CORRODED AT STA XW 761.000. PERFORMED MAJOR REPAIR IAW EODHL-030529, ED-3305. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. REMOVED CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 57-2-1 PG 11-12. TRIMMED ANDSDR DHL2003604749Skin · damagedLT OUTER WING CTR. EXTENDED L/E SLOT HAS ELONGATED HOLES AT STA. XFS.526.000. (MAJOR REPAIR) PERFORMED MAJOR REPAIR IAW EODHL-030550, ED-3353. REMOVED FASTENERS IAW SRM 51-1-21 PG.1. BLENDED OUT THE ELONGATED HOLES SKIN AREA IAW EODHL-030550, ED-3353. PEFORMEDSDR DHL2003604752Doubler · crackedRT OUTER WING CTR EXTENDED L/E SLOT INNER DOUBLER CRACKED (0.063) AT STA. XFS. 526.000. PERFORMED MAJOR REPAIR IAW EODHL-030532, ED-3350. REMOVED FASTENERS IAW SRM 51-1-21 PG.1. STOP DRILLED ON CRACK END (0.250 DIA) IAW EODHL-030532, ED-3350. PERFORMED EDDY SDR DHL2003604647Skin · corrodedLT HORIZONTAL STAB. LE EXTERNAL SKIN SHOWS CORROSION ON SEVERAL SPOTS AT STA. XFS.178.750. PERFORMED MAJOR REPAIR. REMOVED FASTENERS, REMOVED CORROSION ON LT HORIZ. STAB. L/E EXTERNAL SKIN IAW SRM 51-1-8 PG.17-18. FOUND OUT OF LIMITS IAW SRM 55-2-1 FIG.3. TSDR DHL2003604689Skin · crackedRT OUTER WING INBD EXTENDED L/E LOWER PLATING CRACKED 1.650 AROUND STA XFS 597.500. REMOVED FASTENERS IAW SRM 51-1-21 PG 21. PERFORMED STOP HOLE ON CRACK END USING 0.250 DIA DRILL IAW EODHL-030520, ED-3352. PERFORMED EDDY CURRENT INSPECTION IAW NDT SPM PARTSDR DHL2003604606Doubler · crackedRT OUTER WING CTR EXTENDED L/E SLOT INNER DOUBLER CRACKED 0.630 AT STA XFS 526.000. PERFORMED MAJOR REPAIR IAW EODHL-030532, ED-3350. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. STOP DRILLED THE CRACK END 0.250 DIA IAW EODHL-030532, ED-3350. CLEANED, TREATED ASDR DHL2003604553Skin · damagedINTERIM REPAIR ON TOP SURFACE OF LT WING L/E (STA XS 246.518-250.089) MAJOR REPAIR. PERFORMED MAJOR REPAIR IAW SRM 57-2-1 FIG 38, TR NR 57-85. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. TRIMMED OUT DAMAGED AREA AND FABRICATED FILLER AND DOUBLER IAW SRM 57-2-1SDR DHL2003604560Frame · crackedRT WING CENTER L/E FRAME CRACKED 1.000, XFS.366.500 (UPPER INNER). STOP DRILLED CRACK AT XFS.366.500 AND FABRICATED ANGLE DOUBLER (2024-T3 0.040) IAW SRM 57-2-0 PG.9-10. CLEANED, TREATED AND PRIMED AREA AND ANGLE DOUBLER IAW SRM 51-1-8B. INSTALLED ANGLE DOUBSDR DHL2003604545Intercostal · crackedFWD CARGO COMPT PRESSURE BULKHEAD INTERCOSTAL 1.000 AT L-31L, STA 70.000. STOP DRILLED CRACK AT L-31L, STA 70.000 AND FABRICATED DOUBLER IAW SRM 53-2-0 FIG 1B. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED DOUBLER IAW SRM 51-1-21 PG 1.SDR DHL2003604554Skin · crackedLT WING OUTBOARD L/E UPPER SKIN CRACKED 1.500 AT XFS.207.500 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 57-2-1 FIG 38, TR 57-85. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. CUT OUT DAMAGED AREA AND FABRICATED FILLER AND DOUBLER IAW SRM 57-2-1 FIG 38, TR 57-SDR DHL2003604546Frame · crackedRT OUTBD STUB WING FORMER AT STA XS. 512.000 WITH 1.000 CRACK IN IT. STOP DRILLED CRACK 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 51-1-20D PG 9, SSDR DHL2003604596Skin · crackedUPPER FUSELAGE EXTERIOR SKIN WITH 1.000 CRACK AT STA. 1745.000, L-16R - L-17R. CORR.: PERFORMED MAJOR REPAIR IAW SRM 53-2-1 PG.99-100. TRIMMED OUT DAMAGED AREA IAW SRM 53-2-1 PG.99-100. FABRICATED FILLER (7075-T6 0.063) AND INTERNAL DOUBLER (7075-T6 0.040) ANDSDR DHL2003604686Door Frame · crackedAFT LOWER CORNER OF AFT PASSENGER DOOR JAMB WITH 1.000 CRACK IN IT. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 18 SHEET 1, TR 53-134, TR 53-135, DWG 5750776, DWG SR08530021. CUT OUT DAMAGED AREA AND FABRICATED FILLER (7075-T6 AL0.080) AND (2) DOUBLERS (7075-TSDR DHL2003604558Frame · crackedRT. HORIZONTAL STABILIZER L/E INNER FRAME CRACKED 0.500 AT XFS. 47.500. (INNER PART). REMOVED FASTENERS IAW SRM 51-1-21 PG.1. STOP DRILLED CRACK AT XFS.47.500 AND FABRICATED ANGLE DOUBLER (2024-T3 0.032) IAW SRM 55-2-0 PG.7,8. CLEANED, TREATED AND PRIMED AREA SDR DHL2003604728Splice · crackedMAIN CARGO COMPT AFT SPLICE FITTING WITH 1.000 CRACK IN IT (STA 1690.000 A 1700.000, L-30L). PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1, SRM 51-1-20D PG 9, 21. REMOVED CRACKED SPLICE FITTING IAW SRM 51-1-20D PG 21. CLEANED, TREATED AND PRIMED AREA IAW SRM 5SDR DHL2003604743Skin · dentedLWR FUSELAGE SKIN WITH TWO DENTS BETWEEN STA 25.000 AND 45.000, L-24L - L-25L. PERFORMED MAJOR REPAIR IAW EODHL-030513, ED-3285. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. BLENDED OUT DAMAGED AREA IAW EODHL-030513, ED-3285. PERFORMED EDDY CURRENT INSPECTION ISDR DHL2003604563Flap · dentedRT WING OB FLAP T/E DENTED FROM STA XF 304.000 - XF 310.000. REMOVED DAMAGED T/E IAW SRM 51-1-21A PG. 4, FABRICATED NEW T/E IAW SRM 57-1-0 PG 7,SRM 57-7-1 FIG 4. CLEANED, TREATED AND PRIMED AREA AND T/E LOWER SURFACE IAW SRM 51-1-8B. INSTALLED NEW T/E IAW SRM SDR DHL2003604561Frame · crackedLT WING CENTER L/E FORMER CRACKED 0.500 AT XFS 366.500. STOP DRILLED CRACK AT XFS 366.500 AND FABRICATED ANGLE DOUBLER IAW SRM 57-2-0 PG 9-10. CLEANED, TREATED AND PRIMED ANGLE DOUBLER AND AREA IAW SRM 51-1-8B. INSTALLED ANGLE DOUBLER WITH NEW FASTENERS IAWSDR DHL2003604551Frame · crackedLT WING CENTER L/E FORMER CRACKED 0.500 AT XFS 354.000. STOP DRILLED CRACK 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 WITH NEW FASTENERS IAW SRM 51-1-20D PSDR DHL2003604572Frame · crackedRT OUTER WING INBD L/E FORMER CRACKED 0.250 AT XFS 597.500. STOP DRILLED CRACK AT XFS 597.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-20D PG 9, SRM 51-1-21 PG 1.SDR DHL2003604566Frame · crackedLT WING CENTER L/E FORMER CRACKED 0.500 AT XFS 304.000. REMOVED FASTENERS IAW SRM 51-1-21 PG 1 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 WITH NEW FASTENERS IASDR DHL2003604644Skin · damagedRT WING OUTBOARD FLAP UPPER FWD PLATING HAS AN INTERIM REPAIR, AT STA XF 345.000 - XF 350.000 (MAJOR REPAIR). REMOVED FASTENERS, TRIMMED OUT THE DAMAGED SKIN SEGMENT IAW EODHL-030508, ED-3282. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. FABRICATED A NSDR DHL2003604652Skin · damagedLT WING OUTBOARD FLAP LOWER SKIN SHOWS INTERIM REPAIR BETWEEN STA XF 415.000 AND XW 408.000 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW EODHL-030502, ED-3379. REMOVED FASTENERS IAW SRM 51-1-21 PG 1, SRM 51-1-21A PG 4. REMOVED DAMAGED SKIN PANEL IAW EODHL-030SDR DHL2003604615Skin · corrodedLT OUTER WING IB L/E CORRODED AT STA. XFS.710.000. PERFORMED MAJOR REPAIR IAW EODHL-030509, ED-3314. REMOVED FASTENERS. REMOVED CORROSION IAW SRM 51-1-8 PG.17-18. FOUND OUT OF LIMITS IAW SRM 57-2-1 PG.11-12. TRIMMED OUT CORRODED SKIN AREA IAW EODHL-030509, EDSDR DHL2003604655Plate · dentedRT OTBD FLAP LOWER PLATING HAS SEVERAL DENTS BETWEEN, STA. XF 415.000 AND XW 408.000. PERFORMED MAJOR REPAIR IAW EODHL 030512, ED-3382. REMOVED FASTENERS IAW SRM 51-1-21 PAGE1, SRM 51-1-21A PAGE4. REMVOED DAMAGED SKIN PANEL IAW EODHL 030512, ED-3382. CLEANED SDR DHL2003604665Skin · damagedLT WING INBD FLAP UPPER PLATING SHOWS INTERIM REPAIR BETWEEN STA XW 91.000 AND XW 75.500. PERFORMED MAJOR REPAIR IAW EO DHL 030506, ED 3280. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. TRIMMED OUT THE DAMAGED SKIN SEGMENT IAW EO DHL 030506, ED 3280. CLEANED, TSDR DHL2003604708Fitting · crackedMAIN CARGO COMPT BATHTUB FITTING AT STA 680.000 L-6R WITH 1.500 CRACK IN IT. PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1, SRM 51-1-20D PG 9, 21, SRM 51-1-21 PG 1. REMOVED CRACKED BATHTUB FITTING IAW SRM 51-1-20D PG 21. CLEANED, TREATED AND PRIMED AREA IAW SRSDR DHL2003604605Skin · corrodedLT WING CTR L/E UPPER SKIN SHOWS INTERIM REPAIR & CORROSION BETWEEN STA XFS 360.250 AND XFS 379.000. REMOVED FASTENERS AND INTERIM REPAIR. REMOVED CORROSION, FOUND OUT OF LIMITS. TRIMMED OUT DAMAGED AREA. PERFORMED EDDY CURRENT INSPECTION. CLEANED, TREATESDR DHL2003604646Skin · damagedRT HORIZONTAL STAB INTERIM REPAIR ON INBD L/E XFS 178.750. PERFORMED MAJOR REPAIR IAW EODHL-030504, ED-3275. REMOVED FASTENERS, EXISTING INTERIM REPAIR AND FILLER IAW SRM 51-1-21 PG 1. TRIMMED OUT DAMAGED AREA IAW EODHL-030504, ED-3275. CLEANED, TREATED ANSDR DHL2003604593Plate · wornRT WING OTBD FLAP FWD UPPER PLATING WORN ON TWO AREAS BETWEEN STA XF 213.000 TO XF 201.500 (MAJOR REPAIR). REMOVED FASTENERS. TRIMMED OUT THE DAMAGED SKIN SEGMENT IAW EODHL-030507, ED-3281. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. FABRICATED A NEWSDR DHL2003604579Intercostal · crackedLT WING T/E INTERCOSTAL WITH 2.000 CRACK IN IT AT STA. XRS.74.000. STOP DRILLED CRACK AND FABRICATED DOUBLER (2024-T3 0.040) IAW SRM 57-2-0 FIG.2. CLEANED, TREATED AND PRIMED AREA AND DOUBLER IAW SRM 51-1-8B. INSTALLED DOUBLER IAW SRM 51-1-21 PG.1.SDR DHL2003604550Skin · damagedINTERIM REPAIR ON LOWER SURFACE OF LT OUTBOARD FLAP BETWEEN XF 309.000 AND XF 333.000 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 57-1-0 PG 1, SRM 57-7-1 FIG 4. REMOVED LOWER SKIN OF LT OUTBOARD FLAP WITH INTERIM REPAIR (XF 309.000 - XF 333.000) IAW SRM 5SDR DHL2003604530Frame · crackedUPPER CARGO DOOR FORMER INNER SKIN CRACKED 1.000 AT STA 220.000, L-6,L-7L. REMOVED DAMAGED AREA FROM MAIN CARGO DOOR FORMER INNER SKIN AND FABRICATED FILLER AND DOUBLER IAW SRM 53-2-0 FIG 1D. CLEANED, TREATED AND FABRICATED AREA IAW SRM 51-1-8B. INSTALLED FILLSDR DHL2003604531Frame · crackedRT WING CTR L/E FORMER LOWER PORTION CRACKED 1.000, STA XS.466.651. STOP DRILLED CRACK 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 ON RT WING CTR L/E FORMER LWSDR DHL2003604684Door Frame · crackedAFT UPPER CORNER OF RT AFT SERVICE DOOR JAMB WITH 2 CRACKS 1.000 APPROX IN IT. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 16 SHEET 4, TR 53-131, DWG 5750776, DWG SR08530021. CUT OUT DAMAGED AREA AND FABRICATED, FILLER (7075-T6 AL0.032) (7075-T6 AL0.080) AND (SDR DHL2003604565Skin · damagedRT WING INBD FLAP UPPER PLATING HAS INTERIM REPAIR FROM XW 104.000 TO XW 115.000 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 57-1-0 PG 1, SRM 57-7-1 FIG 1. REMOVED PLATING WITH INTERIM REPAIR IAW SRM 51-1-21 PG 1, SRM 51-3-0 PG 1. FABRICATED NEW PLATING SDR DHL2003604683Door Frame · crackedA 1.000 CRACK IN FWD UPPER CORNER OF FWD SERVICE DOOR JAMB. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 14 SHEET 3, TR 53-127, DWG 5750776, DWG SR08530021. CUT OUT DAMAGED AREA; FABRICATED (2) FILLERS (7075-T6 AL0.050) (7075-T6 AL0.063) AND (2) DOUBLER (7075-TSDR DHL2003604577Skin · delaminatedRT WING NR 4 SPOILER EXTERNAL SKIN DELAMINATED. CUT OUT DAMAGED AREA IAW SRM 57-2-3 PG 14 PARAGRAPH 6B. FABRICATED PLUG AND DOUBLER IAW SRM 51-1-9 PG 4 PARAGRAPH 4. CLEANED IAW SRM 51-1-9 PG 1, PARAGRAPH 1. BONDED AND CURED IAW SRM 51-1-9 PG 2, PARAGRAPH 2. FOSDR DHL2003604539Doubler · crackedLT OUTER WING IB L/E LWR DOUBLER CRACKED 2.000, XFS.597.500. REMOVED DAMAGED DOUBLER IAW SRM 51-1-21 PG.1. FABRICATED NEW DOUBLER (7075-T6 AL 0.080) IAW SRM 57-1-0 PG.1, SRM 57-3-3 PG.16. CLEANED, TREATED AND PRIMED AREA AND DOUBLER IAW SRM 51-1-8B. INSTALLED SDR DHL2003604502Panel · delaminatedRT WING UPPER SURFACE - NR 708 FILLET OUTER SKIN DELAMINATED STA 980.000 - 1040.000. REMOVED AND REPLACED NR 708 FILLET ON RT WING UPPER SURFACE, STA 980.000 - STA 1040.000 IAW SRM 51-3-0 PG 1.SDR DHL2003604501Panel · delaminatedLT WING LWR SURFACE- LT NR 540 LWR ACCESS DOOR OUTER SKIN DELAMINATED FROM XS 475.000 - XS 507.000. REMOVED AND REPLACED LT LWR ACCESS DOOR NR 540 (STA 475.000 - 507.000) IAW SRM 51-3-0 PG 1.SDR DHL2003604559Attach Angle · crackedLT WING OUTBOARD STUB WING ATTACHING ANGLE CRACKED 1.000 AT XS 520.168. REMOVED CRACKED ATTACHING ANGLE ON LT WING OUTBOARD STUB WING AT XS 520.168 IAW SRM 51-1-21 PG 1. FABRICATED NEW ANGLE IAW SRM 57-2-0 PG 1. CLEANED, TREATED AND PRIMED NEW ANGLE AND ARE
Back to N604AL