N905AN
Service difficulty reports · 270
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 = 'N905AN' 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 = 'N905AN' 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 AALA202303066402Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE RIGHT HAND TRANSITION PANEL LOCATED BETWEEN BS 767 AND BS 787 AT RBL 20. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G AND DWG 146A8127.SDR AALA202303063530Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 727I + 15 INCHES AND BS 807 AT S25L. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202303068205Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE RIGHT HAND TRANSITION PANEL LOCATED BETWEEN BS 727E + 10 INCHES AND BS 767 AT S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202303079491Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 500C TO BS 500D AT S26R. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202303060045Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN AFT CARGO COMPARTMENT AFT BULKHEAD CENTER ACCESS PANEL LOWER SUPPORT LOCATED AT BODY STATION 947.5 AND BETWEEN RIGHT BUTT LINE 20 TO LEFT BUTT LINE 20. REMOVED AND INSTALLED NEW LOWER SUPPORT.SDR AALA202303062519Landing · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT WHEEL WELL AFT LOWER PANEL LANDING CORRODED IN MULTIPLE PLACES LOCATED AT STA 727+2 AND LEFT BUTT LINE 0 TO LEFT BUTT LINE 35. REMOVED AND REPLACED NEW PANEL LANDING PER SRM.SDR AALA202303067504Flange · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO AFT BULKHEAD LOWER FLANGE HAS SIGNS OF CORROSION AT STA 500I AND 25L. REMOVED AND REPLACED FLANGE.SDR AALA202303068119Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN AFT CARGO COMPARTMENT FLOOR STRUCTURE RIGHT TRANSITION PANEL SECTION BETWEEN BODY STATION 857 AND BODY STATION 867 JUST ABOVE STR 25R. REMOVED AND REPLACED TRANSITION PANEL.SDR AALA202303061765Panel · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT WHEEL WELL FORWARD LOWER VAPOR BARRIER PANEL CRACKED. CRACK LOCATED AT STA 663.75 AND LEFT BUTT LINE 24.97.SDR AALA202303066166Transition Panel · inoperativeAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN AFT CARGO COMPARTMENT FLOOR STRUCTURE RIGHT SIDE TRANSITION PANEL SECTION BETWEEN BODY STATION 867 AND BODY STATION 887 AND RIGHT BUTT LINE 20. REMOVED AND REPLACED AFT CARGO COMPARTMENT RIGHT SISDR AALA202302278700Doubler · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON G4 GALLEY SIDE ROD ATTACHMENT DOUBLER LOCATED AT BS 1006 AND RBL 54. REPLACED ATTACH DOUBLER PER EA 342272.SDR AALA202302271552Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB 3 LOCATED AT STABILIZER STA 92.7. REPLACED RIB FITTING PER SRM 51-40-02-0G.SDR AALA202302274092Strap · gougedAIRCRAFT IN BASE MAINTENANCE: GOUGE IN AFT PASSENGER CABIN RIGHT HAND OUTBOARD SEAT TRACK SPLICE STRAP LOCATED AT BS 905 AND RBL 45. REPLACED STRAP PER SRM 51-40-02-0G.SDR AALA202303060726Web · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN DECK AFT PRESSURE BULKHEAD LOWER WEB AT RIGHT BUTT LINE 3 CORRODED. REMOVED, FABRICATED, AND INSTALLED WEB.SDR AALA202303061393Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN DECK STA 947.5 BETWEEN LEFT BUTT LINE 4 AND RIGHT BUTT LINE 4 FLOOR BEAM CORRODED. REMOVED, FABRICATED, AND INSTALLED FLOOR BEAM SECTION.SDR AALA202303065796Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT WET AREA EXISTING BEAM REPAIR AT STA 986.5 HAS CORROSION AT RIGHT BUTT LINE 4. REMOVED, FABRICATED, AND INSTALLED FLOOR BEAM SECTION.SDR AALA202302274844Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED BETWEEN BS 947.5 TO BS 967 AT RBL 52. REPLACED INTERCOSTAL PER 51-40-02-OG AND AARD 51-00-05-1.SDR AALA202302204431Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE SUPPORT INTERCOSTAL LOCATED AT BS 770 AND RBL 5.5. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202302204692Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR Z ANGLE LOCATED AT BS 992 AND RBL 32. REPLACED Z ANGLE PER SRM 51-40-02-0G.SDR AALA202302218251Pressure Deck · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK AFT PRESSURE BULKHEAD LOWER WEB LOCATED AT BS 1042, WL 211.1, AND RBL 12. REPAIRED WEB PER SRM 51-40-02-0G.SDR AALA202302215264Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK SUPPORT WEB LOCATED AT BS 1026 AND RBL 21. REPAIRED WEB PER SRM 51-40-02-0G.SDR AALA202302215364Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK AFT PRESSURE BULKHEAD LOWER WEB #4 LOCATED AT BS 1026 AND LBL 34. REPAIRED WEB PER 51-40-02-0G.SDR AALA202302203723Pressure Deck · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK AFT PRESSURE BULKHEAD LOWER WEB LOCATED AT BS 1026 AND RBL 35. REPLACED WEB PER 51-40-02-0G.SDR AALA202302204079Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK AFT WEB LOCATED AT BS 1018 AND LBL 30. REPLACED WEB PER 51-40-02-0G.SDR AALA202302202341None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR CUTOUT INNER CHORD LOCATED FROM BS 980 TO BS 986.5 AT LBL 55. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202302202039Scuff Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR SCUFF PLATE LOCATED AT BS 312 AND LBL 62. REPLACED SCUFF PLATE PER SRM 51-40-02-0G.SDR AALA202302215984Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR CUT-OUT INNER CHORD LOCATED FROM BS 947.5 TO BS 992 AT RBL 55. REPLACED CHORD PER SRM 51-40-02-OG AND AARD 51-00-05-1.SDR AALA202302218317Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR WEB LOCATED AT BS 986.5 AND RBL 35. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202302210850Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON Z ANGLE LOCATED AT BS 992.8 AND RBL 50. REPLACED ANGLE PER SRM 51-40-02-0G.SDR AALA202302216510Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WEB LOCATED AT BS 986.5 AND LBL 35. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202302202647Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON ZEE ANGLE LOCATED AT BS 992.8 AND LBL 50. REPLACED ANGLE PER SRM 51-40-02-0G.SDR AALA202302205155Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK AFT PRESSURE BULKHEAD LOWER #3 WEB LOCATED AT BS 1026 AND LBL 21. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202302131892Rib · crackedAIRCRAFT IN BASE MAINTENANCE: TWO CRACKS IN RIGHT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 92.70, AT FIRST AND SECOND STIFFENER AFT OF FORWARD SPAR. REPLACED RIB PER SRM 55-10-09-0I-2 AND SRM 55-10-09-0I PROCEDURE 2.SDR AALA202302139191Mount · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FORWARD GIRT BAR MOUNT LOCATED AT BS 312 AND LBL 58. REPLACED GRIT BAR MOUNT PER SRM 53-10-02, 53-10-15, AND 51-40-02.SDR AALA202302134769None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR CUT-OUT INNER CHORD, LOCATED BETWEEN BS 320 AND BS 335 AT LBL 60. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202302075740Mount · corrodedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR AFT GIRT BAR MOUNT HAS CORROSION LOCATED AT STA 344 AND LEFT BUTT LINE 61. REMOVED AND REPLACED MOUNT PER SRM.SDR AALA202302075114Not Reported · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA R1 DOOR CUT-OUT INNER CHORD HAS CORROSION. LOCATED AT STA 328. REMOVED AND REPLACED CHORD PER SRM.SDR AALA202302061127Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR CUT-OUT LOWER SCUFF PLATE ANGLE LOCATED FROM BS 312 TO BS 328 AT LBL 61. REPLACED ANGLE PER SRM 51-40-02.SDR AALA202302214284Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN DECK AFT PRESSURE BULKHEAD LOWER WEB LOCATED AT BS 1016 AND LBL 5. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202302211948Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED FROM BS 947 TO BS 967 AT RBL 25. REPLACED WEB PER SRM 53-70-51-2R-5.SDR AALA202302214234Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON Z ANGLE LOCATED FROM BS 992.9 TO BS 1006 AT LBL 30. REPLACED ANGLE PER SRM 51-40-02-0G.SDR AALA202003169008Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS ILLUMINATED WITH SWITCH IN OFF POSITION. MAINTENANCE CHARGED BATTERY PACK AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER FIM 33-50-00.SDR AALA2020030329018Support Fitting · damagedAIRCRAFT WAS GROUNDED: RIGHT WING TRAILING EDGE INBOARD FLAP GIMBAL SUPPORT FITTING DAMAGED. REPLACED SUPPORT FITTING PER SRM 51-40-02.SDR AALA202002049015Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN FLOOR INTERCOSTAL BETWEEN BS 312 AND BS 328 AT LBL 47. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202002049014Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN FLOOR INTERCOSTAL BETWEEN BS 328 AND BS 344 AT LBL 47. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2019102329008Tire · separatedAIRCRAFT WAS GROUNDED: CREW DECLARED EMERGENCY INTO EWR ON ACCOUNT OF NOSE LANDING GEAR SHIMMY ON TAKEOFF OUT OF DFW. MAINTENANCE FOUND LOSS OF TREAD ON R/H NLG TIRE. REPLACED L/H & R/H NOSE WHEEL ASSYS IAW AMM 32-45-21, OK FOR SERVICE.SDR AALA201908039011Warning Horn · false activationAIRCRAFT WAS GROUNDED: PILOT REPORTS AT 13000 FEET GOT A PRESSURIZATION WARNING HORN FOR APPROX 7 SECONDS. CABIN ALT 2500, DIFF PRESS 4.2 INCHES 300 FPM DOWN CABIN RATE. NO WARNING LIGHTS NOTED. MAINTENANCE PERFORMED FIM PROCEDURE 31-51-00-810-803 FOR INTERMITSDR AALA201905079001Processor · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS AFTER TAKEOFF IN THE INITIAL CLIMB OUT WE EXPERIENCED A FUEL IMBALANCE. RIGHT TANK WAS REDUCING IN FUEL LOAD, RAPIDLY DECREASING. RETURNED TO AIRPORT. LANDED OVERWEIGHT. 147,000. RETURNED TO MIA, EMERGENCY DECLARED. FLIGHT SDR AALA201904169004Not Reported · not reportedAIRCRAFT NOT GROUNDED: PILOT REPORTS TAKEOFF REJECTED AT 60 KTS WT 152.6 MEDIUM BRAKING. MAINTENANCE ACCOMPLISHED CARD 05-96-17, NO DEFECTS NOTED.SDR AALA2018061859024Warning Light · malfunctionedWHEN THE LANDING GEAR SELECTED TO THE DOWN POSITION AND FLAPS SELECTED 15, RECEIVED A WARNING HORN AND ALL THREE GREEN AND ALL THREE RED LIGHTS. CYCLING THE GEAR HANDLE AND ACHIEVED ALL THREE GREEN ONLY, LANDED. THE AIRCRAFT WAS GROUNDED. ACCOMPLISHED FIM
Back to N905AN