N906AN
Service difficulty reports · 258
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 = 'N906AN' 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 = 'N906AN' 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 AALA20130206003Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 927 TO 967 BETWEEN STRINGERS 23 AND 24 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027976.SDR AALA20130206002Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 927 TO 987 BETWEEN STRINGERS 22 AND 23 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027976.SDR AALA20130119008Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 927 TO 987 BETWEEN STRINGERS 21 AND 22 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027976.SDR AALA20130117005Strap · corrodedCABIN AFT FLOOR WET AREA STRAP (ON TOP OF WEB) HAS AREA OF CORROSION. REMOVED AND REPLACED STRAP PER AARD 51-00-05-1 AND BOEING DRAWING 147A5714.SDR AALA20121212001Transmitter · malfunctionedLAX - INFLIGHT ORD-SNA. CREW REPORTED UNABLE TO LOWER FLAPS TO REQUIRED POSITION FOR LANDING. EMERGENCY DECLARED FLIGHT DIVERTED LAX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND NUMBER 1 FLAP TRANMISSION OVERTORQUED INDICATOR POPPED. RESESDR AALA20120803004Light · damagedSEAT 10D EMERGENCY LIGHT DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 10D. OPS CHECK NORMAL.SDR AALA20120627014Motor · inoperativeLAX - CREW REPORTED ON CLIMBOUT MAIN STAB TRIM INOPERATIVE. EMERGENCY DECLARED FLIGHT RETURNED LAX LANDED WITHOUT INCIDENT. REPLACED STAB TRIM ACTUATOR MOTOR AND PERFORMED STAB TRIM MOTOR ADJUSTMENT. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20090831TUL01Actuator · inoperativeIAD - CREW REPORTED STAB TRIM WAS INOPERATIVE ON DESCENT. EMERGENCY DECLARED LANDED IAD WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED HORIZONTAL STABILIZER TRIM ACTUATOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20090820MIA01Trim Motor · inoperativeMIA - CREW REPORTED STABILIZER TRIM WAS JAMMED. EMERGENCY DECLARED, LANDED AT MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED STABILIZER TRIM MOTOR AND SERVICED TRANSMISSION AND LUBRICATED JACK SCREW. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20090727MIA02Pressure Switch · inoperativeMIA - ON CLIMBOUT LEFT ENGINE FUEL FILTER BYPASS LIGHT ILLUMINATED. FLIGHT RETURNED MIA WITHOUT INCIDENT. REPLACED DIFFERENTIAL SWITCH AND FUEL FILTER. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA2009030900564Lamp · burned outTPA - FORWARD OVERHEAD AISLE EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LAMP IN FORWARD OVERHAED AISLE EMERGENCY EXIT LIGHT.SDR AALA200810555Skin · wornLEFT WING LOWER SKIN WORN BEYOND LIMITS AT OUTBOARD SIDE OF STRUCT FAIRING FORWARD AND AFT OF TANK PLATE CUT OUT. DAMAGE BLENDED TREATED, PRIMED AND REPAIRED PER ESO 61000 DATED 1/2/09.SDR AALA200810550Skin · wornRT WING INBD FLAP OTBD TRACK FWD FAIRING LOWER WING SKIN WORN INBD SIDE IN EXCESS OF 0.030 INCH FROM CONTACT WITH SEAL. REPAIRED IAW ESO 61000, DATED 1-02-09.SDR AALA200810549Skin · wornRT WING LWR SKIN PANEL WORN IN EXCESS OF 0.030 IN OTBD SIDE FROM RT AFT STRUT FAIRING, AFT SIDE OF TANK PLATE.SDR AALA20090713TUL05Vapor Barrier · crackedWING CENTER SECTION TO REAR SPAR VAPOR BARRIER CRACKED. REPAIRED PER SRM 57-10-10-22.SDR AALA200810551Angle · crackedRT TRANSITION ANGLE CRACKED AT STA 432. INSTALLED A SERVICEABLE ANGLE IAW SRM 51-40-02.SDR AALA200810520Web · corrodedAFT CARGO LOWER SCUFF PLATE WEB CORRODED STATION 827. INSTALLED A SERVICEABLE SCUFF PLATE WEB PER ESO 61000 DATED 12-10-08.SDR AALA200810519Cargo Track · corrodedCORROSION ON CARGO TRACK TIE DOWN STATION 807 TO 847. INSTALLED A SERVICEABLE TRACK FROM STATION 807 TO 887 PER SRM 53-00-53-2R.SDR AALA200810516Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 328. FLOORBEAM UPPER CHORD REPLACED PER ESO 6100 DATED 12-16-08.SDR AALA200810517Floorbeam · crackedFLOORBOARD SUPPORT CRACKED AT STATION 610. INSTALLED A SERVICEABLE FLOOR SUPPORT.SDR AALA200810501Angle · corrodedRIGHT TRANSITION ANGLE CORRODED STATION 767 TO 793 RIGHT BUTT LINE 21. INSTALLED A SERVICEABLE SUPPORT ANGLE PER ESO 61000 DATED 12-12-08.SDR AALA200810500Floorbeam · corrodedTOP OF FLOORBEAM STATION 986.5 CORRODED AT RIGHT BUTT LINE 25. REPAIRED PER SRM 51-00-53-2R.SDR AALA200810499Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 986.5 AT LEFT BUTT LINE 22. REPAIRED PER SRM 53-00-51-2R.SDR AALA200810498Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 986.5 AT LEFT BUTT LINE 28. REPAIRED PER SRM 53-00-51-2R.SDR AALA200810497Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 986.5 AT LEFT BUTT LINE 36. REPAIRED PER SRM 53-00-21-2R.SDR AALA200810496Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 986.5 AT LEFT BUTT LINE 16. REPAIRED PER SRM 53-00-51-2R.SDR AALA200810495Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 986.5 AT LEFT BUTT LINE 12. REPAIRED PER SRM 53-00-51-2R.SDR AALA200810484Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 986.5 LEFT BUTT LINE 4. REPAIRED PER SRM 53-00-2R.SDR AALA200810508Angle · corrodedCORROSION ON LEFT Z ANGLE STATION 787 TO 827. REPAIRED PER SRM 53-00-53-2R5.SDR AALA200810507Angle · corrodedCORROSION ON RIGHT Z ANGLE STATION 727I TO 727J. INSTALLED A SERVICEABLE Z ANGLE PER SRM 53-00-53-2R.SDR AALA200810506Floor Support · corrodedCORROSION ON FLOOR SUPPORT AT STATION 310. INSTALLED A SERVICEABLE SUPPORT.SDR AALA200810505Floor Support · corrodedCORROSION ON FLOOR SUPPORT STATION 312 TO 328. INSTALLED A SERVICEABLE FLOOR SUPPORT.SDR AALA200810502Intercostal · crackedINTERCOSTAL CRACKED BETWEEN STATION 312 AND 328 RIGHT BUTT LINE 31. INSTALLED A SERVICEABLE INTERCOSTAL.SDR AALA200910598Beam · corrodedCORROSION ON BEAM STATION 294.5 RBL 30. REPAIRED PER ESO 61000.SDR AALA200810518Floorbeam · corrodedFLOORBOARD SUPPORT CORRODED AT STATION 953 NUT PLATE HOLE. INSTALLED A SERVICEABLE FLOOR SUPPORT PER SRM 51-10-02-0G.SDR AALA200810510Intercostal · crackedCABIN FLOOR INTERCOSTAL CRACKED STATION 284. INSTALLED A SERVICEABLE INTERCOSTAL.SDR AALA200810509Intercostal · crackedCABIN FLOOR INTERCOSTAL CRACKED STATION 321. INSTALLED A SERVICEABLE INTERCOSTAL PER SRM 51-10-2.SDR AALA200810504Web · corrodedCORROSION AROUND RIGHT GALLEY COMPLEX MOUNT STATION 987. INSTALLED WEB REPAIR PER SRM 51-70-13.SDR AALA200810503Panel · corrodedCORROSION ON LEFT TRANSITION PANEL STATION 470. INSTALLED DOUBLER PER SRM 53-00-53-2R.SDR AALA200810483Floor Support · corrodedFLOORBOARD SUPPORT CORRODED FORWARD RIGHT AFT GALLEY DOOR CUTOUT STATION 947.5 TO 976 RIGHT BUTT LINE 52. INSTALLED A SERVICEABLE AFT GALLEY DOOR CREASE ANGLE PER SRM 51-10-02-0G.SDR AALA200810482Web · corrodedCORROSION ON AFT GALLEY WEB STATION 1016. REPAIRED PER SRM 51-70-13.SDR AALA200810481Stiffener · corrodedFLOOR STIFFENER STATION 1016 AT 3 INCHES LEFT BUTT LINE, HAS CORROSION. INSTALLED A SERVICEABLE STRAP (STIFFENER) PER SRM 51-00-02G.SDR AALA20090417TUL01Skin · dentedDENT IN FUSELAGE SKIN ABOVE FORWARD ENTRY DOOR BETWEEN STRINGER 3 LEFT AND 4 LEFT AT STATION 325 TO 338. CUT OUT DAMAGED AREA, INSTALLED DOUBLER PER SRM 53-00-01-2R.SDR AALA200810553Floorbeam · gougedGOUGES ON BOTTOM SIDE OF CABIN FLOORBEAMS AT STA 655. REPAIRED IAW AARD 53-20-00-21.SDR AALA200801040Battery Pack · failedTUL - SEAT MOUNTED EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED TEST. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801039Battery Pack · failedTUL - SEAT MOUNTED EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED TEST. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801038Battery Pack · failedTUL - SEAT MOUNTED EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED TEST. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061321Bulb · burned outMIA - EMERGENCY LIGHT AT SEAT 5F INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 5F. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061047Bulb · inoperativeMIA - EMERGENCY LIGHT AT SEAT 5E INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 5E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061054Battery Pack · failedTUL - EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED TEST. REPLACED BATTERY PACK FOR EMERGENCY LIGHT IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N906AN