N662AW
Service difficulty reports · 307
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 = 'N662AW' AND registry_match = 'registration' 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 = 'N662AW' AND registry_match = 'registration' 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 AALA201711209007Hinge Fitting · excess playEXCESSIVE PLAY ON THE RIGHT ELEVATOR NR 3 HINGE FITTING BEARING, ON THE RIGHT HORIZONTAL STABLIZER. REPLACED THE HINGE FITTING IAW AMM 55-16-42.SDR AALA201711289040Bolt · corrodedCORROSION FOUND ON THE SLAT TRACK NR 5 LOWER AFT BOLT ON LEFT WING. REPLACED SLAT TRACK BOLT IAW AMM 27-84-64.SDR AALA201711279054Bolt · wornWORN THREAD ON SLAT TRACK 3 LOWER AFT BOLT ON RIGHT WING. REPLACED LOWER AFT BOLT IN SLAT 1 TRACK 3 ON RIGHT WING IAW 27-84-63-400-002-A.SDR AALA201711279040Hinge Fitting · looseAIRCRAFT IN BASE MAINTENANCE. LOOSE BEARING ON MAIN DOOR ON LEFT HAND MAIN LANDING GEAR. REPLACED FORWARD HINGE ASSEMBLY WITH BEARING IN DOOR PER CMM 52-81-18.SDR AALA201711209006Hinge Arm · excess playEXCESSIVE PLAY ON THE RIGHT ELEVATOR NR 1 HINGE ARM FITTING BEARING NR 1 ON RIGHT HORIZONTAL STABILIZER. REPLACED HINGE ARM FITTING IAW AMM 55-16-42.SDR AALA201711289043Hinge Arm · looseLOOSE BEARING HINGE ARM NR 7 ON VERTICAL STABILIZER. REPLACED THE HINGE ARM AND FASTENERS IAW SRM 51-72-11.SDR AALA201712049018Strut · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON RIGHT HAND WING INBOARD FLAP INTERCONNECTING STRUT BETWEEN RIB9 AND 11. REPLACED FLAP INTERCONNECTING STRUT PER AMM 27-51-11SDR AALA201712049017Strut · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON LEFT HAND WING INTERCONNECTING STRUT INBOARD FLAP. REPLACED INTERCONNECTING STRUT PER AMM 27-51-44.SDR AALA201711289050Floor Panel · delaminatedDELAMINATION FOUND ON THE FLOOR PANEL 151PF. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011.SDR AALA201711289049Floor Panel · delaminatedDELAMINATION FOUND ON THE FLOOR PANEL 131AF. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011.SDR AALA201711289048Floor Panel · delaminatedDELAMINATION FOUND ON THE FLOOR PANEL 151EF. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011.SDR AALA201711289038Floor Panel · delaminatedDELAMINATION ON FLOOR PANEL 152BF. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011, FIGURE 20109, AND IRM 9701 REVISION G.SDR AALA201711279020Floor Panel · delaminatedDELAMINATION ON FLOOR PANEL 222CF. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006, FIGURE 20106, AND IRM 9701 REVISION G.SDR AALA201711279057Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 231BF. REPLACED FLOOR PANEL PER SRM 53-12-00-300-006.SDR AALA201711279055Support Frame · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION FOUND ON SUPPORT FRAME BETWEEN FR 69 AND 70. REPLACED SUPPORT FRAME PER SRM 51-72-11.SDR AALA201712049016Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION ON AFT GALLEY FLOOR PANEL 261DF. REPLACED FLOOR PANEL PER AMM 53-42-12-400-002-A.SDR AALA201712059010Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION OF FLOOR PANEL 231AF AT FORWARD GALLEY BETWEEN FR 21 AND FR 22 AT LEFT BUTTLINE Y+1254 AND RIGHT BUTTLINE Y-1254. REPLACED FLOOR PANEL 231AF AT FORWARD GALLEY BETWEEN FR 21 AND FR 22 AT LEFT BUTTLINE Y+1254 AND RIGHT SDR AALA201711299013Floor Panel · delaminatedDELAMINATION FOUND ON FLOOR PANEL 261PF IN THE AFT GALLEY AREA. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011.SDR AALA201711289047Floor Panel · delaminatedDELAMINATION FOUND ON THE FLOOR PANEL 261BG. REPLACED THE FLOOR PANEL IAW SRM 53-02-00-300-011.SDR AALA201711289046Floor Panel · delaminatedDELAMINATION FOUND ON THE FLOOR PANEL 221PF. REPLACED THE FLOOR PANEL IAW SRM 53-12-00-300-006.SDR AALA201711279056Support · corrodedCORROSION FOUND ON LOWER SILL AT STRINGER 23R BETWEEN FRAMES 16 AND 20, FORWARD GALLEY AREA. REPAIRED CORRODED AREA IAW SRM 53-11-14-283-005.SDR AALA201711279045Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 222EF. REPLACED FLOOR PANEL PER SRM 53-12-00-300-006.SDR AALA201711279042Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 221DF. REPLACED FLOOR PANEL PER SRM 53-12-00-300-006.SDR AALA201711279039Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 261HG. REPLACED FLOOR PANEL PER SRM 53-02-00-300-011.SDR AALA201711279023Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 221EF AT FORWARD GALLEY AREA. REPLACED FLOOR PANEL PER SRM 53-12-00-300-006SDR AALA201711279022Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 262BG AT AFT GALLEY AREA. REPLACED FLOOR PANEL PER SRM 53-12-00-300-006.SDR AALA201711289041Cover · corrodedCORROSION FOUND ON THE FORWARD GALLEY DUMMY RAIL JOINT COVER AT-Y81 BETWEEN FRAMES 12 AND 16. REPLACED THE DUMMY RAIL JOINT COVER IAW SRM 51-72-11, AND DRAWING D53112829.SDR AALA201711279044Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 211FF. REPLACED FLOOR PANEL PER SRM 53-12-00-300-006.SDR AALA201711279043Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 241KF. REPLACED FLOOR PANEL PER SRM 53-02-00-300-011.SDR AALA201711279041Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 242HF. REPLACED FLOOR PANEL PER SRM 53-02-00-300-011.SDR AALA201711279027Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 241JF. REPLACED FLOOR PANEL PER SRM 53-02-00-300-011.SDR AALA201711279026Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 212EF. REPLACED FLOOR PANEL PER SRM 53-12-00-300-006.SDR AALA201711279025Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 241EF. REPLACED FLOOR PANEL PER SRM 53-02-00-300-011.SDR AALA201711279024Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. DELAMINATION FOUND ON FLOOR PANEL 232UF. REPLACED FLOOR PANEL PER SRM 53-02-00-300-011.SDR AALA201712069021Shear Plate · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON SHEAR PLATE AT STR 23R BETWEEN FR 69 & FR 70 AT AFT GALLEY AREA. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA201712049019Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK ON AFT GALLEY SHEAR PLATE AT STRINGER 23L BETWEEN FR69 TO FR70. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA201712059011Skin · saturatedAIRCRAFT IN BASE MAINTENANCE. TRAPPED WATER INDICATED ON RUDDER LEFT HAND SIDE PANEL AROUND UPPER HOIST POINT AT LEVEL OF TRAILING EDGE FASTENER 20 ON VERTICAL STABILIZER. REPAIRED RUDDER LEFT SIDE PANEL AROUND UPPER HOIST POINT AT LEVEL OF TRAILING EDGE FASTESDR AALA201711289042Floor Support · corrodedCORROSION FOUND THE ON FLOOR SUPPORT BETWEEN FRAMES 12 AND 24, -Y254 IN FORWARD GALLEY. REPLACED THE FLOOR SUPPORT IAW SRM 51-72-11, AND DRAWING D53111462.SDR AALA201711289045Seat Track · corrodedCORROSION FOUND ON THE SEAT TRACK BETWEEN FRAMES 12 AND 24 ON THE RIGHT SIDE. REPLACED THE SEAT TRACK IAW SRM 51-72-11.SDR AALA201711289044Seat Track · corrodedCORROSION FOUND ON THE SEAT TRACK BETWEEN FRAMES 12 AND 24 ON THE RIGHT SIDE. REPLACED THE SEAT TRACK IAW SRM 51-72-11.SDR AALA201711279053Support · corrodedCORROSION FOUND ON LOWER SILL AT LEVEL OF STRINGER 23 RIGHT, FRAME 68 AT AFT GALLEY AREA. PERFORMED PERMANENT REPAIR LOWER SILL PER SRM A320 53-41-14-300-001.SDR AALA201711219015Seat Track · corrodedCORROSION ON AFT GALLEY SEAT TRACK, Y765 BETWEEN FRAMES 64 AND 66 PLUS 5 INCHES. REPLACED THE SEAT TRACK IAW SRM 51-72-11 AND DRAWING D53472815.SDR AALA201711219014Floor Support · corrodedCORROSION ON AFT GALLEY FLOOR SUPPORT AT -Y1292 BETWEEN FRAMES 64 TO 66 PLUS 5 INCHES. REPLACED THE FLOOR SUPPORT IAW SRM 51-72-11 AND DRAWING D53472816.SDR AALA201711209009Seat Track · corrodedCORRODED SEAT TRACK Y1292 BETWEEN FRAMES 64 TO 66 PLUS 5 INCHES. REPLACEDTHE SEAT TRACK IAW SRM 51-72-11, AND DRAWING D53472815.SDR AALA201711209008Floor Support · corrodedCORRODED FLOOR SUPPORT Y254 AT FORWARD GALLEY AREA BETWEEN FRAMES 12 TO 24. REPLACED THE FLOOR SUPPORT IAW SRM 51-72-11, AND DRAWING D53110920.SDR AALA201711209005Support · corrodedCORRODED LOWER SUPPORT AT STRINGER 23L BETWEEN FRAMES 66 & 68. REPAIRED THE SUPPORT IAW SRM 53-41-14-300-001.SDR AALA201711209004Dummy Rail · corrodedCORRODED DUMMY RAIL Y503.2 BETWEEN FRAMES 12 & 16 AT FORWARD GALLEY AREA. REPLACED THE DUMMY RAIL IAW SRM 51-72-11, DRAWING D53112825, AND DRAWING D53110984.SDR AALA201711169010Web · corrodedCORROSION ON THE WEB AT STRINGER 23R AND FRAME 20. REPLACED THE WEB IAW SRM 51-72-11 AND DRAWING D53112784.SDR AALA201712059012Beam · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK INDICATION ON FRAME 36 AT OPEN FASTENER HOLE (A) INBOARD LOCATED PRESSURE PANEL LONGITUDINAL BEAMS LEFT HAND SIDE IN FORWARD CARGO COMPARTMENT AT LEFT BUTTLINE +Y1292. REPAIRED ON FRAME 36 AT OPEN FASTENER HOLE (A) INBOARD LSDR AALA201712069002Annular Shell · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED SIDE SHELL ON FR 35 AT LEVEL OF STRINGER 30 LEFT HAND IN FORWARD CARGO COMPARTMENT. REPAIRED SIDE SHELL ON FR 35 AT LEVEL OF STRINGER 30 LEFT HAND IN FORWARD CARGO COMPARTMENT PER EA 275042.
Back to N662AW