N949AN
Service difficulty reports · 181
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 = 'N949AN' 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 = 'N949AN' 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 AALA201807096010Web · corrodedCORROSION ON THE WEB, FORWARD GALLEY MOUNT BETWEEN BS 986.5 TO 1016, LBL 32. REPLACED THE WEB IAW 51-00-05.SDR AALA20180702001Web · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. WHILE AIRCRAFT WAS IN BASE MAINTENANCE, CORROSION WAS FOUND ON LEFT AFT WEB STATION 1016, LBL 32. REPLACED WEB 147A5712-51 PER 51-00-05.SDR AALA201807029006Angle · corrodedCORROSION ON R1 DOOR CREASE ANGLE BETWEEN BS 332 TO 325 AT FORWARD SERVICE DOOR SILL. REPLACED CREASE ANGLE IAW 51-00-05.SDR AALA20180628010Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK ON FLOOR INTERCOSTAL AT STA 316, LBL 46. REPLACED INTERCOSTAL PER 51-00-05.SDR AALA20180628012Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACKED INTERCOSTAL FOUND BETWEEN STA 328-313 RBL 32. REPLACED INTERCOSTAL PER 51-00-05.SDR AALA201807028008Floor Support · crackedCRACK WAS FOUND ON FLOOR SUPPORT AT BS 328 - 344, LBL 46. REPLACED THE FLOOR SUPPORT 141A5410-16.SDR AALA201807063001Rib · crackedRIGHT STABILIZIER RIB 92.7 WAS CRACKED AT THE NR 2 STIFFENER. REPAIRED THE RIB DOUBLER IAW SRM 51-40-02.SDR AALA20180703019Rib · crackedAIRCRAFT IN BASE MAINTENANCE. LEFT HAND STABILIZER RIB 92.7 CRACKED AT 1 THRU 4 STIFFENERS. REPLACED RIB PER 51-00-05 AND PRINT 182A5301.SDR AALA201806049015Spacer · detachedPIECE OF TEFLON FELL OFF FORWARD R1 DOOR SLIDE. INSTALLED TEFLON SPACER ON THE GIRT BAR, OPS CHECKED NORMAL IAW AMM 25-66-01.SDR AALA201710239043Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT IDENTIFIER BY THE G1 GALLEY HAS A BROKEN LENS COVER. REMOVED AND REPLACED LIGHT L1186 PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201710239042Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT IDENTIFIER BY THE FORWARD FLIGHT ATTENDANT JUMPSEAT HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT L1187 PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201707149017Life Raft · unsecureLIFE RAFT FELL OUT OF FORWARD COMPARTMENT. MAINTENANCE REINSTALLED THE RAFT IAW TASK 25-64-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707059041Light · missingLEFT OVERWING EMERGENCY EXIT MISSING SIGN IN MIDDLE LOCATION. REPLACED LIGHT ASSY IAW AMM 33-51-01.SDR AALA201705059042Cover · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN LEFT HAND SIDE EMERGENCY LIGHT COVER IN PASSENGER CABIN AT SEAT ROW 14. REPLACED LIGHT COVER PER AMM 33-51-01.SDR AALA20170303005Sign · unsecureAIRCRAFT WAS NOT GROUNDED. OVERHEAD EMERGENCY EXIT SIGN BY ROW 14 IS UNSECURE. REINSTALLED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161206023Light · inoperativeAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT ROW 24 IS INOPERATIVE. REMOVED AND REPLACED LIGHT IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20161003004Floor Support · crackedINTERCOSTAL AT LBL 46 BETWEEN FUSELAGE STATION 328 AND 344 IS CRACKED. REMOVED AND REPLACED INTERCOSTAL IAW AARD 51-00-05-1, REPAIR 1.SDR AALA20160829002Flap System · malfunctionedFLAPS SELECTED FROM 30 TO 40 ON LANDING. FLAP INDICATOR STILL SHOWED FLAPS 30. PERFORMED GO-AROUND. FLAPS CAME UP NORMALLY. SELECTED FLAPS 30 ON NEXT LANDING ATTEMPT. FLIGHT LANDED OK. SELECTED FLAPS 40 ON GROUND AND FLAPS EXTENDED OK. INSPECTED FLAPS, NOSDR AALA20160614007Trim System · malfunctionedAIRCRAFT WAS NOT GROUNDED. AIR INTERRUPT, EMERGENCY DECLARED. LANDING UNEVENTFUL. ACFT NOT OVERWEIGHT. DURING CLIMB HORIZONTAL STABILIZER ELECTRIC TRIM FAILED ON BOTH CONTROL YOKES AND AUTOPILOT. MANUAL TRIM REMAINED AVAILABLE. MAINTENANCE ACCOMPLISHED, FISDR AALA20160228004Module · malfunctionedLANDING GEAR LEVER JAMMED IN UP POSITION, WILL NOT GO TO OFF. GEAR & DOORS UP WITH ALL INDICATIONS NORMAL. OVERRIDE SWITCH OK TO CORRECT. FLIGHT DECLARED AN EMER & RETURNED WITHOUT FURTHER INCIDENT. LG EXTENDED WITH NORMAL & SAFE INDICATIONS. REPLACED LG SDR AALA20151022014Warning System · activatedRIGHT ENG LOW OIL QTY & PRESS INDICATION, HIGH TEMPERATURE INDICATION. AN EMER WAS DECLARED & THE FLIGHT DIVERTED WITHOUT FURTHER INCIDENT. ACFT WAS REMOVED FROM SERVICE.SDR AALA20150127011Control Module · defectiveAIR INTERRUPT, RETURNED & AN EMER WAS NOT DECLARED. LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CLIMB CREW RECEIVED A RT WING TO BODY OVERHEAT INDICATION. R & R LT WING OTBD OVERHEAT DETECTOR M268 IAW AMM 26-11-02 & COMPARTMENT OVERHEAT DETECTION CONTRSDR AALA20150107001Control Unit · faultyAIR INTERRUPT, RETURNED & EMER DECLARED. LANDING UNEVENTFUL & ACFT WAS OVERWEIGHT. DURING CLIMB LT WING & BODY OVERHEAT WARNING ILLUMINATED AT 9,000 FEET. PERFORMED QRH PROCEDURE & LIGHT EXTINGUISHED IN ABOUT 3 MINUTES. PERFORMED BITE OF WING & BODY HEAT CSDR AALA20141010005Skin · corrodedCENTER WING LOWER SKIN CORROSION NEAR STATION 540 LT. ACCOMPLISHED REWORK IAW EA B737-57-036658 REV A.SDR AALA20140927003Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 888 TO 1016 BETWEEN STRINGERS 22 TO 26 LT. REMOVED CORROSION & REPLACED RIVETS IAW EA B737-53-036749.SDR AALA20140818005Pitot Tube · cloggedSPLIT AIR SPEED INDICATION ON TAKEOFF. EMER DECLARED FLIGHT RETURNED & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED CAPTAINS PITOT TUBE. SYS GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20140105001Sign · brokenEXIT SIGN AT RT AFT GALLEY BROKEN. REPLACED RT AFT GALLEY EMERGENCY EXIT LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130205005Splice · crackedCABIN FLOOR SEAT TRACK SPLICE, RIGHT 24.75 HAVE CRACKED FASTNERS HOLES INBOARD AND OUTBOARD AFT SIDES. ACCOMPLISHED REPAIR PER EA B737-53-028176.SDR AALA20130205004Splice · crackedCABIN FLOOR SEAT TRACK SPLICE, LEFT 24.75 HAVE CRACKED FASTENERS HOLES INBOARD AND OUTBOARD AFT SIDES. ACCOMPLISHED REPAIR PER EA B737-53-028176.SDR AALA20130202004Splice · crackedCABIN FLOOR SEAT TRACK SPLICE, RIGHT 45.50 HAVE CRACKED FASTENERS HOLES INBOARD AND OUTBOARD AFT SIDES. ACCOMPLISHED REPAIR PER EA B737-53-028176.SDR AALA20130202003Splice · damagedCABIN FLOOR SEAT TRACK SPLICE, LEFT 45.50 HAVE CRACKED FASTENERS HOLES INBOARD AND OUTBOARD AFT SIDES. ACCOMPLISHED REPAIR PER EA B737-53-028176.SDR AALA20120727015Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM AT STATION 294.5, RIGHT BUTTLINES 10 TO 12. REMOVED THE CORROSION DAMAGE AND INSTALLED REPAIR PER EA B737-53-025189 AND SRM 53-10-51-2R REPAIR 11.SDR AALA20120726013Intercostal · crackedINTERCOSTAL FROM STATION 277 TO 294 CRACKED. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120726008Floorbeam · corrodedHEAVY CORROSION TO FLOORBEAM AT STATION 986. ACCOMPLISHED NESTED ANGLE REPAIR PER SRM 53-70-51-2R 4.SDR AALA20120724017Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM AT STATION 328 RIGHT BUTTLINES 7.5 TO 13. REMOVED THE CORROSION DAMAGE AND INSTALLED NESTED ANGLE REPAIR PER SRM 53-10-5102R REPAIR 7.SDR AALA20120724016Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 947.5 AND RIGHT BUTTLINE 24. REMOVED THE CORROSION DAMAGE AND INSTALLED NESTED ANGLE REPAIR PER AARD 53-00-00-7 AND SRM 53-00-51-2R AND EA B737-53-025187.SDR AALA20120723005Track · corrodedRIGHT TIEDOWN TRACK CORRODED STATIONS 790 TO 847. INSTALLED DOUBLER STRAP AND FILLER PER EA B737-53-025100.SDR AALA20120723003Stiffener · crackedSTIFFENER CRACKED AT INBOARD FASTENERS ON LEFT VAPOR BARRIER. INSTALLED NEW STIFFENER PER AARD 51-00-05-1 AND BOEING DOCUMENT 111A1000.SDR AALA20120723002Vapor Barrier · crackedVAPOR BARRIER CRACKED 1ST BAY OUTBOARD OF KEEL BEAM. INSTALLED CROSSBRACE REPAIRS TO BAYS 1L,2L AND 4L PER SRMSUP 57-10-10-2R 2.SDR AALA20120720022Intercostal · crackedFLOORBOARD INTERCOSTAL CRACKED AT CLIPNUT HOLE STATION 324 RIGHT BUTTLINE 33. REMOVED AND REPLACED THE INTERCOSTAL PER AARD 51-10-05-01.SDR AALA20120720021Angle · corrodedTHE FORWARD SERVICE DOOR CREASE ANGLE IS CORRODED. REMOVED AND REPLACED THE CREASE ANGLE PER AARD 51-00-05-1.SDR AALA20120719012Intercostal · corrodedTHE INBOARD INTERCOSTAL AT STATION 927 TO STATION 947, LEFT BUTTLINE 24.75 HAS CORROSION AT LAVATORY MOUNT AREA. REMOVED AND REPLACED THE INTERCOSTAL PER SRM 51-10-02 PARAGRAPH 8.SDR AALA20120719011Attach Angle · crackedINTERCOSTAL FORWARD ATTACH ANGLE, AFT SIDE OF FRAME 500I AT STRINGER 28 RIGHT CRACKED. REMOVED AND REPLACED THE ATTACH ANGLE PER AARD 51-10-05-R1 AND EA B737-53-025021.SDR AALA20120717004Transition Panel · corrodedAFT CARGO RIGHT TRANSITIONAL PANEL Z-PANEL FROM STATIONS 727+4 TO 767 CORRODED. REPLACED PANEL PER SRM 53-00-53-2R 5 AND AARD 51-10-05-R 1.SDR AALA20120713011Receiver · wornLEFT NUMBER 2 DOOR UPPER FORWARD LATCH ROLLER WEARING ON FITTING. REPLACED WORN RECEIVER PER AARD 51-00-05-1.SDR AALA20120712030Frame · crackedLEFT FRAME AT AIR CONDITION RAIL ATTACH IS CRACKED AT THE INBOARD FASTENER AT STATION 500A. INSTALLED REPAIR ANGLES PER ECO J1159AD.SDR AALA20120712029Frame · crackedLEFT FRAME AT AIR CONDITION RAIL ATTACH IS CRACKED AT THE INBOARD FASTENER AT STATION 480. INSTALLED REPAIR ANGLES PER ECO J1159AD.SDR AALA20120712028Frame · crackedLEFT FRAME AT AIR CONDITION RAIL ATTACH IS CRACKED AT THE INBOARD FASTENER AT STATION 440. INSTALLED REPAIR ANGLES PER ECO J1159AD.SDR AALA20120712027Frame · crackedRIGHT FRAME AT AIR CONDITION RAIL ATTACH IS CRACKED AT INBOARD FASTENER AT STATION 867. INSTALLED REPAIR ANGLES PER ECO J1159AD.SDR AALA20120712025Frame · crackedTHE RIGHT FRAME AT AIR CONDITION RAIL ATTACH IS CRACKED AT THE INBOARD FASTENER AT STATION 380. INSTALLED REPAIR ANGLES PER ECO J1159AD.
Back to N949AN