N943AN
Service difficulty reports · 200
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 = 'N943AN' 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 = 'N943AN' 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 AALA20140829006Intercostal · crackedINTERCOSTAL CRACKED AT STATION 320 & LBL 46 IN E & E BAY. R & R INTERCOSTAL IAW SRM 51-40-02.SDR AALA20140504003Module · inoperativeMIA CREW REPORTED CTR PEDESTAL LIGHTS STARTED FLASHING & CREW UNABLE TO SEE OR SET COMMUNICATION FREQUENCIES. FLIGHT RETURNED MIA LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED STABILIZER TRIM & COCKPIT DOOR LOCK MODULE. SYS GND CHECKED NORMASDR AALA20130425001B-Nut · looseLAX - CREW REPORTED DURING FLAP EXTENSION, "B" SYSTEM HYDRAULIC SYSTEM QUANTITY DROPPED TO ZERO. EMERGENCY DECLARED FLIGHT LANDED LAX WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. TIGHTENED "B" SYSTEM SUPPLY TUBE IN RIGHT WING B NUT THAT WAS FOUND LOOSE. SDR AALA20120627017Intercostal · corrodedINTERCOSTAL FROM STATIONS 767 TO 787 STRINGERS 24 TO 25 RIGHT CORRODED. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120625012Frame · crackedFRAME CRACKED AT SUPPORT BRACKET FOR AIR CONDITIONING RAIL AT STATION 500C LEFT. INSTALLED DOUBLER PER EA B737-53-024502.SDR AALA20120625010Intercostal · wornE AND E DOOR SURROUND STRUCTURE, LEFT AND RIGHT INTERCOSTAL WEBS ARE WORN. REPLACED LEFT AND RIGHT INTERCOSTAL WEBS PER AARD 51-10-05-1.SDR AALA20120624006Spar · corrodedRIGHT WING FORWARD SPAR, NUMBER 2 FORWARD BOOST PUMP, TOP BONDING ATTACH POINT HAS CORROSION UNDER SEALANT/PAINT. CORROSION REMOVED PER EA B737-57-024512.SDR AALA20120622012Floor Support · corrodedTHRESHOLD FLOORBOARD SUPPORT CORRODED BETWEEN STATIONS 303 TO 329. REPLACED ANGLE PER SRM 51-10-02-0G.SDR AALA20120621003Threshold · corrodedCORROSION ON FORWARD CARGO ENTRY THRESHOLD TOP SURFACE. REPLACED WEB.SDR AALA20120621002Transition Panel · corrodedCORROSION ON RIGHT TRANSITION PANEL FROM STATIONS 420 TO 440. REPLACED PANEL PER AARD 51-00-05-1.SDR AALA20120619024Track · corrodedCORROSION ON FORWARD AND AFT ENDS OF TRACK, BETWEEN FORWARD AND AFT LEFT AFT GALLEY TIE DOWNS FROM STATIONS 1016 AND 992.8. INSTALLED TRACK PER BOEING DRAWINGS 147A5710 AND 147A5700.SDR AALA20120619017Skin · dentedMULTIPLE DENTS IN AFT CARGO DOOR SKIN. REMOVED DAMAGED SKIN AND REPLACED WITH NEW SKIN PER ESO 60651 AND SRM 52-30-01-2R.SDR AALA20120619012Sill · corrodedAFT CARGO, AFT CARGO DOOR LOWER SILL, PAN CORRODED TOP AND BOTTOM. REMOVED AND REPLACED LOWER DOOR SILL WEB IN AFT CARGO PER AARD 51-00-05-1.SDR AALA20120618004Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 328 RIGHT BUTTLINE 12. INSTALLED FABRICATED REPAIR ANGLE PER EA B737-53-024412, SRM 53-00-51 AND AARD 53-00-00-7.SDR AALA20120616006Frame · crackedFRAME CRACKED AT STATION 500C LEFT SIDE AT AC RAIL ATTACH BRACKET. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120615016Frame · crackedFRAMED CRACKED AT ATTACH BRACKET INBOARD RIVET BETWEEN STRINGERS 8 AND 9 RIGHT AT STATION 440. INSTALLED REPAIR ANGLE PER ECO J1159AD.SDR AALA20120615008Frame · crackedFRAMED CRACKED AT ATTACH BRACKET BETWEEN STRINGERS 8 AND 9 RIGHT AND STATION 400 RIGHT CRACKED. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120622014Angle · crackedCREASE BEAM ANGLE HAS A CRACK AT FASTENER HOLE, IN THE RADIUS, AND 2 CRACKS ABOVE AND BELOW HORIZONTAL FASTENER HOLE AT STATION 302 LEFT BUTTLINE 55. REMOVED AND REPLACED CREASE ANGLE STRUCTURE FROM STATIONS 290 TO 357, LEFT BUTTLINE 55 PER SRM 51-40-02. A MSDR AALA20120614005Floor Support · corrodedFLOORBOARD SUPPORT CORRODED. REPLACED SUPPORT.SDR AALA20120614004Seat Track · corrodedCORROSION ON FORWARD AND AFT ENDS OF TRACK, BETWEEN FORWARD AND AFT LEFT AFT GALLEY TIEDOWNS, BETWEEN STATIONS 1016 AND 992.8. INSTALLED TRACK PER AARD 51-00-05-1.SDR AALA20120614021Beltframe · crackedBELT FRAME CRACKED AT SUPPORT FOR RIGHT AIR CONDITIONING RAIL STATION 400. INSTALLED FRAME REPAIR PER ECO J1159AD.SDR AALA20120614001Stiffener · corrodedSTIFFENER CORRODED AT STATION 1125 RIGHT SIDE AUXILIARY POWER UNIT COMPARTMENT AFT OF APU INLET. INSTALLED SERVICEABLE STIFFENER PER AARD 51-00-05-1.SDR AALA20120613004Intercostal · crackedINTERCOSTAL CRACKED BETWEEN STATIONS 500D AND 500E JUST OUTBOARD OF STRINGER 25 LEFT. INSTALLED BAFFLE PER SRM 51-00-01.SDR AALA20120608023Frame · crackedFRAMED CRACKED AT ATTACH BRACKET INBOARD RIVET BETWEEN STRINGERS 8 AND 9 RIGHT AND STATION 727B. INSTALLED DOUBLER PER ECO 1159AD.SDR AALA20120613017Frame · crackedFRAME CRACKED STATION 294 RIGHT. INSTALLED DOUBLER REPAIR PER SRM 51-40-02 AND 51-70-11-2R.SDR AALA20120620018Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 986.5 RIGHT AND LEFT BUTTLINE 46. REPLACED FLOORBEAM PER SRM 53-70-51-2R4.SDR AALA20120613019Frame · crackedFRAME CRACKED AT BRACKET STATION 480. REMOVED DAMAGE AND INSTALLED DOUBLER/TRIPLER PER ECO J1159AD.SDR AALA20120613013Channel · corrodedAFT CARGO, RIGHT TRANSITIONAL PANEL HAS SEVERAL AREAS OF CORROSION FROM STATIONS 727I TO 767, RIGHT BUTTLINE 20. REMOVED CORRODED SECTION OF Z-CHANNEL AND REPLACED AS PER AARD 51-00-05-1. REPLACEMENT SECTION WAS SPLICED INTO EXTISTING Z-CHANNEL AS PER SRM 53SDR AALA20120628003Skin · dentedINTERIM DOUBLER REPAIR INSTALLED, FOR DENTED AND PUNCTURED SKIN AT STATION 285. REMOVED INTERIM REPAIR AND INSTALLED PERMANENT DOUBLER REPAIR PER EA B737-53-024658.SDR AALA20120617004Support Bracket · crackedSUPPORT BRACKET FOR AIR CONDITIONING RAIL AT STATION 500A LEFT CRACKED. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120617005Support Bracket · crackedSUPPORT BRACKET FOR AIR CONDITIONING RAIL AT STATION 500C RIGHT CRACKED. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120613016Bracket · crackedAIR CONDITIONING RAIL SUPPORT BRACKET CRACKED AT STATION 400R. CUT OUT CRACK AND INSTALLED DOUBLER/TRIPLER PER ECO J1159AD.SDR AALA20120613008Support Bracket · crackedAIR CONDITIOING RAIL SUPPORT BRACKET STATION 827 RIGHT CRACKED. CUT OUT DAMAGED AREA INSTALLED DOUBLER AND TRIPLER TO FRAME PER ECO J1159AD.SDR AALA20120613014Floorbeam · corrodedFLOORBEAM UPPER FLANGE CORROSION AT STATIONS 324 TO 339. REMOVED AND REPLACED FLOORBEAM CHORD CREASE ANGLE FROM STATIONS 259 TO 360 AT RIGHT NUMBER 1 DOOR PER AARD 53-00-00-7 AND EA B737-53-024412.SDR AALA20110221LAX01Target · looseLAX - INFLIGHT SNA-DFW. CREW REPORTED LEFT THRUST REVERSER LIGHT ILLUMINATED ON ROTATION. EMERGENCY DECLARED FLIGHT DIVERTED LAX LANDED WITHOUT INCIDENT. PLACARD LEFT THRUST REVERSER INOPERATIVE. ON 03/01/2011 AT LAX FOUND INBOARD ARM TARGET LOOSE. RE-INSTSDR AALA20100401DTW01Wire Harness · brokenEMERGENCY ESCAPE PATH SEAT MOUNTED LIGHTS INOPERATIVE AT SEAT 22D DUE TO BROKEN WIRE HARNESS. REPLACED CABLE FOR EMERGENCY ESCAPE PATH SEAT MOUNTED LIGHT AT SEAT 22D.SDR AALA20091218TUL15Skin · dentedDENT IN LEADING EDGE OF HORIZONTAL STABILIZER RIGHT SIDE 35 INCHES FROM INBOARD SIDE. REWORKED DENTED AREA BACK TO ORIGINAL CONTOUR PER ESO B737-655-008472 DATED 12-18-09.SDR AALA20091218TUL07Skin · dentedSTABILIZER LEADING EDGE HAS DENTS. CUT AWAY BLENDED AREA 83 INCHES FROM OUTBOARD END AND INSTALLED FLUSH REPAIR PER SRM 55-10-01-2R.SDR AALA20091218TUL06Skin · dentedSTABILIZER LEADING EDGE HAS DENTS. RIGHT LEADING EDGE DENTED 51 INCHES FROM INBOARD SIDE. REWORKED DENT BACK TO ORIGINAL CONTOUR PER SRM 51-70-01-R2.SDR AALA20090928TUL13Battery Pack · failedEMERGENCY LIGHT BATTERY PACK AT M1670 FAILED FUNCTIONAL CHECK. REPLACED BATTERY PACK AT M1670.SDR AALA200802246Connector · looseDFW EMERGENCY LIGHTS AT SEAT ROW 7DEF INOPERATIVE. SECURED CONNECTOR IN SIDEWALL FOR EMERGENCY LIGHTS AT SEAT ROW 7DEF. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200801890Sign · damagedLGA - EMERGENCY EXIT IDENTIFIER LIGHT AT RT NR 1 DOOR NEAR GARBAGE BIN BROKEN. REPLACED EXIT LIGHT IDENTIFIER ASSEMBLY AT RT NR 1 DOOR NEAR GARBAGE BIN. SYSTEM GROUND CHECKED NORMAL OPERATION. (S)SDR AALA20072578Lamp · inoperativeTUL - EMERGENCY LIGHT AT OVERHEAD SEAT ROW 10ABC INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD SEAT ROW 10ABC. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072577Lamp · inoperativeTUL - EMERGENCY LIGHT AT RIGHT FORWARD OVERWING EXIT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT RIGHT FORWARD OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072576Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK AT STATION 322 FAILED TEST. REPLACED BATTERY PACK M1674 FOR EMERGENCY LIGHTS IN FORWARD CABIN AT STATION 322. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072575Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN FORWARD CABIN FAILED TEST. REPLACED BATTERY PACK M1675 FOR EMERGENCY LIGHTS IN FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060745Bulb · inoperativeMIA - EMERGENCY LIGHTS AT 13F, 14AF INOPERATIVE. RELAMPED EMERGENCY LIGHTS AT 13F AND 14AF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050482Battery Pack · inoperativeTUL - EMERGENCY LIGHTS AT FORWARD GALLEY OVERHEAD STATION 328 FAILED TEST IN ACCORDANCE WITH WORK CARD 2311. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD GALLEY OVERHEAD STATION 328. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040468Light · inoperativeMIA - EMERGENCY LIGHT ASSEMBLY AT SEAT 19D INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY AT SEAT 19D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20001699Apu · failedORD - FLT 2099 - SHORTLY AFTER DEPARTURE FROM GATE, CREW REPORTED A LOUD EXPLOSION FOLLOWED BY SMOKE FILLING THE CABIN. APU SHUTDOWN. REPLACED APU AND ACCOMPLISHED LEAK CHECK. SYSTEM GRUOND CHECKED NORMAL OPERATION. (M)
Back to N943AN