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 AALA20180410010Web · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. LEFT HAND MOON WEB CORRODED AT STATION 1010. REPLACED WEB PER 51-00-05 AND DRAWING 147A5712.SDR AALA20180410007Frame · crackedFORWARD GALLEY DOOR STUB FRAME CRACKED WHERE IT MOUNTS TO CREASE ANGLE. INSTALLED DOUBLER AND SPACER AT FORWARD GALLEY STUB DOOR FRAME IAW SRM 51-70-11-2R.SDR AALA20180409001Angle · crackedFORWARD CARGO BAY BAFFLE ANGLE IS CRACKED BELOW THE LEFT TRANSITION PANEL ON THE FORWARD SDIE OF BS 510H. REPLACED THE ANGLE IAW SRM 51-40-02.SDR AALA20180409002Angle · crackedANGLE CRACKED BELOW THE LEFT TRANSITION PANEL ON AFT SIDE AT BS 500H. REPLACED THE ANGLE IAW SRM 51-40-02.SDR AALA20180408005Skin · crackedCRACK IN THE RIGHT HORIZONTAL STABILIZER LOWER SKIN AT HSS 129.5, APPROXIMATELY 18 INCHES AFT OF FRONT SPAR. REPAIRED THE HORIZONTAL STABILIZER LOWER SKIN IAW SRM 55-10-01-2R.SDR AALA20180409005Transition Panel · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT CORROSION ON LEFT HAND TRANSITION PANEL AT STATIONS 727E-847. REPLACED LEFT HAND TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA20180409006Transition Panel · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT CORROSION ON RIGHT HAND TRANSITION PANEL AT STATIONS 727D-727E. REPLACED TRANSITION PANEL PER SRM 53-00-53-R1.SDR AALA20180405005Web · corrodedAIRCRAFT IN BASE MAINTENANCE. RIGHT HAND HALF MOON WEB CORRODED AT STA 1012. REPLACED WEB PER 51-00-05 AND DRAWING 147A5712.SDR AALA20180405007Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. LEFT ANGLE OUTER CHORD HAS CORROSION AROUND THE SECOND FASTENER AFT OF STATION 300, STR 23L. REPAIRED ANGLE OUTER CHORD PER EA 279070.SDR AALA20180410011Transition Panel · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION FOUND ON RIGHT HAND TRANSITION PANEL AT STATIONS 500C TO 500D. INSTALLED SPLICE DOUBLER AND NEW SECTION OF TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5.SDR AALA20180407002Transition Panel · corrodedCORROSION FOUND ON THE RIGHT TRANSITION PANEL BETWEEN BS 500 TO 500A. REPLACED THE TRANSITION PANEL IAW 51-10-05-1, AND SRM 51-10-02-OG.SDR AALA201712059058Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT AFT GALLEY L2 JUMPSEAT IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA201712059057Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT FORWARD CABIN L1 JUMPSEAT IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA20170706008Battery Pack · faultyEXIT LIGHT ABOVE THE L4 DOOR STAYS ON WITH SWITCH IN OFF POSITION. REPLACED L AFT BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201705199026Light · damagedEMERGENCY EXIT LIGHT ASSY AT THE AFT SERVICE DOOR DAMAGED. MAINTENANCE REPLACED THE EXIT LIGHT ASSY IAW AMM 25-63-00, GOOD FOR SERVICE.SDR AALA20170429002Light · brokenEMERGENCY EXIT LOCATOR LIGHT LENS BY L2 DOOR REPORTED BROKEN BY FLIGHT CREW. REPLACED LENS AND LIGHT ASSEMBLY L2 DOOR REF AMM 33-51-01 (EMERGENCY EXIT LOCATOR SIGN), OPS CK NORMAL, OK FOR SERVICE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703299029Lens · missingROW 15 EMERGENCY EXIT LIGHT ON WALL MISSING ITS COVER. REPLACED EMERGENCY LIGHT LENS AT ROW 15. OPS CHECK GOOD. REF AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170213003Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. LEFT AND RIGHT OVERWING EMERGENCY EXIT LIGHTS ABOVE DOORS FAILED TEST. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECK GOOD.SDR AALA20160727007Intercostal · crackedINTERCOSTAL AT LBL 11 BETWEEN BS 344 AND 360 IS CRACKED. REMOVED AND REPLACED INTERCOSTAL IAW AARD 51-10-05 AND DRAWING 141A5400.SDR AALA20160727005Intercostal · crackedINTERCOSTAL AT LBL 1 BETWEEN BS 344 AND 360 IS CRACKED. REMOVED AND REPLACED INTERCOSTAL IAW AARD 51-10-05 AND DRAWING 141A5400.SDR AALA20160726009Web · crackedVERTICAL PRESSURE WEB AT BS 663.75 IS CRACKED BETWEEN RBL 40 - 45.64. ACCOMPLISHED INTERIM REPAIR IAW EA 262224.SDR AALA20160422010Warning System · false activationAIRCRAFT WAS GNDED. DURING TAKEOFF ROLL THE CONFIGURATION WARNING SOUNDED BETWEEN 80 & 90 KNOTS. ABORTED TAKEOFF AT BETWEEN 90 & 100 KNOTS. ACCOMPLISHED TAKEOFF WARNING SYS TEST IAW AMM 31-51-00 WITH NO FAULTS NOTED.SDR AALA20160420009Warning System · false activationAIRCRAFT WAS GNDED. DURING TAKEOFF THE CONFIGURATION WARNING HORN SOUNDED. TAKEOFF ABORTED BETWEEN 80 & 90 KNOTS. ACCOMPLISHED TAKEOFF WARNING SYS TEST IAW AMM 31-51-00, WITH NO FAULTS NOTED. SYS CHECKED NORMAL.SDR AALA20150902002Connector · looseROW 17 EPL LIGHT INOPERATIVE, FOUND CONNECTOR LOOSE UNDER SEAT. CONNECTED & SECURED CONNECTOR. OPERATIONS CHECKED GOOD IAW AMM 33-51-00. REMOVED PLACARD & CLEARED MIC SHEET.SDR AALA20141223001Fseu · faultedEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING APPROACH AT FLAP EXTENSION THE LE FLAPS TRANSIT AMBER LIGHT ILLUMINATED THROUGH FLAPS 1 DEG, 2 DEG & 5 DEG. PERFORMED BITE OF FSEU WHICH RETURNED CODE 27-51109. R & R THE FSEU IAW AMM 27-5SDR AALA20141215013Seat Track · crackedSEAT TRACK JOINT FLANGE IS CRACKED AT STATION 727B & RBL 24.7. REPAIRED SEAT TRACK FLANGE IAW EA 53-037759 DATED 12/12/14 & DWG SB 737-53-1296.SDR AALA20141215012Seat Track · crackedSEAT TRACK JOINT FLANGE IS CRACKED AT STATION 727B & RBL 45.5. REPAIRED SEAT TRACK FLANGE IAW EA 53-037759 DATED 12/12/14 & DWG SB 737-53-1296.SDR AALA20141215011Seat Track · crackedSEAT TRACK JOINT FLANGE IS CRACKED AT STATION 727B & LBL 24.7. REPAIRED SEAT TRACK FLANGE IAW EA 53-037759 DATED 12/12/14 & DWG SB 737-53-1296.SDR AALA20141215005Seat Track · crackedSEAT TRACK JOINT FLANGE IS CRACKED AT STATION 727B & LBL 45.5. REPAIRED SEAT TRACK FLANGE IAW EA 53-037759 DATED 12/12/14 & DWG SB 737-53-1296.SDR AALA20141031004Actuator · obstructedAIR INTERRUPT INFLIGHT WHEN TURNING RT WITH MANUAL CONTROL THERE WAS A HESITATION IN ROLL RESPONSE. AIRPLANE WAS CONTROLLABLE AT ALL TIMES. AUTOPILOT CONTROL WAS NORMAL. DIVERTED, EMER DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. PERFORMED CARD 27-9SDR AALA20140728007Skin · mechanic errorPUNCTURED HOLE IN LT SIDE OF RUDDER WITH TOOLING WHILE POSITIONING SLIDERS ON THE TAIL DOCK. ACCOMPLISHED BONDED REPAIR IAW AARD 51-60-07-01.SDR AALA20140724005Intercostal · crackedINTERCOSTAL CRACKED UNDER FWD ENTRY FLOORBOARD FROM STATIONS 312 TO 328. REPLACED INTERCOSTAL IAW SRM 53-10-51.SDR AALA20140514002Module · inoperativeEMERGENCY LIGHT ON RT FWD & AFT OVERWING EXIT DOORS FAILED. R & R EMERGENCY EXIT LIGHT MODULE M1695, OPERATIONS CHECKED NORMAL.SDR AALA20130408003Wire · burnedSTRONG ELECTRICAL SMELL AND SMOKE COMING FROM THE CENTER CONSOLE WITH CIRCUIT BREAKER TO DISCONNECT SECTOR 3 POPPED. FOUND BURNT WIRE AND CONTACTOR IN THE P-8 HORIZONTAL STABILIZER TRIM/ CABIN DOOR MODULE ASSEMBLY. REMOVED AND REPLACED THE MODULE ASSEMBLY. SDR AALA20130401005Module · shortedSJO - CREW REPORTED ELECTRICAL ISSUES. EMERGENCY DECLARED FLIGHT RETURNED SJO LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ELECTRICAL METERS BATTERY AND GALLEY POWER MODULE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120916005Panel · malfunctionedAMA - INFLIGHT DFW-DEN CREW REPORTED SMOKE IN THE COCKPIT. EMERGENCY DECLARED FLIGHT DIVERTED AMA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. OPENED ATC/TCAS PANEL AND FOUND BURNED CONNECTION TO LIGHT PANEL. REPLACED ATC/TCAS PANEL. SYSTEM GSDR AALA20120514012Intercostal · corrodedINTERCOSTAL BETWEEN STATIONS 827 AND 847 LEFT SIDE CORRODED. REPLACED INTERCOSTAL PER AARD 51-10-05-R1.SDR AALA20120509001Floorbeam · corrodedCABIN FLOORBEAM 328 UPPER FLANGE HAS AREAS OF CORROSION AT STATION 328 RIGHT BUTTLINE 12 AND 14. INSTALLED STRAP REPAIR ON STATION 328 FLOORBEAM PER SRM 53-10-51-2R 8.SDR AALA20120504015Frame · crackedCRACK AT STATION 480 STRINGERS 8 TO 9 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD-0006.SDR AALA20120504014Frame · crackedCRACK AT STATION 400 LEFT STRINGERS 8 TO 9 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD-0006.SDR AALA20120507015Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 400L IS CRACKED AT BIN RAIL. INSTALLED ANGLES A AND B PER ECO J1159AD CARD 0006.SDR AALA20120507003Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 867R IS CRACKED AT BIN RAIL. INSTALLED BELL FRAME REPAIR DOUBLERS AT 867R PER ECO J1159AD-0002.SDR AALA20120506004Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 787 R IS CRACKED AT BIN RAIL. INSTALLED DOUBLER REPAIR PER ECO J1159AD-0007.SDR AALA20120506003Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 727B R IS CRACKED AT BIN RAIL. INSTALLED DOUBLER REPAIR PER ECO J1159AD-0007.SDR AALA20120506002Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 727I L IS CRACKED AT BIN RAIL. INSTALLED REPAIR DOUBLER PER ECO J1159AD-0006.SDR AALA20120506001Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 887L IS CRACKED AT BIN RAIL. INSTALLED REPAIR DOUBLER PER ECO J1159AD-0006.SDR AALA20120505020Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 480R IS CRACKED AT BIN RAIL. INSTALLED REPAIR DOUBLERS PER ECO J1159AD CARD 0007.SDR AALA20120505006Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 500F R IS CRACKED AT BIN RAIL. INSTALLED FRAME REPAIR DOUBLERS PER ECO J1159AD-0007.SDR AALA20120505005Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 500C R IS CRACKED AT BIN RAIL. INSTALLED REPAIR DOUBLERS AS PER ECO J1159AD-0007.SDR AALA20120505004Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 500A R IS CRACKED AT BIN RAIL. INSTALLED REPAIR DOUBLERS AS PER ECO J1159AD-0007.
Back to N939AN