N931AN
Service difficulty reports · 206
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 = 'N931AN' 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 = 'N931AN' 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 AALA201704189011Skin · corrodedINTERGRANULAR CORROSION WITH SKIN BULGING TO RIVETS APROXIMATELY 1 X 3 LOCATED AT BS 1016 AND STRINGER S21L IN THE JOINT OF SECTION 47 TO DOME AFT PRESSURE BULKHEAD. REPAIRED IAW SRM 51-10-02-0G, AND EA 269310. AIRCRAFT WAS GROUNDED.SDR AALA20170123008Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT PROXIMITY FLOODLIGHT AT G2 GALLEY IS DAMAGED. REMOVED AND REPLACED FLOODLIGHT IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA20160916004Tire · failedDURING TAKE OFF, THE NR 2 MAIN TIRE BURST CAUSING DAMAGE TO THE LEFT INBOARD FLAP AND WING TO BODY FAIRING. FLIGHT CONTINUED TO DESTINATION. EMERGENCY DECLARED. THE AIRCRAFT WAS GROUNDED. REMOVED AND REPLACED THE NR 3 MAIN WHEEL ASSEMBLY IAW AMM 32-45-11.SDR AALA20160406012Support Beam · wornAIRCRAFT WAS IN BASE MX. CTR WING SUPPORT BEAM AT PNEUMATIC GND AIR ACCESS DOOR LOCATION IS WORN, BETWEEN FS 536 & 540. REPAIRED SUPPORT BEAM IAW EA 259258.SDR AALA20160406011Window Frame · crackedAIRCRAFT WAS IN BASE MX. FIRST OFFICERS NR 1 WINDOW FRAME IS CRACKED AT UPPER OTBD CORNER. REPAIRED WINDOW FRAME IAW EA 259186 DATED 05 APR 2016 & EA 259274 DATED 05 APR 2016.SDR AALA20160408007Rib · crackedAIRCRAFT WAS IN BASE MX. RIGHT HORIZONTAL STABILIZER INBD CLOSURE RIB FLANGE IS CRACKED. REPAIRED RIB IAW EA 259243.SDR AALA20160305001Battery Pack · dischargedRIGHT SIDE EMER LIGHTS, BETWEEN ROWS 12 - 24 ARE NOT WORKING. REPLACED EMER LIGHT BATTERY. R & R CTR EMER BATTERY PACK IAW AMM 32-51-06. OPERATIONS TESTED GOOD. THE ACFT WAS NOT GNDED.SDR AALA20150426010Spring · faultyL1 DOOR HANDLE NOT FLUSH & PROTRUDING. ACFT DIVERTED WITH EMER DECLARED & LANDED WITHOUT INCIDENT. R & R DOOR HANDLE RETURN SPRING.SDR AALA20140313015Skin · corrodedCORROSION ON BOTTOM OF SKIN OF WING CTR SECTION, STATION 540 BETWEEN STRINGERS 22 & 23 RT, ADJACENT TO CHORD ANGLE. REMOVED CORROSION & ACCOMPLISHED REPAIR IAW EA B737-57-033937.SDR AALA20140307006Intercostal · crackedINTERCOSTAL CRACKED AT CABIN FLOORBOARD ATTACH SCREW BETWEEN STATIONS 312 TO 328 & LBL 45. REPLACED INTERCOSTAL IAW AARD 51-00-05-1.SDR AALA20130828002Strap · crackedCABIN FLOOR SEAT TRACK SPLICE STRAP STATION 727B HOLES HAVE CRACK INDICATIONS AT RBL 45.50. ACCOMPLISHED NESTED ANGLE REPAIR IAW EA B737-53-031298.SDR AALA20130828001Strap · crackedCABIN FLOOR SEAT TRACK SPLICE STRAP STATION 727B HOLES HAVE CRACK INDICATIONS AT RBL 24.75. ACCOMPLISHED NESTED ANGLE REPAIR EA B737-53-031298.SDR AALA20130827013Strap · crackedCABIN FLOOR SEAT TRACK SPLICE STRAP AT STATION 727B HOLES HAVE CRACK INDICATIONS AT LBL 45.50. ACCOMPLISHED NESTED ANGLE REPAIR IAW EA B737-53-031298.SDR AALA20130827012Strap · crackedCABIN FLOOR SEAT TRACK SPLICE STRAP AT STATION 727B HOLES HAVE CRACK INDICATIONS AT LBL 24.75. ACCOMPLISHED NESTED ANGLE REPAIR IAW EA B737-53-031298.SDR AALA20121130012Probe · inoperativeSEA - CREW REPORTED AUXILIARY PITOT TUBE HEATER FAILED DURING CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED SEA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED AUXILIARY PITOT PROBE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120620010Control Panel · failedMCO - INFLIGHT MIA-MBJ. CREW REPORTED WEATHER RADAR FAILED. FLIGHT DIVERTED MCO LANDED WITHOUT INCIDENT. AICRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED WEATHER RADAR CONTROL PANEL AND TRANCEIVER (MPN 6225132633). SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120216TUL02Angle · crackedRIGHT A/C BAY AFT UPPER ANGLE IS CRACKED AT INBOARD END AT SECOND FASTENER HOLE. INSTALLED SPLICE FILLER ANGLE AND REPAIR ANGLE PER EA B737-57-021884, SRM 51-70-11-2R AND BOEING DRAWING 111A1000.SDR AALA20120216TUL01Vapor Barrier · crackedWING CENTER SECTION REAR SPAR VAPOR BARRIER LOCATED IN RIGHT WHEEL WELL BETWEEN RIGHT BUTTLINES 6.15 AND 15.54 CRACKED. INSTALLED REPAIR ANGLES, SHIMS AND STRAPS AT BAY 1R, 2R AND 4R PER SRM 57-10-10-2R, REPAIR 2 AND EA B737-57-021884.SDR AALA20120214TUL04Spar · corrodedFORWARD SPAR CORRODED UNDER BOOST PUMP UPPER BONDING STRAP, INSIDE NUMBER 2 KRUGER FLAP WELL. REPLACED FORWARD SPAR SUPPORT BRACKET PER EA B737-57-021843.SDR AALA20120214TUL01Skin · dentedDAMAGE TO FUSELAGE SKIN AT STATION 807 BETWEEN STRINGERS 27 RIGHT AND 27 LEFT. INSTALLED EXTERNAL REPAIR DOUBLER TRIPLER PER EA B737-53-021834.SDR AALA20120211TUL01Stiffener · crackedRIGHT HORIZONTAL STIFFENER CRACKED AT INBOARD END ABOVE PACK EXHAUST DUCT ON FORWARD SIDE OF BULKHEAD. REPLACED STIFFENER PER AARD 51-10-05-REPAIR 1 AND BOEING DWG 111A1301.SDR AALA20120209TUL07Skin · nickedTWO NICKS IN SKIN 3 INCHES FROM LEFT EDGE. DAMAGED AREA DRILLED OUT AND RIVET INSTALLED PER EA COMP-52-02673.SDR AALA20120209TUL02Angle · corrodedRIGHT CREASE ANGLE CORRODED FROM STATIONS 947 TO 1006. INSTALLED RIGHT CREASE ANGLE FROM STATIONS 893 TO STA 1006 AS PER AARD 51-00-05-1.SDR AALA20120209TUL01Structure · corrodedAFT CARGO, CORROSION ON CARGO FLOOR FROM STATIONS 795 TO 847 RIGHT BUTTLINE 14. INSTALLED REPAIR STRAP PER EA B737-53-021533.SDR AALA20120213TUL01Angle · corrodedZ-ANGLE STATION 986 RIGHT BUTTLINE 32 IS CORRODED. Z-ANGLE REPLACED PER SRM 51-10-2.SDR AALA20120213TUL02Angle · corrodedZ-ANGLE STATION 986 LEFT BUTTLINE 32 HAS CORROSION. REPLACED Z-ANGLE PER SRM 51-10-2.SDR AALA20120208TUL03Angle · corrodedTHE RIGHT CREASE ANGLE HAS CORROSION FROM STATIONS 291 TO 344 AT RIGHT BUTTLINE 60. REMOVED AND REPLACED THE CREASE ANGLE PER SRM 51-10-02-0G.SDR AALA20120207TUL03Floor Support · corrodedIN THE AFT CARGO THE FLOOR SUPPORT TEE IS CORRODED AT STATION 767. INSTALLED A NEW FLOOR SUPPORT TEE PER AARD 51-10-05.SDR AALA20120207TUL02Floorbeam · corrodedTOP OF CABIN FLOORBEAM HAS SMALL AREA OF CORROSION AROUND FASTENER. BLENDED OUT CORROSION AND INSTALLED REPAIR ANGLE PER AARD 53-00-00-7.SDR AALA20120206TUL07Floorbeam · corrodedTHE 328 FLOORBEAM HAS CORROSION ON THE UPPER FLANGE FROM RIGHT BUTTLINES 10 TO 38. INSTALLED A FLOORBEAM T-CHORD REPLACEMENT FROM RIGHT BUTTLINE 1 TO THE RIGHT TERMINATION POINT PER SRM 53-10-51-2R-7.SDR AALA20120203TUL02Floor Support · bentFLOOR SUPPORT FROM STATIONS 807 TO 792, RIGHT BUTTLINE 8, BENT. INSTALLED FILLER AND SPLICE PER SRM 53-00-53-2R2 AND EA B737-53-0210609.SDR AALA20120202TUL03Doubler · crackedRIGHT PACK EXHAUST CUTOUT DOUBLER IS CRACKED AT INBOARD MOUNT TABS. INSTALLED NEW RIGHT PACK EXHAUST CUTOUT DOUBLER PER AARD 51-00-05-1 REPAIR 1 AND BOEING DRAWING 11A1512.SDR AALA20120202TUL02Angle · corrodedSTATION 1088 AUXILIARY POWER UNIT INLET CUTOUT UPPER ANGLE HAS LIGHT CORROSION. REPLACED ANGLE AT APU INLET STATION 1088 PER AARD 51-00-05 AND BOEING DRAWING 148A0924.SDR AALA20120202TUL01Web · crackedLEFT AC BAY, STATION 663 BULKHEAD INBOARD OF PACK EXHAUST HAS TEMPERARY REPAIR. FABRICATED AND INSTALLED ALL REPAIR STRAPS, ANGLES AND JOINT ANGLES FOR BAYS 2L AND 4L. SEALED ALL FASTENERS AND APPLIED VAPOR BARRIER PER SRM -WINGLET APB SUPPLEMENT 57-10-10-2RSDR AALA20120131TUL11Shield · corrodedCORROSION ON RIGHT TRANSITION PANEL BEWEEN STATIONS 767 TO 787. REPLACED SHIELD PER SRM 53-60-15-0I AND BOEING DRAWING 146A8127.SDR AALA20120131TUL09Skin · dentedDENT IN FUSELAGE FROM STATIONS 500F TO 500G BETWEEN STRINGER 25 AND 26 RIGHT. INSTALLED EXTERNAL REPAIR DOUBLER PER E.A B737-53-021575.SDR AALA20120131TUL08Beltframe · crackedBELT FRAME CRACKED AT INBOARD ATTACH FASTENER OF RIGHT AC RAIL BRACKET STATION 480. INSTALLED REPAIR ANGLE PER ECO J1159.SDR AALA20120131TUL07Beltframe · crackedBELT FRAME CRACK AT INBOARD ATTACH FASTENER OF RIGHT AC RAIL BRACKET STATION 440. INSTALLED REPAIR ANGLE PER ECO J1159.SDR AALA20120131TUL06Frame · crackedBELT FRAME CRACKED AT INBOARD ATTACH FASTENER OF LEFT AC RAIL BRACKET STATION 400. INSTALLED REPAIR ANGLE PER ECO J1159AD.SDR AALA20120131TUL05Beltframe · crackedBELT FRAME CRACKED AT INBOARD ATTACH FASTENER OF RIGHT AC RAIL BRACKET STATION 380. INSTALLED REPAIR ANGLE PER ECO J1159AD.SDR AALA20120131TUL04Frame · crackedHFEC SURFACE SCAN INDICATES CRACK AT INBOARD ATTACH FASTENER OF AC RAIL BRACKET STATION 500F. INSTALLED REPAIR ANGLES A AND B PER ECO J1159AD CARD 0007.SDR AALA20120131TUL03Frame · crackedHFEC SURFACE SCAN INDICATES CRACK AT INBOARD ATTACH FASTENER OF AC RAIL BRACKET STATION 727B. INSTALLED REPAIR ANGLES A AND B PER ECO J1159AD CARD 0007.SDR AALA20120131TUL02Frame · crackedHFEC SURFACE SCAN INDICATES CRACK AT INBOARD ATTACH FASTENER OF AC RAIL BRACKET STATION 500F. INSTALLED REPAIR ANGLES A AND B PER ECO J1159AD CARD 0006.SDR AALA20120131TUL01Stiffener · crackedVERTICAL STIFFENER CRACKED AT STATION 663 AFT SIDE OF BULKHEAD OUTBOARD OF LEFT PACK EXHAUST CUTOUT. INSTALLED NEW STIFFENER PER AARD 51-10-05-1 AND DRAWING 149A7210 AND 111A1000.SDR AALA20120128TUL08Fitting · crackedRIGHT TRANSITION PANEL, FORWARD OF STATION 500F BAFFLE CLIP CRACKED. REPLACED BAFFLE CLIP AT RIGHT TRANSITION PANEL, FORWARD OF STATION 500G PER EA B737-53-021464.SDR AALA20120128TUL07Fitting · crackedRIGHT TRANSITION PANEL, AFT OF STATION 500G BAFFLE CLIP CRACKED. REPLACED BAFFLE CLIP AT RIGHT TRANSITION PANEL, AFT OF STATION 500G PER EA B737-53-021464.SDR AALA20120128TUL06Fitting · crackedRIGHT TRANSITION PANEL, FORWARD OF STATION 500G BAFFLE CLIP CRACKED. REPLACED BAFFLE CLIP AT RIGHT TRANSITION PANEL, FORWARD OF STATION 500G PER EA B737-53-021464.SDR AALA20120128TUL05Fitting · crackedRIGHT TRANSITION PANEL, FORWARD OF STATION 500H BAFFLE CLIP CRACKED. REPLACED BAFFLE CLIP AT RIGHT TRANSITION PANEL, FORWARD OF STATION 500H PER EA B737-53-021464.SDR AALA20120128TUL04Fitting · crackedRIGHT TRANSITION PANEL, AFT OF STATION 500H BAFFLE CLIP CRACKED. REPLACED BAFFLE CLIP AT RIGHT TRANSITION PANEL, AFT OF STATION 500H PER EA B737-53-021464.SDR AALA20120127TUL12Stringer Clip · crackedIN THE FORWARD CARGO AT RIGHT TRANSITION PANEL THE 26 RIGHT STRINGER CLIP IS CRACKED AT STATION 500G. REMOVED AND REPLACED THE STRINGER CLIP PER EA B737-53-021464.
Back to N931AN