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 DHL2003604580Tee Fitting · crackedRT OUTBD FLAP TEE ANGLE 2.000 CRACKED (FLAP JOINT AREA) STA XF 165.000. REMOVED DAMAGED TEE ANGLE IAW SRM 51-1-21 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TEE ANGLE IAW SRM 51-1-21 PG 1.SDR DHL2003604609Fitting · corrodedAFT CARGO COMPT CLIP RETAINER FITTING CORRODED, STA 1380.000 - STA.1400.000 LBL 8. REMOVED CORRODED FITTING IAW SRM 51-1-21 PG 1. REMOVED CORROSION ON AFT CARGO COMPT CLIP RETAINER FITTING STA 1380.000 - STA.1400.000, LBL 8 IAW SRM 51-1-8 PG 17-18. FOUND OUT SDR DHL2003604713Fitting · crackedMAIN CARGO COMPT FITTING CRACKED AT STA 1170.000, L-21R. PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1, SRM 51-1-20D PG 9, 21. REMOVED CRACKED FITTING IAW SRM 51-1-20D PG 21. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW FITTING WITH NEW FASSDR DHL2003604736Fitting · crackedMAIN CARGO COMPT FITTING CRACKED AT STA 1170.000, L-21R. PERFORMED MAJOR REPAIR IAW SRM 51-1-20D PG 9, 21. REMOVED CRACKED FITTING IAW SRM 51-1-20D PG 21. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW FITTING WITH NEW FASTENERS IAW SRM 51SDR DHL2003604771Skin · corrodedRT INNER WING CTR EXTENDED L/E UPPER SKIN CORRODED AROUND STA XFS 354.000 - XFS 385.250. REMOVED FASTENERS. REMOVED CORROSION, FOUND OUT OF LIMITS. TRIMMED OUT THE CORRODED SKIN AREA. PERFORMED NDT INSPECTION. CLEANED, TREATED AND PRIMED AREA. FABRICATEDSDR DHL2003604638Skin · damagedINTERIM REPAIR ON UPPER SKIN OF LT INBOARD FLAP, BETWEEN STA XW.2.000 - XW.91.000 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW EODHL-030566, ED-3396. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. REMOVED DAMAGED SKIN PANEL IAW EODHL-030566, ED-3396. CLEANED, TREATSDR DHL2003604673Skin · damagedINTERIM REPAIR (2 INCH X 1 INCH) AND WEAR AROUND STA. 32.000 LT LWR SIDE OF FWD PASS. DOOR EXTERNAL SKIN. PERFORMED MAJOR REPAIR IAW EODHL-030559, ED-3297. REMOVED FASTENERS AND INTERIM REPAIR IAW SRM 51-1-21 PG.1. CUT OUT DAMAGED AREA IAW EODHL-030559, ED-32SDR DHL2003604685Door Frame · damagedINTERIM REPAIR ON FWD UPPER CORNER OF FWD PASSENGER DOOR JAMB. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 15 SHEET 4, TR 53-129, DWG 5750776, DWG SR08530021. CUT OUT DAMAGED AREA AND FABRICATED FILLER (7075-T6 AL0.050) AND (2) DOUBLERS (7075-T6 AL0.063) (7075SDR DHL2003604702Door Frame · damagedINTERIM REPAIR ON AFT LWR CORNER OF FWD SERVICE DOOR JAMB. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 14, SHEET 2, TR 53-127, DWG 5750776, DWG SR08530021. REMOVED INTERIM REPAIR IAW SRM 51-1-21 PG 1. CUT OUT DAMAGED AREA AND FABRICATED FILLER AND 2 DOUBLERS SDR DHL2003604657Plate · dentedLT WING INBD FLAP LOWER PLATING HAS DENTS ON SEVERAL SPOTS BETWEEN STA XW 5.000 AND XW115.250. PERFORMED MAJOR REPAIR IAW EODHL-030568, ED-3293. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. REMOVED DAMAGED SKIN PANEL IAW EODHL-030568, ED-3293. CLEANED, TREATED ASDR DHL2003604557Panel · delaminatedRT WING T/E LWR PANEL EXTERNAL SKIN DELAMINATED BETWEEN STA XRS 162.000 AND XF 219.000. REMOVED AND REPLACED RT WING T/E LWR PANEL (STA XRS 162.000 - XF 219.000) IAW SRM 51-3-0 PG 1.SDR DHL2003604555Panel · delaminatedLT WING T/E LWR PANEL EXTERNAL SKIN DELAMINATED AT STA XRS 219.000. REMOVED AND REPLACED LT WING T/E LWR PANEL AT STA XFS 219.000 IAW SRM 51-3-0 PG 1.SDR DHL2003604687Door Frame · damagedINTERIM REPAIR ON FWD LWR CORNER OF AFT PASSENGER DOOR JAMB. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 18, SHEET 2, TR 53-135, DWG 5750776, DWG SR08530021. REMOVED INTERIM REPAIR AND EXISTING DOUBLER IAW SRM 51-1-21 PG 1. FABRICATED (2) DOUBLERS IAW SRM 53-SDR DHL2003604668Skin · dentedLT ELEVATOR UPPER EXTERNAL SKIN HAS SEVERAL DENTS FROM STA XE 132.000 TO XE 246.000 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW EO DHL 030501, ED 3277. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. REMOVED DAMAGED SKIN PANEL IAW EO DHL 030501, ED 3277. CLEANED, TSDR DHL2003604776Attach Fitting · corrodedFWD ACCESSORY COMPT FITTING ATTACHING FLOORBEAM TO CUSP EXTRUSION AT STA 25.000 L-21R CORRODED. PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1, SRM 51-1-20D PG 9, 21, SRM 51-3-0 PG 1. REMOVED CORROSION FROM FITTING IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS ISDR DHL2003604766Attach Fitting · corrodedFWD ACCESSORY COMPT FITTING ATTACHING FLOORBEAM TO FRAME AT STA 35.000 L-21R CORRODED. PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1, SRM 51-1-20D PG 9, 21. REMOVED CORROSION FROM FITTING IAW SRM 51-1-8 PG 17-18. FOUND OUT OF ALLOWABLE LIMITS IAW SRM 53-2-0 PGSDR DHL2003604567Skin · crackedFWD SERVICE DOOR UPPER AFT PART INNER SKIN CRACKED 1.000. STOP DRILLED CRACK AND FABRICATED DOUBLER IAW SRM 52-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 DHL2003604571Skin · delaminatedRT WING T/E LOWER PANEL EXT. SKIN DELAMINATED (NR 540 ACCESS) REMOVED AND REPLACED LOWER PANEL ON RT WING T/E (NR 540 ACCESS) IAW SRM 51-3-0 PG.1SDR DHL2003604660Skin · corrodedLT WING CTR LE UPPER PLATING HAS CORROSION AND INTERIM REPAIR FROM STA XFS 341.500 TO XW 257.000). REMOVED INTERIM REPAIR AND FASTENERS. REMOVED CORROSION ON LT WING CTR L/E UPPER PLATING. FOUND OUT OF LIMITS. TRIMMED OUT THE CORROSION SKIN AREA IAW EO DHLSDR DHL2003604733Attach Fitting · crackedMAIN CARGO COMPT. FITTING CRACKED 2.000 AT STA.1187.000, L-21R. PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG.1, SRM 51-1-20D PG.9,21. REMOVED CRACKED FITTING IAW SRM 51-1-20D PG.21. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW FITTING WITH NEWSDR DHL2003604698Attach Fitting · crackedMAIN CARGO COMPT. FITTING CRACKED 1.000 AT STA. 1170.000, L-21R. PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG.1, SRM 51-1-20D PG.9,21. REMOVED CRACKED FITTING IAW SRM 51-1-20D PG.21. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW FITTING WITH NESDR DHL2003604721Skin · corrodedLT WING CTR L/E UPPER PLATING HAS CORROSION AND INTERIM REPAIR FROM STA XFS 341.500 TO XW 257.000. REMOVED INTERIM REPAIR AND FASTENERS. REMOVED CORROSION ON LT WING CTR L/E UPPER PLATING, FOUND OUT OF LIMITS. TRIMMED OUT CORROSION SKIN AREA. PERFORMED EDDSDR DHL2003604651Flap · damagedRT WING INBD FLAP HAS THREE INTERIM REPAIRS FROM STA XW 2.000 CANT TO XW 91.000. PERFORMED MAJOR REPAIR IAW EO DHL 030514, ED-3300. REMOVED FASTENERS IAW SRM 51-1-21 PAGE 1. REMOVED DAMAGED SKIN PANEL IAW EO DHL 030514, ED-3300. CLEANED, TREATED & PRIMED ASDR DHL2003604556Panel · delaminatedLT WING T/E LOWER PANEL INTERNAL AND EXTERNAL SKIN DELAMINATED (NR 577B ACCESS). REMOVED AND REPLACED DELAMINATED LOWER PANEL ON LT WING T/E (NR 577B ACCESS) IAW SRM 51-3-0 PG 1.SDR DHL2003604586Skin · corrodedLT INNER WING CENTER EXTENDED L/E UPPER SKIN CORRODED AROUND STA. XFS.341.500 TO XODI 6.2245. 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 OUT CORRODED AREA. CLEANED, TSDR DHL2003604643Skin · damagedRT INBOARD SLOT VANE OUTER PLATING SHOWS ELONGATED HOLES AT STA XS 247.000. PERFORMED MAJOR REPAIR. REMOVED FASTERNERS FASTENERS IAW SRM 51-1-21 PG 1. TRIMMED OUT THE DAMAGED AREA IAW SRM 51-1-8B. FABRICATED A REPAIR EXTERNAL DOUBLER AN INTERNAL DOUBLER ANDSDR DHL2003604735Floorbeam · corrodedAFT ACCY COMPT FLOORBEAM CORRODED, STA 1640.000, LBL-5 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 1G, TR 53-124. REMOVED CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2P. CLEANED, TREATED AND PRIMED AREA IAW SRM 51SDR DHL2003604700Support Fitting · crackedRT INBD AILERON INBD SUPPORT FITTING ASSY AT STA. XA.448.000 WITH 1.000 CRACK IN IT. PERFORMED MAJOR REPAIR IAW SRM 57-1-0 PG.1, SRM 51-1-20D PG.9,21. REMOVED CRACKED FITTING IAW SRM 51-1-20D PG.21. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NSDR DHL2003604699Attach Fitting · crackedMAIN CARGO COMPT. FITTING CRACKED 1.000 AT STA. 1210.000, L-21R. PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG.1, SRM 51-1-20D PG.9,21. REMOVED CRACKED FITTING IAW SRM 51-1-20D PG.21. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW FITTING WITH NEW SDR DHL2003604671Attach Fitting · crackedLT HORIZONTAL STAB. FITTING WITH 1.000 CRACK IN IT AT FWD. LWR. SECTION STA. XFS.60.000. PERFORMED MAJOR REPAIR IAW SRM 55-1-0 PG.1, SRM 51-1-20D PG.9,21, SRM 51-1-21 PG.1. REMOVED CRACKED FITTING IAW SRM 51-1-21 PG.1. SRM 1-1-20D PG.21. CLEANED, TREATED, AND SDR DHL2003604645Vane · damagedRT WING OB SLOT VANE OUTER PLATING SHOWS ELONGATED HOLES AT STA. XOLDI.6.224. PERFORMED MAJOR REPAIR IAW EODHL-030552, ED-3292. REMOVED FASTENERS. TRIMMED OUT THE ELONGATED HOLES SKIN AREA IAW EODHL-030552, ED-3292. CLEANED, TREATED AND PRIMED AREA IAW SRM 51SDR DHL2003604694Fitting · crackedMAIN CARGO COMPT FITTING CRACKED 2.000, STA. 1177.000, L-21R. PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG.1, SRM 51-1-20D PG.9, 21. REMOVED CRACKED FITTING IAW SRM 51-1-20D PG.21. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW FITTING WITH NEW FSDR DHL2003604754Skin · damagedRT WING EXTENDED L/E OTBD VANE HAS SEVERAL ELONGATED HOLES AND INTERIM REPAIR AT STA XOLDI 67.000. REMOVED FASTENERS, REMOVED EXISTING INTERIM REPAIR. TRIMMED OUT ELONGATED HOLES SKIN AREA. PERFORMED EDDY CURRENT INSPECTION. CLEANED, TREATED AND PRIMED ARESDR DHL2003604703Fitting · crackedAFT ACCESSORY COMPT FITTING AT STA 660.000 WITH 7.000 CRACK IN IT BETWEEN L-35R AND L-36. PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1, SRM 51-1-20D PG 9, 21, SRM 51-3-0 PG 1. REMOVED CRACKED FITTING IAW SRM 51-1-20D PG 21. CLEANED, TREATED AND PRIMED AREA IASDR DHL2003604706Skin · corrodedLT OUTER WING OTBD L/E SHOWS CORROSION AT STA XW 761.000. 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 THE DAMAGED SKIN AREA IAW EODHL-030547, ED-3313. PERFORMED NDT INSPECTION, CLEASDR DHL2003604760Clip · crackedAFT ACCESSORY COMPT. CLIP ATTACHING FRAME TO SKIN AT STA. 660.000 L-22L WITH 1.500 CRACK IN IT. REMOVED CRACKED CLIP IAW SRM 51-1-20D PG.21. FABRICATED NEW CLIP (STEEL 0.500 H0.050) IAW SRM 53-1-0 PG.1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALSDR DHL2003604759Stringer Clip · crackedAFT ACCESSORY COMPT. CLIP ATTACHING FRAME TO SKIN AT STA.660.000 L-22R WITH 2.000 CRACK IN IT. REMOVED CRACKED CLIP IAW SRM 51-1-20D PG.21. FABRICATED NEW CLIP (STEEL 301 0.500 H0.050) IAW SRM 53-1-0 PG.1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTSDR DHL2003604755Skin · damagedLT WING EXTENDED L/E INBD. VANE SHOWS ELONGATED HOLES AND INTERIM REPAIR AT STA. XS.247.000. PERFORMED MAJOR REPAIR IAW EODHL-030563, ED-3312. REMOVED FASTENERS AND EXISTING DOUBLER IAW SRM 51-1-21 PG.1. TRIMMED OUT DAMAGED AREA IAW EODHL-030563, ED-3312. PESDR DHL2003604570Track · brokenD-BELLY DOOR FWD TRACK BROKEN, STA 1400.000. REMOVED BROKEN TRACK IAW SRM 51-1-21 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TRACK IAW SRM 51-1-21 PG 1. SEE N/R 0530 FOR OPS CK.SDR DHL2003604594Skin · corrodedLT OUTER WING OB L\E SHOWS CORROSION AT STA. XW.761.000. REMOVED FASTENERS IAW SRM 51-1-21 PG.1. REMOVED CORROSION ON LT OUTER WING OB. L\E IAW SRM 51-1-8 PG.17-18. FOUND OUT OF LIMITS. TRIMMED OUT THE DAMAGED SKIN AREA IAW EODHL-030547, ED-3313. CLEANED, TRESDR DHL2003604604Vane · damagedRT WING EXTENDED LE OB VANE HAS SEVERAL ELONGATED HOLES AND INTERIM REPAIR AT STA XOLDO 67. REMOVED FASTENERS. REMOVED THE EXISTING INTERIM REPAIR IAW EO DHL 030558, ED-3351. CLEANED TREATED AND PRIMED AREA IAW SRM 51-1-8B. FABRICATED AN EXTERNAL REPAIR DOUBSDR DHL2003604599Vane · damagedLT WING EXTENDED L/E INBD VANE SHOWS ELONGATED HOLES AND INTERIM REPAIR AT STA XS.247.000. PERFORMED MAJOR REPAIR IAW EODHL-030563, ED-3312. REMOVED FASTENERS AND THE EXSISTING DOUBLER IAW SRM 51-1-21 PG 1. TRIMMED OUT THE ELONGATED HOLES SKIN AREA. CLEANED, SDR DHL2003604562Frame · crackedVERTICAL STAB L/E FORMER INNER SECTION CRACKED 0.500 AT STA ZFS 104.750 LT SIDE. STOP DRILLED CRACK AT ZFS 104.750 AND FABRICATED REINFORCEMENT IAW SRM 55-2-0 FIG 2. CLEANED, TREATED AND PRIMED AREA AND REINFORCEMENT IAW SRM 51-1-8B. INSTALLED REINFORCEMENT IASDR DHL2003604548Panel · delaminatedLT WING T/E UPPER PANEL EXTERNAL SKIN DELAMINATED AT XRS 436.000. REMOVED AND REPLACED UPPER PANEL ON LT WING T/E AT XRS 436.000 IAW SRM 51-3-0 PG 1.SDR DHL2003604578Seat Track · damagedNAVIGATOR FWD SEAT TRACK WITH ELONGATED HOLES. REMOVED NAVIGATOR FWD. SEAT TRACK WITH ELONGATED HOLES IAW SRM 51-3-0 PG.1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW NAVIGATOR FWD. SEAT TRACK IAW SRM 51-3-0 PG.1SDR DHL2003604723Skin · corrodedRT INNER WING UPPER SKIN CORRODED AROUND STA XRS 184.000 BETWEEN CTR SPAR AND S-9R. REMOVED FASTENERS, FOUND OUT OF LIMITS IAW SRM 57-2-0 PG 16. BLENDED OUT DAMAGED SKIN AREA IAW EODHL-030534, ED-3356. PERFORMED NDT INSPECTION IAW DC8 NDT SPM PART 06-10-01-SDR DHL2003604775Skin · corrodedUPPER EXTERNAL FUSE SKIN CORRODED AT STA 1050.000 BETWEEN L-2R - L-2L. 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 53-2-0 PG 2P. PERFORMED EDDY CURRENT INSPECTION IAW DC8 NDT SPM PART 06-10SDR DHL2003604595Skin · corrodedRT INNER WING UPPER SKIN CORRODED AROUND STA XRS 184.000 BETWEEN CTR SPAR AND S-9R (MAJOR REPAIR). 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-0 PG 16. BLENDED OUT DAMAGED SKIN AREA IAWSDR DHL2003604598Skin · corrodedLT OUTER WING OTBD EXTENDED L/E OUTER PLATING LOWER SURFACE CORRODED AROUND STA XFS 710.000. REMOVED FASTENERS, REMOVED CORROSION, FOUND OUT OF LIMITS. TRIMMED OUT DAMAGED SKIN AREA. PERFORMED NDT INSPECTION IAW DC8 NDT SPM PART 06-10-01-001. CLEANED, TREASDR DHL2003604602Skin · damagedLT WING EXTENDED L/E OTBD. VANE SHOWS ELONGATED HOLES AND INTERIM REPAIR AT STA. XOLDI 67.000 PERFORMED MAJOR REPAIR. REMOVED FASTENERS IAW SRM 51-1-21 PG.1. REMOVED EXISTING INTERIM REPAIR AND FILLER. TRIMMED OUT DAMAGED SKIN AREA IAW EODHL-030545, ED-3302. P
Back to N604AL