N905AN
Service difficulty reports · 270
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 = 'N905AN' 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 = 'N905AN' 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 AALA20130927005Seat Track · crackedTWO OTBD FASTENER HOLES IN SEAT TRACK CRACKED AT STATION 727B & LBL 24.75. ACCOMPLISHED REPAIR IAW EA B737-53-031772.SDR AALA20130927004Splice · crackedCRACK FOUND ON SEAT TRACK SPLICE STRAP AT RBL 45.50 & STATION 727B. ACCOMPLISHED REPAIR IAW EA B737-53-031772.SDR AALA20130927002Seat Track · crackedTWO INBD FASTENER HOLES IN SEAT TRACK CRACKED AT RBL 24.75. ACCOMPLISHED REPAIR IAW EA B737-53-031772.SDR AALA20130927001Seat Track · crackedTWO FASTENER HOLES CRACKED IN SEAT TRACK AT STATION 45.5. ACCOMPLISHED REPAIR TO SEAT TRACK IAW EA B737-5-3-031772.SDR AALA20130927003Seat Track · crackedTWO INBD FASTENER HOLES CRACKED IN SEAT TRACK AT STATION 727B & LBL 24.75. ACCOMPLISHED REPAIR IAW EA B737-53-031772.SDR AALA20130204002Slide · unsecureLEFT NUMBER 1 DOOR SLIDE INADVERTANTLY UNSUCCESSFULLY DEPLOYED. SLIDE PACK FELL FROM DOOR WHEN THE AGENT ATTEMPTED TO OPEN THE LEFT NUMBER 1 DOOR. REPLACED LEFT NUMBER 1 DOOR SLIDE ASSEMBLY.SDR AALA20121214007Intercostal · crackedINTERCOSTAL FROM STATIONS 328 TO 344 LEFT BUTTLINE 46 CRACKED. INSTALLED NEW INTERCOSTAL PER AARD 51-00-05.SDR AALA20121214006Intercostal · crackedINTERCOSTAL FROM STATIONS 315 TO 328 LEFT BUTTLINE 46 CRACKED. INSTALLED NEW INTERCOSTAL PER AARD 51-00-05.SDR AALA20120113AUS01Light · inoperativeLEFT NUMBER 1 DOOR EXTERIOR SLIDE LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 1 DOOR EXTERIOR SLIDE LIGHT. OPS CHECK NORMAL.SDR AALA20110723TUL04Transmitter · inoperativeNAS - CREW REPORTED FLAPS WOULD NOT EXTEND. EMERGENCY DECLARED FLIGHT LANDED NAS WITHOUT INCIDENT. LANDED WITH LEADING EDGE DEVICES ONLY. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT FLAP POSITION TRANSMITTER. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20110719MEX01Connector · dirtyMEX - CREW REPORTED UNABLE TO EXTEND LEADING EDGE DEVICES, EXTENDED LEADING EDGE DEVICES WITH ALTERNATE MODE. EMERGENCY DECLARED FLIGHT LANDED MEX WITHOUT INCIDENT. INSPECTED RIGHT FLAP TRANSMITTER AND CLEANED CONNECTOR. CYCLED SEVERAL TIMES NO DISCREPANCIESDR AALA20110127ORD01Wire · openFOUND EMERGENCY LIGHTS AT FORWARD GALLEY AREA INOPERATIVE. FOUND OPEN WIRE. REPAIRED WIRE. OPS CHECK NORMAL.SDR AALA20110125ORD01Sensor · faultyORD - CREW REPORTED DURING APPROACH EXPERIENCED A TRAILING EDGE FLAP ASYMMETRY. LEFT FLAP 15DG AND RIGHT FLAP INDICATOR 12DG, FLAPS WOULD NOT MOVE FROM THIS POSITION. ACCOMPLISHED A GO-AROUND. EMERGENCY DECLARED FLIGHT LANDED ORD WITHOUT INCIDENT. AIRCRAFTSDR AALA20101117TUL01Intercostal · corrodedFOUND CORROSION ON LEFT INTERCOSTAL STATION 930 LEFT BUTTLINE 24. INSTALLED NEW INTERCOSTAL PER SRM 5551-10-02-0G.SDR AALA20101202TUL09Floorbeam · corrodedFLOORBEAM CORRODED STATION 927 RIGHT BUTTLINES 50 TO 53 ON TOP SURFACE. ACCOMPLISHED T-CAP REPAIR PER EA B737-53-014129.SDR AALA20101202TUL10Floorbeam · corrodedFLOORBEAM STATION 947 CORRODED AT RIGHT BUTTLINE 52 TOP SURFACE. ACCOMPLISHED T-CAP REPAIR PER SRM 53-70-51-2R 5.SDR AALA209031200003Relay · failedMIA - DURING CLIMBOUT THE CENTER FUEL BOOST PUMP FAILED. RETURNED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED THE PUMP CONTROL RELAY FOR THE LEFT CENTER FUEL BOOST PUMP AND THE UNIVERSAL FAULT INTERRUPTER 1030001001 FOR THE RIGHT CENTER FSDR AALA2009031201009Connector · disconnectedMSP - EMERGENCY LIGHT AT 18R OVERHEAD INOPERATIVE. RECONNECTED CONNECTOR.SDR AALA2009011500164Sensor · faultedIAD INFLIGHT DFW TO DCA - CREW REPORTED LEADING EDGE FLAP TRANSIT LIGHT ILLUMINATED WHEN LEADING EDGE FLAPS WERE SELECTED TO 5. LANDED IAD WITHOUT INCIDENT AT 15 DEGREE FLAPS. REPLACED NUMBER FOUR FLAP RETRACT SENSOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200810415Angle · corrodedAFT SERVICE DOOR CREASE ANGLE CORRODED STATION 945 TO 993. INSTALLED A SERVICEABLE CREASE ANGLE PER SRM 53-70-51.SDR AALA200810402Bulkhead · canningAFT PRESSURE BULKHEAD OIL CANNING BETWEEN 10 O'CLOCK AND 12 O'CLOCK POSITION. REPAIRED PER ESO 61000 DATED 11-24-08.SDR AALA200810386Floor Support · corrodedTOP OF FLOOR SUPPORT CORRODED AT STATION 929 AND BUTT LINE 46 RIGHT. REMOVED AND REPLACED FLOOR SUPPORT PER SRM 51-10-02-0G STATION 929 BUTT LINE 46 RIGHT.SDR AALA200810385Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN STATION 986.5 AND STATION 1006 BUTT LINE 32 LEFT. INSTALLED INTERCOSTAL PER SRM 53-10-51.SDR AALA200810384Support · corrodedGALLEY WALL SUPPORT AT STATION 991 BETWEEN BUTT LINE 34 LEFT AND BUTT LINE 45 LEFT CORRODED. INSTALLED NEW GALLEY WALL SUPPORT PER SRM 53-10-51.SDR AALA200810383Angle · corrodedAFT ENTRY DOOR OPENING CREASE ANGLE CORRODED. INSTALLED NEW CREASE ANGLE PER SRM 51-10-02-05.SDR AALA200810382Floor Support · corrodedFLOOR SUPPORT CORRODED AT STATION 958 AND BUTT LINE 49 RIGHT. REMOVED AND REPLACED FLOOR SUPPORT PER SRM 53-70-51.SDR AALA200810398Bracket · crackedBRACKET CRACKED IN RADIUS UNDER RIGHT TRANSITION PANEL IN FORWARD CARGO AT STATION 500F AFT SIDE OF BELLFRAME CONNECTED TO INTERCOSTAL. REMOVED AND REPLACED BRACKET PER SRM.SDR AALA200810397Bracket · crackedBRACKET CRACKED IN RADIUS UNDER RIGHT TRANSITION PANEL IN FORWARD CARGO AT STATION 500H FORWARD SIDE OF BELLFRAME CONNECTED TO INTERCOSTAL. REMOVED AND REPLACED BRACKET PER SRM.SDR AALA200810396Bracket · crackedBRACKET CRACKED IN RADIUS UNDER RIGHT TRANSITION PANEL IN FORWARD CARGO AT STATION 500F FORWARD SIDE BETWEEN BELLFRAME AND INTERCOSTAL. REMOVED AND REPLACED BRACKET PER SRM.SDR AALA200810395Bracket · crackedBRACKET CRACKED IN RADIUS UNDER RIGHT TRANSITION PANEL IN AFT CARGO, STATION 500E FORWARD SIDE BETWEEN BELLFRAME AND INTERCOSTAL. REMOVED AND REPLACED BRACKET PER SRM.SDR AALA200810401Bracket · crackedFORWARD CARGO, BRACKET CRACKED IN RADIUS UNDER RIGHT TRANSITION PANEL STATION 500H FORWARD SIDE OF BELTFRAME CONNECTED TO INTERCOSTAL. REMOVED AND REPLACED WITH SERVICEABLE BRACKET.SDR AALA200810400Bracket · crackedFORWARD CARGO, BRACKET CRACKED IN RADIUS UNDER RIGHT TRANSITION PANEL STATION 500G FORWARD SIDE OF BELTFRAME CONNECTED TO INTERCOSTAL.SDR AALA200810399Bracket · crackedFORWARD CARGO, BRACKET CRACKED IN RADIUS UNDER LEFT HAND TRANSITION PANEL STATION 500H FORWARD SIDE OF BELTFRAME CONNECTED TO INTERCOSTAL. REMOVED AND REPLACED WITH SERVICEABLE BRACKET.SDR AALA200810394Floorbeam · corrodedFLOORBEAM STATION 328 ALL MOUNT HOLES FROM BUTT LINE 10 RIGHT TO OUTBOARD FUSELAGE HAS CORROSION AFT LIP. INSTALLED FLOOR BEAM REPAIR STATION 328 PER ESO 61000 DATED 11/21/08.SDR AALA200810389Floorbeam · corruptedTOP OF FLOORBEAM CORRODED AT STATION 986 AND BUTT LINE 42 LEFT. INSTALLED REPAIR ANGLE PER AARD 53-00-00-7.SDR AALA200810388Floorbeam · corrodedTOP OF FLOORBEAM CORRODED AT STATION 986 BETWEEN BUTT LINE 29 LEFT AND BUTT LINE 31 LEFT. INSTALLED REPAIR ANGLE PER AARD 53-00-00-7.SDR AALA200810387Floor Support · crackedINTERCOSTAL FLOOR BOARD SUPPORT CRACKED AT MOUNT HOLES BUTT LINE 30 RIGHT BETWEEN STATIONS 312 AND STATION 328. INSTALLED NEW FLOOR SUPPORT BRACKET.SDR AALA200810393Angle · puncturedAFT CARGO LEFT TRANSITION ANGLE HAS HOLE BETWEEN STATION 727H AND STATION 727I HOLE IS THROUGH PANEL. REMOVED DAMAGED AREA AND FABRICATED NEW ANGLE, INSTALLED PER SRM 53-00-53-2R5.SDR AALA200810392Skin · dentedDENT IN FUSELAGE SKIN JUST BELOW STRINGER 3 LEFT AT STATION 328. INSTALLED REPAIR AS PER SRM 53-00-01.SDR AALA200810414Strap · corrodedWEB STRAP CORRODED AT STATION 1018 TO 1026 AFT CABIN GALLEY FLOOR AREA. INSTALLED A SERVICEABLE STRAP PER SRM 53-70-51-2R.SDR AALA200810413Strap · corrodedWEB STRAP CORRODED AT STATION 1019 TO 1022 AFT CABIN GALLEY FLOOR AREA. INSTALLED A SERVICEABLE STRAP PER SRM 53-70-51-2R.SDR AALA200810412Floor Support · corrodedCORROSION ON FLOOR SUPPORT AT STATION 967 TO 987. INSTALLED SERVICEABLE FLOOR SUPPORT PER SRM 51-10-02G.SDR AALA200810391Floor Support · corrodedRIGHT FLOOR SUPPORT TRANSITION PANEL IN AFT CARGO HAS CORROSION BETWEEN STATION 767 AND STATION 787. REMOVED CORRODED SUPPORT AND INSTALLED NEW PART PER ESO 61000 DATED 11/17/08.SDR AALA200810390Floorbeam · corrodedTOP OF FLOORBEAM CORRODED STATION 948 AND BUTT LINE 40 RIGHT. INSTALLED REPAIR DOUBLER PER SRM 53-00-51.SDR AALA200810411Frame · crackedSTATION 500A LEFT, FRAME CRACKED AT AIR CONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810410Frame · crackedSTATION 480 LEFT, FRAME CRACKED AT AIR CONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810409Frame · crackedSTATION 500C LEFT, FRAME CRACKED AT AIRCONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810408Frame · crackedSTATION 500A RIGHT, FRAME CRACKED AT AIRCONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810407Attach Fitting · crackedSTATION 727B LEFT, FRAME CRACKED AT AIR CONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.SDR AALA200810406Frame · crackedSTATION 480 RIGHT, FRAME CRACKED AT AIRCONDITIONING RAIL ATTACH POINT. REPAIRED PER ECO J1159AA.
Back to N905AN