N939AN
Service difficulty reports · 233
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 = 'N939AN' 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 = 'N939AN' 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 AALA202002119015Pressure Switch · faultyAIRCRAFT NOT GROUNDED: AUTO BRAKE DISARM LIGHT ILLUMINATED AT TOUCHDOWN WHILE SET AT 3. REMOVED AND REPLACED RH RUDDER PEDAL PRESSURE SWITCH IAW MM 32-42-71.SDR AALA2020020549007Autobrake Sys · malfunctionedAIRCRAFT NOT GROUNDED: AUTOBRAKE SYSTEM DISARMED ON TOUCHDOWN WITH NO BRAKE OR INPUT.***SUPPLEMENTAL ACTION SECT 4: TROUBLESHOOT IAW FIM 32-42-00-810-828 NO FAULTS FOUND. PERFORMED AACU BITE CHECK IAW 32-42-00-810-801 BITE CHECK GOOD.***(CLOSED)SDR AALA201909029002Slide · low pressureAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS L2 DOOR EVACUATION SLIDE PRESSURE LOW. REMOVED AND REPLACED L-2 DOR SLIDE IAW AMM 25-66-01.SDR AALA2019083000022Indicator · splitON APPROCH,FLAP INDICATOR SPLIT NEEDLES AT 7+9 AND FLAPS STOPPED TRACKING. COMPLETED QRH AND RESET FLAP LEVER TO 5. LANDED WITH FLAP LEVER AT 5.THE NEEDLES COME TOGETHER AT APPROX. 7.SDR AALA201908309006Transmitter · unreliableAIRCRAFT WAS GROUNDED: FLIGHT DIVERTED ON ACCOUNT OF FLAP ASYMETRY ISSUE. EMERGENCY DECLARED. ON APPROACH INTO CZM FLAP INDICATOR SPLIT NEEDLES AT 7+9 DEG AND FLAPS STOPPED TRACKING, COMPLETED QRH AND RESET FLAP LEVER TO 5 DEG THE NEEDLES CAME TOGETHER AT APPSDR AALA2019080539001Screw · looseAIRCRAFT WAS NOT GROUNDED, AFT GALLEY EXIT SIGN CELLING PANEL HAD 2 SCREWS LOOSE. MAINTENANCE SECURED SIGN PER STANDARD PRACTICES.SDR AALA201907099005Module · inoperativeAIRCRAFT WAS GROUNDED: PILOT REPORTS CTR TANK FED ENGINES INCORRECTLY SHORTLY AFTER TAKE OFF A FUEL IMBALANCE OCURRED WITH LEFT TANK OVER 1000LBS LOWER THAN THE RIGHT. SUSPECT LEFT CTR BOOST PUMP OUTPUT IS TOO LOW DURING HIGH POWER SETTINGS (TAKE OFF, CLIMB) SDR AALA201906249011Sensor · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS SPD LIM FLAG IN VIEW ON CA SIDE CAME ON AFTER TAKEOFF AND STAYED ON ENTIRE FLIGHT, STALL WARNING STICK SHAKER CAME ON AT LEAST 10 TIMES IN FLIGHT FOR A FEW SECONDS EACH TIME. ALSO, FLT CONT LIGHT ON AND AUTO SLAT FAIL STAYSDR AALA201906139013Floor Panel · damagedAIRCRAFT WAS GROUNDED: MAIN CABIN FLOOR PANEL AT ROW 6 VERY SPONGY. REPAIRED FLOOR PANEL PER 53-00-00-6.SDR AALA201810229051Sensor · defectiveAIRCRAFT WAS GROUNDED. PHX-MIA DECLARED EMERGENCY INBOUND MIA ACCOUNT FLAPS WOULD NOT EXTEND. FLIGHT LANDED WITHOUT INCIDENT. ON APPROACH AFTER SELECTING FLAPS TO 1, FLAP INDICATION WAS UP AND SPLIT. CREW DID FLAP ECS LANDING. REPLACED SENSOR NR 1 OUT B FLAP SSDR AALA2018102329030Fseu · defectiveFLAP ASYMMETRY UPON EXTENSION LEFT NEEDLE AT "0", RIGHT NEEDLE APPROXIMATELY "0.1". LEADING EDGE DEVICE EXTENDED VIA ALTERNATE FLAP SWITCH, NO EXCESSIVE BRAKE USE REQUIRED FOR LANDING. THE AIRCRAFT WAS GROUNDED. ACCOMPLISHED VISUAL INSPECTION OF TRAILING EDGSDR AALA2018092549040Spring · out of positionL1 DOOR GUST LOCK WOULD NOT STAY LATCHED. MAINTENANCE FOUND THE SPRING OUT OF PLACE AND REPOSITIONED THE SPRING, OPERATED DOOR.SDR AALA201809119011Slide · damagedFORWARD GALLEY DOOR SLIDE GIRT BAR PULLED OUT OF SLIDE. REPLACED THE SLIDE IAW 25-94-10.SDR AALA2018042500001Floorbeam · corrodedCORROSION ON FLOORBEAM ANGLE AT BS 500I. REPLACED THE FLOORBEAM ANGLE IAW DRAWING 143A9481.SDR AALA2018042500013Floor Support · corrodedFORWARD CROSS SECTION HAS CORROSION ON FLOOR SUPPORT AT RBL 16 AT THE FASTNER HOLES AND NUT PLATES AT POD LOCK AT BS 500I MINUS 4 INCHES. REPAIRED THE FLOOR SUPPORT IAW EA 279913 AND SRM 53-00-53-2R-4.SDR AALA20180420011Floor Support · corrodedLEFT FLOOR SUPPORT CORRODED AT BS 951, LBL 26. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1, AND DRAWING 815A0010.SDR AALA20180419010Floorbeam · corrodedFLOORBEAM CORRODED AT BS 951, LBL 17 - LBL 26. INSTALLED SERVICABLE FLOORBEAM ANGLE IAW 51-00-05-1, AND DRAWING 815A0010, AND 141A5676.SDR AALA2018042019009Floorbeam · corrodedCORROSION FOUND ON THE FLOORBEAM, BS 951, BETWEEN LBL 27 AND 48. REPLACED THE FLOORBEAM TEE IAW 51-00-05-1, AND DWG 815A0010.SDR AALA20180419008Web · corrodedCORROSION FOUND ON THE RIGHT WEB, BS 998. REPLACED THE WEB IAW 51-00-05, AND DRAWING 147A5700.SDR AALA2018042019007Angle · corrodedCORROSION FOUND ON THE RIGHT ZEE ANGLE LOCATED BETWEEN BS 990 AND 1016, RBL 32. REPLACED THE ANGLE IAW 51-00-05, AND DRAWING 147A5700.SDR AALA2018042019006Floor Support · corrodedCORROSION FOUND ON THE FLOOR SUPPORT BS 958, RBL 52. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1, AND DRAWING 815A0010.SDR AALA20180418008Threshold · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AT R2 DOOR THRESHOLD WEB, ON BOTTOM SIDE, AT STATION 947 TO STATION 986. REPLACED R2 DOOR THRESHOLD WEB PER DRAWING 147A8510 AND AARD 51-00-05, AND EA 279053.SDR AALA20180418010Angle · corrodedRIGHT CREASE ANGLE IS CORRODED BETWEEN BS 955 TO 986. REPLACED THE CREASE ANGLE IAW DRAWING 147A8501.SDR AALA20180417012Floor Support · corrodedCORROSION FOUND ON THE FLOOR SUPPORT, BS 951 - 966, LBL 52. CORROSION FOUND TO BE OUT OF LIMITS. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1, AND DRAWING 815A0010.SDR AALA20180417011Bulkhead Web · crackedBULKHEAD WEB CRACKED, BS 663, RBL 40 - 45.64. REMOVED THE DAMAGE AND REPAIRED IAW SRM 57-10-10-2R-3.SDR AALA20180417005Floorbeam · corrodedFLOORBEAM BS 986.5 CORRODED AT LBL 4, 26, 33, 43 AND RBL 20, 32, 34, 42. A FLOORBEAM TEE REPAIR WAS INSTALLED IAW SRM 53-70-51-2R-4.SDR AALA20180416013Intercostal · corrodedDURING REPLACEMENT OF THE SHIELD ASSMEBLY, FORWARD OF THE AFT CARGO DOOR, FOUND ATTACHMENT INTERCOSTAL CORRODED. REPLACED THE INTERCOSTAL.SDR AALA20180416017Intercostal · corrodedAFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL IS CORRODED AT RBL 12. REPLACED THE INTERCOSTAL IAW 51-00-05 AND DRAWING 148A0922 REVISION A.SDR AALA20180416012Intercostal · corrodedAFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL IS CORRIDED AT LBL 5. REPLACED INTERCOSTAL PER AARD 51-00-05 AND BOEING DRAWING 148A0922 REVISION A.SDR AALA20180416010Floorbeam · corrodedAFT CARGO, CORROSION ON THE FLOORBEAM ANGLE, BS 947.5, RBL 10. INSTALLED NEW FLOORBOARD SUPPORT BRACKET ASSEMBLY.SDR AALA20180416015Intercostal · corrodedAFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL IS CORRODED AT LBL 21. REPLACED THE INTERCOSTAL IAW 51-00-05, AND DRAWING 148A0922, REVISION A.SDR AALA201804180014Intercostal · corrodedAFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL IS CORRODED AT LBL 12. REPLACED THE INTERCOSTAL IAW 51-00-05, AND DRAWING 148A0922, REVISION A.SDR AALA2018041806018Intercostal · corrodedAFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL IS CORRODED AT RBL 21. REPLACED INTERCOSTAL IAW 51-00-05, AND DRAWING 148A0922, REVISION A.SDR AALA201804180016Intercostal · corrodedAFT PRESSURE BULKHEAD WATER SEAL INTERCOSTAL IS CORRODED AT RBL 5. REPLACED INTERCOSTAL IAW 51-00-05, AND DRAWING 148A0922, REVISION A.SDR AALA20180416011Intercostal · corrodedAFT PRESSURE BULKHEAD INTERCOSTAL AT STRINGER 34R IS CORRODED. REPLACED INTERCOSTAL IAW 51-00-05, AND DRAWING 148A0922, REVISION A.SDR AALA2018041800009Web · corrodedCORROSION ON THE L2 DOOR LOWER CUT OUT WEB BETWEEN BS 951 TO 992, LBL 51. REPLACED THE WEB IAW 51-00-05-1, AND DRAWING 147A8501.SDR AALA20180416008Intercostal · corrodedAFT PRESSURE BULKHEAD INTERCOSTAL CORRODED AT BS 1028, LBL 34. REPLACED THE INTERCOSTAL IAW 51-00-05, AND DRAWING 148A0922, REVISION A.SDR AALA2018041800007Floor Support · crackedLEFT CENTER FLOOR SUPPORT CRACKED AT BS 540, BL 0. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-2.SDR AALA2018041800006Floor Support · crackedRIGHT CENTER FLOOR SUPPORT CRACKED AT BS 540, BL 0. REPLACED THE FLOOR SUPPORT IAW 51-10-2.SDR AALA20180416005Angle · corrodedLEFT ZEE ANGLE CORRODED AT BS 992, FROM LBL 32 TO LBL 44. INSTALLED A NEW ZEE ANGLE IAW 51-00-05, AND DRAWING 147A5700.SDR AALA2018041800003Angle · corrodedLEFT ZEE ANGLE CORRODED BETWEEN BS 992 & 1016, LBL 32. INSTALLED A NEW ZEE ANGLE IAW 51-00-05, AND DRAWING 147A5700.SDR AALA2018041800002Web · corrodedLEFT K ANGLE WEB CORRODED BETWEEN BS 986 TO 991, LBL 31. INSTALLED A NEW WEB IAW 51-00-07, AND DRAWING 147A5700.SDR AALA20180413002Angle · corrodedLEFT CREASE BEAM ANGLE CORRODED BETWEEN BS 947 TO 992. REPLACED THE CREASE BEAM ANGLE IAW 51-00-05, AND DRAWING 147A8501.SDR AALA20180413010Floor Support · corrodedAFT CARGO, BS 847 - 787 FLOOR SUPPORT CORRODED INBOARD OF WEB, RIGHT SIDE. REPLACED THE FLOOR SUPPORT IAW DRAWING 146A8128, 51-00-05, AND EA 279462, DRAFT 2.SDR AALA20180411006Mount · corrodedFORWARD ENTRY FORWARD GIRT BAR FITTING MOUNT CORRODED AT BS 312, LBL 54. REPLACED GIRT BAR MOUNT IAW SRM 51-40-02.SDR AALA20180411005Mount · corrodedFORWARD ENTRY AFT GIRT BAR FITTING MOUNT CORRODED AT BS 344 AND LBL 59. REPLACED THE GIRT BAR MOUNT IAW SRM 51-40-02.SDR AALA20180411004Crease Beam · corrodedRIGHT CREASE BEAM ANGLE CORRODED BETWEEN BS 308 AND 337. REPLACED CREASE BEAM ANGLE IAW DRAWING 141A8310, AND 51-00-05-1.SDR AALA20180411003Intercostal · crackedINTERCOSTAL BETWEEN BS 277 TO 294.5, CRACKED AT FASTENER HOLE. INSTALLED A NEW INTERCOSTAL IAW SRM 51-40-02.SDR AALA20180410012Channel · corrodedCORROSION WAS FOUND ON THE FORWARD CARGO LEFT TRANSITION PANEL CHANNEL AROUND THE OUTBOARD FASTENER HOLES, BETWEEN BS 410 AND 500C. INSTALLED A NEW TRANSITION PANEL CHANNEL IAW SRM 53-00-53-2R-6.SDR AALA20180410013Transition Panel · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION ON FORWARD CARGO LEFT HAND TRANSITION PANEL AT STATIONS 500H AND 500I. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R5.
Back to N939AN