N924AN
Service difficulty reports · 212
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 = 'N924AN' 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 = 'N924AN' 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 AALA201706089002Fitting · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON VERTICAL STABILIZER LEFT FORWARD FITTING CLEVIS, AFT LUG ON FORWARD SURFACE AND FORWARD LUG ON AFT SURFACE. REPAIRED IAW EA#269829.SDR AALA20170602005Fitting · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON VERTICAL STABILIZER RIGHT FORWARD FITTING CLEVIS, AFT LUG ON FORWARD SURFACE AND FORWARD LUG ON AFT SURFACE. REPAIRED IAW EA 269829.SDR AALA20170531003Plate · corrodedCORROSION ON AFT CARGO DOOR LOWER SILL PLATE BETWEEN BS 787 AND 847. REMOVED AND REPLACED SILL PLATE IAW SRM 51-30-01, SRM 53-60-15-2R, AND DRAWING 146A8123.SDR AALA201706099018Floor Support · corrodedCORROSION FOUND ON THE AFT CARGO FLOOR SUPPORT, BS 787+4, RBL 8.1. REPAIRED IAW SRM 53-00-53-2R-2 AND EA 270205.SDR AALA20170529001Cargo Track · corrodedCORROSION ON AFT CARGO, CARGO TRACK ASSEMBLY BS 787+4, RBL 3. REPAIRED IAW SRM 53-00-53-2R-2, AND EA 270205.SDR AALA201706089053Floorbeam · corrodedCORROSION ON AFT CABIN FLOORBEAM ANGLE AFT OF BS 986.5, LBL 32 TO LBL 45. REMOVED AND REPLACED FLOORBEAM ANGLE IAW 51-00-05-1 AND DRAWING 147A5700.SDR AALA20170526005Angle · corrodedCORROSION ON AFT CABIN G4 GALLEY FLOOR SUPPORT ANGLE BETWEEN BS 991 AND 1016, LBL 32. REMOVED AND REPLACED THE ANGLE IAW 51-00-05-1, SRM 53-70-51-1A AND DRAWING 147A5710.SDR AALA20170526004Web · corrodedCORROSION ON AFT CABIN FLOOR LEFT WEB, BETWEEN BS 986.5 AND 1016, LBL 33. REMOVED AND REPLACED THE FLOOR WEB IAW 51-00-05-1, SRM 53-70-51-1A, AND DRAWING 147A5700.SDR AALA20170526003Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON LEFT CREASE ANGLE BETWEEN FUSELAGE STATIONS 944 AND 996 AT LBL64. REMOVED AND REPLACED ANGLE IAW SRM 51-40-02, AARD 51-00-05-1, SRM 53-70-51-1A, AND DRAWING 147A8501.SDR AALA20170525011Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON RIGHT CREASE ANGLE BETWEEN FUSELAGE STATIONS 947 AND 992 AT RBL64. REMOVED AND REPLACED ANGLE IAW SRM 51-40-02, AARD 51-00-05-1, SRM 53-70-51-1A, AND DRAWING 147A8501.SDR AALA20170525010Web · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON RIGHT OUTBOARD WEB UNDER THE G4 GALLEY, BETWEEN FUSELAGE STATIONS 986 AND 1016, RBL33 TO RBL45. REMOVED AND REPLACED WEB IAW AARD 51-00-05-01 DRAWING 147A5700.SDR AALA20170525009Strap · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON G4 GALLEY LOWER FLOOR STRAP BETWEEN FUSELAGE STATION 1006 AND AFT PRESSURE BULKHEAD AT RBL28. REMOVED AND REPLACED STRAP IAW AARD 51-00-05-01 AND DRAWING 147A5714.SDR AALA20170524018Floorbeam · corrodedCORROSION FOUND ON THE AFT CABIN FLOORBEAM ANGLE AT BS 693, LBL 33 AND 45. REPLACED THE FLOORBEAM ANGLE IAW SRM 53-70-51-1A.SDR AALA20170523012Floor Support · corrodedCORROSION ON RIGHT OTBD FLOOR SUPPORT AROUND THE NUT PLATE HOLES, BETWEEN BS 947 AND 956, RBL 51. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02, SRM 51-40-03, AND DRAWING 147A5660.SDR AALA20170523010Floor Support · corrodedCORROSION ON AFT CABIN G4 FLOOR SUPPORT ANGLE BETWEEN BS 993 AND 1016, RBL 33. REMOVED AND REPLACED THE FLOOR SUPPORT ANGLE IAW 51-00-05-1, AND DRAWING 147A5700.SDR AALA20170523009Floorbeam · corrodedCORROSION ON AFT CABIN G4 GALLEY FLOORBEAM ANGLE AT BS 993, RBL 33 TO 45. REMOVED AND REPLACED FLOORBEAM ANGLE IAW 51-00-05-1, SRM 53-70-51-1A, AND DRAWING 147A5700.SDR AALA20170523008Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 951, RBL 27 TO 49. REMOVED AND REPLACED THE FLOORBEAM IAW 51-00-05-1, AND DRAWING 147A5700.SDR AALA20170523007Floor Support · corrodedCORROSION ON AFT GALLEY FLOOR SUPPORT BETWEEN BS 947 AND 967 AT LBL 51. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 53-70-51-2R.SDR AALA20170522008Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON AFT CARGO FLOOR RIGHT TRANSITION PANEL BETWEEN FUSELAGE STATIONS 767 AND 787, S28R. REMOVED AND REPLACED TRANSITION PANEL BETWEEN FUSELAGE STATIONS 767 AND 791 IAW SRM 53-60-15, AARD 51-00-05, AND DRAWING 146A81SDR AALA20170522009Transition Panel · corrodedCORROSION ON AFT CARGO LEFT FLOOR TRANSITION PANEL BETWEEN BS 727D AND 727E, LBL 28. REMOVED AND REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA20170519002Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON AFT CARGO FLOOR RIGHT TRANSITION PANEL BETWEEN FUSELAGE STATIONS 747 AND 767. REMOVED AND REPLACED TRANSITION PANEL BETWEEN FUSELAGE STATIONS 727 AND 767 IAW SRM 51-40-02, SRM 51-10-02, AND SRM 53-00-53.SDR AALA20170519001Web · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON AFT CABIN FLOOR LEFT 1/2 MOON WEB, FUSELAGE STATION 1016 TO AFT PRESSURE BULKHEAD. REMOVED AND REPLACED WEB IAW SRM 51-40-02, SRM 53-70-51-1A AND DRAWING 147A5700.SDR AALA20170518003Floorbeam · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON UPPER CHORD OF FLOORBEAM, FUSELAGE STATION 947.5, LBL10. REPAIRED IAW SRM 53-70-51-2R-5.SDR AALA20170518001Support Beam · wornAIRCRAFT WAS IN BASE MAINTENANCE. WEAR DAMAGE ON THE CENTER WING SUPPORT BEAM REPAIR AT THE PNEUMATIC GROUND AIR DOOR UPPER SURFACE OF THE LANDING. REPAIRED IAW EA 269639 AND SRM 51-10-02.SDR AALA20170516007Angle · crackedCRACKED J ANGLE ON THE RIGHT FORWARD MOUNT OF THE VERTICAL STABILIZER. REMOVED AND REPLACED THE ANGLE IAW 55-30-09-3 AND SRM 51-40-02.SDR AALA20170515003Web · damagedDAMAGED WEB AT FASTENER HOLES BS 994, STRINGER 18R, RBL45. REMOVED AND REPLACED THE WEB IAW 51-00-05-1 AND DRAWING 147A8501.SDR AALA20170511009Spar · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON RIGHT OUTER WING AFT SPAR WEB AT FUEL BOOST PUMP ATTACHMENT POINT, UNDER LOWER BONDING STRAP, WING STATION 150.022 . REPAIRED IAW SRM 57-20-10-1A, SRM 51-10-02, AND EA 269805.SDR AALA20170511007Floorbeam · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON FORWARD CARGO COMPARTMENT AFT WALL LOWER FLOORBOARD SUPPORT RAIL (ANGLE) AT FUSELAGE STATION 500I, LBL24 TO RBL24. REMOVED AND REPLACED RAIL ASSEMBLY IAW SRM 51-40-02.SDR AALA20170511008Spar · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON RIGHT OUTER WING FORWARD SPAR WEB AT FUEL BOOST PUMP, UNDER LOWER BONDING STRAP, WING STATION 120 . REPAIRED IAW SRM 57-20-10-1A-3, SRM 51-10-02, AND EA 269774.SDR AALA20170511006Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON FORWARD CARGO COMPARTMENT RIGHT TRANSITION PANEL BETWEEN FUSELAGE STATIONS 420 AND 440, RBL23. REMOVED AND REPLACED TRANSITION PANEL IAW SRM 53-00-53-2R, SRM 51-10-02-0G, AND DRAWING 143A8126.SDR AALA20170511005Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON FORWARD CARGO COMPARTMENT RIGHT TRANSITION PANEL BETWEEN FUSELAGE STATIONS 500A AND 500B, RBL23. REMOVED AND REPLACED TRANSITION PANEL BETWEEN FUSELAGE STATIONS 500A AND 500I IAW SRM 53-00-53-2R AND SRM 51-10-02.SDR AALA20170511004Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON FORWARD CARGO COMPARTMENT LEFT TRANSITION PANEL BETWEEN FUSELAGE STATIONS 440 AND 460, LBL21. REMOVED AND REPLACED TRANSITION PANEL BETWEEN FUSELAGE STATIONS 410 AND 500I IAW SRM 53-00-53-2R AND SRM 51-10-02.SDR AALA20170509005Floorbeam · corrodedCORROSION ON THE UPPER TEE OF THE FLOORBEAM AT BS 986.5, RBL 50 TO LBL 50. REPAIRED IAW SRM 53-70-51-24-4.SDR AALA20170510006Stringer · wornUPPER LOBE STRINGER 15L WORN IN TWO AREAS BETWEEN BS 500I AND 520. REPAIRED IAW SRM 53-00-03-2R-1 AND EA269845.SDR AALA20170501003Strap · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON STRAP AT R1 ENTRY CREASE ANGLE BETWEEN FUSELAGE STATIONS 277 AND 302. REMOVED AND REPLACED STRAP IAW SRM 51-10-02 AND DRAWING 141A8316.SDR AALA20170523011Floorbeam · corrodedCORROSION ON AFT CARGO FLOORBBEAM AT BS 767+4, RBL 8.1 AND 3. REPAIRED IAW SRM 53-00-53-2 AND EA270205.SDR AALA20170516005Mount · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON L1 DOOR AFT GIRT BAR TIEDOWN ASSEMBLY (MOUNT). REMOVED AND REPLACED MOUNT IAW SRM 51-10-02.SDR AALA20170516003Mount · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON L1 DOOR FORWARD GIRT BAR TIEDOWN ASSEMBLY (MOUNT). REMOVED AND REPLACED MOUNT IAW SRM 51-10-02.SDR AALA20170515005Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON L1 DOOR THRESHOLD CREASE ANGLE BETWEEN FUSELAGE STATIONS 339 AND 344. REMOVED AND REPLACED CREASE ANGLE IAW 51-00-05, SRM 51-40-02, AND DRAWING 141A8112.SDR AALA20170421008Fmc · faultyAFTER ROTATION AT 4000 FEET PILOTS LOST BOTH FMC"S AND LATERAL AND VERTICLE NAV. AFTER MULTIPLE ATTEMPTS THEY WERE RESET. THEN A REPEAT ELEVATOR FEEL DIFFERENTIAL LIGHT CAME ON WITH A MUSHY FEEL. THIS LEAD TO AN AIR TURN BACK WITH AN EMER LANDING DECLARED FOSDR AALA201703299022Sign · damagedWHILE ACCOMPLISHING MCM CARD 2904, FOUND L2 DOOR EMERGENCY EXIT SIGN DAMAGED, LIGHT WORKS NORMAL. REMOVED AND REPLACED L2 DOOR EMERGENCY EXIT SIGN ASSY PER AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170303006Sign · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT THE FORWARD FLIGHT ATTENDANT STATION IS INOPERATIVE. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161220004Girt Bar · out of adjustR1 DOOR EVACUATION SLIDE GIRT BAR IS LOOSE AND MISALIGNED. ADJUSTED GIRT BAR IAW AMM 25-66-00. OPERATIONAL CHECKED GOOD.SDR AALA20161109024Bulkhead Web · crackedVERTICAL PRESSURE WEB AT BS 663.75 IS CRACKED BETWEEN RBL 25.00 AND RBL 43.80 AND BETWEEN LBL 35 AND LBL 43.80. REPAIRED WEB IAW EA #265146. AIRCRAFT WAS GROUNDED.SDR AALA20151223006Control Panel · faultyAIRCRAFT WAS GNDED. AIR INTERRUPT, EMER DECLARED, LANDING UNEVENTFUL & ACFT OVERWEIGHT. DURING CLIMB LG WOULD NOT RETRACT & LNAV WOULD ENGAGE, BUT NOT LOCK. PERFORMED MANUAL EXTENSION SYS ACCESS DOOR SWITCH ADJUSTMENT IAW AMM 32-34-00. PERFORMED GEAR SWINGSDR AALA20151222007Switch · out of adjustAIRCRAFT WAS GNDED. AIR INTERRUPT, EMER DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CLIMB LG WOULD NOT RETRACT & LT NAV WOULD ENGAGE BUT NOT LOCK. PERFORMED MANUAL EXTENSION SYS ACCESS DOOR SWITCH ADJUSTMENT IAW AMM 32-34-00. PERFORMED GEAR SDR AALA20151218006Skin · crackedL1 DOOR CRACKED AT AFT EDGE OF INNER SKIN, 4TH STOP FROM BOTTOM. REPAIRED L1 DOOR AFT EDGE INNER SKIN IAW EA 256894. ACFT IN BASE MX.SDR AALA20151217007Intercostal · crackedE & E COMPARTMENT INTERCOSTAL CRACKED, BETWEEN STATIONS 344 & 360 AT LBL 12. R & R INTERCOSTAL IAW SRM 51-10-02-0G.SDR AALA20150928007Unknown · malfunctionedWHEN ENG ANTI-ICE WAS TURNED ON, THE BLEEDS TRIPPED OFF & CABIN PRESS STARTED TO CLIMB. EMER WAS DECLARED & A DESCENT WAS STARTED. RESET PACK TRIP, PRESSURIZATION RETURNED TO NORMAL. FLIGHT DECLARED AN EMER, DIVERTED & LANDED WITHOUT FURTHER INCIDENT. ACFSDR AALA20141212007Battery · dischargedDURING ACCOMPLISHMENT OF SIC 2908 THE MID CABIN & AFT GALLEY EMER LIGHT WOULD NOT SATISFY THE 15 MIN DURATION. RECHARGED BATTERIES IAW 33-51-06. OPERATIONAL TESTED IAW SIC, CHECKED OK.
Back to N924AN