N964AN
Service difficulty reports · 221
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 = 'N964AN' 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 = 'N964AN' 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 AALA20130320002Web · crackedFLOOR TO SIDE WALL SUPPORT HAS CRACKED SUPPORT WEB BETWEEN STATIONS 500B AND 500C LEFT SIDE. REMOVED AND REPLACED WEB PER AARD 51-00-05-1.SDR AALA20130319031Skin · debondedLEFT WING OUTBOARD AFT FLAP INBOARD AFT CORNER SKIN DISBONDED. ACCOMPLISHED BONDED REPAIR PER SRM 57-53-01-1A 4.SDR AALA20130319034Wedge · chafedSLAT NUMBER 5 TRAILING EDGE WEDGE LOWER SURFACE CHAFED AT SEVERAL AREAS. REPAIRED NUMBER 5 SLAT TRAILING EDGE WEDGE.SDR AALA20130319025Skin · damagedRIGHT WING INBOARD AFT FLAP LOWER SURFACE DAMAGED. REMOVED AND REPLACED RIGHT WING INBOARD AFT FLAP.SDR AALA20130319024Skin · gougedLEFT WING FIXED LADING EDGE BULLNOSE SKIN JUST INBOARD OF PYLON, GOUGED. REMOVED AND REPLACED LEFT WING FIXED LEADING EDGE BULLNOSE SKIN PANEL JUST INBOARD OF PYLON PER SRM 51-10-02-0G.SDR AALA20130319023Attach Fitting · brokenBROKEN WIRE BUNDLE ATTACH CLIP COMMON TO BODY STATION 867 FRAME BETWEEN STRINGERS 2 AND 3 RIGHT. REMOVED AND REPLACED CLIP PER SRM 51-40-02-0G.SDR AALA20130319014Web · corrodedCORROSION ON FLOOR WEB AT BODY STATION 987, RIGHT BUTTLINE 44 WATER LINE 205. REPLACED WEB PER AARD 51-00-05-1.SDR AALA20130319011Sill · corrodedCORROSION ON CUTOUT MOP SILL BETWEEN BODY STATIONS 294.5 TO 331, RIGHT BUTTLINE 59, WATERLINE 208. REPLACE MOP SEAL PER AARD 51-00-05-1.SDR AALA20130319007Bulkhead · corrodedAFT BULKHEAD LOWER CHORD HAS CORROSION AT BODY STATION 500I, STRINGER 26 RIGHT TO LEFT BUTTLINE 0, WATERLINE 155. REMOVED CORROSION AND REPAIRED PER EA B737-53-028831.SDR AALA20130318046Fairing · crackedWING TO BODY FAIRING 195CL AFT SIDE HAS ELONGATED HOLE. REPAIRED ELONGATED HOLE AND CRACK IN RADIUS OF PANEL 195CL PER SRM 53-40-70 AND SRM 51-70-05.SDR AALA20130318044Wedge · damagedNUMBER 4 SLAT TRAILING EDGE WEDGE LOWER SURFACE CHAFED AT SEVERAL AREAS. CHAFING DAMAGE REPAIRED.SDR AALA20130318043Wedge · chafedSLAT NUMBER 7 TRAILING EDGE WEDGE LOWER SURFACE CHAFED AT SEVERAL AREAS. REPAIRED CHAFED AREAS ON SLAT NUMBER 7 TRAILING EDGE LOWER SURFACE.SDR AALA20130318042Wedge · chafedSLAT NUMBER 8 TRAILING EDGE WEDGE LOWER SURFACE CHAFED AT SEVERAL AREAS. REPAIRED CHAFED AREAS ON NUMBER 8 SLAT TRAILING EDGE WEDGE LOWER SURFACE PER SRM 57-42-01.SDR AALA20130318041Plate · crackedLEFT WING HAS WIGGLE PLATE WITH CRACK AT FASTENER HOLE AT ORSS 257. REMOVED AND REPLACED WIGGLE PLATE PER AARD 51-00-5.SDR AALA20130318040Wedge · chafedSLAT NUMBER 2 TRAILING EDGE WEDGE LOWER SURFACE CHAFED AT SEVERAL AREAS. REPAIRED CHAFED AREAS ON NUMBER 2 SLAT LOWER TRAILING EDGE WEDGE.SDR AALA20130318039Support Beam · crackedLEFT WING REAR SPAR TRAILING EDGE PANEL SUPPORT BEAM COMMON TO PANEL 561AB IS CRACKED AT INBOARD FASTENER HOLE. REMOVED AND REPLACED LEFT WING REAR SPAR TRAILING EDGE PANEL SUPPORT BEAM.SDR AALA20130318021Splice · corrodedCORROSION ON AFT CARGO BAY FLOOR SPLICE AT BODY STATION 773, LEFT AND RIGHT BUTTLINES 21, WATERLINE 156. REMOVED AND REPLACED FLOOR SPLICE PER AARD 51-10-05-1.SDR AALA20130318020Splice · corrodedCORROSION ON ACB FLOOR SPLICE AT BODY STATION 727D+5, LEFT BUTTLINE 21 TO RIGHT BUTTLINE 21, WATERLINE 156. REPLACED ACB FLOOR SPLICE PER AARD 51-10-05-1.SDR AALA20130318019Splice · corrodedCORROSION ON ACB FLOOR SPLICE AT BODY STATION 727I+5, LEFT BUTTLINE 21 TO RIGHT BUTTLINE 21, WATERLINE 156. REPLACED SPLICE PER AARD 51-10-05-1.SDR AALA20130318018Threshold · scratchedFCB DOOR CUTOUT THRESHOLD WEB UPPER SURFACE HAS SCRATCHES AT BODY STATIONS 446 TO 490, RIGHT BUTTLINES 24 TO 27. REMOVED AND REPLACED WEB PER AARD 51-00-05 REPAIR 1.SDR AALA20130318017Attach Angle · missingFLOOR SUPPORT BAFFEL FRAME ATTACHMENT ANGLE MISSING AT BODY STATION 500E, STRINGER 25R. INSTALLED FRAME ATTACHMENT ANGLE AT BODY STATION 500E AFT SIDE OF FRAME AT STRINGER 25R PER AARD 51-10-05-1.SDR AALA20130315037Wedge · chafedSLAT NUMBER 3 TRAILING EDGE WEDGE LOWER SURFACE CHAFED AT SEVERAL AREAS. ACCOMPLISHED REPAIR PER SRM 51-70-2R-4, SRM 51-70-10-2R-6 AND SRM 51-70-10-2R.SDR AALA20130315031Intercostal · corrodedLAVATORY SERVICE PAN IS CORRODED AROUND THE FLUSH LINE FITTING ON THE INTERIOR SIDE. REMOVED AND REPLACED PAN (INTERCOSTAL) PER AARD 51-00-05-1.SDR AALA20130315030Support Angle · crackedBODY STATION 500G FRAME TO INTERCOSTAL ANGLE SUPPORT AFT SIDE IS CRACKED AT STRINGER 25 RIGHT. REPLACED INTERCOSTAL ANGLE SUPPORT PER AARD 51-00-05-01.SDR AALA20130315024Support Angle · crackedBODY STATION 500G FRAME TO INTERCOSTAL ANGLE SUPPORT FORWARD SIDE IS CRACKED AT STRINGER 25 RIGHT. REMOVED INTERCOSTAL ANGLE SUPPORT AARD 51-00-05-1.SDR AALA20130315023Support Angle · crackedBODY STATION 500H FRAME TO INTERCOSTAL ANGLE SUPPORT AFT SIDE IS CRACKED AT STRINGER 25 RIGHT. REPLACED INTERCOSTAL ANGLE SUPPORT PER AARD 51-00-05-1.SDR AALA20130315022Support Angle · crackedBODY STATION 500H FRAME TO INTERCOSTAL ANGLE SUPPORT FORWARD SIDE IS CRACKED AT STRINGER 25. REPLACED ANGLE SUPPORT AARD 51-00-05-1.SDR AALA20130315021Intercostal · crackedFLOOR SUPPORT CHANNEL IS CRACKED BETWEEN BODY STATIONS 312 TO 328, RIGHT BUTTLINE 31, WATERLINE 208. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20130315012Wedge · chafedSLAT NUMBER 1 TRAILING EDGE WEDGE LOWER SURFACE CHAFED AT SEVERAL AREAS. ACCOMPLISHED REPAIRE PER SRM 51-70-10-2R-4 AND SRM 51-70-10-2R-6.SDR AALA20130313033Skin · tornEXTERNAL POWER SERVICE PANEL CUTOUT, AFT EDGE TORN. REPAIRED EXTERNAL SERVICE PANEL CUTOUT PER CARD 51-92-02-01 AND SRM 53-10-15-2R-4.SDR AALA20130313029Shield · corrodedCORROSION ON AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT BODY STATIONS 767 TO 794, RIGHT BUTTLINE 2, WATER LINE 156 AT NUT PLATES. REMOVED AND REPLACED SHIELD PER AARD 51-00-05 REPAIR 1.SDR AALA20130312007Cargo Track · corrodedCORROSION ON FCB FLOORBOARD BEAM AT TIE-DOWN BODY STATION 500H+16, LEFT BUTTLINE 19, WATER LINE 155 ON UPPER AND LOWER SURFACES. REMOVED DAMAGED SECTION AND REPAIRED PER SRM 53-00-53-2R-3 CATAGORY A.SDR AALA20130312006Intercostal · crackedCRACKED INTERCOSTAL UNDER FLOOR TO SIDEWALL SUPPORT AT STRINGER 25 RIGHT BETWEEN BODY STATIONS 500F AND 500G. REPAIRED INTERCOSTAL PER SRM 51-20-01-0G AND 51-40-02-0G.SDR AALA20130312002Channel · damagedPANEL SUPPORT CHANNEL HAS FRETTING DAMAGE BOTTOM SIDE AT BODY STATIONS 663R TO 673R, 27 INCHES OUTBOARD OF BEACON. REMOVED AND REPLACED CHANNEL PER SRM 51-40-02-0G AND SRM 51-40-05-0G.SDR AALA20130311019Wedge · chafedSLAT NUMBER SIX TRAILING EDGE WEDGE LOWER SURFACE CHAFED AT SEVERAL AREAS. REPAIRED CHAFED AREAS ON NUMBER SIX PER SRM 57-42-01 AND SRM 51-70-10.SDR AALA20130311018Attach Angle · crackedLEFT WING TRAILING EDGE, UPPER FIXED TRAILING EDGE ATTACH ANGLE CRACKED AT ORSS 270. REMOVED AND REPLACED THE CRACKED TRAILING EDGE ATTACH ANGLE ON LEFT WING TRAILING EDGE PER SRM 51-40-02-0G AND SRM 51-40-05-0G.SDR AALA20130311003Fitting · bentSTRINGER 16 LEFT CLIP IS BENT ON UPPER HORIZONTAL FLANGE AT INBOARD EDGE, BODY STATION 727F. REMOVED INSTALLED NEW CLIP PER DRAWING PL146A1010, AARD 51-00-05 REPAIR-1 AND SRM 51-40-02.SDR AALA20130307007Skin · crackedSKIN CRACK, LEFT HORIZONTAL STAB, LOWER SKIN, STATION 129, 11 INCHES FROM AFT SPAR. INSTALLED DOUBLER REPAIR PER SRM 55-10-01-0I-4 AND SRM 51-10-01-2R-11.SDR AALA20110924MCO01Switch · inoperativeMCO - CREW REPORTED LANDING GEAR WOULD NOT RETRACT AFTER THREE ATTEMPTS. EMERGENCY DECLARED FLIGHT RETURNED MCO LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FAULTY MANUAL GEAR EXTENSION DOOR MICROSWITCH. SYSTEM GROUND CHECK NORMAL OPERASDR AALA20110512TUL04Skin · dentedFUSELAGE SKIN HAS DENT WITH DEEP GOUGE 42 INCHES FORWARD AND 24 INCHES ABOVE WINDOWS, AT STATIONS 905 TO 927 BETWEEN STRINGERS 9 AND 10 LEFT. INSTALLED EXTERNAL DOUBLER REPAIR SRM 53-00-2R 4.SDR AALA20101114TUL04Overheat Loop · defectivePTY - CREW REPORTED ON DEPARTURE PASSING AT APPROXIMATELY 5000 FEET LEFT WING/BODY OVERHEAT LIGHT ILLUMINATED. FLIGHT RETURNED PTY LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED OUTBOARD LEADING EDGE LOOP AND AFT RIGHT ENGINE LOOP. SYSTEMSDR AALA20100726SJU01Sign · missingLEFT NUMBER 2 DOOR MISSING EXIT SIGN. REPLACED LEFT NUMBER 2 DOOR EXIT SIGN ASSEMBLY. OPS CHECKED NORMAL.SDR AALA20091105DFW14Lens · looseEMERGENCY LIGHT AT THE LEFT AISLE BULLNOSE SEAT ROW 22 HAS LOOSE LENS. SECURED THE LENS FOR THE EMERGENCY LIGHT AT SEAT ROW 22.SDR AALA20091105DFW13Light · damagedSEAT MOUNTED EMERGENCY LIGHT AT SEAT 18D IS MISSING LAMPS, LENS, AND SHROUD. REPLACED THE LIGHT ASSEMBLY AT SEAT 18D.SDR AALA20091105DFW12Lens · crackedEMERGENCY LIGHT EXIT SIGN ABOVE THE AFT LEFT OVERWING EXIT HATCH HAS A CRACKED LENS. REPLACED THE LENS FOR THE EXIT SIGN ABOVE THE OVERWING EXIT HATCH.SDR AALA20091105DFW11Lens · crackedEMERGENCY LIGHT EXIT MARKER FORWARD OF THE RIGHT OVERWING EXIT HATCH HAS A CRACKED LENS. REPLACED THE EXIT MARKER LIGHT ASSEMBLY.SDR AALA20091105DFW10Lens · looseEMERGENCY LIGHT AT FORWARD GALLEY OVERHEAD EXIT SIGN LENS IS LOOSE. SECURED FORWARD GALLEY OVERHEAD EXIT SIGN LENS.SDR AALA20091105DFW09Shroud · crackedEMERGENCY LIGHT AT SEAT 27D HAS CRACKED SHROUD. REPLACED SHROUD AT SEAT 27D.SDR AALA20091105DFW08Shroud · crackedEMERGENCY LIGHT AT SEAT 26D HAS CRACKED SHROUD. REPLACED SHROUD AT SEAT 26D.SDR AALA20091105DFW07Shroud · crackedEMERGENCY LIGHT AT SEAT 25D HAS CRACKED SHROUD. REPLACED SHROUD AT SEAT 25D.
Back to N964AN